[Serusers] ser mysql problem - SER Mysql HowTo

Kofi Obiri-Yeboah kofi at radiocomplex.com
Fri Jul 8 21:16:44 CEST 2005


I have been following this list for a while now. It is my observation that
the mySQL setup part is a major issue for practically everyone. I went
through "a very tough time"  the first time around, myself. I am therefore
volunteering to do a MySQL-Ser Database Howto. What this is going to entail
will be how to setup mySQL client and server properly for a start, how to
generate the appropriate tables, how to check and ensure that the
appropriate users and permissions are set. After that someone else can take
over from there. I am currently compiling my notes on Fedora Core 3. I will
be happy to release my notes as I go along or wait and release at
completion. Please comment.

Cheers

KOFI

-----Original Message-----
From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org]On
Behalf Of Jan Janak
Sent: Friday, July 08, 2005 11:30 AM
To: Abdul Lateef
Cc: serusers at lists.iptel.org
Subject: Re: [Serusers] ser mysql problem


I am not sure if serctl start/stop works well. I would recommend to use
the standard startup scripts for your distribution. They are typically
in /etc/ini.d on SysV based systems (debian, redhat, fedora).

  Jan.

On 02-07-2005 12:57, Abdul Lateef wrote:
> I tried the all following commonds.
>
> [root at localhost root]# /usr/local/sbin/serctl stop
> Stopping SER : /usr/local/sbin/serctl: kill: (1513) -
> No such process
> stopped
> [root at localhost root]# /usr/local/sbin/serctl start
>
> Starting SER : PID file exists! (/var/run/ser.pid)
> already running?
> [root at localhost root]# killall ser
> [root at localhost root]# /usr/local/sbin/serctl start
>
> Starting SER : PID file exists! (/var/run/ser.pid)
> already running?
> [root at localhost root]#
>
>
>
> --- Iqbal <iqbal at gigo.co.uk> wrote:
>
> >
> > how r u trying to stop it
> >
> > Iqbal
> >
> > On 7/2/2005, "Abdul Lateef" <abdul_zu at yahoo.com>
> > wrote:
> >
> > >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
> > >
> >
> === message truncated ===
>
>
> 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

_______________________________________________
Serusers mailing list
serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers




More information about the sr-users mailing list