Hi, Since I've upgraded to Asterisk 1.4 I can't use a MySQL database anymore for select queries :-( I'm using dbquery from MysqlPool Application 1.4 and selecting something from a table returns nothing even if I try to do a query like "SELECT 1;" Is anyone in the same troubles ? Do you advice me another solution to connect to my database ? For information, I'm using MySQL 5.1 (for xml) on a ubuntu gutsy server. Regards. -- Cyril SCETBON
On Tuesday 18 December 2007 03:59:04 Cyril SCETBON wrote:> Is anyone in the same troubles ? Do you advice me another solution to > connect to my database ?See func_odbc.conf. -- Tilghman
On 12/18/07, Cyril SCETBON <cyril.scetbon at free.fr> wrote:> Hi, > > Since I've upgraded to Asterisk 1.4 I can't use a MySQL database anymore > for select queries :-( > I'm using dbquery from MysqlPool Application 1.4 and selecting something > from a table returns nothing even if I try to do a query like > "SELECT 1;" > > Is anyone in the same troubles ? Do you advice me another solution to > connect to my database ?app_addon_sql_mysql from asterisk-addons - it works fine for me. Regards, Atis -- Atis Lezdins VoIP Developer, IQ Labs Inc. atis at iq-labs.net Skype: atis.lezdins Cell Phone: +371 28806004 Work phone: +1 800 7502835
can we use it for cdr information too ? Tilghman Lesher wrote:> On Tuesday 18 December 2007 03:59:04 Cyril SCETBON wrote: >> Is anyone in the same troubles ? Do you advice me another solution to >> connect to my database ? > > See func_odbc.conf. >-- Cyril SCETBON
On Friday 18 January 2008 06:09:54 Cyril SCETBON wrote:> Tilghman Lesher wrote: > > On Tuesday 18 December 2007 03:59:04 Cyril SCETBON wrote: > >> Is anyone in the same troubles ? Do you advice me another solution to > >> connect to my database ? > > > > See func_odbc.conf. > > can we use it for cdr information too ?You can use ODBC, sure, via cdr_odbc or (new in trunk) cdr_adaptive_odbc. -- Tilghman
Apparently Analagous Threads
- Accessing a MySQL database and using the same db for cdr
- database queries from extensions.conf
- ast_indicate_data: Unable to handle indication 3
- replace astdb with a cluster-capable sql database engine
- subtract a list of vectors from a list of data.frames in an elegant way