I'm unclear on how multiple domains should be handled in sip/openser,
etc. The scope of my confusion may be broader than just with openser,
and this is more of a "concept" problem, but I'm hoping someone here
can point me in the right direction.
I've read the "domain" module documentation at openser.org.
I'm using a Linksys SPA942 IP phone for this experiment with
my openser 1.0.1 server.
The SPA942 appears to do the following:
a) sends "sip:$PROXY" for the REGISTER request-uri.
Here $PROXY is the actual entry typed in by the user,
as opposed to something looked up by using DNS SRV.
b) appends "@$PROXY" to the "User ID:" entry in the "From:" field
and appends @IP:PORT for "Contact:"
That is, as the person who configures the phone, I can view the
proxy setting as declaring the domain of the user.
But it seems more natural to me to put the actual host name of the
proxy in that setting. That is, if I run a service on sip.foo.net and
have customers in domains bif.net and baz.net then each of them
listing sip.foo.net as their sip proxy is reasonable.
But, if I go that route, then it seems the only way for the user to
send the sip server their domain is as part of the userID:
john(a)baz.net and if they do that then I get "From:" fields like
john@baz.net@sip.foo.net, and similar "Contact:" settings.
Now, I can strip off the trailing domain but the clumsiness of that
uri (sip:john@baz.net@sip.foo.net) gives me the feeling that this is
the wrong approach. Looking at the "Contact:" pretty much convinces
me of this: sip:john@baz.net@192.168.168.214:5060
But that takes me back to using the Proxy field as dual-duty:
specifying the proxy and also the user's domain.
I just looked at a cisco 7905 and it too does not appear to have
a way to set the user domain.
I can see how I could use unique AuthIDs to look up domains at
registration time, but that seems misguided too.
What am I missing?
Thanks,
-mark
> -----Original Message-----
> From: Andreas Granig [mailto:andreas.granig@inode.info]
> Sent: Wednesday, May 31, 2006 9:05 AM
> To: Douglas Garstang
> Cc: martin.klisch(a)stud.hs-merseburg.de; users(a)openser.org
> Subject: Re: [Users] OpenSER and Redundancy
>
>
> Douglas Garstang wrote:
> > We tried to use OpenSER in a redundant fashion (three
> servers all pointing to the same database), but got
> unexpected results. We gave up after posting questions to
> this list multiple times and getting incomplete half answers
> to our questions, about something that the 'documentation'
> says is supported.
>
> We use such a setup (with a MySQL cluster as DB backend and cacheless
> mode of usrloc) for months now without any problems.
That's a neat treat, because I was told by the developers in this list that this mode of operation was not supported, which surprised me, because it contradicted the docs.
> -----Original Message-----
> From: Martin Klisch [mailto:martin@campus-merseburg.de]
> Sent: Wednesday, May 31, 2006 12:13 AM
> To: users(a)openser.org
> Subject: [Users] OpenSER and Redundancy
>
>
> Hi,
>
> is anyone using openser in a redundancy enviroment? i'm
> planning to use
> two sunfire with a running openser on each.
>
> both openser get the same ip adress. on a cisco switch i can switch
> between too servers via hsrp. so i have a running openser on
> the expensive
> sunfire with redundant disk-drives and power supply. on the
> other cheap
> sunfire runs the backup client on standby. the backup server
> checks (for
> example via sipsak) the availability of the main server every second.
>
> the user-locations are written into a mysql table.
>
> so if server1 fails, server2 can recognize it in a second and
> can switch
> over.
> so only some transaction, which were processed at the moment of the
> failure will lost.
>
> what do you think. could this work? anyone has other ideas?
>
> bye, martin
We tried to use OpenSER in a redundant fashion (three servers all pointing to the same database), but got unexpected results. We gave up after posting questions to this list multiple times and getting incomplete half answers to our questions, about something that the 'documentation' says is supported.
Doug
Thanks for that information. But, how does Ser know to send start or stop message to radius ?
Thanks,
ilker
________________________________
From: sip [mailto:sip@arcdiv.com]
Sent: Wednesday, May 31, 2006 2:13 PM
To: İlker Aktuna (Koç.net); serusers(a)iptel.org
Subject: RE: [Serusers] Radius accounting howto
These are essentially log flags.
In order to log an INVITE or a BYE to the radius server (assuming your log_flag param was set to 1), you'd do something like:
if((method=="INVITE" && !has_totag()) || method=="BYE")
{
setflag(1);
};
I stick that BEFORE the loose_route section of my config, as if I don't, it doesn't seem to catch things correctly. I've yet to debug why. The reason I put the extra !has_totag() in there is for my accounting, so I don't end up logging reINVITES from the remote side.
Basically, the parameter for log_flag determines which flag you set in order to log the packet to the radius server.
N.
[UTF-8?]On Wed, 31 May 2006 10:48:42 +0300, İlker Aktuna \(Koç.net\) wrote
> Hi,
>
> Thanks for your reply. I saw that in the source and changed according to them. But I still can't see any radius packets created/sent by Ser when a call is made.
> What should I add to the configuration to send start/stop packets ?
>
> Regards,
> ilker
>
> -----Original Message-----
> From: serusers-bounces(a)lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of sip
> Sent: Tuesday, May 30, 2006 8:28 PM
> To: serusers(a)iptel.org
> Subject: Re: [Serusers] Radius accounting howto
>
> Those params are valid for the old acc module compiled with radius support.
> The acc_radius module I think uses log_flag and log_missed_flag (according to the source).
>
> N.
>
> On Tue, 30 May 2006 17:54:40 +0300, Ýlker Aktuna (Koç.net) wrote
> > Hi everyone,
> >
> > I am trying to use acc_radius module with presence CVS sources.
> > I compiled the radiusclient library and compiled ser with acc_radius module.
> >
> > Then I added following lines to the config:
> >
> > loadmodule "/root/ser/lib/ser/modules/acc_radius.so"
> > modparam("acc_radius", "radius_config",
> "/usr/local/etc/radiusclient-ng/radiusclient.conf")
> > modparam("acc_radius", "service_type", 15) modparam("acc_radius",
> > "radius_flag", 1) modparam("acc_radius", "radius_missed_flag", 3)
> > modparam("acc_radius", "report_ack", 0)
> >
> >
> > But when I try to start ser, it doesn't accept 2 parameters:
> > modparam("acc_radius", "radius_flag", 1) modparam("acc_radius",
> > "radius_missed_flag", 3)
> >
> > What should be the correct syntax for these parameters ? are they required ?
> >
> > And what else should I add to the configuration to send radius-start
> > and
> radius-stop messages to the radius server ?
> >
> > Thanks,
> > ilker
> >
> >
> >
> >
> _
>
> <http://387555.sigclick.mailinfo.com/sigclick/02090504/00064E0A/07084E03/211…>
>
> _____________________________________________________________________________________________________________________________________________
> 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.
> _____________________________________________________________________________________________________________________________________________
<http://387555.sigclick.mailinfo.com/sigclick/00090204/03044D0A/0B014903/231…>
_____________________________________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________________________________
_____________________________________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________________________________
Ok, it's not that important. I just wanted to use it because it was in the example configs.
Usrloc db support is more important for me now.
Otherwise I can't use lookup_user("To") for user uri.
Thanks,
ilker
-----Original Message-----
From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
Sent: Wednesday, May 31, 2006 12:57 PM
To: İlker Aktuna (Koç.net)
Cc: samuel; serusers(a)iptel.org
Subject: Re: Authorizing IM requests
The file format is different! You really CAN NOT set these rules from EyeBeam. The filename is given as parameter to authorize_message function (in CVS version; not snapshot).
If you need it quickly you really have to correct it somewhere in sources (I don't know where).
Vaclav
On Wed, May 31, 2006 at 10:52:42AM +0300, ?lker Aktuna (Koç.net) wrote:
> Hi Vaclav,
>
> On which file does Ser look for when authorizing messages ?
> According to that maybe I can link privacy-lists file to im-rules file
> (which Ser looks for) Would that work ?
>
> Usrloc problem is very important for me. Please tell me anything I can
> do to find out the problem (if there is anything that I can do)
>
> Thanks,
> ilker
>
> -----Original Message-----
> From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
> Sent: Wednesday, May 31, 2006 9:29 AM
> To: ?lker Aktuna (Koç.net)
> Cc: samuel; serusers(a)iptel.org
> Subject: Re: Authorizing IM requests
>
> Hi,
> yes I did, but I had forgotten...
>
> You can NOT use EyeBeam to work with message authorization - it will NEVER set the rules which are needed by SER. You can do this only manually on XCAP server.
>
> I try to look on the userloc problem, but don't know when.
>
> Vaclav
>
> On Tue, May 30, 2006 at 05:29:27PM +0300, ?lker Aktuna (Koç.net) wrote:
> > Hi Vaclav,
> >
> > Did you receive my following email ?
> >
> > Btw, I still couldn't find the neccessary db structure for using
> > usrloc with db support. Can you point me to the right person who
> > knows the required db structure ?
> >
> > Thanks,
> > ilker
> >
> > ________________________________
> >
> > From: ?lker Aktuna (Koç.net)
> > Sent: Monday, May 29, 2006 12:52 PM
> > To: 'Vaclav Kubart'
> > Cc: samuel; serusers(a)iptel.org
> > Subject: RE: Authorizing IM requests
> >
> >
> >
> >
> > Well, then what can I use in the following line to authorize IM messages ?
> >
> > if (authorize_message("https://sip.koc.net/xcap")) {
> >
> > Eyebeam updates file /xcap/privacy-lists/user/privacy-lists.xml when I change the "privacy" configuration on Eyebeam client.
> >
> > Thanks,
> > ilker
> >
> > -----Original Message-----
> > From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
> > Sent: Friday, May 26, 2006 4:48 PM
> > To: ?lker Aktuna (Koç.net)
> > Cc: samuel; serusers(a)iptel.org
> > Subject: Re: Authorizing IM requests
> >
> > Yes, I meant, that this will not work together.
> >
> > I don't know. Privacy-lists are something eyeBeam's internal or something standardized?
> >
> > Im-rules are SER internal.
> >
> > Vaclav
> >
> > On Fri, May 26, 2006 at 04:43:35PM +0300, ?lker Aktuna (Koç.net) wrote:
> > > Do you mean it won't work with privacy-lists ?
> > > What can I try ?
> > >
> > > Thanks,
> > > ilker
> > >
> > > -----Original Message-----
> > > From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
> > > Sent: Friday, May 26, 2006 4:40 PM
> > > To: ?lker Aktuna (Koç.net)
> > > Cc: samuel; serusers(a)iptel.org
> > > Subject: Re: Authorizing IM requests
> > >
> > > EyeBeam won't use im-rules and SER won't use with privacy-lists. It something else.
> > >
> > > Vaclav
> > >
> > > On Fri, May 26, 2006 at 02:24:42PM +0300, ?lker Aktuna (Koç.net) wrote:
> > > > Hi Samuel,
> > > >
> > > > Now that presence is working I'm checking xcap possibilities.
> > > > I see that IM xcap authorization is not working.
> > > >
> > > > I don't know what to use in:
> > > > >if (authorize_message("im-rules.xml")){
> > > >
> > > > My client (Eyebeam) does not use im-rules.xml , but it uses
> > > > privacy-lists.xml and that file is in privacy-lists folder. How
> > > > should I change the configuration line to use this file ?
> > > >
> > > > Regards,
> > > > ilker
> > > >
> > > > -----Original Message-----
> > > > From: samuel [mailto:samu60@gmail.com]
> > > > Sent: Tuesday, May 16, 2006 5:26 PM
> > > > To: Vaclav Kubart
> > > > Cc: ?lker Aktuna (Koç.net); serusers(a)iptel.org
> > > > Subject: Re: [Serusers] PA error sending notifies
> > > >
> > > > 2006/5/16, Vaclav Kubart <vaclav.kubart(a)iptel.org>:
> > > > > reply inline...
> > > > > > If you are using XCAP authentication for MESSAGEs, there's a
> > > > > > function called authorize_message that needs to have as
> > > > > > parameter the file name of the IM ruleset.
> > > > > > For user sam, in xcap-root/im-rules/users/sam/im-rules.xml
> > > > > > there are the rules for this function. The XML file is
> > > > > > similar to the presence-rules but has important differences
> > > > > > (correct me if I'm wrong,
> > > > > > Vaclav!!!):
> > > > > > *it only has a blacklist parameter (no whitelist!!)
> > > > >
> > > > > It doesn't depend on name of the rule
> > > > > (blacklist/whitelist/...) it depends on the action (block,
> > > > > ...). You can have as many rules as you want, but to
> > > > > explicitly enable something
> > > > > (whitelist) is needless because MESSSAGEs are allowed by
> > > > > default (at the end of the presence handbook I tried to
> > > > > describe im-rules the same way as presence-rules are described in their draft).
> > > > >
> > > > > > *the namespace is different (so be carefull in copy&paste
> > > > > > from the
> > > > > > presence-rules!!!) and, as Vaclav poitned out "proprietary"
> > > > > > from iptel.
> > > > >
> > > > > And the action element name differs: <im-handling> is used
> > > > > instead of <sub-handling>.
> > > > >
> > > >
> > > > Uops...I haven't noticed :P thanks!
> > > >
> > > > > Vaclav
> > > > >
> > > > > >
> > > > > > About the structure I have: x86 debian testing. Libraries
> > > > > > versions I don't know exactly but the ones in the testing
> > > > > > repository EXCEPT a library which I had to get for serweb
> > > > > > from the stable version...but it's not affecting SER part.
> > > > > >
> > > > > > Samuel.
> > > > > > 2006/5/16, ?lker Aktuna (Koç. net ) <ilkera(a)koc.net>:
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >Hi,
> > > > > > >
> > > > > > >What did you mean by following:
> > > > > > >
> > > > > > >>Instead of
> > > > > > >>>
> > > > > > >>> if (authorize_message("http://localhost/xcap")) {
> > > > > > >>
> > > > > > >>there should be
> > > > > > >>
> > > > > > >>if (authorize_message("im-rules.xml")){
> > > > > > >
> > > > > > >Btw, did you receive my email with following questions :
> > > > > > >
> > > > > > >>> I have the same problem with notification and other
> > > > > > >>> presence messages
> > > > > > >with you.
> > > > > > >>> Can you tell me which Linux distribution you are using Ser on ?
> > > > > > >>> Also please include version numbers for libraries that
> > > > > > >>> are required by
> > > > > > >Ser.
> > > > > > >>>
> > > > > > >>> I am trying to find similarities between yours and my ser server.
> > > > > > >
> > > > > > >Regards,
> > > > > > >ilker
> > > > > > >
>
>
>
>
>
> <http://387555.sigclick.mailinfo.com/sigclick/06090304/030C4A09/020148
> 03/15141696.jpg>
> ______________________________________________________________________
> ______________________________________________________________________
> _ 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.
> ______________________________________________________________________
> ______________________________________________________________________
> _
<http://387555.sigclick.mailinfo.com/sigclick/030A0606/02044D0A/07044D01/202…>
_____________________________________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________________________________
_____________________________________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________________________________
Now I am getting the following error while running SER:
stateless - initializing
0(0) Maxfwd module- initializing
textops - initializing
root@ubuntu:/usr/local/sbin # 0(0) new_connection(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
0(0) db_init(): Could not create a connection
0(0) register_udomain(): Can not open database connection
0(0) domain_fixup(): Error while registering domain
ERROR: error -1 while trying to fix configuration
It will be great if some one can throw some light on how to resolve this this issue.
MySql version is 5.0
Thanks,
Benjamin.
_____
From: Mindaugas Kuprys [mailto:mindaugask@erdves.lt]
Sent: Tuesday, May 30, 2006 6:40 PM
To: George, Benjamin
Cc: serusers(a)iptel.org
Subject: Re: [Serusers] mysql configuration issue
Check if your mysqld is running. Check if you socket is in the right place (
/var/run/mysqld/mysqld.sock) If not try to connect through tcp/ip insted of socked - rewrite localhost with 127.0.0.1 in ser.cfg file.
Benjamin.George(a)t-systems.com <mailto:Benjamin.George@t-systems.com> wrote:
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> [mailto:serusers-bounces@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 <mailto:serusers@iptel.org>
Subject: Re: [Serusers] mysql configuration issue
what does /var/log/messages say?
On 5/29/06, Benjamin.George(a)t-systems.com <mailto:Benjamin.George@t-systems.com> <mailto:Benjamin.George@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 <mailto:andrey.kouprianov@gmail.com> ]
Sent: Monday, May 29, 2006 12:39 PM
To: serusers(a)iptel.org <mailto:serusers@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/ <ftp://ftp.iptel.org/pub/ser/presence/>
On 5/29/06, Benjamin.George(a)t-systems.com <mailto:Benjamin.George@t-systems.com> <mailto:Benjamin.George@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 <mailto:Serusers@lists.iptel.org>
http://lists.iptel.org/mailman/listinfo/serusers <http://lists.iptel.org/mailman/listinfo/serusers>
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org <mailto:Serusers@lists.iptel.org>
http://lists.iptel.org/mailman/listinfo/serusers <http://lists.iptel.org/mailman/listinfo/serusers>
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org <mailto:Serusers@lists.iptel.org>
http://lists.iptel.org/mailman/listinfo/serusers <http://lists.iptel.org/mailman/listinfo/serusers>
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org <mailto:Serusers@lists.iptel.org>
http://lists.iptel.org/mailman/listinfo/serusers <http://lists.iptel.org/mailman/listinfo/serusers>
Hi,
is anyone using openser in a redundancy enviroment? i'm planning to use
two sunfire with a running openser on each.
both openser get the same ip adress. on a cisco switch i can switch
between too servers via hsrp. so i have a running openser on the expensive
sunfire with redundant disk-drives and power supply. on the other cheap
sunfire runs the backup client on standby. the backup server checks (for
example via sipsak) the availability of the main server every second.
the user-locations are written into a mysql table.
so if server1 fails, server2 can recognize it in a second and can switch
over.
so only some transaction, which were processed at the moment of the
failure will lost.
what do you think. could this work? anyone has other ideas?
bye, martin
there is no plan for it, but I was thinking this would be nice as will
provide survivor over restart and an easy way for other apps to have
access to the dialog info.
for the moment you have the fifo cmd "dlg_list" that lists all current
monitored dialogs.
regards,
bogdan
Martin Klisch wrote:
>>Hi Martin,
>>
>>you mean "MySQL-functionality in dialog module" , right?
>>
>>
>
>yeah right.
>
>
>
>
>>if so, can you be more specific about the purpose of this functionality?
>>
>>
>
>like the usrloc mysql db. so the data (how many opened dialogs) can be
>saved into a mysql table. with timers for saving and so on.
>
>or can i save the data via avp into a db?
>
>
>bye, martin
>
>
>
>
Hi,
Thanks for your reply. I saw that in the source and changed according to them. But I still can't see any radius packets created/sent by Ser when a call is made.
What should I add to the configuration to send start/stop packets ?
Regards,
ilker
-----Original Message-----
From: serusers-bounces(a)lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of sip
Sent: Tuesday, May 30, 2006 8:28 PM
To: serusers(a)iptel.org
Subject: Re: [Serusers] Radius accounting howto
Those params are valid for the old acc module compiled with radius support.
The acc_radius module I think uses log_flag and log_missed_flag (according to the source).
N.
On Tue, 30 May 2006 17:54:40 +0300, Ýlker Aktuna (Koç.net) wrote
> Hi everyone,
>
> I am trying to use acc_radius module with presence CVS sources.
> I compiled the radiusclient library and compiled ser with acc_radius module.
>
> Then I added following lines to the config:
>
> loadmodule "/root/ser/lib/ser/modules/acc_radius.so"
> modparam("acc_radius", "radius_config",
"/usr/local/etc/radiusclient-ng/radiusclient.conf")
> modparam("acc_radius", "service_type", 15) modparam("acc_radius",
> "radius_flag", 1) modparam("acc_radius", "radius_missed_flag", 3)
> modparam("acc_radius", "report_ack", 0)
>
>
> But when I try to start ser, it doesn't accept 2 parameters:
> modparam("acc_radius", "radius_flag", 1) modparam("acc_radius",
> "radius_missed_flag", 3)
>
> What should be the correct syntax for these parameters ? are they required ?
>
> And what else should I add to the configuration to send radius-start
> and
radius-stop messages to the radius server ?
>
> Thanks,
> ilker
>
>
>
>
_
<http://387555.sigclick.mailinfo.com/sigclick/02090504/00064E0A/07084E03/211…>
_____________________________________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________________________________
Hi padmaja,
Running openser from cvs would not solve your problem. Openser from cvs is the development version which will be released after final testing is done.
To be safe, its better if you use .tar.gz file to install. For enabling mysql, go to the openser directory and you'll find a makefile. In the makefile there is a line exclude_modules?= somewhere around line no.49. From there just remove mysql and recompile it again.
You can start openser using openserctl start from the command line.
To check for some errors you can set debug=9 in the openser.cfg file.
Normally the logs are stored into /var/log/messages. You can check for errors in this file.
Hi!
there is something I need to mention here with respect to openser not
working.....
Initially I had openser installed from .tar.gz and i could run it from
/usr/local/sbin/openser. It worked fine that way without any authentication.
I could see local registration of my sip UAs with the openser being
successful. then i set up mysql. It too started successfulyy thru webmin.
next I tried to create the openser database in mysql from
/usr/sbin/openser_mysql.sh create. It prompted me for the root password of
mysql, the domain name and then failed stating that the Ha1 calculation
failed. also when i tried to modify the openser.cfg file to support mysql
database i found that there is no mysql.so module in the
/usr/local/lib/openser/modules/ path.
Because of the above problems, I tried installing openser from CVS and here
all the modules and configuration files are present in the respective
locations as mentioned in the web link for installing openser. I could even
create the openser database structures in mysql. i tried uncommenting the
needed modules for database suppport. now when i try to run openser thru
monit, there is absolutely no response and openser does not look like
running............
I am a newbie at openser......please help me which way i should run
openser.....
thanks and regards,
Padmaja
---------------------------------
Yahoo! India Answers: Share what you know. Learn something new Click here
Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now
