[SR-Users] kamdbctl create changing mysql root password

[Reda Aouad]

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 at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120515/cbca8c93/attachment.htm>