sr-users January 2003

sr-users@lists.kamailio.org

47 participants
77 discussions

RE: [Serusers] Password problem with ser and mysql
by Jiri Kuthan 17 Jan '03

17 Jan '03

At 01:59 PM 1/17/2003, Klaus Darilion wrote: >Yes, that was my problem! Thank you very mutch! > >Are you involved in the SHIP (http://voip.sh.cvut.cz/about.shtml) >project? (because of your emailaddress). Jan is. >I read that you are using Vocal >as voice mail server. Do you have an installation guide how to setup >such a system with vocal and ser? I tried to deploy the vocal voicemail a while ago and it did not meet me expectations. We are working on our own now. -Jiri

1 0

RE: [Serusers] Password problem with ser and mysql
by Klaus Darilion 17 Jan '03

17 Jan '03

Hello Jan! Comments inline. > default username and password for auth module is > serro:47serro11, if you are able to login as ser:heslo, then > username and password can be changed. > If you change your password in mysql, you must change it for > ser@localhost For example: grant ALL on ser.* to > ser@localhost identified by 'klaus'; I changed it for localhost, but it won't work. > If you use something like grant ALL on ser.* to ser > identified by 'klaus'; then the server will be unable to > login to the database. > > Try also the following: > mysql -h localhost -u ser -p ser I changed the password of ser@localhost to 'klaus'. I can connect to mysql with mysql -h localhost -u ser -p ser and password 'klaus'. I changed the password in ser.cfg to 'klaus' modparam("auth", "db_url", "sql://ser:klaus@localhost/ser") , but still the ser server can't start: : connect_db(): Access denied for user: 'ser@localhost' (Using password: YES) I still think there must be a bug somewhere, so that ser tries to connect with the 'heslo' password. regards, Klaus > This will prompt for password, if you are unable to login > with your password, ser will be unable to login as well > (probably because you changed password for ser and not for > ser@localhost) > > regards, Jan. > > On 16-01 18:34, Klaus Darilion wrote: > > Hello! > > > > I have sucessfully installed the ser server (0.8.10 from > rpms) with an > > mysql database. When I use the standard password for the user "ser" > > everything works fine. But if I change the password from > "heslo" to a > > new one, for example "klaus" instead of "heslo" (of course in the > > mysql-database und in the config file) the ser server can not start > > up. > > > > Following are some different configurations and my suggestions what > > could be the problem. > > > > ser.cfg: modparam("auth", "db_url", "sql://ser:heslo@localhost/ser") > > mySQL-root-password: XXXXX > > mySQL-ser-password: heslo > > ---> works fine > > > > ser.cfg: modparam("auth", "db_url", "sql://ser:klaus@localhost/ser") > > mySQL-root-password: XXXXX > > mySQL-ser-password: klaus > > ---> doesn't work: connect_db(): Access denied for user: > > ---> 'ser@localhost' > > (Using password: YES) > > should work, so I tried another user > > > > ser.cfg: modparam("auth", "db_url", > "sql://root:XXXXX@localhost/ser") > > mySQL-root-password: XXXXX > > mySQL-ser-password: heslo > > ---> works fine > > > > ser.cfg: modparam("auth", "db_url", > "sql://root:XXXXX@localhost/ser") > > mySQL-root-password: XXXXX > > mySQL-ser-password: klaus > > ---> doesn't work: connect_db(): Access denied for user: > > ---> 'ser@localhost' > > (Using password: YES) > > very strange, because I told ser to connect as root. Is ser > using the > > default user/password instead of the configured one? > > > > ser.cfg: modparam("auth", "db_url", > "sql://root:YYYYY@localhost/ser") > > mySQL-root-password: XXXXX > > mySQL-ser-password: heslo > > ---> doesn't work: connect_db(): Access denied for user: > > 'root@localhost' (Using password: YES) > > of course it doesn't work, wrong password. So ser cares about the > > settings in ser.cfg > > > > So my suggestion is that ser connects several times to the database > > whereas one time it uses the configured user/password and > another time > > it uses the default user/password - maybe a bug in the auth module? > > > > Or does somebody of you changed the password successfuly? > > > > It would be nice if you can help me. > > > > Thanks, > > Klaus > > > > My system is: > > Linux version 2.4.18-14 (bhcompile(a)astest.test.redhat.com) > (gcc version > > 3.2 20020903 (Red Hat Linux 8.0 3.2-7)) #1 Wed Sep 4 > 12:13:11 EDT 2002 > > MySQL 3.23.52 > > ser-0.8.10-2.i386.rpm > > ser-mysql-0.8.10-2.i386.rpm > > _______________________________________________ > > Serusers mailing list > > serusers(a)lists.iptel.org > > http://lists.iptel.org/mailman/listinfo/serusers > > >

2 1

[Serusers] SER & IPv6
by Antonino Mendes Monteiro 17 Jan '03

17 Jan '03

Hello, I would like to know if SER supports IPv6. If not, do you have any plans for it ? When ? Thanks in advance, Antonino

2 1

[Serusers] Password problem with ser and mysql
by Klaus Darilion 16 Jan '03

16 Jan '03

Hello! I have sucessfully installed the ser server (0.8.10 from rpms) with an mysql database. When I use the standard password for the user "ser" everything works fine. But if I change the password from "heslo" to a new one, for example "klaus" instead of "heslo" (of course in the mysql-database und in the config file) the ser server can not start up. Following are some different configurations and my suggestions what could be the problem. ser.cfg: modparam("auth", "db_url", "sql://ser:heslo@localhost/ser") mySQL-root-password: XXXXX mySQL-ser-password: heslo ---> works fine ser.cfg: modparam("auth", "db_url", "sql://ser:klaus@localhost/ser") mySQL-root-password: XXXXX mySQL-ser-password: klaus ---> doesn't work: connect_db(): Access denied for user: 'ser@localhost' (Using password: YES) should work, so I tried another user ser.cfg: modparam("auth", "db_url", "sql://root:XXXXX@localhost/ser") mySQL-root-password: XXXXX mySQL-ser-password: heslo ---> works fine ser.cfg: modparam("auth", "db_url", "sql://root:XXXXX@localhost/ser") mySQL-root-password: XXXXX mySQL-ser-password: klaus ---> doesn't work: connect_db(): Access denied for user: 'ser@localhost' (Using password: YES) very strange, because I told ser to connect as root. Is ser using the default user/password instead of the configured one? ser.cfg: modparam("auth", "db_url", "sql://root:YYYYY@localhost/ser") mySQL-root-password: XXXXX mySQL-ser-password: heslo ---> doesn't work: connect_db(): Access denied for user: 'root@localhost' (Using password: YES) of course it doesn't work, wrong password. So ser cares about the settings in ser.cfg So my suggestion is that ser connects several times to the database whereas one time it uses the configured user/password and another time it uses the default user/password - maybe a bug in the auth module? Or does somebody of you changed the password successfuly? It would be nice if you can help me. Thanks, Klaus My system is: Linux version 2.4.18-14 (bhcompile(a)astest.test.redhat.com) (gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)) #1 Wed Sep 4 12:13:11 EDT 2002 MySQL 3.23.52 ser-0.8.10-2.i386.rpm ser-mysql-0.8.10-2.i386.rpm

2 1

[Serusers] problems getting started with ser/serweb
by Stephan Reiff-Marganiec 16 Jan '03

16 Jan '03

Hi, I have installed ser and was amazed how easy it was to install (we have previously experimented with sipd, which finally runs ...). I have run through the archives and also looked at all the documentation, but some things still don't work. I use kphone 2.11 as client, but have tried sipc on a solaris box to the same extend. I am running kphone and ser 0.8.10 on redhat 8. MySQL is 3.23.52. I have set the domain/realm things to cs.stir.ac.uk and restarted ser. I have then set up a user using "serctl add srm test srm(a)cs.stir.ac.uk". Now, on serweb in user_interface/index I cannot login with this user. In kphone, I cannot register (it works ok on the columbia server): ----kphone says------------------------------------------ SipTransaction: Retransmit 1 (4000) SipClient: Sending: 15:09:37.098 -------------------------------- REGISTER sip:cs.stir.ac.uk SIP/2.0 Via: SIP/2.0/UDP 139.153.254.196:5062 CSeq: 488 REGISTER To: "Stephan" <sip:srm@cs.stir.ac.uk> Expires: 900 From: "Stephan" <sip:srm@cs.stir.ac.uk> Call-ID: 1902284369(a)139.153.254.196 Content-Length: 0 User-Agent: KPhone/2.11 Event: registration Allow-Events: presence Contact: "root" <sip:root@139.153.254.196:5062;transport=udp>;methods="INVITE, MESSAGE, INFO, SUBSCRIBE, OPTIONS, BYE, CANCEL, NOTIFY, ACK" SipClient: Receiving message... SipClient: Received: 15:09:39.724 --------------------------------- SIP/2.0 478 Unresolveable destination (478/TM) Via: SIP/2.0/UDP 139.153.254.196:5062 CSeq: 488 REGISTER To: "Stephan" <sip:srm@cs.stir.ac.uk>;tag=0a96755a1d32d0360b3e454593e5079b-9b73 From: "Stephan" <sip:srm@cs.stir.ac.uk> Call-ID: 1902284369(a)139.153.254.196 Server: Sip EXpress router (0.8.10 (i386/linux)) Content-Length: 0 Warning: 392 139.153.254.196:5060 "Noisy feedback tells: pid=5138 req_src_ip=139.153.254.196 in_uri=sip:cs.stir.ac.uk out_uri=sip:cs.stir.ac.uk via_cnt==1" --- end kphone ----------------------------------------------------- ser does answer, the Replied locally counter in serctl moni reflects this ok. what is wrong? do you need any other files? In case you need more detail, where exactly is the server log?? by the way, I have tried this with auth turned on and off in ser.cfg. and without persistence. always the same ... thanks S -- Dr Stephan Reiff-Marganiec Research Fellow Department of Computing Science; University of Stirling email: srm(a)cs.stir.ac.uk tel: 01786 46 7448 -- The University of Stirling is a university established in Scotland by charter at Stirling, FK9 4LA. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not disclose, copy or deliver this message to anyone and any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the University of Stirling shall be understood as neither given nor endorsed by it.

2 1

[Serusers] authentication problems
by sunil 16 Jan '03

16 Jan '03

hi all, i've downloaded the ser package from you and it is working fine with msn. but as u said i tried for authentication... it is not working properly... i've done - a.uncommented the lines required for authentication... b.changed iptel.org to localhost in www_* (2 places) c.created mysql tables d.did'nt made any changes in mysql tables e.tried to authenticate using admin/heslo and signinname as admin@<myipaddress> f.restarted SER :( again asking for username/pass pl. give ur comments thanks in advance.. best regards sunil __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

3 3

[Serusers] SER on masqueraded/NAT connection
by Craig Graham 16 Jan '03

16 Jan '03

I have a Linux box at home acting as a masquerading/NAT gateway for a few Windows PCs, and have installed SER on there in order to use MS Messenger to talk to people outside. SER appears to be working in that I can get Messenger up on two PCs, connect to SER and set up a voice connection between the two PCs. However, I cannot connect to people offsite. Relevant IPChains entries are target prot opt source destination ports ACCEPT udp ----l- anywhere anywhere any -> 5060 ACCEPT udp ------ anywhere anywhere any -> 7070:7080 I have made no changes to the default SIP configuration; it is working as installed by the rpm package ser-0.8.10-1.i386.rpm. A browse through the mailing list archive and through the admin guide doesn't show anything obvious. No errors are reported to /etc/messages or /etc/syslog and serctl moni does not show anything that looks relevant. Does anyone have any suggestions? -- Dr. Craig Graham, Software Engineer Advanced Analysis and Integration Limited, UK. http://www.aail.co.uk/

4 6

[Serusers] Moving SDP-related functions into core parser
by Maxim Sobolev 15 Jan '03

15 Jan '03

Folks, My nathelper module will need to tweak body of the messages, therefore it will be third module after im and sms that needs body-related functions. IMO it would probably make a lot of sense to move those functions into core parser, so that modules will not have to import im module just to use one or two utility functions. Please let me know what do you think. Thanks! -Maxim

2 1

[Serusers] Access control on PSTN gateways
by Michael Graff 15 Jan '03

15 Jan '03

We have a group of people who run their own SIP servers (some are SER, some are not) and we are going to be sharing a PSTN gateway (Cisco box). I need to rewrite the identities for the users of our gateway into something that can be presented to the PSTN gateway for billing purposes. We don't want to do that mapping on the gateway itself, for various reasons. How do people handle this situation? Is it wise to put all functionality for user handling and incoming call handling and forwarding to another place in the same SER server? --Michael

5 14

[Serusers] encryption on authorization
by Karsten Knüttel 15 Jan '03

15 Jan '03

Hi there, In a REGISTER case there is a HeaderField AUTHORIZATION. The usual encryption algorithm is "MD5". Is it possible to REGISTER without any encryption? Please give a statement if I understood everything right or correct me: Digest Username => not encrypted; realm =>not encrypted; URI =>not encrypted; Nonce => encrypted => is Password? Response => encrypted => what´s that? Thanks! P.S.: I sniffered the network traffic when I registerd,established a VoIP-Connection and ended my call. Etherreal, the snifferprogramm, does understand SIP and SDP so I could easy protocol and understand what was going on.

2 1

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users January 2003