[OpenSIPS-Users] ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

vivid333 vivid333 at 163.com
Fri Jan 4 09:54:36 CET 2013


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130104/78e254b4/attachment.htm>


More information about the Users mailing list