All,
A new DB module has been submitted to the trunk that incorporates the Berkeley DB into Openser.
This module depends on Berkeley DB, which is a high-performance embedded DB kernel.
The Berkeley DB offers a couple of architectures:
1. Concurrent Data Store (CDS)
2. Transaction Data Store
This module uses the CDS model. One of the main differences between these architectures is DB recovery and robustness (Please refer to the Berkeley DB for full details). In a nutshell, the onus of recovery is on the application (e.g. openser). This modules contains a recovery program utils/db_berkeley/bdb_recover that can be used to recover DB files.
Like other DB modules, the DB must be created before Openser can be started. The standard openserdbctl script can be used to create the DB once the Berkeley DB is installed.
The module is experimental, and has been tested primarily with registration.
**Important**
Berkeley DB v4.6.19 contains a bug that will most certainly result in deadlock. There is a patch available for Berkeley DB 4.6.19, and the fix is to be sourced in the next release of 4.6.
Special thanks to the authors of dbtext and postgesql modules:
dbtext - Daniel-Constantin Mierla
postgres - Greg Fausak, Andy Fullford, Norman Brandinger
Also thanks to Henning Westerholt for reviewing the code .
Regards,
William Quan
Cisco Systems
Hi,
thanks for reply my email. I made the following test: I sent five different messages:
one
two
three
four
five
and I traced the SIP traffic passing through the server. They were stored in the DB in the correct sequence. So far so good. Now comes the problem, I saw the IM going out from my SIP Server and the sequence was wrong:
three
five
two
four
one
And exactly in that way appeared the IM in my client when the user went online.
In my opinion the IM were not properly sent when they went out from OpenSER
Cheers,
Cesar
-----Ursprüngliche Nachricht-----
Von: Daniel-Constantin Mierla [mailto:daniel@voice-system.ro]
Gesendet: Donnerstag, 04. Oktober 2007 13:28
An: Cesar Troncoso
Cc: users(a)openser.org
Betreff: Re: [OpenSER-Users] MSILO: dump stored messages
Hello,
they should be sent in order of receiving -- however I will double
check. Because they are sent in a very short time frame, maybe the get
in a different order to the user, because of network transmission. Can
you watch the sip traffic sent by proxy?
Cheers,
Daniel
On 10/04/07 13:39, Cesar Troncoso wrote:
>
> Hello,
>
>
>
> I have a problem by using the MSILO Module. The messages stored in the
> DB (table SILO) are not sent in the right sequence. Therefore when the
> user goes online again and receives the messages previously stored in
> the DB, he is not able to understand them. Any Ideas or suggestions
> how to deal this problem?
>
>
>
> Thanks,
>
>
>
> Cesar
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
HiBogdan,
Ithink it is a great idea, personally i had a lot of problem identifying
types of database before.and about the issues of VON materials it will
be usefull for us who didnot attend to get the feel of what happened if
you will develop the culture of uploading them at OpenSER site...
Regards,
Lu.
On Thu, 2007-10-04 at 14:14 +0200, users-request(a)openser.org wrote:
> 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: system variables : isbflagset (Daniel Grotti)
> 2. Re: store AVPs with dialog module (Bogdan-Andrei Iancu)
> 3. Re: system variables : isbflagset (Klaus Darilion)
> 4. Re: OpenSER training and consultants in (Northern) Europe?
> (Bogdan-Andrei Iancu)
> 5. Re: system variables : isbflagset (Bogdan-Andrei Iancu)
> 6. Re: OpenSER Admin Course at VoN Italy ---> documentation?
> (Bogdan-Andrei Iancu)
> 7. Renaming the DB modules (Bogdan-Andrei Iancu)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 04 Oct 2007 09:55:42 +0200
> From: Daniel Grotti <daniel.grotti(a)unibo.it>
> Subject: Re: [OpenSER-Users] system variables : isbflagset
> To: Marcello Lupo <mlist(a)itspecialist.it>
> Cc: users(a)openser.org
> Message-ID: <47049C7E.6070500(a)unibo.it>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> Thank for your answer.
> But I'd like to know and read on std output the real value of bflag, not
> that it's set.
> I don't know if it's possible.
> Ex.:
> ....
> ....
> xlog("L_INFO", "the value of branch flag is [STRING]");
> if (method=="INVITE")
> { setbflag(6);
> xlog("L_INFO","the value of bflag is now [STRING]");
> };
> ....
> ..
>
> so, which kind of [STRING] I have to put in?
> Bye
> daniel
>
> Marcello Lupo wrote:
> > Hi Daniel,
> >
> >
> > if(isbflagset(6)) {
> > xlog("L_NOTICE","BFLAG 6 is SET");
> > }
> >
> >
> > Bye,
> > Marcello
> >
> > Daniel wrote:
> >> Hi everybody,
> >>
> >> I'm using openser 1.2.2 and I'd like to know the result of some
> >> expression used in my main route.
> >> For exemple, How can I read the answer of "isbflagset (6)" expression
> >> and write it on standard output with xlog ?
> >>
> >> thanks.
> >> daniel
> >>
> >> Daniel
> >> ________________________
> >> e-mail : d.grotti(a)gmail.com <mailto:d.grotti@gmail.com>
> >> ------------------------------------------------------------------------
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users(a)openser.org
> >> http://openser.org/cgi-bin/mailman/listinfo/users
> >
> >
>
> --
> ------------------------------
> Daniel Grotti
> DEIS - Universit di Bologna
> ------------------------------
> Via Venezia, 52
> 47023 Cesena (FC) - ITALY
> ------------------------------
> email: daniel.grotti(a)unibo.it
> ------------------------------
>
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Thu, 04 Oct 2007 12:22:23 +0300
> From: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro>
> Subject: Re: [OpenSER-Users] store AVPs with dialog module
> To: Klaus Darilion <klaus.mailinglists(a)pernau.at>
> Cc: users(a)openser.org
> Message-ID: <4704B0CF.8070407(a)voice-system.ro>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Klaus,
>
> currently it is not possible, but I'm flirting with the idea... I plan
> to start some work in this direction for 1.4.
>
> regards,
> bogdan
>
> Klaus Darilion wrote:
> > Hi!
> >
> > Currently, to have AVPs also in in-dialog transaction I store them in
> > RR parameters. Would it be possible to store them inside the dialog
> > module - from script and from within other modules?
> >
> > regards
> > klaus
> >
> > _______________________________________________
> > Users mailing list
> > Users(a)openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Thu, 04 Oct 2007 11:24:31 +0200
> From: Klaus Darilion <klaus.mailinglists(a)pernau.at>
> Subject: Re: [OpenSER-Users] system variables : isbflagset
> To: Daniel Grotti <daniel.grotti(a)unibo.it>
> Cc: users(a)openser.org
> Message-ID: <4704B14F.6000701(a)pernau.at>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> A flag is binary, thus it is set or unset - 0 or 1.
>
> all the flags are stored in a bitfield. You can dump the whole flags
> using the pseudo variables:
>
> http://openser.org/dokuwiki/doku.php/pseudovariables:1.2.x
>
> $bf - reference to branch flags of branch 0 (RURI) - decimal output
> $bF - reference to branch flags of branch 0 (RURI) - hexa output
> $mf - reference to flags set for current SIP request
> $mF -reference to flags set for current SIP request in hexa
> $sf - reference to script flags - decimal output
> $sF - reference to script flags - hexa output
>
> klaus
>
> Daniel Grotti schrieb:
> > Thank for your answer.
> > But I'd like to know and read on std output the real value of bflag, not
> > that it's set.
> > I don't know if it's possible.
> > Ex.:
> > ....
> > ....
> > xlog("L_INFO", "the value of branch flag is [STRING]");
> > if (method=="INVITE")
> > { setbflag(6);
> > xlog("L_INFO","the value of bflag is now [STRING]");
> > };
> > ....
> > ..
> >
> > so, which kind of [STRING] I have to put in?
> > Bye
> > daniel
> >
> > Marcello Lupo wrote:
> >> Hi Daniel,
> >>
> >>
> >> if(isbflagset(6)) {
> >> xlog("L_NOTICE","BFLAG 6 is SET");
> >> }
> >>
> >>
> >> Bye,
> >> Marcello
> >>
> >> Daniel wrote:
> >>> Hi everybody,
> >>>
> >>> I'm using openser 1.2.2 and I'd like to know the result of some
> >>> expression used in my main route.
> >>> For exemple, How can I read the answer of "isbflagset (6)" expression
> >>> and write it on standard output with xlog ?
> >>>
> >>> thanks.
> >>> daniel
> >>>
> >>> Daniel
> >>> ________________________
> >>> e-mail : d.grotti(a)gmail.com <mailto:d.grotti@gmail.com>
> >>> ------------------------------------------------------------------------
> >>>
> >>> _______________________________________________
> >>> Users mailing list
> >>> Users(a)openser.org
> >>> http://openser.org/cgi-bin/mailman/listinfo/users
> >>
> >>
> >
>
>
>
> ------------------------------
>
> Message: 4
> Date: Thu, 04 Oct 2007 12:24:43 +0300
> From: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro>
> Subject: Re: [OpenSER-Users] OpenSER training and consultants in
> (Northern) Europe?
> To: Roy Sigurd Karlsbakk <roy(a)karlsbakk.net>
> Cc: OpenSER Users <users(a)openser.org>
> Message-ID: <4704B15B.2000609(a)voice-system.ro>
> Content-Type: text/plain; charset=windows-1252; format=flowed
>
> Hi Roy,
>
> Well.....currently only in English and if interested, Romanian ;).....
>
> We are currently investigating to keep the course in different
> locations, but no sure plans for the moment....
> All courses will be promptly posted on the web site and lists.
>
> regards,
> bogdan
>
> Roy Sigurd Karlsbakk wrote:
> > Hi all
> >
> > I became aware of the openser training in Milano some days late, so I
> > wondered if there are others across Europe. Language: Scandinavian or
> > English.
> >
> > I am also interested in getting in contact with OpenSER consultants in
> > Scandinavia.
> >
> > Best reagards
> >
> > roy
> > ---
> > Roy Sigurd Karlsbakk
> > roy(a)karlsbakk.net <mailto:roy@karlsbakk.net>
> > Tlf: 98013356
> > ---
> > Our enemies are innovative and resourceful, and so are we. They never
> > stop thinking about new ways to harm our country and our people, and
> > neither do we. - George W. Bush
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Users mailing list
> > Users(a)openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Thu, 04 Oct 2007 12:30:29 +0300
> From: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro>
> Subject: Re: [OpenSER-Users] system variables : isbflagset
> To: Klaus Darilion <klaus.mailinglists(a)pernau.at>
> Cc: Daniel Grotti <daniel.grotti(a)unibo.it>, users(a)openser.org
> Message-ID: <4704B2B5.2050104(a)voice-system.ro>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Or using bitwise operations, you dump only the value of a single flag.
>
> regards,
> bogdan
>
> Klaus Darilion wrote:
> > A flag is binary, thus it is set or unset - 0 or 1.
> >
> > all the flags are stored in a bitfield. You can dump the whole flags
> > using the pseudo variables:
> >
> > http://openser.org/dokuwiki/doku.php/pseudovariables:1.2.x
> >
> > $bf - reference to branch flags of branch 0 (RURI) - decimal output
> > $bF - reference to branch flags of branch 0 (RURI) - hexa output
> > $mf - reference to flags set for current SIP request
> > $mF -reference to flags set for current SIP request in hexa
> > $sf - reference to script flags - decimal output
> > $sF - reference to script flags - hexa output
> >
> > klaus
> >
> > Daniel Grotti schrieb:
> >> Thank for your answer.
> >> But I'd like to know and read on std output the real value of bflag,
> >> not that it's set.
> >> I don't know if it's possible.
> >> Ex.:
> >> ....
> >> ....
> >> xlog("L_INFO", "the value of branch flag is [STRING]");
> >> if (method=="INVITE")
> >> { setbflag(6);
> >> xlog("L_INFO","the value of bflag is now [STRING]");
> >> };
> >> ....
> >> ..
> >>
> >> so, which kind of [STRING] I have to put in?
> >> Bye
> >> daniel
> >>
> >> Marcello Lupo wrote:
> >>> Hi Daniel,
> >>>
> >>>
> >>> if(isbflagset(6)) {
> >>> xlog("L_NOTICE","BFLAG 6 is SET");
> >>> }
> >>>
> >>>
> >>> Bye,
> >>> Marcello
> >>>
> >>> Daniel wrote:
> >>>> Hi everybody,
> >>>>
> >>>> I'm using openser 1.2.2 and I'd like to know the result of some
> >>>> expression used in my main route.
> >>>> For exemple, How can I read the answer of "isbflagset (6)"
> >>>> expression and write it on standard output with xlog ?
> >>>>
> >>>> thanks.
> >>>> daniel
> >>>>
> >>>> Daniel
> >>>> ________________________
> >>>> e-mail : d.grotti(a)gmail.com <mailto:d.grotti@gmail.com>
> >>>> ------------------------------------------------------------------------
> >>>>
> >>>>
> >>>> _______________________________________________
> >>>> Users mailing list
> >>>> Users(a)openser.org
> >>>> http://openser.org/cgi-bin/mailman/listinfo/users
> >>>
> >>>
> >>
> >
> > _______________________________________________
> > Users mailing list
> > Users(a)openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
>
>
>
>
> ------------------------------
>
> Message: 6
> Date: Thu, 04 Oct 2007 12:33:05 +0300
> From: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro>
> Subject: Re: [OpenSER-Users] OpenSER Admin Course at VoN Italy --->
> documentation?
> To: Matteo Campana <matteo.campana(a)klarya.it>
> Cc: users(a)openser.org
> Message-ID: <4704B351.8070905(a)voice-system.ro>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Matteo,
>
> The materials will be made available via the VoN document repository -
> If this takes too long, probably they will be hosted on the openser site.
>
> Keep posted.
>
> regards,
> bogdan
>
> Matteo Campana wrote:
> > Hi OpenSer team and ML,
> > can I find the slides and the examples of the Rome's conference
> > somewhere in the internet ? :)
> >
> > Regards,
> > Matteo.
> > --
> > *Ing. Matteo Campana
> > System Engineer
> >
> > Klarya s.r.l.*
> >
> > Sede Operativa:
> > Via Agnini 47 - 41037 Mirandola (MO)
> >
> > Tel +39 0535 27325
> >
> > Fax +39 0535 610050
> >
> > Mob +39 320 4258536
> >
> > Sede Legale:
> > Via Salgari, 17 - 41100 Modena
> >
> > Tel +39 059 821332 Fax +39 059 821492
> >
> > email: matteo.campana(a)klarya.it
> >
> > web: www.klarya.it
> >
> >
> > *
> > **Open Source IP Communications*
> > __________________________________________________
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Users mailing list
> > Users(a)openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
>
>
>
>
> ------------------------------
>
> Message: 7
> Date: Thu, 04 Oct 2007 12:59:56 +0300
> From: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro>
> Subject: [OpenSER-Users] Renaming the DB modules
> To: devel <devel(a)openser.org>, "users openser.org" <users(a)openser.org>
> Message-ID: <4704B99C.300(a)voice-system.ro>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi,
>
> during the reviewing process of the new DB module for Berkeley, I made
> proposal to make a naming convention for all the modules implementing
> the DB API.
>
> I suggest something similar as for the modules implementing the MI
> interface, all having the "mi_" prefix. So, for the DB modules we should
> use "db_" prefix:
> db_berkeley
> mysql -> db_mysql
> postgres -> db_postgres
> dbtext -> db_text
> unixodbc -> db_unixodbc
> flatstore -> db_flatstore
>
>
> Does anybody see any drawback or problem if we rename the module before 1.3?
>
> Regards,
> bogdan
>
>
>
> ------------------------------
>
> _______________________________________________
> Users mailing list
> Users(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>
> End of Users Digest, Vol 29, Issue 21
> *************************************
Hi,
during the reviewing process of the new DB module for Berkeley, I made
proposal to make a naming convention for all the modules implementing
the DB API.
I suggest something similar as for the modules implementing the MI
interface, all having the "mi_" prefix. So, for the DB modules we should
use "db_" prefix:
db_berkeley
mysql -> db_mysql
postgres -> db_postgres
dbtext -> db_text
unixodbc -> db_unixodbc
flatstore -> db_flatstore
Does anybody see any drawback or problem if we rename the module before 1.3?
Regards,
bogdan
I built a Sip Server with CentOS-V5 run on the Virtual Machine.I created 2 subscribers in Mysql server.I started Sip server and Mysql and then used Xlite to registered to Sip server. However, I couldn't registered to Sip server. (Xlite run on XP platform on Real PC).So, I have question: Does the Sip Server run on the CentOS platform was set up on Virtual Machine?
---------------------------------
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us.
Hello,
I have a problem by using the MSILO Module. The messages stored in the
DB (table SILO) are not sent in the right sequence. Therefore when the
user goes online again and receives the messages previously stored in
the DB, he is not able to understand them. Any Ideas or suggestions how
to deal this problem?
Thanks,
Cesar
I have a working version of OpenSER running on Xen guest on RedHat/Fedora 5. So in theory Centos 5 should work....
Neill....;o)
----- Original Message ----
From: tran tuan <tuan83vnn(a)yahoo.com>
To: serusers(a)lists.iptel.org
Sent: Thursday, 4 October, 2007 9:11:07 AM
Subject: [Serusers] Does the Sip Server run on the CentOS platform was set up on Virtual Machine?
I built a Sip Server with CentOS-V5 run on the Virtual Machine.I created 2 subscribers in Mysql server.I started Sip server and Mysql and then used Xlite to registered to Sip server. However, I couldn't registered to Sip server. (Xlite run on XP platform on Real PC).So, I have question: Does the Sip Server run on the CentOS platform was set up on Virtual Machine?
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us.
Hi OpenSer team and ML,
can I find the slides and the examples of the Rome's conference
somewhere in the internet ? :)
Regards,
Matteo.
--
*Ing. Matteo Campana
System Engineer
Klarya s.r.l.*
Sede Operativa:
Via Agnini 47 - 41037 Mirandola (MO)
Tel +39 0535 27325
Fax +39 0535 610050
Mob +39 320 4258536
Sede Legale:
Via Salgari, 17 - 41100 Modena
Tel +39 059 821332 Fax +39 059 821492
email: matteo.campana(a)klarya.it
web: www.klarya.it
*
**Open Source IP Communications*
__________________________________________________
Hi everybody,
I'm using openser 1.2.2 and I'd like to know the result of some expression
used in my main route.
For exemple, How can I read the answer of "isbflagset (6)" expression and
write it on standard output with xlog ?
thanks.
daniel
Daniel
________________________
e-mail : d.grotti(a)gmail.com
Hi all
I became aware of the openser training in Milano some days late, so I
wondered if there are others across Europe. Language: Scandinavian or
English.
I am also interested in getting in contact with OpenSER consultants
in Scandinavia.
Best reagards
roy
---
Roy Sigurd Karlsbakk
roy(a)karlsbakk.net
Tlf: 98013356
---
“Our enemies are innovative and resourceful, and so are we. They
never stop thinking about new ways to harm our country and our
people, and neither do we.” - George W. Bush