[Serusers] ser mysql problem

[Abdul Lateef]

Hello,

I opned the serctl and configured to accept the DB
server. But still i i have trouble to start and stop
ser.

here is new log:
Jul  2 22:40:09 localhost ser: WARNING:
fix_socket_list: could not rev. resolve 10.0.0.20 
Jul  2 22:40:09 localhost ser: WARNING:
fix_socket_list: could not rev. resolve 10.0.0.20 
Jul  2 22:40:09 localhost ser[3194]: INFO: udp_init:
SO_RCVBUF is initially 65535 
Jul  2 22:40:09 localhost ser[3194]: INFO: udp_init:
SO_RCVBUF is finally 262142 
Jul  2 22:40:09 localhost ser[3195]: INFO: fifo
process starting: 3195 
Jul  2 22:40:09 localhost ser[3196]:
NOTICE:init_avp_child: no avp_db_url specified ->
feature disabled 
Jul  2 22:40:09 localhost ser[3197]:
NOTICE:init_avp_child: no avp_db_url specified ->
feature disabled 
Jul  2 22:40:09 localhost ser[3198]:
NOTICE:init_avp_child: no avp_db_url specified ->
feature disabled 
Jul  2 22:40:09 localhost ser[3199]:
NOTICE:init_avp_child: no avp_db_url specified ->
feature disabled 
Jul  2 22:40:09 localhost ser[3195]: SER:
open_uac_fifo: fifo server up at /tmp/ser_fifo... 
Jul  2 22:40:09 localhost ser[3195]: WARNING: no
fifo_db_url given - fifo DB commands disabled!



--- harry gaillac <gaillacharry at yahoo.fr> wrote:

> try openserctl
> --- Abdul Lateef <abdul_zu at yahoo.com> a écrit :
> 
> > hi,
> > 
> > I configured ser.cfg to use mysql authuntication
> > withe
> > guide of http://www.onsip.org
> > 
> > but i have some trouble i cannot
> restart/start/stop
> > the ser server using serctl I would like to paste
> > the
> > exactly log of ser.
> > 
> > -------------------
> > Jul  2 21:52:27 localhost ser: WARNING:
> > fix_socket_list: could not rev. resolve 10.0.0.20 
> > Jul  2 21:52:27 localhost ser: WARNING:
> > fix_socket_list: could not rev. resolve 10.0.0.20 
> > Jul  2 21:52:28 localhost ser[2385]: INFO:
> udp_init:
> > SO_RCVBUF is initially 65535 
> > Jul  2 21:52:28 localhost ser[2385]: INFO:
> udp_init:
> > SO_RCVBUF is finally 262142 
> > Jul  2 21:52:28 localhost ser[2385]: ERROR:
> > tcp_init:
> > bind(6, 0x8114d24, 16) on 10.0.0.20: Address
> already
> > in use 
> > Jul  2 21:52:28 localhost ser[2385]: INFO: signal
> 15
> > received 
> > ---------------------------------
> > 
> > 
> > here is the main configuration of file.
> > 
> > debug=3
> > fork=yes
> > log_stderror=no
> > 
> > listen=10.0.0.20          # put your server IP
> > address
> > here
> > port=5060
> > children=4
> > 
> > dns=no
> > rev_dns=no
> > 
> > fifo="/tmp/ser_fifo"
> > fifo_db_url="mysql://root:123@10.0.0.26/ser"
> > 
> > loadmodule "/usr/local/lib/ser/modules/mysql.so"
> > loadmodule "/usr/local/lib/ser/modules/sl.so"
> > loadmodule "/usr/local/lib/ser/modules/tm.so"
> > loadmodule "/usr/local/lib/ser/modules/rr.so"
> > loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
> > loadmodule "/usr/local/lib/ser/modules/usrloc.so"
> > loadmodule
> "/usr/local/lib/ser/modules/registrar.so"
> > loadmodule "/usr/local/lib/ser/modules/auth.so"
> > loadmodule "/usr/local/lib/ser/modules/auth_db.so"
> > loadmodule "/usr/local/lib/ser/modules/uri_db.so"
> > 
> > modparam("auth_db|uri_db|usrloc", "db_url",
> > "mysql://root:123@10.0.0.26/ser")
> > modparam("auth_db", "calculate_ha1", 1)
> > modparam("auth_db", "password_column", "password")
> > modparam("usrloc", "db_mode", 2)
> > modparam("rr", "enable_full_lr", 1)
> > 
> > 
> > Yours,
> > Abdul Lateef
> > Computer Programmer
> > HATIF COM
> > Mob: +974 - 5405022
> > Tel: +974 - 4883068
> > ICQ: 276994704
> > YM!: abdul_zu
> > Fax: +974 - 4883063
> > Doha Qatar
> > http://www.hatif.com
> > 
> > 
> > 		
> >
> ____________________________________________________
> > 
> > Yahoo! Sports 
> > Rekindle the Rivalries. Sign up for Fantasy
> Football
> > 
> > http://football.fantasysports.yahoo.com
> > 
> > _______________________________________________
> > Serusers mailing list
> > serusers at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers
> > 
> 
> 
> 
> 	
> 
> 	
> 		
>
___________________________________________________________________________
> 
> Appel audio GRATUIT partout dans le monde avec le
> nouveau Yahoo! Messenger 
> Téléchargez cette version sur
> http://fr.messenger.yahoo.com
> 


Yours,
Abdul Lateef
Computer Programmer
HATIF COM
Mob: +974 - 5405022
Tel: +974 - 4883068
ICQ: 276994704
YM!: abdul_zu
Fax: +974 - 4883063
Doha Qatar
http://www.hatif.com


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Helps protect you from nasty viruses. 
http://promotions.yahoo.com/new_mail