Hi,
I've already tried that. Doesn't work...
I guess the new CVS version has some new table structure but that's not updated on the database creating scripts.
How can I learn the new database structure ?
Thanks,
ilker
-----Original Message-----
From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
Sent: Wednesday, May 24, 2006 4:30 PM
To: İlker Aktuna (Koç.net)
Cc: Andrey Kouprianov; serusers(a)iptel.org
Subject: Re: [Serusers] new table version
Drop tables and create them again (both with ser_mysql) - this should work.
Vaclav
On Wed, May 24, 2006 at 04:16:59PM +0300, ?lker Aktuna (Koç.net) wrote:
> Hi,
>
> what's the bad idea ?
> "reinit" ?
> it doesn't work. Anyway, I couldn't start new CVS installation with mysql...
>
> any idea ?
>
> regards,
> ilker
>
>
> ________________________________
>
> From: serusers-bounces(a)lists.iptel.org
> [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Andrey
> Kouprianov
> Sent: Wednesday, May 24, 2006 4:14 PM
> To: serusers(a)iptel.org
> Subject: Re: [Serusers] new table version
>
>
> dont mind that... bad idea..
>
>
> On 5/24/06, Andrey Kouprianov <andrey.kouprianov(a)gmail.com> wrote:
>
> maybe "ser_mysql.sh reinit"?
>
>
> On 5/24/06, ?lker Aktuna (Koç. net) < ilkera(a)koc.net <mailto:ilkera@koc.net> > wrote:
>
>
>
> Hi,
>
> I reinstalled a new CVS version of Ser today. I receive the following errors. It says that this version uses a new table structure I guess.
> But the suggested command "ser_mysql.sh reinstall" does not exist. ser_mysql.sh does not have "reinstall" parameter.
>
> What can I do to build the new tables ?
>
> May 24 15:40:43 sesapp /root/ser/sbin/ser[23613]: domain_fixup(): Error while registering domain
> May 24 15:44:35 sesapp /root/ser/sbin/ser[23655]: register_udomain():
> Invalid table version (use ser_mysql.sh reinstall)
>
> Thanks,
> ilker
>
>
>
<http://387555.sigclick.mailinfo.com/sigclick/0609010D/04064D01/02054A0A/651…>
_____________________________________________________________________________________________________________________________________________
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 Masters,
Iam using my SER on a public ip , and i register some users staying
behind NAT till now every thing going smooth and when called from xten soft
phone to another phone i can hear the ring but when i answered the phone i
cannot hear in both sides any thing with pindrop silence
I think there is problem in codecs or some thing else ? and iam
using G711-u,G711a in both the phones can you please tell me the solution
for this
Iam using ser-0.9.6
mediaproxy-1.4.2
iam not using dispatcher
looking for your help ... thanks in advance
kindly Regards,
Ravi.
I am using dispatcher module, when I put Destination List File IPs
(Gateways) in numerical order and "ds_select_dst("1", "4")" the openser send
Invites to all gateway in this files. But if the IPs (gateways) isn't in
numerical order the openser send only the first gateway. Is this true or
erro in my test?
Example in numerical order:
10.0.0.1:5060
10.10.10.2:5060
Hi,
what's the bad idea ?
"reinit" ?
it doesn't work. Anyway, I couldn't start new CVS installation with mysql...
any idea ?
regards,
ilker
________________________________
From: serusers-bounces(a)lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Andrey Kouprianov
Sent: Wednesday, May 24, 2006 4:14 PM
To: serusers(a)iptel.org
Subject: Re: [Serusers] new table version
dont mind that... bad idea..
On 5/24/06, Andrey Kouprianov <andrey.kouprianov(a)gmail.com> wrote:
maybe "ser_mysql.sh reinit"?
On 5/24/06, İlker Aktuna (Koç. net) < ilkera(a)koc.net <mailto:ilkera@koc.net> > wrote:
Hi,
I reinstalled a new CVS version of Ser today. I receive the following errors. It says that this version uses a new table structure I guess.
But the suggested command "ser_mysql.sh reinstall" does not exist. ser_mysql.sh does not have "reinstall" parameter.
What can I do to build the new tables ?
May 24 15:40:43 sesapp /root/ser/sbin/ser[23613]: domain_fixup(): Error while registering domain
May 24 15:44:35 sesapp /root/ser/sbin/ser[23655]: register_udomain(): Invalid table version (use ser_mysql.sh reinstall)
Thanks,
ilker
<http://387555.sigclick.mailinfo.com/sigclick/03090E04/0C024D07/07034503/001…>
_____________________________________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________________________________
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
<http://387555.sigclick.mailinfo.com/sigclick/050E0602/04024D06/01054D05/166…>
_____________________________________________________________________________________________________________________________________________
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,
I reinstalled a new CVS version of Ser today. I receive the following errors. It says that this version uses a new table structure I guess.
But the suggested command "ser_mysql.sh reinstall" does not exist. ser_mysql.sh does not have "reinstall" parameter.
What can I do to build the new tables ?
May 24 15:40:43 sesapp /root/ser/sbin/ser[23613]: domain_fixup(): Error while registering domain
May 24 15:44:35 sesapp /root/ser/sbin/ser[23655]: register_udomain(): Invalid table version (use ser_mysql.sh reinstall)
Thanks,
ilker
<http://387555.sigclick.mailinfo.com/sigclick/03090E04/0C024D07/07034503/001…>
_____________________________________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________________________________
Thanks Klaus, you pointed me in the right direction, I dropped my p_assert
table and used the subscriber table instead. If you guys wouldn't mind
looking this over for me when you get a chance, I would appreciate it. It
seems to be working just fine, but I wouldn't mind a second opinion if there
is a better way to do something. Here is what I ended up with:
# ------------- avpops params --------------------
# define "from_hdr" as an alias to AVP ID 12
#
modparam("avpops", "avp_aliases", "from_hdr=s:12")
modparam("avpops", "avp_table", "avptable")
modparam("avpops", "uuid_column", "contact")
modparam("avpops", "username_column", "username")
modparam("avpops", "domain_column", "domain")
modparam("avpops", "db_scheme",
"scheme0:table=subcriber;uuid_col=uuid;username_col=username;value_type=stri
ng")
I moved this up to the "if method=register" section after my www challenge:
# write sip_uri "from" as avp "from_hdr"
avp_write("$from", "from_hdr");
And this is after "if method=invite":
# Remove P-Asserted-Identity if it exist
#
remove_hf("P-Asserted-Identity");
# If Privacy header is set to ID make
anonymous
if (search("[Pp]rivacy:[^@][Ii][Dd][^@];")
{
append_hf("P-Asserted-Identity:
<anonymous(a)anonymous.invalid>");
uac_replace_from("Anonymous","sip:anonymous@anonymous.invalid");
}
# Else insert P-Asserted-Identity
if (!search("[Pp]rivacy:[^@][Ii][Dd][^@];")
{
# P-Asserted-Identity Insertion
#
avp_printf("s:12",
"<sip:$fU@64.192.174.8>");
avp_pushto("$P-Asserted-Identity",
"s:12");
}
Ty Manthey
-----Original Message-----
From: Klaus Darilion [mailto:klaus.mailinglists@pernau.at]
Sent: Tuesday, May 23, 2006 5:05
To: Ty Manthey
Cc: users(a)openser.org
Subject: Re: [Users] P-Asserted-Identity
Ty Manthey wrote:
> This is kicking my butt.
>
> OpenSER 1.0.1
>
> I just want the P-Asserted-Identity field to populate with info it gets
out
> of the "from" header.
>
> modules loaded:
> loadmodule "/usr/lib/openser/modules/mysql.so"
>
> loadmodule "/usr/lib/openser/modules/avpops.so"
> loadmodule "/usr/lib/openser/modules/sl.so"
> loadmodule "/usr/lib/openser/modules/tm.so"
> loadmodule "/usr/lib/openser/modules/rr.so"
> loadmodule "/usr/lib/openser/modules/maxfwd.so"
> loadmodule "/usr/lib/openser/modules/usrloc.so"
> loadmodule "/usr/lib/openser/modules/registrar.so"
> loadmodule "/usr/lib/openser/modules/textops.so"
>
> avpops params:
>
> modparam("avpops", "avp_url", "mysql://openser:xxxxxxx@localhost/openser")
> modparam("avpops", "avp_aliases", "from=s:from")
> modparam("avpops", "avp_table", "avptable")
> modparam("avpops", "uuid_column", "contact")
> 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")
> modparam("avpops", "db_scheme",
>
"scheme0:table=p_assert;uuid_col=uuid;username_col=username;value_type=strin
> g")
>
> ( I built a table "p_assert" in the openser database with the above
columns,
> varchar(255) )
>
>
> attempted insertion:
>
> # P-Asserted-Identity Insertion
> #
> avp_write("$from", "s:from");
> avp_db_load("$from", "s:pai/p_assert");
> avp_printf("s:from",
> "<sip:$fu(s:pai)@64.192.174.8>");
Not sure if this overwrite the previously created AVP or it creates a
second one with the same name.
Further - what is the problem? Pushing into the header or fetching from DB?
Have you tried it without loading from DB? If this works, make it
dynamically loading from DB.
btw: I put the PAI into the rpid column in the subscriber table. Thus,
the s:rpid gets loaded during authentication.
regards
klaus
> remove_hf("P-Asserted-Identity");
> #avp_pushto("$P-Asserted-Identity/request",
> "s:pai");
> append_hf("P-Asserted-Identity:
> <sip:7034633348@64.192.174.8>\r\n");
> log(1,"***P asserted ID placed *** \n");
>
> I think it's obvious I know enough to get myself into trouble, but I
thought
> populating the P-asserted header field with info out of the "From" header
> wouldn't be this complicated. What am I missing/doing wrong?
>
> Thanks.
>
>
> Ty Manthey
>
>
> _______________________________________________
> Users mailing list
> Users(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
Because of this , it causes a problem for my RTPproxy.
My RTP proxy reference the same dialog by the call-id , so if it is
different from the initial call-id, the entire dialog will be
interpreted as 2 separated sessions and RTP ports allocated differently.
The end result ? , one way voice.
Is this kind of behaviour correct ?
-----Original Message-----
From: users-bounces(a)openser.org [mailto:users-bounces@openser.org] On
Behalf Of Mike Williams
Sent: Wednesday, May 24, 2006 7:47 PM
To: users(a)openser.org
Subject: Re: [Users] Call-ID discrepancy
On Wednesday 24 May 2006 07:01, Daniel-Constantin Mierla wrote:
> > I notice that during a dialog session from a UA to the server going
> > to the PSTN gateway, it was refering to this Call-ID until the point
> > when the request was forwarded to the PSTN gateway. When the PSTN
> > gateway replies, it replied with a same Call-ID with a different IP
> > address at the back (9ce97fd3-1a800040(a)123.234.123.234
> > <mailto:9ce97fd3-1a800040@123.234.123.234> )
>
> That is very wrong. Maybe there is an ALG in the path which replaces
> the private address with public ones, but that should not apply to the
> call-id. The caller should reject the reply.
I have actually seen an ALG do exactly that before, and my client
dropped all messages coming back through it, as expected.
---Mike
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
Dear all,
help me please to understand - what it could be mean:
this line appear in openser ( OpenSer (1.0.1) log:
- May 23 21:16:05 sh /usr/local/sbin/openser[11409]:
BUG:tm:run_failure_handlers: stack level is 1!!
after execution this part of my config file:
....
if (!((src_ip == 127.0.0.1) && (src_port == 5060))) {
xlog("L_ALERT"," Flow: SER -->
B2B ... \n");
rewritehost("127.0.0.1");
t_on_failure("1");
t_relay();
....
also it appear when on_reply section processed
Failure_route[1] look like that:
failure_route[1]
{
xlog("L_ALERT"," \n");
xlog("L_ALERT","Failure_Route[1]: \n");
# authentication reply received?
if ( t_check_status("401") )
{
xlog("L_ALERT"," Status code:
[401] [Unauthorized] \n");
} ........
Thank you,
Alexey
Hi All,
I notice during the NGREP session , there is this field called Call-ID .
It is something like this format :-
9ce97fd3-1a800040(a)172.16.1.123 <mailto:9ce97fd3-1a800040@172.16.1.123> .
According to the RFC , it is said that this field is generated by the UA
who started the request. I was just wondering, how did they get the IP
Address at the back ? Which IP Address did they reference it from ?
>From the RFC, it also says that the all request/response in the dialog
should use the same Call-ID. When they say this, does it mean the entire
field with the ip address (eg. 9ce97fd3-1a800040(a)172.16.1.123 ) or just
the front part of it (eg. 9ce97fd3-1a800040 ) ?
I notice that during a dialog session from a UA to the server going to
the PSTN gateway, it was refering to this Call-ID until the point when
the request was forwarded to the PSTN gateway. When the PSTN gateway
replies, it replied with a same Call-ID with a different IP address at
the back (9ce97fd3-1a800040(a)123.234.123.234 )
172.16.1.123 - Private address of the UA
123.234.123.234 - Public address of the UA
Strange ? Give your comment. Somehow i feel that this implementation is
wrong.
Regards,
Sam
