On Tue, May 15, 2012 at 7:20 PM, Tim King
<tim.compnetwork@gmail.com> wrote:
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 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?
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