[Users] Re: Persistent Data Storage

[Klaus Darilion]

Hi!

Please send your emails to the list. This way others can help you too, 
and others will also benefit.

In Openser, all DB task will be done via openser's DB layer. Thus, the 
modules do not have to take care of the used DB. Under the DB layer, 
there are the DB drivers: There is at the moment mysql, postgresql and 
unixodbc.

When configuring openser, you only have to use the proper configuration, 
thus use "postgres://..." isntead of "mysql://...."

For setting up the database, use the openser_postgresql.sh script.

For setting up openser in general, please refer to the Gettign Started 
Tutorial on onsip.org

regards
klaus



voiceoverip wrote:
> Hi Klaus,
>  
> forgive me for being a nuisance:) I've tried google and Openser manuals, 
> haven't been able to find any revelant Openser setup guide with 
> PostgreSQL, would be glad if you can point me to any online reference(s).
>  
> Also, I assume that by native, you meant the client interface to the 
> underlying DB platform. Therefore, Postgres support would still be 
> essentially modular?
>  
> Thanks for your patience.
>  
> Regards
>  
> Klaus Darilion writes:
>  > voiceoverip wrote:
>  >> Hi Klaus,
>  >> thanks for your advice, will check it out. Can i say that MySQL support
>  >> is native? Mind if i ask what major difference(s) between modular and
>  >> native support?
>  >
>  > mysql and postgres have native support. Both works well. I've never 
> tried
>  > the unixodbc yet.
>  >
>  > regards
>  > klaus
>  >
>  >> Regards
>  >> voiceoverip
>  >> Klaus Darilion writes:
>  >> > voiceoverip wrote:
>  >> >> Hi,
>  >> >> I am new to OpenSER.
>  >> >> As noted in the installation notes(Persistent Data Storage) - "you
>  >> need
>  >> >> to make sure MySQL is installed on your box". Guess other 
> backends(in
>  >> >> particular PostgreSQL) are not supported. If true, wonder if 
> there are
>  >> >> plans to support other backends. Thanks.
>  >> >
>  >> > Take a look at the modules directory. There is already postgresql and
>  >> > unixodbc.
>  >> >
>  >> > There is also native oralce support in ser's experimental tree.
>  >> >
>  >> > regards
>  >> > klaus
>  >> ________________________________
>  >> Free POP3 Email from www.gawab.com
>  >> Sign up NOW and get your account @gawab.com!!
>  >
> ________________________________
> Free POP3 Email from www.gawab.com <http://www.gawab.com>
> Sign up NOW and get your account @gawab.com!!