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

[Julien Chavanton]

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 <vivid333 at 163.com> 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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130104/e3eb5bc1/attachment.htm>