Menggunakan opensipsdbctl - Revision history

Onnowpurbo at 10:16, 21 October 2016

2016-10-21T10:16:35Z

← Older revision		Revision as of 10:16, 21 October 2016
Line 28:		Line 28:
	==Menu Help==		==Menu Help==

	# opensipsdbctl -h		cd /usr/local/lib/opensips/opensipsctl
			opensipsdbctl -h

	MySQL password for root:		MySQL password for root:

Onnowpurbo at 23:56, 20 October 2016

2016-10-20T23:56:46Z

← Older revision		Revision as of 23:56, 20 October 2016
Line 1:		Line 1:
			Jika kita menggunakan database, maka kita perlu melakukan setup [[database]].


	Setup [[database]]		Setup [[database]]

Onnowpurbo at 02:37, 20 October 2016

2016-10-20T02:37:27Z

Onnowpurbo at 00:38, 31 December 2013

2013-12-31T00:38:05Z

← Older revision		Revision as of 00:38, 31 December 2013
Line 20:		Line 20:
	Pastikan MySQL beroperasi		Pastikan MySQL beroperasi

	$ sudo su -		sudo su
	# /etc/init.d/mysql restart		/etc/init.d/mysql restart

	==Menu Help==		==Menu Help==

Onnowpurbo: /* Pranala Menarik */

2013-12-30T23:04:35Z

Pranala Menarik

← Older revision		Revision as of 23:04, 30 December 2013
Line 99:		Line 99:
	==Pranala Menarik==		==Pranala Menarik==

			* [[OpenSIPS]]
	* [[OpenSIPS Softswitch]]		* [[OpenSIPS Softswitch]]
	* [[Compile OpenSIPS]]		* [[Compile OpenSIPS]]
Line 107:		Line 108:
	* [[Konfigurasi minimal OpenSIPS]]		* [[Konfigurasi minimal OpenSIPS]]
	* [[OpenSIPS: Demo User]]		* [[OpenSIPS: Demo User]]
			* [[Relay ke PSTN Menggunakan OpenSIPS]]
			* [[Relay ke Selular Menggunakan OpenSIPS]]
			* [[ENUM Query di OpenSIPS]]

Onnowpurbo: /* Pranala Menarik */

2013-12-30T23:01:17Z

Pranala Menarik

← Older revision		Revision as of 23:01, 30 December 2013
Line 100:		Line 100:

	* [[OpenSIPS Softswitch]]		* [[OpenSIPS Softswitch]]
	* [[OpenSIPS: Demo User]]
	* [[Compile OpenSIPS]]		* [[Compile OpenSIPS]]
			* [[OpenSIPS: Cek Konfigurasi]]
			* [[OpenSIPS: Demo Dial Plan]]
			* [[Menggunakan opensipsdbctl]]
	* [[Menggunakan opensipsctl]]		* [[Menggunakan opensipsctl]]
	* [[Konfigurasi ~~Minimal~~ OpenSIPS]]		* [[Konfigurasi minimal OpenSIPS]]
	* [[~~Internet Telepon~~]]		* [[OpenSIPS: Demo User]]

Onnowpurbo: /* Cek Database */

2013-12-30T22:55:44Z

Cek Database

← Older revision		Revision as of 22:55, 30 December 2013
Line 73:		Line 73:
	mysqlshow -u root -p		mysqlshow -u root -p

	Akan keluar tampilan		Akan keluar tampilan kira-kira

	+--------------------+		+--------------------+
Line 81:		Line 81:
	\| mysql \|		\| mysql \|
	\| opensips \|		\| opensips \|
			\| performance_schema \|
			\| test \|
	+--------------------+		+--------------------+


	==Delete / Drop Database==		==Delete / Drop Database==

Onnowpurbo: /* Inisialisasi Database */

2013-12-30T22:55:00Z

Inisialisasi Database

← Older revision		Revision as of 22:55, 30 December 2013
Line 52:		Line 52:

	MySQL password for root:		MySQL password for root:

	INFO: test server charset		INFO: test server charset
	INFO: creating database opensips ...		INFO: creating database opensips ...
Line 61:		Line 62:
	INFO: Presence tables succesfully created.		INFO: Presence tables succesfully created.

	Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist? (y/n): y		Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist registrant? (y/n): y

	INFO: creating extra tables into opensips ...		INFO: creating extra tables into opensips ...

Onnowpurbo at 22:46, 30 December 2013

2013-12-30T22:46:08Z

← Older revision		Revision as of 22:46, 30 December 2013
Line 11:		Line 11:
	DBENGINE=MYSQL		DBENGINE=MYSQL
	DBHOST=localhost		DBHOST=localhost
			DBROUSER=opensipsro
			DBROPW=opensipsro
	DBNAME=opensips		DBNAME=opensips
	DBRWUSER=opensips		DBRWUSER=opensips
	~~DBROUSER~~=~~opensipsro~~		DBRWPW="opensipsrw"
	~~DBROPW=opensipsro~~
	DBROOTUSER="root"		DBROOTUSER="root"

	~~Copy scripts ke /usr/local/lib/opensips/opensipsctl~~

	~~cp -Rf /usr/local/src/opensips-1.6.4-2--tls/scripts/* /usr/local/lib/opensips/opensipsctl/~~

	Pastikan MySQL beroperasi		Pastikan MySQL beroperasi
Line 33:		Line 30:

	usage: opensipsdbctl create <db name or db_path, optional> .....(creates a new database)		usage: opensipsdbctl create <db name or db_path, optional> .....(creates a new database)
	opensipsdbctl ~~drop~~ <db name or db_path, optional> .......(!entirely deletes tables!)		opensipsdbctl dropopensipsdbctl -h <db name or db_path, optional> .......(!entirely deletes tables!)
	opensipsdbctl reinit <db name or db_path, optional> .....(!entirely deletes and than re-creates tables!)		opensipsdbctl reinit <db name or db_path, optional> .....(!entirely deletes and than re-creates tables!)
	opensipsdbctl backup <file> .................................(dumps current database to file)		opensipsdbctl backup <file> .................................(dumps current database to file)
Line 49:		Line 46:
	==Inisialisasi Database==		==Inisialisasi Database==

	Membuat [[database]] opensips. Pastikan perintah opensipsdbctl di jalankan dari folder /usr/local/~~lib~~/opensips/~~opensipsctl~~		Membuat [[database]] opensips. Pastikan perintah opensipsdbctl di jalankan dari folder /usr/local/src/opensips-1.10.0-tls/scripts/

	cd /usr/local/~~lib~~/opensips/~~opensipsctl~~		cd /usr/local/src/opensips-1.10.0-tls/scripts/
	opensipsdbctl create		opensipsdbctl create

Onnowpurbo at 08:07, 31 January 2011

2011-01-31T08:07:05Z

← Older revision		Revision as of 08:07, 31 January 2011
Line 19:		Line 19:
	Copy scripts ke /usr/local/lib/opensips/opensipsctl		Copy scripts ke /usr/local/lib/opensips/opensipsctl

	cp -Rf /usr/local/src/opensips-1.6.3-tls/scripts/* /usr/local/lib/opensips/opensipsctl/		cp -Rf /usr/local/src/opensips-1.6.4-2--tls/scripts/* /usr/local/lib/opensips/opensipsctl/

	Pastikan MySQL beroperasi		Pastikan MySQL beroperasi

← Older revision		Revision as of 02:37, 20 October 2016
Line 26:		Line 26:

	# opensipsdbctl -h		# opensipsdbctl -h

	MySQL password for root:		MySQL password for root:
	/usr/local/sbin/opensipsdbctl $Revision: 3997 $		/usr/local/sbin/opensipsdbctl $Revision: 3997 $

	usage: opensipsdbctl create <db name or db_path, optional> .....(creates a new database)		usage: opensipsdbctl create <db name or db_path, optional> ...(creates a new database)
	opensipsdbctl ~~dropopensipsdbctl -h~~ <db name or db_path, optional> .......(!entirely deletes tables!)		opensipsdbctl drop <db name or db_path, optional> .....(!entirely deletes tables!)
	opensipsdbctl reinit <db name or db_path, optional> .....(!entirely deletes and ~~than~~ re-creates tables!)		opensipsdbctl reinit <db name or db_path, optional> ...(!entirely deletes and then re-creates tables!)
	opensipsdbctl backup <file> ~~......~~...........................(dumps current database to file)		opensipsdbctl backup <file> ...........................(dumps current database to file)
	opensipsdbctl restore <file> ~~......~~..........................(restores tables from a file)		opensipsdbctl restore <file> ..........................(restores tables from a file)
	opensipsdbctl copy <new_db> ~~......~~...........................(creates a new db from an existing one)		opensipsdbctl copy <new_db> ...........................(creates a new db from an existing one)
	opensipsdbctl migrate <old_db> <new_db> ~~......~~...............(migrates DB from 1.2 ~~to 1~~.~~3, not implemented yet!~~)		opensipsdbctl migrate <old_db> <new_db> ...............(migrates DB from 2.1.x to 2.2.x)
	opensipsdbctl presence ~~......~~................................(adds the presence related tables)		opensipsdbctl presence ................................(adds the presence related tables)
	opensipsdbctl extra ~~......~~...................................(adds the extra tables)		opensipsdbctl extra ...................................(adds the extra tables)

	if you want to manipulate database as other database user than		if you want to manipulate database as other database user than
	root, want to change database name from default value "opensips",		root, want to change database name from default value "opensips",
	or want to use other values for users and password, edit the		or want to use other values for users and password, edit the
	"config vars" section of the command opensipsdbctl.		"config vars" section of the command opensipsdbctl.

			opensipsdbctl pframework create .......................(creates a sample provisioning framework file)


	==Inisialisasi Database==		==Inisialisasi Database==

	Membuat [[database]] opensips. Pastikan perintah opensipsdbctl di jalankan dari folder /usr/local/~~src~~/opensips~~-1.10.0-tls/scripts~~/		Membuat [[database]] opensips. Pastikan perintah opensipsdbctl di jalankan dari folder /usr/local/lib/opensips/opensipsctl

	cd /usr/local/~~src~~/opensips~~-1.10.0-tls/scripts~~/		cd /usr/local/lib/opensips/opensipsctl
	opensipsdbctl create		opensipsdbctl create