Difference between revisions of "Menggunakan opensipsdbctl"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | Jika kita menggunakan database, maka kita perlu melakukan setup [[database]]. | ||
| + | |||
| + | |||
Setup [[database]] | Setup [[database]] | ||
| Line 20: | Line 23: | ||
Pastikan MySQL beroperasi | Pastikan MySQL beroperasi | ||
| − | + | sudo su | |
| − | + | /etc/init.d/mysql restart | |
==Menu Help== | ==Menu Help== | ||
| − | + | cd /usr/local/lib/opensips/opensipsctl | |
| + | 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> | + | usage: opensipsdbctl create <db name or db_path, optional> ...(creates a new database) |
| − | opensipsdbctl | + | opensipsdbctl drop <db name or db_path, optional> .....(!entirely deletes tables!) |
| − | opensipsdbctl reinit <db name or db_path, optional> | + | opensipsdbctl reinit <db name or db_path, optional> ...(!entirely deletes and then re-creates tables!) |
| − | opensipsdbctl backup <file> | + | opensipsdbctl backup <file> ...........................(dumps current database to file) |
| − | opensipsdbctl restore <file> | + | opensipsdbctl restore <file> ..........................(restores tables from a file) |
| − | opensipsdbctl copy <new_db> | + | opensipsdbctl copy <new_db> ...........................(creates a new db from an existing one) |
| − | opensipsdbctl migrate <old_db> <new_db> | + | opensipsdbctl migrate <old_db> <new_db> ...............(migrates DB from 2.1.x to 2.2.x) |
| − | opensipsdbctl presence | + | opensipsdbctl presence ................................(adds the presence related tables) |
| − | opensipsdbctl extra | + | 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/ | + | Membuat [[database]] opensips. Pastikan perintah opensipsdbctl di jalankan dari folder /usr/local/lib/opensips/opensipsctl |
| − | cd /usr/local/ | + | cd /usr/local/lib/opensips/opensipsctl |
opensipsdbctl create | opensipsdbctl create | ||
Latest revision as of 17:16, 21 October 2016
Jika kita menggunakan database, maka kita perlu melakukan setup database.
Setup database
vi /usr/local/etc/opensips/opensipsctlrc
atau
vi /etc/opensips/opensipsctlrc
Pastikan
DBENGINE=MYSQL DBHOST=localhost DBROUSER=opensipsro DBROPW=opensipsro DBNAME=opensips DBRWUSER=opensips DBRWPW="opensipsrw" DBROOTUSER="root"
Pastikan MySQL beroperasi
sudo su /etc/init.d/mysql restart
Menu Help
cd /usr/local/lib/opensips/opensipsctl opensipsdbctl -h
MySQL password for root:
/usr/local/sbin/opensipsdbctl $Revision: 3997 $
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 reinit <db name or db_path, optional> ...(!entirely deletes and then re-creates tables!)
opensipsdbctl backup <file> ...........................(dumps current database to file)
opensipsdbctl restore <file> ..........................(restores tables from a file)
opensipsdbctl copy <new_db> ...........................(creates a new db from an existing one)
opensipsdbctl migrate <old_db> <new_db> ...............(migrates DB from 2.1.x to 2.2.x)
opensipsdbctl presence ................................(adds the presence related tables)
opensipsdbctl extra ...................................(adds the extra tables)
if you want to manipulate database as other database user than
root, want to change database name from default value "opensips",
or want to use other values for users and password, edit the
"config vars" section of the command opensipsdbctl.
opensipsdbctl pframework create .......................(creates a sample provisioning framework file)
Inisialisasi Database
Membuat database opensips. Pastikan perintah opensipsdbctl di jalankan dari folder /usr/local/lib/opensips/opensipsctl
cd /usr/local/lib/opensips/opensipsctl opensipsdbctl create
MySQL password for root:
INFO: test server charset INFO: creating database opensips ... INFO: Core OpenSIPS tables succesfully created.
Install presence related tables? (y/n): y
INFO: creating presence tables into opensips ... INFO: Presence tables succesfully created.
Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist registrant? (y/n): y
INFO: creating extra tables into opensips ... INFO: Extra tables succesfully created.
Cek Database
Cek apakah opensips database telah terbuat
mysqlshow -u root -p
Akan keluar tampilan kira-kira
+--------------------+ | Databases | +--------------------+ | information_schema | | mysql | | opensips | | performance_schema | | test | +--------------------+
Delete / Drop Database
Jika ada masalah dengan database & kita perlu mendelete database yang lama, maka lakukan perintah
mysql -u root -p Enter password: mysql> drop database opensips; mysql> quit