palmdoc2005

I've starting this thread for the unlocked GSM Pre as a place to summarise what I've learnt from other threads in this forum (many thanks to Dick99999 for the post buried in this thread) , and also to make sure I got the steps right since I need to do this once I get my GSM Palm Pre

I assume that one will have an unlocked GSM Pre which is activated, has network access via Wifi but may have 3G data connection problems due to incorrect carrier connection settings.
Modifying the file CarrierNetworkSettings.db3 found in /usr/lib/luna/ may fix the problem
You of course also need to first check what the correct data network settings (APN/login/username etc) for your carrier are (call them up if you are unsure)

Step 1) Copying the carrier network database file to your PC
Several methods

a) Obtain the database from the webosdoctor image
Download the image appropriate for your device
Use 7zip to unpack the file
The file is found in :
webosdoctorp100eww-wr\resources\webOS\nova-cust-image-castle.rootfs.tar\nova-cust-image-castle.rootfs\usr\lib\luna\CarrierNetworkSettings.db3

b)Obtain the database from the device itself:
you can
1) SSH to to your Pre using Putty, type
cp /usr/lib/luna/CarrierNetworkSettings.db3 /media/internal. This will copy the database file to the internal storage.
Put your Pre into USB disk mode and copy the database file to your machine.

or

2) use Internalz
navigate to /usr/lib/luna/
and copy CarrierNetworkSettings.db3 to /media/internal
Put your Pre into USB disk mode and copy the database file to your machine.

or

3) Use WebOS Quick Install tool
Put your Pre in Developer Mode
Attach to PC and select Just Charge
Launch WOQI
Select Receive File from the menu
enter /usr/lib/luna/CarrierNetworkSettings.db3
select destination folder in your PC


Step 2) Editing the database on your PC

I suppose it is prudent to back up the file before making modifications

a) Obtain a free SQLite database editor
- SQLite Database Browser
or
-Firefox SQLite manager extension

b) Open the carrier network db3 file in SQLite database browser
Click on the Browse Data tab

- From the drop down menu, select the ..._CarrierNetworkSettings table
- Locate your carrier by browsing or searching the table
- Note the 13 digit number such as 2199023255831 ID value of the carrier at the end of the record on the right hand side
- Change the voicemail number if desired: Locate your carrier by browsing or searching the table
- check and enter the field voicemailNumber

- From the drop down menu, select the ..._DataConnectionSettings table
- Locate that same ID in the dataconnections table
Now you can edit the APN , username and password if these have been changed by your carrier but not updated in the Palm database



Save the file

Step 3) Copying the database back to the device

Use Jason Robitaille's WebOS Quick Install tool
Click on Tools - Send File and point it to the amended database file.
As the destination folder use /usr/lib/luna/ and click Send To Device!
Repeat this, only this time use /var/luna/data/ as the destination folder.

Reset your Pre. That should be it. I hope.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

jvvpc

So if my carrier aint supported yet i should be able to add it manuel ?

This is the only reason why im holding back buying one, as the best carrier in DK for data aint supported

palmdoc2005

You should check if your carrier is in the database. Which is it anyway?

jvvpc

3 Denmark and its says on this list it aint supported

http://forums.precentral.net/gsm-pre...-networks.html

But im dl the file now and looking thru

dubiki

read this http://forums.precentral.net/1998902-post36.html and this posts http://forums.precentral.net/2000870-post37.html

hope you'll filnd it usefull.

Andrew. from kiev)

jvvpc

That looks really promising !! I'll talk to hotdp as he should be able to help me out

U just made my day ! ;D

amjz

Im on Orange Network, in 1.1.3 my Netwok settings was worked perfectly, after upgrading to 1.3.1 from scratch my network setting aint working anymore.
so i checked your way and i found that Network settings are correct and dont need any change, whats the problem then?

palmdoc2005

In 1.3.1 one can enter the network settings manually in the Phone App:
Preferences/Network switch Manual Settings On, Edit Network settings. A reboot seems to be necessary.
Hth.

TIWizard

Wait, what? Which one do you send the file to?

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Weatherman, Stickyman, LOL, Fart Man, Don't Taze Me Man, and more

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

palmdoc2005

both iianm

TIWizard

Oh, I read it wrong

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Weatherman, Stickyman, LOL, Fart Man, Don't Taze Me Man, and more

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

bruba

For some people (like me) the right settings simply don't work anymore in 1.3.1.

See http://forums.precentral.net/gsm-pre...-1-3-1-uk.html

Dick99999

Thanks palmdoc2005, that looks smart. The inventer btw is Der Jens who initially kindly offered this a s service!
Could I suggest to change
Note the ID value of the carrier at the end of the record on the right hand side
into something like (based on experience of someone misunderstanding ID)
Note the 13 digit number such as 2199023255831 ID value of the carrier at the end of the record on the right hand side

And perhaps a suggestion to check and enter the voicemeil number? something like:
- Locate your carrier by browsing or searching the table
Insert
- check and enter the field voicemailNumber
see why

palmdoc2005

Hi, have edited the post and made the changes you suggest. Also Added one more option to get the db3 file - using WOQI.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

vladdu

Hi,
and what if my carier is not on the list at all?

I can enter it manually I guess, but not really sure what data to insert.
My carier is MTel Bulgaria, country code is 284, APN: inet-gprs.mtel.bg; no user name and password ... any help appreciated...

Andreas

If you intend to add a voice mail to the database this should be done before entering any manual settings.

As soon as you enter a manual setting it seems to take a copy of the original database settings and from then on the manual settings will never read the original database. So, any changes to the database after manual settings been activated will only work when Manual Settings = OFF.

So, if you use manual settings and need to add a voice mail number then add the number first and then enter manual settings. The device will then take a copy of the modified database and voice mail button will work in both settings (manual on/off).

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

vladdu

I managed to insert new record for M-Tel Bulgaria + new record for the data connection.
So important fields are mmc mnc (my case 284 for the country and 1 for the operator) the carrier ID from _CarrierNetworkSettings table must match with the id in the _DataConnectionSettings table of course.

Dick99999

Thanks, however shouldn't the line
- Change the voicemail number if desired: Locate your carrier by browsing or searching the table

be right after the following line?
- Note the 13 digit number such as 2199023255831 ID value of the carrier at the end of the record on the right hand side

The voicemail is stored in the other table: _CarrierNetworkSettings table

gguile

Thanks for the guide. I hope this can be a sticky since there is a lot of newbie user who would want to edit database setting and this is of a great help.

phil71

If you have changed your apn carrier settings and that your data connection is still not working, try to use a friend's sim card from another operator in your country. You have to surf the web and/or send a mms.
This procedure enables me to get my data connection to work. Hope it works for you as well.