sr-users May 2006

sr-users@lists.kamailio.org

195 participants
503 discussions

RE: [Serusers] mysql configuration issue
by Benjamin.George＠t-systems.com 30 May '06

30 May '06

Hi, I put the debug on now and started getting debug messages. The error which I am getting now is pasted below: root@ubuntu:/usr/local/etc/ser # ser start Listening on udp: 127.0.0.1 [127.0.0.1]:5060 udp: 10.25.119.97 [10.25.119.97]:5060 tcp: 127.0.0.1 [127.0.0.1]:5060 tcp: 10.25.119.97 [10.25.119.97]:5060 Aliases: tcp: ubuntu:5060 tcp: localhost:5060 tcp: localhost.localdomain:5060 udp: ubuntu:5060 udp: localhost:5060 udp: localhost.localdomain:5060 stateless - initializing 0(0) Maxfwd module- initializing textops - initializing 0(0) new_connection(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 0(0) db_init(): Could not create a connection 0(0) ERROR: auth_db_ver: unable to open database connection 0(0) auth_db:str_fixup(): Error while querying table version 0(0) ERROR: fix_expr : fix_actions error ERROR: error -1 while trying to fix configuration What might be the possible reason for this error? Can anyone help me out to solve this issue or it will be great if someone throw some light on why this error happens while starting SER with MySql. Thanks, Benjamin. -----Original Message----- From: serusers-bounces(a)lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Andrey Kouprianov Sent: Monday, May 29, 2006 7:36 PM To: serusers(a)iptel.org Subject: Re: [Serusers] mysql configuration issue what does /var/log/messages say? On 5/29/06, Benjamin.George(a)t-systems.com <Benjamin.George(a)t-systems.com> wrote: > Hi, > Thanks for the reply! > > My installed SER version is >0.9.x. Anyway, my issue is not with presence server for the time being. Before experimenting with presence server, I have to complete the mysql configuration with SER. I ran the script to create the Ser DB and tables. It went successfully and all the tables got created. After this, I modified the ser.cfg file to configure mysql with SER (.cfg file is attached). After these modifications, ser -c command was executed and I got an error related to libmysqlclient.so.12. Then I created a soft link to libmysqlclient.so.10. After this, ser -c command was through but when I tried to start the server, it is not getting started. I could not understand the real issue why the SER server is not getting started. I have to configure the mysql to continue my experiments with presence server. It will be great if somebody can get me some pointers on configuring mysql with SER. Some links or tutorials are also well being appreciated. > Thanks, > Benjamin > > -----Original Message----- > From: Andrey Kouprianov [mailto:andrey.kouprianov@gmail.com] > Sent: Monday, May 29, 2006 12:39 PM > To: serusers(a)iptel.org > Subject: Re: [Serusers] mysql configuration issue > > you have installed version <= 0.9.x. This version doesnt have any > presence support, except simply forwarding presence/IM messages back > and forth. What you need is to install ser with presence. it's still > unstable, but try it anyway. > > ftp.iptel.org/pub/ser/presence/ > > > On 5/29/06, Benjamin.George(a)t-systems.com <Benjamin.George(a)t-systems.com> wrote: > > > > > > > > Hi , > > > > > > > > I am a new user of SER and last week only I started installing and > > configuring SER to deploy some presence based applications on top of SER. I > > am finiding some configuration issues with mysql and SER. I installed SER > > and registerd users (X-Lite) successfully. After that I installed mysql to > > store all registration and other information to database instead of in RAM. > > After mysql installation, I ran the script to create the Ser database and > > tables for SER, every thing got craeted successfully. Then the lines > > mentioned to uncomment to use mysql also has been uncommented in ser.cfg > > file. But when I registerd the users again, I could not see any users in the > > table subsriber. It will be great if somebody can throw some light in to > > this issue so that I could complete my mysql configuration with Ser. What > > extra configuration has to be done in ser.cfg file to use mysql? > > > > > > > > Thanks in advance, > > > > Benjmain. > > > > > > _______________________________________________ > > 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

2 1

[Users] how to run openser through monit daemon?
by Padmaja RV 30 May '06

30 May '06

Hi all! I have installed openser through CVS from the following link http://openser.org/dokuwiki/doku.php?id=install_and_maintain_openser_from_c… till the 8 th step in the link everything went well fine. in the 9 th step, there is a link to make oepnser.init script work and i did all the steps as described. I downloaded and installed the monit daemon to start openser thru it. however, now if i type /etc/init.d/openser start, it says command monit to start openser and then the command prompt appears back. i dont see the tcp and udp ports (5060 ) and other information etc when the openser is started.....and i cant figure out if it is running at all.....if i issue ps command, i dont see any pid for openser.....if i open the web interface of the monit daemon, i see that it is trying to start the openser but after some time it shows failed to start...... please let me know what to do asap..... Thanks ----- Original Message ----- From: <users-request(a)openser.org> To: <users(a)openser.org> Sent: Friday, May 26, 2006 3:30 PM Subject: Users Digest, Vol 12, Issue 71 > Send Users mailing list submissions to > users(a)openser.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://openser.org/cgi-bin/mailman/listinfo/users > or, via email, send a message with subject or body 'help' to > users-request(a)openser.org > > You can reach the person managing the list at > users-owner(a)openser.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Users digest..." > > > Today's Topics: > > 1. Re: How to extract sip-id when using alias-id? > (Bogdan-Andrei Iancu) > 2. Route Algorithm. (raviprakash sunkara) > 3. Re: Forward SUBSCRIBER (Bogdan-Andrei Iancu) > 4. RE: 2 Openser Instances (Sam Lee) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 26 May 2006 12:35:21 +0300 > From: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> > Subject: Re: [Users] How to extract sip-id when using alias-id? > To: Frogger <froggerandbongo(a)yahoo.com> > Cc: users(a)openser.org > Message-ID: <4476CBD9.80002(a)voice-system.ro> > Content-Type: text/plain; charset=us-ascii; format=flowed > > Hi, > > what you can do is to save into an AVP the alias before doing > lookup(aliases). In failure route, before sending to voicemail, push the > AVP into RURI to have the alias and not the sip id. > > regards, > bogdan > > Frogger wrote: > >>Good point. >>I need to clarify... >> >>The alias is working to route to the user however if >>the timer expires, the route fails or if there is a >>reject, the failure routes are applying their logic to >>the alias-id not the sip-id. >> >>What I need to do is apply the failure route logic to >>the sip-id so we can send the attempt to voicemail. >> >>Let say I have an alias of 1000(a)sip.com for sip-id >>5551212(a)sip.com. >> >>When 1000(a)sip.com is dialed by another user in the >>domain (I am using "use_domain") the call is properly >>routed to: 5551212(a)sip.com. >> >>However, if 5551212(a)sip.com does not answer, timer >>expires, or a reject, then the failure logic is be >>applied to the alias. >> >>Failure route says: >> >>prefix("66"); >>append_branch(); >>append_urihf("CC-Diversion: ", "\r\n"); >>t_relay(); >> >> >>Result of the failure logic: >> >>661000(a)sip.com >> >>Needs to be: >> >>665551212(a)sip.com >> >> >>Thoughts? >> >>F >> >> >>--- Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> >>wrote: >> >> >> >>>Hi, >>> >>>not sure I understand - you dial an alias and via >>>db_aliases you replace >>>the alias with the sip-id. So you have the sip-id .. >>>where is the problem? >>> >>>regards, >>>bogdan >>> >>>Frogger wrote: >>> >>> >>> >>>>I am using alias_db to store alias's for users. >>>> >>>>However when an alias is dialed I need to also be >>>> >>>> >>>able >>> >>> >>>>to restore the alias owners original sip-id. >>>> >>>>This is necessary to forward the call to voicemail >>>>using sip-id. >>>> >>>>Any guidance on getting the sip-id out of the >>>> >>>> >>>alias_db >>> >>> >>>>and replacing the alias-id prior to forwarding to >>>>vmail? >>>> >>>>Thanks in advance! >>>> >>>>F >>>> >>>>__________________________________________________ >>>>Do You Yahoo!? >>>>Tired of spam? Yahoo! Mail has the best spam >>>> >>>> >>>protection around >>> >>> >>>>http://mail.yahoo.com >>>> >>>>_______________________________________________ >>>>Users mailing list >>>>Users(a)openser.org >>>>http://openser.org/cgi-bin/mailman/listinfo/users >>>> >>>> >>>> >>>> >>>> >>> >>> >> >> >>__________________________________________________ >>Do You Yahoo!? >>Tired of spam? Yahoo! Mail has the best spam protection around >>http://mail.yahoo.com >> >> > > > > > ------------------------------ > > Message: 2 > Date: Fri, 26 May 2006 05:38:23 -0400 > From: "raviprakash sunkara" <sunkara.raviprakash.feb14(a)gmail.com> > Subject: [Users] Route Algorithm. > To: Users(a)openser.org, "Klaus Darilion" > <klaus.mailinglists(a)pernau.at>, daniel(a)voice-system.ro, > nickm(a)kryptontech.com > Message-ID: > <f0f0f9340605260238l2e6ce419qd109b6f97e57c485(a)mail.gmail.com> > Content-Type: text/plain; charset="iso-8859-1" > > Hi listers and Users. > > Please help me in " how to make a call from one place to other place in > route algorithm " > > > I got Call not approved ? what is this and also $04 and $08 messages as > not > found and request timeout........ > > > It connect ( REgister) to server . > > server respond as 1 st " 200 ok " and then " 408 request time out.... > > plesse help me > > Bye.. > -- > Thanks and Regards with cheers > Sunkara Ravi Prakash (Voip Developer) > Hyperion Technology > www.hyperion-tech.com > <b> >

2 5

[Serusers] Mysql structure for new CVS sources
by İlker Aktuna (Koç.net) 30 May '06

30 May '06

Hi, After updating to the latest CVS sources, I am not able to use usrloc with db support. If I set the usrloc db_mode to something other than 0 , it doesn't work. I get the following error. This is what causes the error: modparam("usrloc", "db_mode", 2) This is the error: May 25 16:44:57 sesapp /root/ser/sbin/ser[3173]: register_udomain(): Invalid table version (use ser_mysql.sh reinstall) May 25 16:44:57 sesapp /root/ser/sbin/ser[3173]: register_udomain(): Invalid table version (use ser_mysql.sh reinstall) Before the update to latest CVS, I was using an older CVS source (maybe for 3 weeks) and I could use db_mode 2 for usrloc. After this error , I tried to drop all database and create again with Ser's mysql script. But I still get the error. So, I wonder the required mysql structure and table versions (for new CVS sources). is there anyone with working usrloc db_mode 2 ? Thanks, ilker <http://387555.sigclick.mailinfo.com/sigclick/010A0500/0C044F0E/07014E07/622…> _____________________________________________________________________________________________________________________________________________ Bu e-posta mesaji kisiye ozel olup, gizli bilgiler iceriyor olabilir. Eger bu e-posta mesaji size yanlislikla ulasmissa, icerigini hic bir sekilde kullanmayiniz ve ekli dosyalari acmayiniz. Bu durumda lutfen e-posta mesajini kullaniciya hemen geri gonderiniz ve tum kopyalarini mesaj kutunuzdan siliniz. Bu e-posta mesaji, hic bir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz. Bu e-posta mesaji viruslere karsi anti-virus sistemleri tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin - virus koruma sistemleri ile kontrol ediliyor olsa bile - virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hicbir sorumlulugu kabul etmez. This message is intended solely for the use of the individual or entity to whom it is addressed , and may contain confidential information. If you are not the intended recipient of this message or you receive this mail in error, you should refrain from making any use of the contents and from opening any attachment. In that case, please notify the sender immediately and return the message to the sender, then, delete and destroy all copies. This e-mail message, can not be copied, published or sold for any reason. This e-mail message has been swept by anti-virus systems for the presence of computer viruses. In doing so, however, sender cannot warrant that virus or other forms of data corruption may not be present and do not take any responsibility in any occurrence. _____________________________________________________________________________________________________________________________________________

1 0

RE: [Serusers] mysql configuration issue
by Benjamin.George＠t-systems.com 30 May '06

30 May '06

Hi, I am not finding anything in /var/log/messages related to SER or MySql. Really strange! Are there any other log files on SER available to understand what is happening while running it? Below is the tail output from messges log file. root@ubuntu:/var/log # tail -f messages May 29 22:56:58 ubuntu -- MARK -- May 29 23:16:58 ubuntu -- MARK -- May 29 23:36:58 ubuntu -- MARK -- May 29 23:56:58 ubuntu -- MARK -- May 30 00:16:58 ubuntu -- MARK -- May 30 00:36:58 ubuntu -- MARK -- May 30 00:56:58 ubuntu -- MARK -- May 30 01:16:59 ubuntu -- MARK -- May 30 01:36:59 ubuntu -- MARK -- May 30 01:56:59 ubuntu -- MARK -- Shown below is the out put which I get while executing 'ser start' command. root@ubuntu:/usr/local/etc/ser # ser start Listening on udp: 127.0.0.1 [127.0.0.1]:5060 udp: 10.25.119.97 [10.25.119.97]:5060 tcp: 127.0.0.1 [127.0.0.1]:5060 tcp: 10.25.119.97 [10.25.119.97]:5060 Aliases: tcp: ubuntu:5060 tcp: localhost:5060 tcp: localhost.localdomain:5060 udp: ubuntu:5060 udp: localhost:5060 udp: localhost.localdomain:5060 But after this, when I ran netstat, no application listen on port 5060 ! If I comment out all the mysql and authorization related lines from ser.cfg, SER server start working perfectly. So what wrong is happening when I am trying to use MySql ?! It will be great if some one can throw some light on how to solve this issue. Thanks, Benjamin. -----Original Message----- From: serusers-bounces(a)lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Andrey Kouprianov Sent: Monday, May 29, 2006 7:36 PM To: serusers(a)iptel.org Subject: Re: [Serusers] mysql configuration issue what does /var/log/messages say? On 5/29/06, Benjamin.George(a)t-systems.com <Benjamin.George(a)t-systems.com> wrote: > Hi, > Thanks for the reply! > > My installed SER version is >0.9.x. Anyway, my issue is not with presence server for the time being. Before experimenting with presence server, I have to complete the mysql configuration with SER. I ran the script to create the Ser DB and tables. It went successfully and all the tables got created. After this, I modified the ser.cfg file to configure mysql with SER (.cfg file is attached). After these modifications, ser -c command was executed and I got an error related to libmysqlclient.so.12. Then I created a soft link to libmysqlclient.so.10. After this, ser -c command was through but when I tried to start the server, it is not getting started. I could not understand the real issue why the SER server is not getting started. I have to configure the mysql to continue my experiments with presence server. It will be great if somebody can get me some pointers on configuring mysql with SER. Some links or tutorials are also well being appreciated. > Thanks, > Benjamin > > -----Original Message----- > From: Andrey Kouprianov [mailto:andrey.kouprianov@gmail.com] > Sent: Monday, May 29, 2006 12:39 PM > To: serusers(a)iptel.org > Subject: Re: [Serusers] mysql configuration issue > > you have installed version <= 0.9.x. This version doesnt have any > presence support, except simply forwarding presence/IM messages back > and forth. What you need is to install ser with presence. it's still > unstable, but try it anyway. > > ftp.iptel.org/pub/ser/presence/ > > > On 5/29/06, Benjamin.George(a)t-systems.com <Benjamin.George(a)t-systems.com> wrote: > > > > > > > > Hi , > > > > > > > > I am a new user of SER and last week only I started installing and > > configuring SER to deploy some presence based applications on top of SER. I > > am finiding some configuration issues with mysql and SER. I installed SER > > and registerd users (X-Lite) successfully. After that I installed mysql to > > store all registration and other information to database instead of in RAM. > > After mysql installation, I ran the script to create the Ser database and > > tables for SER, every thing got craeted successfully. Then the lines > > mentioned to uncomment to use mysql also has been uncommented in ser.cfg > > file. But when I registerd the users again, I could not see any users in the > > table subsriber. It will be great if somebody can throw some light in to > > this issue so that I could complete my mysql configuration with Ser. What > > extra configuration has to be done in ser.cfg file to use mysql? > > > > > > > > Thanks in advance, > > > > Benjmain. > > > > > > _______________________________________________ > > 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

1 0

[Users] pap2 ATA problem
by Jayesh Nambiar 30 May '06

30 May '06

Hello everybody, I have implemented few features in my openser script. The features are like if a user presses *86 followed by any number, that number will be his forwarded number when someone calls him and he is busy. Similarly the code for forwarding on no-answer is *87 followed by the number to which it should be forwarded. I've tested these features using Eyebeam softphone and Audiocodoes MP series analog gateways. But while testing it with a linksys pap2 device, it does'nt work. The problem is that as soon as the user dials *86 the phone gets disconnected and his forwarded number becomes blank in the table where i store these numbers. I dont understand how does the device recognises the code which is written in my openser script. Its like if the user dials any feature enabling code, before he enters the number the call is disconnected. Can anyone please help me in this regard or can anyone please guide me if they worked on this kind of idea before. the snippet of cfg is as below: if(uri=~"sip:\*87[0-9]*@") { if(isflagset(9)) { #--check if the feature is allowed for user-- log(1,"Entered *87 condition"); avp_db_query("select attribute from usr_preferences where username='$fU' and attribute='fwd_noanswer'", "$avp(i:91)"); if(!avp_check("$avp(i:91)", "eq/fwd_noanswer/i")) { strip(3); avp_db_query("insert into usr_preferences values('', '$fU', '', 'fwd_noanswer', '', '$ruri', '')"); log(1,"Entered in DB"); sl_send_reply("200", "OK"); exit; }; strip(3); avp_db_query("update usr_preferences set value='$ruri' where username='$fU' and attribute='fwd_noanswer'"); sl_send_reply("200", "OK"); exit; }; sl_send_reply("403", "Forbidden"); exit; }; Waiting for reply, w/regards, Jayesh --------------------------------- Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now

2 1

[Serusers] No. of users to register behind single NAT device.
by ravi reddy 30 May '06

30 May '06

HI all , My SER is running fine i made some test calls between two ,three soft phones who stayed in different places but , i tried to register some soft phones who are staying behind same NAt device but i can only register only two phones and remaining i cannot what is the reason for this one is it a serious problem ? Please help me .. Thanks in advance, Regards Ravi

2 1

[Users] uac_auth cseq workaround - ANY ?
by G.Jacobsen 30 May '06

30 May '06

Hello, I am trying to use the uac_auth function against an asterisk box and receive 488 not acceptable here. It appears that this is not due to a media problem since the client which is routed through openser can issue an authenticated invite without problems when registered directly with the asterisk box - with exactly the the same media settings. So I supect that this 488 message is due to the fact that openser does not increase the cseq during authentication causing asterisk to issue a 488 after the correct response to the challenge. What are my workaround options to authenticate openser against asterisk (or any other RFC compliant proxy) ? ANY practical hints would be highly appreciated. TIA for your help. Gerry

2 2

[Users] Unknown value error
by Giuseppe Parlato 30 May '06

30 May '06

Hello is there a way to ignore an attribute value when I make an authorization request to MsSQL database? that value is not important I think and it creates an error: ERROR: radius_xlat: '122(a)domain.com' rlm_sql (sql): sql_set_user escaped user --> '122(a)domain.com' radius_xlat: 'VoIP_Radius '122(a)domain.com'' rlm_sql (sql): Reserving sql socket id: 16 radius_xlat: '' radius_xlat: 'VoIP_Radius '122(a)domain.com','', '','192.168.1.1',''' rlm_sql: Failed to create the pair: Unknown value VoIP for attribute Service-Type rlm_sql (sql): Error getting data from database radius_xlat: '' MsSQL authorization queries: authorize_check_query = "VoIP_Radius '%{User-Name}'" authorize_reply_query = "VoIP_Radius '%{User-Name}','%{Calling-Station-Id}', \ '%{Called-Station-Id}','%{NAS-IP-Address}','%{h323-conf-id}','VoIP'" I tried to remove value VoIP from authorization query but the problem doesn't expire. Giuseppe Thank you

2 1

[Users] CVS Head breaks Serweb
by G.Jacobsen 30 May '06

30 May '06

CVS head seems to break in several places serweb: 0. no login possible into user menues. Authentication seems to work but then serweb log shows problems with apu_aliases and apu_acl application layers. Admin functions: 1. Accounting details dont show - "caller_deleted" field missing in acc table 2. user account details cannot be accessed in admin - I suspect problem with key index since user_preference tables is indexed by uuid whereas in every other table username is used. 3. Aliases cannot be added - serweb doesnt throw error but hangs Are these things which should be ammended in openser or rather in serweb ? I suspect that problems with serweb will increase while openser develops independently from SER. Perhaps the openser maintainers might like to consider to fork also a serweb version and put it on the openser cvs system ? Thank you for your interest in the matter. Gerry Send instant messages to your online friends http://uk.messenger.yahoo.com

2 1

[Serusers] help!!!
by Nhadie 30 May '06

30 May '06

Hi All, How can I make sure that an extension would only log-in once? Just want to make sure no one is usingmy extensios only my clients. Please help! Thank You Regards, Ron ________________________________________________ Message sent using UebiMiau 2.7

1 0

← Newer
1
2
3
4
5
6
7
8
9
...
51
Older →

Jump to page:

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 May 2006