10 Jul
2005
10 Jul
'05
5:12 a.m.
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(a)iptel.org [mailto:serusers-bounces@lists.iptel.org]On
Behalf Of Jan Janak
Sent: Friday, July 08, 2005 11:30 AM
To: Abdul Lateef
Cc: serusers(a)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@localhost root]# /usr/local/sbin/serctl stop
Stopping SER : /usr/local/sbin/serctl: kill: (1513) -
No such process
stopped
[root@localhost root]# /usr/local/sbin/serctl start
Starting SER : PID file exists! (/var/run/ser.pid)
already running?
[root@localhost root]# killall ser
[root@localhost root]# /usr/local/sbin/serctl start
Starting SER : PID file exists! (/var/run/ser.pid)
already running?
[root@localhost root]#
--- Iqbal <iqbal(a)gigo.co.uk> wrote:
=== 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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
how r u trying to stop it
Iqbal
On 7/2/2005, "Abdul Lateef" <abdul_zu(a)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(a)yahoo.fr> wrote:
> try openserctl
> --- Abdul Lateef <abdul_zu(a)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(a)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.