[ previous ] [ next ] [ threads ]
 To :  Taisuke Yamada <tai@r...>
 From :  Bernd Plagge <bplagge@c...>
 Subject :  Re: [yate] Expected behavior of [resource.subscribe] inregister.conf?
 Date :  Tue, 20 Jan 2009 20:28:51 +0900
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yamada-san,

to support SQLite (version 3?) you need to write a program like
pgsqldb.cpp (this is for Postgresql of course).

YOu could put the stored procedure in a different DB table.

Best regards,
Bernd

On Tue, 20 Jan 2009 19:10:04 +0900
Taisuke Yamada  wrote:

> Thanks for the message (in Japanese :-).
> 
> I wasn't aware of existence of yateadmin package (it's not in
> Debian distribution - only yate was packaged), so I'll look into it.
> 
> I also received stored procedure definition off the list (thanks!).
> I'll probably need to do some code/SQL hacking as SQLite does not
> support stored procedure.
> 
> But since libdbi can support other databases like MSSQL/Oracle,
> I'll submit it even if I failed to make SQLite work with Yate.
> 
> Best Regards,
> Taisuke Yamada
> 
> >> I have written a new database module to support SQLite (and
> >> any database supported by libdbi) with Yate, but having problem
> >> rewriting SQL queries in register.conf.
> > 
> > 山田さん、
> > Hi Mr. Yamada,
> > 
> > you need to download the yateadmin package which contains the schema etc to load the postgres database. 
> > Postgres is using stored procedure not only to register but also for the routing.
> 


- -- 
Bernd Plagge - プラゲ ベェアント 
First Choice Internet Ltd., Tokyo - ファースト・チョイス・インターネット(有)
Tel. 03-4500-7799 - Fax. 03-4400-3723
mail: bplagge@c... - url: http://www.choicenet.ne.jp
	**************************************************************
			*** Campaign ***
Affordable Web Sites http://choicenet.ne.jp/en/hpcampaign.html
ホームページキャンペーン  http://choicenet.ne.jp/jp/hpcampaign.html
	**************************************************************
FREE Web Assessment: http://choicenet.ne.jp/en/website_assessment.html
Web Design:          http://choicenet.ne.jp/en/webdesign.html
Web Hosting:         http://choicenet.ne.jp/en/hosting.html
Net Support:         http://choicenet.ne.jp/en/netsupport.html
			*******************
無料ウエブサイト評価     http://choicenet.ne.jp/jp/website_assessment.html
ウエブデザイン:          http://choicenet.ne.jp/jp/webdesign.html
ウエブホスティング:      http://choicenet.ne.jp/jp/hosting.html
ネットワークサポート:    http://choicenet.ne.jp/jp/netsupport.html

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkl1tXMACgkQpYU8M8PbPV6GGACfWTkuog3XsK+kvrOwey9upREI
XusAnRyGxvhFJibPhS8oVuKJJWh2u33u
=3uW9
-----END PGP SIGNATURE-----