International SIM Card Settings
From nookDevs
This is the page where you can post successful sql commands for the international operators to allow use of their SIM-card in nook.
Contents |
How to look up your provider settings
- You can find the MCC (Mobile Country Code) and MNC (Mobile Network Code) of your country and provider on this wikipedia page: [1]. For example the Hungarian Vodafone has MCC="216" and MNC="70".
- Search your provider's web pages for the APN settings. This is usually described on a page where the setup of an USB stick or other network device settings described. Note that APN settings may differ between the subscription plans, so check yours. You may also find it on one of the linked pages starting from this WikiPedia page: [2]. For example the Hungarian Vodafone's "Internet Easy" subscription has the APN "internet.vodafone.net" for monthly subscriptions and "vitamax.internet.vodafone.net" for prepaid cards.
- Now you have all the information. Build the SQL by putting the MCC/MNC/APN values to the appropriate positions to the script. The "numeric" value should contain the MCC and MNC values concatenated.
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('' , ', ' ' ' , '' , '' , 1);
For example this setting should work for Hungarian Vodafone (I have not verified it yet, still waiting for my nook ;-):
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('Vodafone', '21670', '216', '70', 'internet.vodafone.net', 1);
Please follow the example below.
Armenia
Vivacell/MTS
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('vivacell', '28305', '283', '05', 'inet.vivacell.am', 1);
Australia
Telstra
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('telstra', '50501', '505', '01', 'telstra.internet', 1);
Optus
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('optus', '50502', '505', '02', 'internet', 1);
Vodafone
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('vodafone', '50503', '505', '03', 'vfinternet.au', 1);
Austria
drei (3)
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('drei', '23210', '232', '10', 'drei.at', 1);
Chile
Entel
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, mmsc, type, current) VALUES ('Entel', '73001', '730', '01', 'bam.entelpcs.cl', 'entelpcs', '', 'entelpcs', '', '', '', '', '', 'default', 1);
China
Unicom
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('Unicom', '46001', '460', '01', '3gnet', 1);
Croatia
T-Mobile Simpa (prepaid)
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, mmsc, type, current) VALUES ('T-Mobile', '21901', '219', '01', 'web.htgprs', '*', '', '*', '', '', '', '', 'null', 'default', 1);
Denmark
All information gathered from [[3]].
3
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('3 DK', '23806', '238', '06', 'data.tre.dk', 1);
BiBoB
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('BiBoB', '23802', '238', '02', 'internet.bibob.dk', 1);
CBB
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('CBB', '23802', '238', '02', 'internet', 1);
Happii
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('Telmore', '23801', '238', '01', 'internet', 1);
Telenor
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('Telenor DK', '23802', '238', '02', 'internet', 1);
Telia
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('Telia DK', '23820', '238', '20', 'www.internet.mtelia.dk', 1);
Telmore
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('Telmore', '23801', '238', '01', 'internet', 1);
Ecuador
Porta GSM
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('Porta GSM', '74001', '740', '01', 'internet.porta.com.ec', 1);
Finland
Elisa
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('Elisa', '24405', '244', '05', 'internet', 1);
Germany
o2 (contract, not prepaid)
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, mmsc, type, current) VALUES ('o2-de', '26207', '262', '07', 'surfo2', '', '', '', '', '', '', '', '', 'default', 1);
T-Mobile (contracts: Complete S, M, L, XL)
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, mmsc, type, current) VALUES ('t-mobile', '26201', '262', '01', 'smartsites.t-mobile', '', '', '', '', '', '', '', '', 'default', 1);
T-Mobile (all other contracts than: Complete S, M, L, XL)
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, mmsc, type, current) VALUES ('t-mobile', '26201', '262', '01', 'internet.t-mobile', '', '', '', '', '', '', '', '', 'default', 1);
India
Airtel (Tamil Nadu)
For other states, please provide the appropriate [4] mcc & mnc codes
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, mmsc, type, current) VALUES ('Airtel', '40494', '404', '94', 'airtelgprs.com', '*', '', '*', '', '', '', '', 'null', 'default', 1);
BSNL (Tamil Nadu)
For other states, please provide the appropriate [5] mcc & mnc codes. It seems that APN too varies with the region. Talk to your customer care for appropriate APN.
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, mmsc, type, current) VALUES ('Bsnl', '40480', '404', '80', 'gprssouth.cellone.in', '*', '', '*', '', '', '', '', 'null', 'default', 1);
Pakistan
Warid
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('Warid', '41007', '410', '07', 'warid', 1);
Telenor
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, password, type, current) VALUES ('Telenor', '41006', '410', '06', 'Internet', 'Telenor', 'Telenor', 'default', 1);
Poland
Play Online (prepaid)
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, mmsc, type, current) VALUES ('PlayOnline', '26006', '260', '06', 'internet', '', '', '', '', '', '', '', '', 'default', 1);
Russia
MTS
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, password, current) VALUES ('MTS', '25001', '250', '01', 'internet.mts.ru', 'mts', 'mts', 1);
MegaFon
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, password, current) VALUES ('MTS', '25002', '250', '02', 'internet', 'gdata', 'gdata', 1);
Beeline
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, password, current) VALUES ('MTS', '25099', '250', '99', 'internet.beeline.ru', 'beeline', 'beeline', 1);
Singapore
Starhub
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, msc, type, current) VALUES ('Starhub', '52505', '525', '05', 'shwapint', '', '', '', '', '', '', '', '', 'default', 1);
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, msc, type, current) VALUES ('Starhub MMS', '52505', '525', '05', 'shmms', '', '', '', '', '', '10.12.1.80', '80', 'http://mms.starhubgee.com.sg:8002/', 'mms', 1);
Spain
Movistar
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, mmsc, type, current) VALUES ('Movistar', '21407', '214', '07', 'movistar.es', '*', '', '*', '', '', '', '', '', 'default', 1);
Sweden
Telia
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, mmsc, type, current) VALUES ('Telia', '24001', '240', '01', 'online.telia.se', '*', '', '*', '', '', '', '', '', 'default', 1);
Thailand
AIS
INSERT INTO carriers (name, numeric, mcc, mnc, apn, user, server, password, proxy, port, mmsproxy, mmsport, mmsc, type, current) VALUES ('AIS', '52001', '520', '01', 'internet', '*', '', '*', '', '', '', '', '', 'default', 1);
Ukraine
Beeline
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('Beeline', '25502', '255', '02', 'internet.beeline.ua', 1);
Kyivstar
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('Kyivstar', '25503', '255', '03', '3g.kyivstar.net', 1);
life:)
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('life:)', '25506', '255', '06', 'internet', 1);
UTel
INSERT INTO carriers (name, numeric, mcc, mnc, apn, current) VALUES ('Ukrtelecom', '25507', '255', '07', '3g.utel.ua', 1);
United States
T-Mobile US (Postpaid)
The nook already include an APN that has the same MCC/MNC values as T-Mobile so you need to update that entry versus add a new one. Note that nook is not compatible with T-Mobile 3G, it will only work at EDGE speeds.
UPDATE carriers SET apn = 'internet2.voicestream.com', name = 'T-Mobile' WHERE name='TelKila';