15 May
2012
15 May
'12
1:43 p.m.
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. Since you set them to root, it seems the root password
is overwritten.
Reda
On Tue, May 15, 2012 at 7:20 PM, Tim King <tim.compnetwork(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users