<div dir="ltr"><font color="#3366ff"><font><font face="tahoma,sans-serif">DBRWUSER and DBROUSER are users created by kamdbctl to access the kamailio database. They should be like kamalioro and kamailiorw or whatever you want, but not root. </font></font></font><span style="color:rgb(51,102,255);font-family:tahoma,sans-serif">Since you set them to root, it seems the root password is overwritten.</span><div>
<div><div dir="ltr"><font color="#3366ff" face="tahoma, sans-serif"><br></font><div><font color="#3366ff" face="tahoma, sans-serif">Reda</font></div></div><br>
<br><br><div class="gmail_quote">On Tue, May 15, 2012 at 7:20 PM, Tim King <span dir="ltr"><<a href="mailto:tim.compnetwork@gmail.com" target="_blank">tim.compnetwork@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
This is not the first time I have had this issue during installation,
but this time around I am having difficulty figuring out what I am doing
wrong. Mysql is up and working, and client works. I can connect to it
with the client and run queries without issue. When I run kamdbctl
create I get the following.<br>
<br>INFO: test server charset<br>INFO: creating database openser ...<br>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)<br>ERROR: Creating core tables failed!<br><br>It
creates the database but than fails to create tables. From this point I can no longer
connect to mysql with what was my root password. I have to go through
the process of resetting my root password before I can log back into
mysql. How is this script chaning or corrupting my mysql root password?<br>
<br>This is the relevant content of my kamctlrc file:<br><br># $Id$<br>#<br># The Kamailio configuration file for the control tools.<br>#<br># Here you can set variables used in the kamctl and kamdbctl setup<br># scripts. Per default all variables here are commented out, the control tools<br>
# will use their internal default values.<br><br>## your SIP domain<br>SIP_DOMAIN=<a href="http://sbc.mydomain.net" target="_blank">sbc.mydomain.net</a><br><br>## chrooted directory<br># $CHROOT_DIR="/path/to/<div>
chrooted/directory"<br>
<br>## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, DBTEXT, or SQLITE<br># by default none is loaded<br>#<br># If you want to setup a database with kamdbctl, you must at least specify<br># this parameter.<br>DBENGINE=MYSQL<br>
<br>## database host<br>DBHOST=localhost<br><br>## database name (for ORACLE this is TNS name)<br>DBNAME=openser<br><br># database path used by dbtext, db_berkeley or sqlite<br># DB_PATH="/usr/local/etc/kamailio/dbtext"<br>
<br>## database read/write user<br>DBRWUSER=root<br><br>## password for database read/write user<br>DBRWPW="mypassword"<br><br>## database read only user<br>DBROUSER=root<br><br>## password for database read only user<br>
DBROPW="mypassword"<br><br>## database super user (for ORACLE this is 'scheme-creator' user)<br>DBROOTUSER="root"</div>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div></div></div>