Menggunakan opensipsdbctl

From OnnoWiki
Revision as of 17:05, 27 March 2009 by Onnowpurbo (talk | contribs)
Jump to navigation Jump to search

Setup database

# vi /usr/local/etc/opensips/opensipsctlrc 

atau

# vi /etc/opensips/opensipsctlrc 

Pastikan

DBENGINE=MYSQL
DBHOST=localhost
DBNAME=opensips
DBRWUSER=opensips

Pastikan MySQL beroperasi

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

Buat MySQL database

# mysql -u root -p
Enter password:
mysql> create database opensips;
mysql> grant INSERT,SELECT on root.* to opensips@localhost;
mysql> grant CREATE, INSERT, SELECT, DELETE, UPDATE on opensips.* to opensips@localhost identified by 'opensipspass';
mysql> grant CREATE, INSERT, SELECT, DELETE, UPDATE on opensips.* to opensips identified by 'opensipspass';
mysql> exit