When installing SER and configuring it to work with MySQL. Do I need to create the database and tables or there is a script that can do it for me.
Also, how do I uninstall SER?
I am sure that someone can help me!!!
Thanks,
__________________________________
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50 15 19
Mobile: +250-08517768
Email: dg(a)nefacomp.net
http://www.nefacomp.net/
I think I should post this to the PHP or MySQL mail list but if anyone can help me, please.
Below is the error message I am getting while trying to open serweb.
Fatal error: Call to undefined function: mysql_pconnect() in /var/www/phplib/db_mysql.inc on line 73
I have not tried to see if other PHP-MYSQL stuffs work.
Please help me
__________________________________
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50 15 19
Mobile: +250-08517768
Email: dg(a)nefacomp.net
http://www.nefacomp.net/
Would someone mind passing along a url for Radius software that is known
to function with Ser?
I can either rpm it or compile from source (RH v9).
Rich
I am dealing with one NetBsd and a FreeBsd... Now the question is for
the second one, I uncommented this line: loadmodule
"/usr/local/lib/ser/modules/mysql.so" only (just testing if it can find
the mysql module). I got:
0(95642) ERROR: load_module: could not open module
</usr/local/lib/ser/modules/mysql.so>: Shared object
"libmysqlclient.so.10" not found
0(95642) parse error (22,13-49): failed to load module
ERROR: bad config file (1 errors)
==
file libmysqlclient.so.10
libmysqlclient.so.10: ELF 32-bit LSB shared object, Intel 80386, version
1 (FreeBSD), not stripped
==
/usr/local/mysql/lib/mysql
-rwxr-xr-x 1 root mysql 136729 Jun 30 22:23 libmysqlclient.so.10
==
modules/mysql/Makefile
# $Id: Makefile,v 1.15 2002/11/12 12:32:17 andrei Exp $
...
LIBS=-L/usr/lib/mysql -L /usr/local/lib -L/usr/local/lib/mysql \
-L/usr/local/mysql/lib/mysql/ \
-lmysqlclient -lz
All seemed to be OK but not, any help is highly appreciated.
Thanks,
Marcelo.
-----Original Message-----
From: Andrei Pelinescu-Onciul
[mailto:pelinescu-onciul@fokus.fraunhofer.de]
Sent: Wednesday, July 02, 2003 1:13 PM
To: Marcelo Schmidt
Cc: serusers(a)lists.iptel.org
Subject: Re: [Serusers] Mysql.so
On Jul 02, 2003 at 11:57, Marcelo Schmidt <mschmidt(a)equinix.com> wrote:
> Like I said, I used: exclude_modules="" modules --no errors, ser is
> running but I don't see any mysql.so under modules, I thought that it
> wouldn't matter since the mysql's binaries are already installed but
> when I tried to include the very first line: loadmodule
> "/usr/local/lib/ser/modules/mysql.so" then the configuration
> complains. If I am missing something please let me know.
You have to run make install in the same way as make modules: make
exclude_modules="" install or make include_modules=mysql install
(to install only the mysql module you need only:
make modules=modules/mysql install )
Andrei
(you forgot to CC the mailing list)
a possibility is that the contacts you registered cause a loop.
andy
At 06:22 PM 6/24/2003, Chintan Thakker wrote:
>Hi,
> Seems I missed something, I am sending INVITE to sip:9727610001@192.1.2.17 with Route: <sip:192.1.2.17;lr> to the proxy server ('ser') running on 192.1.2.17 and getting 483 - too many hops message. I modified ser.conf to add alias = "192.1.2.17" but it still gives me the same problem.
> What am I missing out ?. I guess an 'alias=192.1.2.17' entry should return a true to 'uri==myself' matching performed in the script and make the server process that request rather than forwarding it (to itself in this case)
>
>Thanks,
>Chintan
>
>-- ser.cfg --
>
> 1 #
> 2 # $Id: ser.cfg,v 1.20 2003/05/31 21:12:19 jiri Exp $
> 3 #
> 4 # simple quick-start config script
> 5 #
> 6
> 7 # ----------- global configuration parameters ------------------------
> 8
> 9 debug=3 # debug level (cmd line: -dddddddddd)
> 10 fork=yes
> 11 log_stderror=no # (cmd line: -E)
> 12
> 13 /* Uncomment these lines to enter debugging mode
> 14 debug=7
> 15 fork=no
> 16 log_stderror=yes
> 17 */
> 18
> 19 check_via=no # (cmd. line: -v)
> 20 dns=no # (cmd. line: -r)
> 21 rev_dns=no # (cmd. line: -R)
> 22 port=5060
> 23 children=4
> 24 fifo="/tmp/ser_fifo"
> 25
> 26 # ------------------ module loading ----------------------------------
> 27
> 28 # Uncomment this if you want to use SQL database
> 29 #loadmodule "/usr/local/lib/ser/modules/mysql.so"
> 30
> 31 loadmodule "/usr/local/lib/ser/modules/sl.so"
> 32 loadmodule "/usr/local/lib/ser/modules/tm.so"
> 33 loadmodule "/usr/local/lib/ser/modules/rr.so"
> 34 loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
> 35 loadmodule "/usr/local/lib/ser/modules/usrloc.so"
> 36 loadmodule "/usr/local/lib/ser/modules/registrar.so"
> 37
> 38 # Uncomment this if you want digest authentication
> 39 # mysql.so must be loaded !
> 40 #loadmodule "/usr/local/lib/ser/modules/auth.so"
> 41 #loadmodule "/usr/local/lib/ser/modules/auth_db.so"
> 42
> 43 # ----------------- setting module-specific parameters ---------------
> 44
> 45 # -- usrloc params --
> 46
> 47 modparam("usrloc", "db_mode", 0)
> 48
> 49 # Uncomment this if you want to use SQL database
> 50 # for persistent storage and comment the previous line
> 51 #modparam("usrloc", "db_mode", 2)
> 52
> 53 # -- auth params --
> 54 # Uncomment if you are using auth module
> 55 #
> 56 #modparam("auth_db", "calculate_ha1", yes)
> 57 #
> 58 # If you set "calculate_ha1" parameter to yes (which true in this config),
> 59 # uncomment also the following parameter)
> 60 #
> 61 #modparam("auth_db", "password_column", "password")
> 62
> 63 # ------------------------- request routing logic -------------------
> 64
> 65 #add aliases
> 66 alias="192.1.2.17"
> 67
> 68 # main routing logic
> 69
> 70 route{
> 71
> 72 # initial sanity checks -- messages with
> 73 # max_forwards==0, or excessively long requests
> 74 if (!mf_process_maxfwd_header("10")) {
> 75 sl_send_reply("483","Too Many Hops");
> 76 break;
> 77 };
> 78 if (len_gt( max_len )) {
> 79 sl_send_reply("513", "Message too big");
> 80 break;
> 81 };
> 82
> 83 # we record-route all messages -- to make sure that
> 84 # subsequent messages will go through our proxy; that's
> 85 # particularly good if upstream and downstream entities
> 86 # use different transport protocol
> 87 record_route();
> 88 # loose-route processing
> 89 if (loose_route()) {
> 90 t_relay();
> 91 break;
> 92 };
> 93
> 94 # if the request is for other domain use UsrLoc
> 95 # (in case, it does not work, use the following command
> 96 # with proper names and addresses in it)
> 97 if (uri==myself) {
> 98
> 99 if (method=="REGISTER") {
> 100
> 101 # Uncomment this if you want to use digest authentication
> 102 # if (!www_authorize("iptel.org", "subscriber")) {
> 103 # www_challenge("iptel.org", "0");
>
>53,1 65%
> 104 # break;
> 105 # };
> 106
> 107 save("location");
> 108 break;
> 109 };
> 110
> 111 # native SIP destinations are handled using our USRLOC DB
> 112 if (!lookup("location")) {
> 113 sl_send_reply("404", "Not Found");
> 114 break;
> 115 };
> 116 };
> 117 #Let tje server [rpcess tje cirremt reqiest
> 118 #if(uri =~ "^sip:(.+@)?(192\.1\.2\.17)([:;\?].*)?$" )
> 119 #{
> 120 # break;
> 121 #};
> 122
> 123 # forward to current uri now; use stateful forwarding; that
> 124 # works reliably even if we forward from TCP to UDP
> 125 if (!t_relay()) {
> 126 sl_reply_error();
> 127 };
> 128
> 129 }
> 130
>- end ser.cfg --
>Andy Blen wrote:
>
>>most likely a misconfig issue on your side, feel free to read the doc, http://www.iptel.org/ser/doc/prerelease/x1026.html#AEN1032
>>
>>andy
>>
>>At 12:18 AM 6/21/2003, Chintan Thakker wrote:
>>
>>
>>>Hi,
>>>Consider the following scenario. UA1 is trying to call UA2 both registered with the same proxy. (UA1 -> 'ser' -> UA2)
>>>
>>>1.
>>>UA1 sends INVITE to the proxy with request uri set to UA2. It also sets the Route header in the invite to that of the proxy.
>>>This returns a 483 - too many hops to UA1
>>>
>>>It seems that in the above mentioned scenario, the proxy loops back the INVITE multiple times locally. This decrements the Max Forwards value every time until it becomes zero and hence sends 483 back to UA1. It seems to me this is not the correct behavior of the server. It should forward the request to UA2.
>>>
>>>Thanks in advance,
>>>
>>>Chintan
>>>
>>>-- Start trace --
>>>
>>>U 2003/06/20 15:24:42.362466 192.1.2.88:5060 -> 192.1.2.17:5060
>>>INVITE sip:9727610001@192.1.2.17 SIP/2.0.Via: SIP/2.0/UDP 192.1.2.88:5060;b
>>>ranch=z9hG4bK421668676.Max-Forwards: 70.From: 9727619271 <sip:9727619271@19
>>>2.1.2.88>;tag=421668676.To: 9727610001 <sip:9727610001@192.1.2.17>.Call-ID:
>>>421668676(a)192.1.2.88.CSeq: 1 INVITE.Contact: <sip:9727619271@192.1.2.88>.C
>>>ontent-Type: application/sdp.Content-Length: 138.Route: <sip:192.1.2.17;lr>
>>>..v=0.o=username 421668676 421668676 IN IP4 192.1.2.88.s=Session SDP.c=IN I
>>>P4 192.1.2.88.t=0 0.m=audio 54454 RTP/AVP 0.a=rtpmap:0 PCMU/8000.
>>>
>>>U 2003/06/20 15:24:42.363813 192.1.2.17:5060 -> 192.1.2.88:5060
>>>SIP/2.0 100 trying -- your call is important to us..Via: SIP/2.0/UDP 192.1.
>>>2.88:5060;branch=z9hG4bK421668676..From: 9727619271 <sip:9727619271@192.1.2
>>>.88>;tag=421668676.To: 9727610001 <sip:9727610001@192.1.2.17>.Call-ID: 4216
>>>68676(a)192.1.2.88.CSeq: 1 INVITE.Server: Sip EXpress router (0.8.11pre29 (i3
>>>86/linux))..Content-Length: 0..Warning: 392 192.1.2.17:5060 "Noisy feedback
>>>tells: pid=15107 req_src_ip=192.1.2.88 req_src_port=5060 in_uri=sip:97276
>>>10001(a)192.1.2.17 out_uri=sip:9727610001@192.1.2.17 via_cnt==1"....
>>>#
>>>U 2003/06/20 15:24:42.794681 192.1.2.17:5060 -> 192.1.2.88:5060
>>>SIP/2.0 483 Too Many Hops..Via: SIP/2.0/UDP 192.1.2.88:5060;branch=z9hG4bK4
>>>21668676..From: 9727619271 <sip:9727619271@192.1.2.88>;tag=421668676.To: 97
>>>27610001 <sip:9727610001@192.1.2.17>;tag=b27e1a1d33761e85846fc98f5f3a7e58.4
>>>632.Call-ID: 421668676(a)192.1.2.88.CSeq: 1 INVITE.Server: Sip EXpress router
>>>(0.8.11pre29 (i386/linux))..Content-Length: 0..Warning: 392 192.1.2.17:506
>>>0 "Noisy feedback tells: pid=15107 req_src_ip=192.1.2.17 req_src_port=5060
>>>in_uri=sip:9727610001@192.1.2.17 out_uri=sip:9727610001@192.1.2.17 via_cnt
>>>==71"....
>>>
>>>-- End trace --
>>>
>>>ps: We checked it with loose routing(suceeding ';lr' present in URIs in Route) as well as strict routing(suceeding ';lr' not present in URIs in Route). Should the type of routing used matter ?
>>>
>>>_______________________________________________
>>>Serusers mailing list
>>>serusers(a)lists.iptel.org
>>>http://lists.iptel.org/mailman/listinfo/serusers
>>>
>>
>>--
>>Andy Blen
>>iptel.org Services
>>
>
>
--
Andy Blen
iptel.org Services
Thanks, that worked. I'll let you know how it goes with NetBsd along with including mysql there too. Later.
Marcelo.
-----Original Message-----
From: Andrei Pelinescu-Onciul [mailto:pelinescu-onciul@fokus.fraunhofer.de]
Sent: Thu 7/3/2003 9:14 AM
To: Marcelo Schmidt
Cc: serusers(a)iptel.org
Subject: Re: [Serusers] Mysql.so
On Jul 03, 2003 at 08:48, Marcelo Schmidt <mschmidt(a)equinix.com> wrote:
> Andrei,
>
> Now in FreeBSD:
>
> ldd /usr/local/lib/ser/modules/mysql.so
> /usr/local/lib/ser/modules/mysql.so:
> ldd: /usr/local/lib/ser/modules/mysql.so: Exec format error
> /usr/local/lib/ser/modules/mysql.so: exit status 1
Yes, sorry, ldd does not work on shared libraries on FreeBSD.
objdump -p /usr/local/lib/ser/modules/mysql.so |grep lib
was the right command.
>
> ldconfig -r |grep mysql
> (I got no output)
This means your libmysqlclient library is not in your shared library
cache file and the dynamic linker cannot find it.
(see ldconfig(8), rtld(1)).
You can merge your mysql libs to the system cache:
ldconfig -m /usr/local/mysql/lib/mysql # you have to run it as root
or you can set up the environment variable LD_LIBRARY_PATH:
export LD_LIBRARY_PATH=/usr/local/mysql/lib/mysql
However you will have to do this each time you reboot the machine.
To do it automatically add /usr/local/mysql/lib/mysql to
ld_config_paths in /etc/rc.conf:
ldconfig_paths="$ld_config_paths /usr/local/mysql/lib/mysql"
(ldconfig_paths is initialized in /etc/default/rc.conf).
Andrei
Andrei,
Yes, it is i386. All the defualt ser's modules are working OK. I will let you know if I find any problems on NetBSD/i386.
Now in FreeBSD:
ldd /usr/local/lib/ser/modules/mysql.so
/usr/local/lib/ser/modules/mysql.so:
ldd: /usr/local/lib/ser/modules/mysql.so: Exec format error
/usr/local/lib/ser/modules/mysql.so: exit status 1
ldconfig -r |grep mysql
(I got no output)
Marcelo.
btw: sorry for this email/html but I had no other quicker options from here today.
-----Original Message-----
From: Andrei Pelinescu-Onciul [mailto:pelinescu-onciul@fokus.fraunhofer.de]
Sent: Thu 7/3/2003 4:09 AM
To: Marcelo Schmidt
Cc: serusers(a)iptel.org
Subject: Re: [Serusers] Mysql.so
On Jul 02, 2003 at 16:04, Marcelo Schmidt <mschmidt(a)equinix.com> wrote:
> I am dealing with one NetBsd and a FreeBsd...
Are you running ser on NetBSD/i386? We tried so far NetBSD only on
sparc64. Is it working ok? (can I add it to the tested architectures?)
> Now the question is for
> the second one, I uncommented this line: loadmodule
> "/usr/local/lib/ser/modules/mysql.so" only (just testing if it can find
> the mysql module). I got:
>
> 0(95642) ERROR: load_module: could not open module
> </usr/local/lib/ser/modules/mysql.so>: Shared object
> "libmysqlclient.so.10" not found
> 0(95642) parse error (22,13-49): failed to load module
> ERROR: bad config file (1 errors)
>
> ==
> file libmysqlclient.so.10
> libmysqlclient.so.10: ELF 32-bit LSB shared object, Intel 80386, version
> 1 (FreeBSD), not stripped
> ==
> /usr/local/mysql/lib/mysql
> -rwxr-xr-x 1 root mysql 136729 Jun 30 22:23 libmysqlclient.so.10
> ==
> modules/mysql/Makefile
> # $Id: Makefile,v 1.15 2002/11/12 12:32:17 andrei Exp $
> ...
> LIBS=-L/usr/lib/mysql -L /usr/local/lib -L/usr/local/lib/mysql \
> -L/usr/local/mysql/lib/mysql/ \
> -lmysqlclient -lz
>
> All seemed to be OK but not, any help is highly appreciated.
Try (& send the output to me):
ldd /usr/local/lib/ser/modules/mysql.so
and
ldconfig -r |grep mysql
(libmysqlclient should be in ldconfig hints file)
Andrei
When I enable SER to start at boot time it hangs my computer. I then need to
restart the computer in interactive mode and prevent the SER from starting.
If I start SER after the computer boots, I never have a problem.
Anyone know what the problem is?
I am running the lastest RH9. and SER pre29.
Leo P.
That was what I was missing, thx.
-----Original Message-----
From: Andrei Pelinescu-Onciul
[mailto:pelinescu-onciul@fokus.fraunhofer.de]
Sent: Wednesday, July 02, 2003 1:13 PM
To: Marcelo Schmidt
Cc: serusers(a)lists.iptel.org
Subject: Re: [Serusers] Mysql.so
On Jul 02, 2003 at 11:57, Marcelo Schmidt <mschmidt(a)equinix.com> wrote:
> Like I said, I used: exclude_modules="" modules --no errors, ser is
> running but I don't see any mysql.so under modules, I thought that it
> wouldn't matter since the mysql's binaries are already installed but
> when I tried to include the very first line: loadmodule
> "/usr/local/lib/ser/modules/mysql.so" then the configuration
> complains. If I am missing something please let me know.
You have to run make install in the same way as make modules: make
exclude_modules="" install or make include_modules=mysql install
(to install only the mysql module you need only:
make modules=modules/mysql install )
Andrei