With recently changed behavior of MySQL the reconnection scheme of SER
( and I am running SER 0.9.4 and MySQL 5.0.13 ) would no longer work..
It's OK, that can be fixed with slight correction of MySQL configuration
or with minor change in SER code..
What I noticed though is that if the database does go down, the REGISTER
request does not get any response, while I would expect SER to still
send something like 500 Internal Server Error.. I wonder if it's a SER
bug or a routing script issue..
Thanks,
Sergei
Ok!
I will try to acomplish it by creating a new table in ser database.
But this suxs a lot because serctl script only fills in aliases
database, so I will have to do it by hand!!
Any trouble will be reported again.
p.d: Moltes gràcies, tant sem nota?
El 26/10/2005, a las 12:35, Samuel Osorio Calvo escribió:
> I haven't played with AVP much so I might be wrong, but I think you
> should replace the $ from the username after the alias:
>
> avp_db_load($alias/$username,i:alias")--->
> avp_db_load($alias/username,i:alias")
>
> ^
> And about the pushto....I have no idea if it accepts two headers,
> so somebody with more experience will tell you if it is possible to
> push the alias into the ruri and to in the same avp_pushto. Just a
> guess, try to do it in two different commands.
>
> Hope it helps,
>
> Samuel.
>
> P.D. Espero q algú et pugui ajudar...sort!!
>
> Unclassified
>
>
>>>> Pol <kuroki(a)gmail.com> 10/19/05 09:27PM >>>
>>>>
>>>>
> Hi SerUsers!
> I'm completly crazy tryin' to do the following:
> I just want to load from DB user alias and rewrite it into "$to
> $ruri", because these calls shoud go directly to asterisk voicemail
> and they are numerical not alphanumeric.
> i tried to do the following:
>
> if(avp_db_load($alias/$username,i:alias")
> avp_pushto("$ruri/$to","alias")
> just to load from alias table username into an integer called alias
> and then pushed to new $ruri.
>
> I'm new in ser and avps module it's really usefull but a little bit
> "unreadable", plz this should work for tomorrow :$ any help plz!?
> be as much especific as can, because i don't know if i have done the
> proper modparams.
> these are:
>
> modparam("avpops", "avp_url", "mysql://ser:heslo@localhost/ser")
> modparam("avpops", "avp_table", "usr_preferences")
> #modparam("avpops", "use_domain", "1")
> modparam("avpops", "uuid_column", "uuid")
> modparam("avpops", "username_column", "username")
> modparam("avpops", "domain_column", "domain")
> modparam("avpops", "attribute_column", "attribute")
> modparam("avpops", "value_column", "value")
> modparam("avpops", "type_column", "type")
>
> THX
>
>
> On 10/13/05, Iqbal <iqbal(a)gigo.co.uk> wrote:
>
>
>>
>>
>> Hi
>>
>> I think you have the source syntax written below in the avp_db_load
>> statements
>>
>> so the source will have $from or $to or $ruri optionally followed
>> by the
>> words "username" or domain
>>
>> eg
>>
>> avp_db_load($from/username) of avp_db_load($to/domain) ---note
>> these are
>> not completed syntax
>>
>> OR instead of the sip_uri which is $from,$to,$ruri you can have
>> avp_alias
>>
>> which is exactly what it says, its an alias,
>>
>> Str_value this is the number directly related to the predefined
>> alias in
>> the line above
>>
>> The name can be a string S:
>> interger i:
>>
>> or you can leave out the S: and just use the name
>>
>> or of course an alias
>>
>> I know thats probably not clear...in fact I just read it myself,
>> the best
>> thing with avpops , is to look at the db, and create a few, and
>> then see
>> how to pop them out and play with 'em
>>
>> Iqbal
>>
>>
>> On 10/12/2005, "Lenir" <lenirsantiago(a)yahoo.com> wrote:
>>
>>
>>
>>> Hello list,
>>>
>>> I'm reading the documentation for AVPOPS, and Im a little
>>> confused in this
>>> section:
>>>
>>> --------------------------------------------------------------------
>>> --------
>>> -----
>>> #avp_db_load(source,name)
>>> #Loads from DB into memory the AVPs corresponding to the given
>>> source.
>>>
>>> Meaning of the parameters is as follows:
>>>
>>>
>>> source - what info is used for identifying the AVPs. Parameter
>>> syntax:
>>>
>>>
>>> source = (sip_uri)['/'('username'|'domain')]) | (avp_alias) |
>>> str_value
>>>
>>> sip_uri = '$from' | '$to' | '$ruri'
>>>
>>>
>>> name - which AVPs will be loaded from DB into memory. Parameter
>>> syntax is:
>>>
>>>
>>> name = avp_spec['/'(table_name|'$'db_scheme)]
>>>
>>> avp_spec = ''|'s:'|'i:'|avp_name|avp_alias
>>>
>>>
>>> Example 1-12. avp_db_load usage
>>>
>>> ....
>>> avp_db_load("$from","i:678");
>>> avp_db_load("$ruri/domain","i:/domain_preferences");
>>> avp_db_load("$uuid","s:404fwd/fwd_table");
>>> avp_db_load("$ruri","i:123/$some_scheme");
>>> ....
>>>
>>> --------------------------------------------------------------------
>>> --------
>>> -----
>>>
>>> My question are:
>>>
>>> Can someone explain the source syntax?
>>> Can someone explain the name syntax?
>>> what are i:, s:, avp_name and avp_alias?
>>>
>>> Thanks!
>>>
>>> Lenir
>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>
>> _____________________________________________________________________
>> Mensaje analizado y protegido, tecnologia antivirus www.trendmicro.es
>>
>>
>>
>
> _______________________________________________
> Serusers mailing list
> serusers(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
>
_____________________________________________________________________
Mensaje analizado y protegido, tecnologia antivirus www.trendmicro.es
Okay you Cisco Call Manager and SER GURU's. Two questions in this posting
the first one is what I call the harder of the two.
I work for a company which has Cisco Call manager 3.3 and 2 gateway
routers running h323. The system works well when it works. Yet as we all
know Cisco Call Manager does not support SIP. Only 4.0 supports sip
trunking. Yet my company has sales people who want to use the phones to
connect into the company and use their system in a remote user fashion.
What I want to do is setup a small SER server on the DMZ configure it for
remote users to call internal extensions which are configured by the Cisco
Call Manager and I want to my remote users to be able to call out to PSTN
via our routers using h323. Is this difficult to do with SER. If possible
in your response give me details, and configuration examples.
Currently we are using a 5 year old VPN and that is killing our VPN
appliance and would rather have it external for our sales force to connect
directly from home via a sip device.
That was question 1.
Second question,
I have SER installed on a FEDORA Core 4 and one of the forum users was
nice enough to forward me RPM's of Ser. I installed all the RPM along with
SERWEB. I am unable to access the url via http://<your-host>/ser/admin
Everything installed properly
I have looked at my httpd and have done multple /etc/rc.d/init.d/httpd start
Everything seems like it starting up. I just can't get the SerWeb working
properly.
Thanks in Advance
Goran Donev
Hi,
this is not a technical question regarding OpenSER, but more of req for
information.
I'm using Cisco phones and gateways and have implemented DNS SRV
redundancy.
However, I have never seen a SIP phone that really works with DNS SRV
redundancy, except from Cisco. (which actually works as a charm)
Does anyone know other phones that can use dns srv for redundancy?
At least Cisco tries the next DNS SRV entry if it receives a port
unreachable from the highest priority proxy...
--
mvh/best regards
Helge Waastad
System Engineer
Smartnet
Hi,
I am using 2 ser servers and they both share a common database, so
they write the location information to that database. but problem is
they don'read the information from database, is there a way to force
them to lookup the database, so that changes made by one are reflected
to other or atleast to refresh cache from database.
Regards,
Ranveer.
Hi,
I will appreciate your kind help in the following issue:
1. I could not find ser-mysql package for download. I need the package for REDHAT linux 9.0.
-- Can anybody please help?
2. I have Mysql server that automatically installed with REDHAT linux but when I tried:
mysql> connect ser
-- it fails with a message, "error 1049 unknown database ser".
Please help.
Thanks
Pappu
Hello list,
I'm reading the documentation for AVPOPS, and Im a little confused in this
section:
----------------------------------------------------------------------------
-----
#avp_db_load(source,name)
#Loads from DB into memory the AVPs corresponding to the given source.
Meaning of the parameters is as follows:
source - what info is used for identifying the AVPs. Parameter syntax:
source = (sip_uri)['/'('username'|'domain')]) | (avp_alias) | str_value
sip_uri = '$from' | '$to' | '$ruri'
name - which AVPs will be loaded from DB into memory. Parameter syntax is:
name = avp_spec['/'(table_name|'$'db_scheme)]
avp_spec = ''|'s:'|'i:'|avp_name|avp_alias
Example 1-12. avp_db_load usage
...
avp_db_load("$from","i:678");
avp_db_load("$ruri/domain","i:/domain_preferences");
avp_db_load("$uuid","s:404fwd/fwd_table");
avp_db_load("$ruri","i:123/$some_scheme");
...
----------------------------------------------------------------------------
-----
My question are:
Can someone explain the source syntax?
Can someone explain the name syntax?
what are i:, s:, avp_name and avp_alias?
Thanks!
Lenir
Hello,
I would like to know if SER stores somewhere the last "registration"
date for a given user.
I have looked at all tables and couldn't find such a field.
So I would like to know if there is a recommended way to automatically
delete all users who haven't logged in since more than x months?
Thank you,
--
_ Damien Sandras
(o- GnomeMeeting: http://www.gnomemeeting.org/
//\ FOSDEM 2006 : http://www.fosdem.org
v_/_ SIP Phone : sip:dsandras@gnomemeeting.net
sip:600000@gnomemeeting.net
