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 id=":5fn">
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>