[Serusers] ser mysql problem - SER Mysql HowTo

Greger V. Teigre greger at teigre.com
Sun Jul 10 11:12:48 CEST 2005 

Kofi,
If you suggest changes, improvements, or additions to the ONsip.org 
document, we will be happy to take them.  I'm not sure if another mysql 
setup document is really needed, but if you are thinking about a mysql 
specific tutorial for those who know nothing about mysql, that's probably 
useful for some.
    BTW, did you have all these problems using the ONsip.org document, 
config files, and Getting Started source package??
g-)

Kofi Obiri-Yeboah wrote:
> 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
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers

More information about the sr-users mailing list