Unite ITPolicy modifications - BlackBerryForums.com : Your Number One BlackBerry Community

Grimlin · 10:45 PM

THIS THREAD IS NOT ABOUT GETTING RID OF THE ITPOLICY OR WHINING ABOUT IT MESSING UP YOUR BROWSER

This thread is about modifying the default ITPolicy laid down by Unite so that you can customize it to fit your needs. My personal goals are to:

Enable Bluetooth Desktop Connectivity
Enable Wireless Bypass
Enable GPS Tracking
Enable Other Browsers

**************************************
Steps for changing ITPolicy on Unite:
IF YOU DO NOT UNDERSTAND THIS FULLY DO NOT TRY THIS. I TAKE NO RESPONSIBILITY FOR FOULED UP UNITE SERVERS. THIS WORKED FOR ME AND I AM PUTTING THE INFO OUT THERE FOR OTHERS THAT WANT TO EXPERIMENT.

Download
Double-click
Answer Prompts
Enjoy

There were too many steps, so... I created a VBScript. It is internally documented and can be viewed in Notepad.

Nextel User · 12:19 AM

EDITED.

this is a great thread. hopefully you can figure out how to modify many many settings

Grimlin · 05-12-2008, 07:48 PM

You are missing the point here. This thread is not about the whole whining I want to get rid of the ITPolicy. This is about changing the ITPolicy that Unite pushes down. I probably should have been more specific. Will update the top post.

Nextel User · 05-12-2008, 10:06 PM

sorry. i didnt get that from the original post.

it's not really changing it, but if you connect the device again, you can log into unite and reactivate the browser.

John Clark · **OS:** 4.6.1.250

If I recall, this was so that one could use bluetooth, right? That would be a neat feature.

Grimlin · 05-12-2008, 11:38 PM

Quote:

Originally Posted by John Clark

If I recall, this was so that one could use bluetooth, right? That would be a neat feature.

It works by the way. Email and web work fine over bluetooth. One of my voice only devices already had a BES policy on it because I plugged it in at work. So I dummied up a new policy for it on the BES and then connected it bluetooth to the unite box. Works like a champ. I am going to export the new policy I made on the BES and import it into the Unite box. Change it to the default and see if I can get my other device (never touched a BES) working. If it is successful, I will post some instructions.

Grimlin · 11:41 PM

Quote:

Originally Posted by Nextel User

sorry. i didnt get that from the original post.

it's not really changing it, but if you connect the device again, you can log into unite and reactivate the browser.

Not about the browser being gone. browser is fine. shhhhhh....quiet... calm down... totally different thread here. The one you should be posting in is here: http://www.blackberryforums.com/blac...tml#post923751

RobM · 05-13-2008, 12:40 AM

I wish you luck in this project as I know many are waiting for the answer...keep up the fight

Grimlin · 05-13-2008, 09:40 AM

Created three new ITPolicies on the BES for Unite.

Bluetooth - enables bluetooth desktop connection and wireless bypass
Tracking - Tells devices to report their GPS location back to the Unite server on 15min intervals
Bluetooth and tracking - Duh

BCP Export:

Code:

bcp "SELECT * FROM ITPolicy2 Where ID > 5" queryout C:\Docume~1\username\Desktop\ITPolicy2.txt -S server\instance -T

This exported the binary data and I can use it in reverse to insert the data into the Unite server. The ID > 5 was just the easiest way to specify which ones I wanted. Your query will vary.

Here is the table structure we are dealing with:

Code:

9.0
8
1       SQLINT        0       4       ""   1     Id                                                     ""
2       SQLCHAR       2       128     ""   2     PolicyName                                             SQL_Latin1_General_CP1_CI_AS
3       SQLINT        0       4       ""   3     AllowOtherEmailServices                                ""
4       SQLINT        0       4       ""   4     AllowOtherBrowserServices                              ""
5       SQLIMAGE      4       0       ""   5     HandheldBlob                                           ""
6       SQLIMAGE      4       0       ""   6     DesktopBlob                                            ""
7       SQLINT        1       4       ""   7     SessionId                                              ""
8       SQLBINARY     2       8       ""   8     Lurnum                                                 ""

When I get home tonight, I will import them into Unite and post the results.

Again, this information is just for the few nerds that want to follow along. When I am done and it is tested, I will try to post files and concise instructions.

John Clark · **OS:** 4.6.1.250

For some reason, I really like this thread. I don't even use Unite!

ezrunner · 05-13-2008, 11:41 AM

agreed

matthiasj · **OS:** 5.0.0.314

good work, its good to see some users actually having luck with unite

Grimlin · 05-13-2008, 01:27 PM

Quote:

Originally Posted by John Clark

For some reason, I really like this thread. I don't even use Unite!

I have a warm spot in my heart for you too John...

Grimlin · **My rant -** 05-13-2008, 01:35 PM

Quote:

Originally Posted by matthiasj

good work, its good to see some users actually having luck with unite

---This is not directed at you, so don't take it personal. I just feel the need to say it.---

Not to put too fine a point on it, but Unite wasn't released to the majority of the audience here. Myself included. So in a sense (to us) it is beta software. You should treat it as such. I had a hell of a time with it, but I didn't whine about it. first off, it wouldn't install because the MSDE setup kept bombing. I went out myself and downloaded MSDE separately and installed it. Then, I had problems with the "Server" service not being enabled on my machine so the controller kept bombing on its RPC calls. The dispatcher was coming up too quickly and it would fail because MSDE wasn't started yet. Since the controller wouldn't connect to the dispatcher, it couldn't restart it automatically. I say all of this to say that if you aren't a customer of the carrier that released it, you need to shut up or deal with it. pick one.

matthiasj · **OS:** 5.0.0.314

Quote:

Originally Posted by Grimlin

---This is not directed at you, so don't take it personal. I just feel the need to say it.---

Not to put too fine a point on it, but Unite wasn't released to the majority of the audience here. Myself included. So in a sense (to us) it is beta software. You should treat it as such. I had a hell of a time with it, but I didn't whine about it. first off, it wouldn't install because the MSDE setup kept bombing. I went out myself and downloaded MSDE separately and installed it. Then, I had problems with the "Server" service not being enabled on my machine so the controller kept bombing on its RPC calls. The dispatcher was coming up too quickly and it would fail because MSDE wasn't started yet. Since the controller wouldn't connect to the dispatcher, it couldn't restart it automatically. I say all of this to say that if you aren't a customer of the carrier that released it, you need to shut up or deal with it. pick one.

you havent seen my whining about anything at this point. i'm posting threads on a help forum for HELP, and i thought that is what its for. i know it wasn't released to everyone, but regardless there are users on here that know more about it than me (you included) and i'm just wanting to have my phone back working properly. excuse me if my post are bothering you, just skip them if thats the case, and if you would like to help that would be appreciated .

Grimlin · 05-13-2008, 01:51 PM

Quote:

Originally Posted by matthiasj

you havent seen my whining about anything at this point. i'm posting threads on a help forum for HELP, and i thought that is what its for. i know it wasn't released to everyone, but regardless there are users on here that know more about it than me (you included) and i'm just wanting to have my phone back working properly. excuse me if my post are bothering you, just skip them if thats the case, and if you would like to help that would be appreciated .

That wasn't directed at you. You just reminded me of it and it seemed like a good time to rant. That is all. Sorry to offend I can remove the post if you would like. PM me and I will edit it.

matthiasj · **OS:** 5.0.0.314

no big deal bud!

Grimlin · 05-13-2008, 02:09 PM

ahhh. The thread is friendly again... whew...

Grimlin · 05-13-2008, 08:16 PM

Got It!!!! I was able to import the policy onto Unite. Shut down blackberry services. Imported policies. Changed the ID in the UserConfig table. Restarted services. Plugged in my device and it got the new policy. If anyone else is feeling adventurous, I will post the files and the steps I went through. By the way, I lifted the defaulted "There shall be no other browsers before me" restriction while I was at it...

Dawg · **OS:** 4.5.0.138

was it alot of steps grim.

Nextel User · 05-13-2008, 08:21 PM

so now you can track your wife's gps enabled bb all day?

kidding.....

this is fantastic. you are making the unite software do more than rim allowed(wanted) it to.

keep up the good work

Grimlin · 05-13-2008, 08:43 PM

Quote:

Originally Posted by Dawg

was it alot of steps grim.

Not since I made the export file. I'll post it with a do at your own risk kinda thing. Working on it now.

matthiasj · **OS:** 5.0.0.314

that sounds good makes me wanna try it again hah!

Grimlin · 09:22 PM

OK, top post is updated. I made the instructions in a hurry, so they are pretty un-user-friendly. Are they understandable?

Dawg · **OS:** 4.5.0.138

too much for me to do tonight I will play with it tomorrow.

Sith_Apprentice · 05-13-2008, 09:53 PM

thread stuck

RobM · 05-14-2008, 09:48 AM

I guess I will play a wait and see how others use it and like it now...I have already done the wipe to remove unite but this looks interesting now..but I aint jumpin till I see some others

Grimlin · 05-15-2008, 10:05 AM

Anyone else tried it yet? Success? Failure? Don't Care?

hrbuckley · **OS:** 4.6.0.303

Quote:

Originally Posted by Grimlin

THIS THREAD IS NOT ABOUT GETTING RID OF THE ITPOLICY OR WHINING ABOUT IT MESSING UP YOUR BROWSER
..snip..

This did exactly what you said it would do, which is exactly what I wanted.

I wonder why RIM didn't include the ability to fine tune the ITPolicy in the first place. Anyway thanks! Your the man!

Grimlin · 05-15-2008, 11:06 AM

Quote:

Originally Posted by hrbuckley

I wonder why RIM didn't include the ability to fine tune the ITPolicy in the first place. Anyway thanks! Your the man!

Probably because they would have to call it a BES. The backend is a BES with most of the functionality loss being tied to the lack of a proper console to configure things. I need to try and install the BES Console and see if you can point it to the Unite instance.

ebj75 · 05-15-2008, 11:27 AM

Worked like a charm.

Out of curiosity - do you know where the tracking data gets stored in the DB?

Thanks for this.

Grimlin · 05-15-2008, 01:19 PM

Quote:

Originally Posted by ebj75

Worked like a charm.

Out of curiosity - do you know where the tracking data gets stored in the DB?

Thanks for this.

http://www.blackberryforums.com/bes-...-does-log.html

hrbuckley · 10:13 AM

Grim,

OK, I read the bes-admin-corner thread. The last post seemed to indicate that tracking is not enabled. Is this still true, or are you able to get it to work on yours? I've got your ITPolicy2 installed, and have the SyncLBS table but there is no data in it.

Never mind. Though one ref said 4.2.2 HH OS was required for this, other (more correct) source says 4.3 required. Which I don't have.

Grimlin · 05-16-2008, 10:13 AM

Quote:

Originally Posted by hrbuckley

Grim,

OK, I read the bes-admin-corner thread. The last post seemed to indicate that tracking is not enabled. Is this still true, or are you able to get it to work on yours? I've got your ITPolicy2 installed, and have the SyncLBS table but there is no data in it.

Tracking is not enabled by default. Thus the policy change. You will know it is working when the device gets a prompt that tracking is now enabled. Which policy have you put your users on? Do they have OS 4.2.2 or above? Do they have a device with GPS?

hrbuckley · **OS:** 4.6.0.303

Thanks for the reply. I have only one unit so far (mine) which is an Unlocked AT&T 8820 with 4.2.2. I only see two policies default and Unite, which now I wonder if that means I had a problem...

Going through the steps again I notice:

Code:

                                
bcp Unite.dbo.ITPolicy2 in ITPolicy2.sql -T
accept all defaults except save tofile
Do you want to save this format information in a file? [Y/n] n                  
                                                                                
Starting copy...                                                                
SQLState = S1000, NativeError = 0                                               
Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP data-file                                                                          
                                                                                
0 rows copied.                                                                  
Network packet size (bytes): 4096                                               
Clock Time (ms.): total        1

I wonder if I got a corrupt ITPolicy2.sql file. Uncompressed it is 234 bytes.

Anyway I did get the default policy pushed to the BB and got my old browsers back. I played with Device Management (restricting phone use etc) but opened everything back up. Now I have the Unite policy and can't seem to change it. But since there was an error with BCP that is probably something to worry about later.

Grimlin · 05-16-2008, 01:27 PM

Wirelessly posted

Did you open the file and save it before you ran bcp?
It could have scrambled the formatting. What does the itpolicy2 table look like?

hrbuckley · **OS:** 4.6.0.303

Might have, curiosity killed the cat. I will re-extract from the zip and try again. The table looks ok, just the two policies in it.

Grimlin · 05-16-2008, 01:59 PM

Quote:

Originally Posted by hrbuckley

The table looks ok, just the two policies in it.

Then it most definitely did not import. Those policies are the default ones that come with Unite.

hrbuckley · **OS:** 4.6.0.303

Tried downloading the zip and extracting again. Still get the same error.

ebj75 · 05-16-2008, 02:31 PM

I had the same error message. Which I attributed to opening and probably saving the file prior to running bcp.

I re-downloaded and unziped. Re-ran the bcp command and it worked fine. Make sure the datestamp matches - 2008-05-13 9:28AM (which is the date stamp of ITPolicy2.sql in the zip file)