Menggunakan opensipsdbctl: Difference between revisions
From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs) New page: Setup database # vi /usr/local/etc/opensips/opensipsctlrc atau # vi /etc/opensips/opensipsctlrc Pastikan DBENGINE=MYSQL DBHOST=localhost DBNAME=opensips DBRWUSER=opensips |
Onnowpurbo (talk | contribs) No edit summary |
||
| 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 10: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