ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

vivid333
Hi,
     server1(opensips_localip)   ------>   server2(mysql_remoteip)
     my opensips's script works(can connect to mysql server, and register is ok)
      such as:
               modparam("usrloc", "db_url","mysql://opensips:opensipsrw@remoteip/opensips")

 if I use following operation,mysql connections works(that means mysql  Server configurations is correct)
        #mysql -uroot -hremote_ip -p
          Enter password:
          Welcome to the MySQL monitor.  Commands end with ; or \g.
          Your MySQL connection id is 11831
          Server version: 5.0.77 Source distribution

          Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

          Oracle is a registered trademark of Oracle Corporation and/or its
          affiliates. Other names may be trademarks of their respective  owners.

          Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
          mysql>


//////////////////////////////////////////////////////////////////////////////
but when i do following instruction
    # opensipsctl ul show
        /etc/opensips/opensipsctlrc: 23: DBHOST: not found
        //etc/opensips//opensipsctlrc: 23: DBHOST: not found
        /etc/opensips/opensipsctlrc: line 23: DBHOST: command not found
        //etc/opensips//opensipsctlrc: line 23: DBHOST: command not found
        Cannot load core functions '/sbin/opensipsctl.base' - exiting ...


    # ./opensipsdbctl create
        /etc/opensips/opensipsctlrc: 23: DBHOST: not found
        /usr/local/etc/opensips/opensipsctlrc: 23: DBHOST: not found
        /etc/opensips/opensipsctlrc: line 23: DBHOST: command not found
        /usr/local/etc/opensips/opensipsctlrc: line 23: DBHOST: command not found
        MySQL password for root:       (I am sure password here is correct)
        INFO: test server charset
        ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
        ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
        Usage: grep [OPTION]... PATTERN [FILE]...
        Try `grep --help' for more information.
        ./opensipsdbctl.mysql: line 114: [: =: unary operator expected
        INFO: creating database opensips ...
        ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
        ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
        ERROR: Creating core database and grant privileges failed!




////////////////////////////////////////////////////////////// # cat /etc/opensips/opensipsctlrc
# $Id: opensipsctlrc 7337 2010-10-28 22:02:46Z osas $
#
# The OpenSIPS configuration file for the control tools.
#
# Here you can set variables used in the opensipsctl and opensipsdbctl setup
# scripts. Per default all variables here are commented out, the control tools
# will use their internal default values.

## your SIP domain
 SIP_DOMAIN=remoteip

## chrooted directory
# $CHROOT_DIR="/path/to/chrooted/directory"

## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, or DBTEXT,
## by default none is loaded
# If you want to setup a database with opensipsdbctl, you must at least specify
# this parameter.
 DBENGINE=MYSQL

## database host
#DBHOST=localhost
DBHOST = remoteip
## database name (for ORACLE this is TNS name)
 DBNAME=opensips

# database path used by dbtext or db_berkeley
 DB_PATH="/usr/local/etc/opensips/dbtext"

## database read/write user
 DBRWUSER=opensips

## password for database read/write user
 DBRWPW="opensipsrw"

## database read only user
 DBROUSER=opensipsro

## password for database read only user
 DBROPW=opensipsro

## database super user (for ORACLE this is 'scheme-creator' user)
 DBROOTUSER="root"

# user name column
 USERCOL="username"


# SQL definitions
# If you change this definitions here, then you must change them
# in db/schema/entities.xml too.
# FIXME

# FOREVER="2020-05-28 21:32:15"
# DEFAULT_ALIASES_EXPIRES=$FOREVER
# DEFAULT_Q="1.0"
# DEFAULT_CALLID="Default-Call-ID"
# DEFAULT_CSEQ="13"
# DEFAULT_LOCATION_EXPIRES=$FOREVER


# Program to calculate a message-digest fingerprint
# MD5="md5sum"

# awk tool
# AWK="awk"

# grep tool
# GREP="grep"

# sed tool
# SED="sed"


# Describe what additional tables to install. Valid values for the variables
# below are yes/no/ask. With ask (default) it will interactively ask the user
# for an answer, while yes/no allow for automated, unassisted installs.
#

# If to install tables for the modules in the EXTRA_MODULES variable.
# INSTALL_EXTRA_TABLES=ask

# If to install presence related tables.
# INSTALL_PRESENCE_TABLES=ask

# Define what module tables should be installed.
# If you use the postgres database and want to change the installed tables,
# then you must also adjust the STANDARD_TABLES or EXTRA_TABLES variable
# accordingly in the opensipsdbctl.base script.

# opensips standard modules
# STANDARD_MODULES="standard acc lcr domain group permissions registrar usrloc
#                   msilo alias_db uri_db speeddial avpops auth_db pdt dialog
#                   dispatcher dialplan drouting nathelper load_balancer"

# opensips extra modules
# EXTRA_MODULES="imc cpl siptrace domainpolicy carrierroute userblacklist b2b"


## type of aliases used: DB - database aliases; UL - usrloc aliases
## - default: none
# ALIASES_TYPE="DB"

## control engine: FIFO or UNIXSOCK
## - default FIFO
# CTLENGINE=xmlrpc

## path to FIFO file
 OSIPS_FIFO="/tmp/opensips_fifo"

## MI_CONNECTOR control engine: FIFO, UNIXSOCK, UDP, XMLRPC
 MI_CONNECTOR=FIFO:/tmp/opensips_fifo
# MI_CONNECTOR=UNIXSOCK:/tmp/opensips.sock
# MI_CONNECTOR=UDP:192.168.2.133:8000
# MI_CONNECTOR=XMLRPC:192.168.2.133:8000

## check ACL names; default on (1); off (0)
# VERIFY_ACL=1

## ACL names - if VERIFY_ACL is set, only the ACL names from below list
## are accepted
# ACL_GROUPS="local ld int voicemail free-pstn"

## verbose - debug purposes - default '0'
# VERBOSE=1

## do (1) or don't (0) store plaintext passwords
## in the subscriber table - default '1'
# STORE_PLAINTEXT_PW=0

## OPENSIPS START Options
## PID file path - default is: /var/run/opensips.pid
# PID_FILE=/var/run/opensips.pid

## Extra start options - default is: not set
# example: start opensips with 64MB share memory: STARTOPTIONS="-m 64"
# STARTOPTIONS=









 maybe I forget some configurations.
I really don't kown how to solve it,  who can help me, thanks in advance.

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Flavio Goncalves
Sounds silly,but remove the space before the lines. I'm not sure if this is the problem, but I remember once having these problems because of the extra space in front of the statements. DBHOST is certainly a valid command. 

Flavio E. Goncalves

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

vivid333
the same configuration(opensips.cfg/opensipsctlrc) on another server is OK, I am sure the reason is not the extra space between lines.

Sounds silly,but remove the space before the lines. I'm not sure if this is the problem, but I remember once having these problems because of the extra space in front of the statements. DBHOST is certainly a valid command. 

Flavio E. Goncalves

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



To start a new topic under OpenSIPS - Users, email [hidden email]
To unsubscribe from OpenSIPS (Open SIP Server), click here.
NAML

Reply | Threaded
Open this post in threaded view
|

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Julien Chavanton-2
In reply to this post by vivid333
Hi,  before looking at calling an external application, I was wandering.

Is there any way to access the fifo from the routing script ?

More precisely I want to use dlg_end_dlg from the routing script to terminate another dialog
Exported MI Functions of the dialog module dlg_end_dlg

Thanks

On Fri, Jan 4, 2013 at 9:54 AM, vivid333 <[hidden email]> wrote:
Hi,
     server1(opensips_localip)   ------>   server2(mysql_remoteip)
     my opensips's script works(can connect to mysql server, and register is ok)
      such as:
               modparam("usrloc", "db_url","mysql://opensips:opensipsrw@remoteip/opensips")

 if I use following operation,mysql connections works(that means mysql  Server configurations is correct)
        #mysql -uroot -hremote_ip -p
          Enter password:
          Welcome to the MySQL monitor.  Commands end with ; or \g.
          Your MySQL connection id is 11831
          Server version: 5.0.77 Source distribution

          Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

          Oracle is a registered trademark of Oracle Corporation and/or its
          affiliates. Other names may be trademarks of their respective  owners.

          Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
          mysql>


//////////////////////////////////////////////////////////////////////////////
but when i do following instruction
    # opensipsctl ul show
        /etc/opensips/opensipsctlrc: 23: DBHOST: not found
        //etc/opensips//opensipsctlrc: 23: DBHOST: not found
        /etc/opensips/opensipsctlrc: line 23: DBHOST: command not found
        //etc/opensips//opensipsctlrc: line 23: DBHOST: command not found
        Cannot load core functions '/sbin/opensipsctl.base' - exiting ...


    # ./opensipsdbctl create
        /etc/opensips/opensipsctlrc: 23: DBHOST: not found
        /usr/local/etc/opensips/opensipsctlrc: 23: DBHOST: not found
        /etc/opensips/opensipsctlrc: line 23: DBHOST: command not found
        /usr/local/etc/opensips/opensipsctlrc: line 23: DBHOST: command not found
        MySQL password for root:       (I am sure password here is correct)
        INFO: test server charset
        ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
        ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
        Usage: grep [OPTION]... PATTERN [FILE]...
        Try `grep --help' for more information.
        ./opensipsdbctl.mysql: line 114: [: =: unary operator expected
        INFO: creating database opensips ...
        ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
        ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
        ERROR: Creating core database and grant privileges failed!




////////////////////////////////////////////////////////////// # cat /etc/opensips/opensipsctlrc
# $Id: opensipsctlrc 7337 2010-10-28 22:02:46Z osas $
#
# The OpenSIPS configuration file for the control tools.
#
# Here you can set variables used in the opensipsctl and opensipsdbctl setup
# scripts. Per default all variables here are commented out, the control tools
# will use their internal default values.

## your SIP domain
 SIP_DOMAIN=remoteip

## chrooted directory
# $CHROOT_DIR="/path/to/chrooted/directory"

## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, or DBTEXT,
## by default none is loaded
# If you want to setup a database with opensipsdbctl, you must at least specify
# this parameter.
 DBENGINE=MYSQL

## database host
#DBHOST=localhost
DBHOST = remoteip
## database name (for ORACLE this is TNS name)
 DBNAME=opensips

# database path used by dbtext or db_berkeley
 DB_PATH="/usr/local/etc/opensips/dbtext"

## database read/write user
 DBRWUSER=opensips

## password for database read/write user
 DBRWPW="opensipsrw"

## database read only user
 DBROUSER=opensipsro

## password for database read only user
 DBROPW=opensipsro

## database super user (for ORACLE this is 'scheme-creator' user)
 DBROOTUSER="root"

# user name column
 USERCOL="username"


# SQL definitions
# If you change this definitions here, then you must change them
# in db/schema/entities.xml too.
# FIXME

# FOREVER="2020-05-28 21:32:15"
# DEFAULT_ALIASES_EXPIRES=$FOREVER
# DEFAULT_Q="1.0"
# DEFAULT_CALLID="Default-Call-ID"
# DEFAULT_CSEQ="13"
# DEFAULT_LOCATION_EXPIRES=$FOREVER


# Program to calculate a message-digest fingerprint
# MD5="md5sum"

# awk tool
# AWK="awk"

# grep tool
# GREP="grep"

# sed tool
# SED="sed"


# Describe what additional tables to install. Valid values for the variables
# below are yes/no/ask. With ask (default) it will interactively ask the user
# for an answer, while yes/no allow for automated, unassisted installs.
#

# If to install tables for the modules in the EXTRA_MODULES variable.
# INSTALL_EXTRA_TABLES=ask

# If to install presence related tables.
# INSTALL_PRESENCE_TABLES=ask

# Define what module tables should be installed.
# If you use the postgres database and want to change the installed tables,
# then you must also adjust the STANDARD_TABLES or EXTRA_TABLES variable
# accordingly in the opensipsdbctl.base script.

# opensips standard modules
# STANDARD_MODULES="standard acc lcr domain group permissions registrar usrloc
#                   msilo alias_db uri_db speeddial avpops auth_db pdt dialog
#                   dispatcher dialplan drouting nathelper load_balancer"

# opensips extra modules
# EXTRA_MODULES="imc cpl siptrace domainpolicy carrierroute userblacklist b2b"


## type of aliases used: DB - database aliases; UL - usrloc aliases
## - default: none
# ALIASES_TYPE="DB"

## control engine: FIFO or UNIXSOCK
## - default FIFO
# CTLENGINE=xmlrpc

## path to FIFO file
 OSIPS_FIFO="/tmp/opensips_fifo"

## MI_CONNECTOR control engine: FIFO, UNIXSOCK, UDP, XMLRPC
 MI_CONNECTOR=FIFO:/tmp/opensips_fifo
# MI_CONNECTOR=UNIXSOCK:/tmp/opensips.sock
# MI_CONNECTOR=UDP:192.168.2.133:8000
# MI_CONNECTOR=XMLRPC:192.168.2.133:8000

## check ACL names; default on (1); off (0)
# VERIFY_ACL=1

## ACL names - if VERIFY_ACL is set, only the ACL names from below list
## are accepted
# ACL_GROUPS="local ld int voicemail free-pstn"

## verbose - debug purposes - default '0'
# VERBOSE=1

## do (1) or don't (0) store plaintext passwords
## in the subscriber table - default '1'
# STORE_PLAINTEXT_PW=0

## OPENSIPS START Options
## PID file path - default is: /var/run/opensips.pid
# PID_FILE=/var/run/opensips.pid

## Extra start options - default is: not set
# example: start opensips with 64MB share memory: STARTOPTIONS="-m 64"
# STARTOPTIONS=









 maybe I forget some configurations.
I really don't kown how to solve it,  who can help me, thanks in advance.

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users