Hi Felipe, use "opensips -f cfg_file" when starting OpenSIPS.
Regards, Bogdan Felipe R. Pasa wrote: > Hi Bogdan > > the file is /etc/opensips/opensips.cfg > i change the opensips user to root > and than work!, but i dont understand why the opensips user didnt. > whatever. > > when you tell me about " -f " , what is this? where i use this option > > Thanks. > > > > 2009/2/6 Bogdan-Andrei Iancu <[email protected]>: > >> Hi Felipe, >> >> If using the same values (host, username, passwd) from myql cli works, than >> be sure you are using the cfg file you are editing. be explicit and pass >> with "-f" the cfg file you are working on. >> >> Regards, >> Bogdan >> >> Felipe R. Pasa wrote: >> >>> Hi Folks, >>> >>> I am new in opensips and i have making some tests with this greate >>> software, >>> >>> my objective is make all UA register in a mysql database, for this >>> i set some modparam in /etc/opensips/opensips.cfg >>> >>> ================= >>> modparam("usrloc", "db_mode", 2) >>> modparam("usrloc", "db_url", >>> "mysql://opensips:[email protected]/opensips") >>> >>> modparam("auth_db", "calculate_ha1", yes) >>> modparam("auth_db", "password_column", "password") >>> modparam("auth_db", "db_url", >>> "mysql://opensips:[email protected]/opensips") >>> modparam("auth_db", "load_credentials", "") >>> =============== >>> >>> in a manual connection with mysql the user and password are correct. >>> stoping and starting with openserctl start the log says... >>> >>> ================ >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: >>> DBG:textops:fixup_method: using id for method [CANCEL/2] >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: DBG:core:fix_actions: >>> fixing t_check_trans, line 174 >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: DBG:core:fix_actions: >>> fixing t_relay, line 175 >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: DBG:core:fix_actions: >>> fixing t_check_trans, line 179 >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: DBG:core:fix_actions: >>> fixing proxy_authorize, line 184 >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: DBG:core:db_do_init: >>> connection 0x735568 not found in pool >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: >>> DBG:db_mysql:db_mysql_new_connection: opening connection: >>> mysql://xxxx:[email protected]/opensips >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: >>> ERROR:db_mysql:db_mysql_new_connection: driver error: Access denied >>> for user 'opensips'@'localhost' (using password: YES) >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: ERROR:core:db_do_init: >>> could not add connection to the pool >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: >>> ERROR:auth_db:auth_fixup: unable to open database connection >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: ERROR:core:fix_actions: >>> fixing failed (code=-1) at cfg line 184 >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: CRITICAL:core:fix_expr: >>> fix_actions error >>> Feb 6 12:58:33 sip /usr/sbin/opensips[8058]: ERROR:core:main: failed >>> to fix configuration with err code -1 >>> ================== >>> >>> Thanks in advance. >>> >>> >>> >>> >>> >>> >> > > > > _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
