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.
INFO: test server charset INFO: creating database openser ... ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ERROR: Creating core tables failed! It creates the database but than fails. 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? This is the relevant content of my kamctlrc file: # $Id$ # # The Kamailio configuration file for the control tools. # # Here you can set variables used in the kamctl and kamdbctl setup # scripts. Per default all variables here are commented out, the control tools # will use their internal default values. ## your SIP domain SIP_DOMAIN=sbc.mydomain.net ## chrooted directory # $CHROOT_DIR="/path/to/chrooted/directory" ## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, DBTEXT, or SQLITE # by default none is loaded # # If you want to setup a database with kamdbctl, you must at least specify # this parameter. DBENGINE=MYSQL ## database host DBHOST=localhost ## database name (for ORACLE this is TNS name) DBNAME=openser # database path used by dbtext, db_berkeley or sqlite # DB_PATH="/usr/local/etc/kamailio/dbtext" ## database read/write user DBRWUSER=root ## password for database read/write user DBRWPW="mypassword" ## database read only user DBROUSER=root ## password for database read only user DBROPW="mypassword" ## database super user (for ORACLE this is 'scheme-creator' user) DBROOTUSER="root"
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
