OpenBTS: Set SQLite parameter smqueue - Revision history

Onnowpurbo: /* Melalui Web */

2017-04-07T12:38:35Z

Melalui Web

← Older revision		Revision as of 12:38, 7 April 2017
Line 53:		Line 53:

	jangan di set eth0:1 eth0:2 dsb ..		jangan di set eth0:1 eth0:2 dsb ..

			==iptables==

			Pastikan interface di iptables benar di Ubuntu 16.04 enp0s4

			# Generated by iptables-save v1.4.4
			*nat
			:PREROUTING ACCEPT [0:0]
			:POSTROUTING ACCEPT [0:0]
			:OUTPUT ACCEPT [0:0]
			-A POSTROUTING -o enp0s4 -j MASQUERADE
			COMMIT
			# Generated by iptables-save v1.4.4
			*filter
			:INPUT ACCEPT [0:0]
			:FORWARD ACCEPT [0:0]
			:OUTPUT ACCEPT [0:0]
			COMMIT

	==Pranala Menarik==		==Pranala Menarik==

Onnowpurbo: /* Melalui Web */

2017-04-07T12:36:22Z

Melalui Web

← Older revision		Revision as of 12:36, 7 April 2017
Line 45:		Line 45:
	iface eth0 inet static		iface eth0 inet static
	pre-up iptables-restore < /etc/OpenBTS/iptables.rules		pre-up iptables-restore < /etc/OpenBTS/iptables.rules
	address 192.168.0.23		address 192.168.0.21
	netmask 255.255.252.0		netmask 255.255.252.0
	network 192.168.0.0		network 192.168.0.0
	broadcast 192.168.0.255		broadcast 192.168.0.255
	gateway 192.168.0.1		gateway 192.168.0.223
	dns-nameservers ~~192~~.~~168~~.0.23		dns-nameservers 8.8.8.8

	jangan di set eth0:1 eth0:2 dsb ..		jangan di set eth0:1 eth0:2 dsb ..






	==Pranala Menarik==		==Pranala Menarik==

Onnowpurbo at 12:34, 7 April 2017

2017-04-07T12:34:48Z

← Older revision		Revision as of 12:34, 7 April 2017
Line 12:		Line 12:

	DELETE from "CONFIG" where KEYSTRING = 'SIP.myIP2';		DELETE from "CONFIG" where KEYSTRING = 'SIP.myIP2';
	INSERT INTO "CONFIG" VALUES('SIP.myIP2','192.168.0.22',0,0,'The external IP address that is communciated to the SIP endpoints.');		INSERT INTO "CONFIG" VALUES('SIP.myIP2','192.168.0.21',0,0,'The external IP address that is communciated to the SIP endpoints.');

	DELETE from "CONFIG" where KEYSTRING = 'SC.Register.Digits.Override';		DELETE from "CONFIG" where KEYSTRING = 'SC.Register.Digits.Override';

Onnowpurbo at 06:17, 16 February 2016

2016-02-16T06:17:37Z

← Older revision		Revision as of 06:17, 16 February 2016
Line 17:		Line 17:
	INSERT INTO "CONFIG" VALUES('SC.Register.Digits.Override','1',0,0,'1=enabled, 0=disabled - Ignore phone number digit length checks.');		INSERT INTO "CONFIG" VALUES('SC.Register.Digits.Override','1',0,0,'1=enabled, 0=disabled - Ignore phone number digit length checks.');

			.exit

Onnowpurbo at 09:20, 8 March 2015

2015-03-08T09:20:17Z

← Older revision		Revision as of 09:20, 8 March 2015
Line 7:		Line 7:
	DELETE from "CONFIG" where KEYSTRING = 'SC.Register.Digits.Max';		DELETE from "CONFIG" where KEYSTRING = 'SC.Register.Digits.Max';
	INSERT INTO "CONFIG" VALUES('SC.Register.Digits.Max','12',0,0,'The maximum number of digits a phone number can have.');		INSERT INTO "CONFIG" VALUES('SC.Register.Digits.Max','12',0,0,'The maximum number of digits a phone number can have.');

			DELETE from "CONFIG" where KEYSTRING = 'SC.Register.Digits.Min';
			INSERT INTO "CONFIG" VALUES('SC.Register.Digits.Min','4',0,0,'The minimum number of digits a phone number must have.');

			DELETE from "CONFIG" where KEYSTRING = 'SIP.myIP2';
			INSERT INTO "CONFIG" VALUES('SIP.myIP2','192.168.0.22',0,0,'The external IP address that is communciated to the SIP endpoints.');

			DELETE from "CONFIG" where KEYSTRING = 'SC.Register.Digits.Override';
			INSERT INTO "CONFIG" VALUES('SC.Register.Digits.Override','1',0,0,'1=enabled, 0=disabled - Ignore phone number digit length checks.');




	~~DELETE from "CONFIG" where KEYSTRING = 'SIP.myIP2';~~
	~~INSERT INTO "CONFIG" VALUES('SIP.myIP2','192.168.0.23',0,0,'The external IP address that is communciated to the SIP endpoints.');~~

Onnowpurbo at 23:50, 16 June 2014

2014-06-16T23:50:39Z

← Older revision		Revision as of 23:50, 16 June 2014
Line 12:		Line 12:
	DELETE from "CONFIG" where KEYSTRING = 'SIP.myIP2';		DELETE from "CONFIG" where KEYSTRING = 'SIP.myIP2';
	INSERT INTO "CONFIG" VALUES('SIP.myIP2','192.168.0.23',0,0,'The external IP address that is communciated to the SIP endpoints.');		INSERT INTO "CONFIG" VALUES('SIP.myIP2','192.168.0.23',0,0,'The external IP address that is communciated to the SIP endpoints.');



			===Melalui Web===

			masuk ke web

			klik configuration > smqueue configuration > routing > SIPmyIP2

			isi dengan IP address LAN OpenBTS-nya

			pastikan cuma ada satu IP LAN di OpenBTS

			ssh openbts@192.168.0.xx
			sudo su
			cd /etc/network
			nano interfaces


			Pastikan cuma ini yang di set

			# The primary network interface
			auto eth0
			iface eth0 inet static
			pre-up iptables-restore < /etc/OpenBTS/iptables.rules
			address 192.168.0.23
			netmask 255.255.252.0
			network 192.168.0.0
			broadcast 192.168.0.255
			gateway 192.168.0.1
			dns-nameservers 192.168.0.23

			jangan di set eth0:1 eth0:2 dsb ..

Onnowpurbo at 23:38, 16 June 2014

2014-06-16T23:38:26Z

← Older revision		Revision as of 23:38, 16 June 2014
Line 7:		Line 7:
	DELETE from "CONFIG" where KEYSTRING = 'SC.Register.Digits.Max';		DELETE from "CONFIG" where KEYSTRING = 'SC.Register.Digits.Max';
	INSERT INTO "CONFIG" VALUES('SC.Register.Digits.Max','12',0,0,'The maximum number of digits a phone number can have.');		INSERT INTO "CONFIG" VALUES('SC.Register.Digits.Max','12',0,0,'The maximum number of digits a phone number can have.');



			DELETE from "CONFIG" where KEYSTRING = 'SIP.myIP2';
			INSERT INTO "CONFIG" VALUES('SIP.myIP2','192.168.0.23',0,0,'The external IP address that is communciated to the SIP endpoints.');

Onnowpurbo at 23:58, 24 February 2014

2014-02-24T23:58:16Z

Show changes

Onnowpurbo at 12:17, 24 February 2014

2014-02-24T12:17:09Z

← Older revision		Revision as of 12:17, 24 February 2014
Line 5:		Line 5:
	kemudian ketik misalnya		kemudian ketik misalnya

	~~INSERT OR IGNORE INTO~~ "CONFIG" ~~VALUES(~~'SC.Register.Digits.Max'~~,'12',0,0,'The maximum number of digits a phone number can have.')~~;		DELETE from "CONFIG" where KEYSTRING = 'SC.Register.Digits.Max';
			INSERT INTO "CONFIG" VALUES('SC.Register.Digits.Max','12',0,0,'The maximum number of digits a phone number can have.');
	INSERT INTO "CONFIG" VALUES('SC.Register.Digits.Max','12',0,0,'~~Nilai Max');~~

	~~INSERT INTO "CONFIG" VALUES('SC~~.~~Register.Digits.Max','12',0,0,'~~');

Onnowpurbo: New page: Edit sqlite3 /etc/OpenBTS/smqueue.db kemudian ketik misalnya INSERT OR IGNORE INTO "CONFIG" VALUES('SC.Register.Digits.Max','12',0,0,'The maximum number of digits a phone number can ...

2014-02-24T12:11:11Z

New page: Edit sqlite3 /etc/OpenBTS/smqueue.db kemudian ketik misalnya INSERT OR IGNORE INTO "CONFIG" VALUES('SC.Register.Digits.Max','12',0,0,'The maximum number of digits a phone number can ...

New page

Edit

sqlite3 /etc/OpenBTS/smqueue.db

kemudian ketik misalnya

INSERT OR IGNORE INTO "CONFIG" VALUES('SC.Register.Digits.Max','12',0,0,'The maximum number of digits a phone number can have.');

INSERT INTO "CONFIG" VALUES('SC.Register.Digits.Max','12',0,0,'Nilai Max');

INSERT INTO "CONFIG" VALUES('SC.Register.Digits.Max','12',0,0,'');