Difference between revisions of "Menggunakan opensipsdbctl"

From OnnoWiki
Jump to navigation Jump to search
(New page: Setup database # vi /usr/local/etc/opensips/opensipsctlrc atau # vi /etc/opensips/opensipsctlrc Pastikan DBENGINE=MYSQL DBHOST=localhost DBNAME=opensips DBRWUSER=opensips)
 
Line 13: Line 13:
 
  DBNAME=opensips
 
  DBNAME=opensips
 
  DBRWUSER=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

Revision as of 17:05, 27 March 2009

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