Isql is a process by which you can test your ODBC connection without calling to asterisk. Just one line command to test the ODBC connectivity.
**echo "select 1" | isql -v *asterisk-connector* here asterisk-connector is your OBDC connection name. On Sun, May 1, 2011 at 12:10 PM, Rizwan Hisham <[email protected]>wrote: > isql? > > > On Sat, Apr 30, 2011 at 6:18 PM, Pezhman Lali <[email protected]> wrote: > >> check your odbc connection with isql >> >> best >> >> >> >> On Fri, Apr 29, 2011 at 9:33 PM, Warren Selby <[email protected]>wrote: >> >>> You're using 1.4.2. Why not try upgrading to a more recent release of 1.4 >>> (I believe 1.4.41 is current) and see if your issue has been resolved. >>> >>> Thanks, >>> --Warren Selby, dCAP >>> >>> On Apr 29, 2011, at 7:32 AM, Rizwan Hisham <[email protected]> >>> wrote: >>> >>> Yes I have it there, here the content of the file: >>> >>> i think the code is buggy, >>> >>> here is a comment from the function which generated the error >>> (ast_odbc_smart_execute in res_odbc.c line 155 ) >>> >>> /* This is a really bad method of trying to correct a dead connection. >>> It >>> * only ever really worked with MySQL. It will not work with any other >>> * database, since most databases prepare their statements on the server, >>> * and if you disconnect, you invalidate the statement handle. Hence, if >>> * you disconnect, you're going to fail anyway, whether you try to >>> execute >>> * a second time or not. >>> */ >>> >>> This function is used all over. >>> >>> On Fri, Apr 29, 2011 at 12:23 AM, Sherwood McGowan >>> <<[email protected]> >>> [email protected]> wrote: >>> >>>> On Thu, Apr 28, 2011 at 11:09 AM, Rizwan Hisham <<[email protected]> >>>> [email protected]> wrote: >>>> >>>>> Hi list, >>>>> yesterday I converted my voicemail.conf to realtime voicemail and also >>>>> configured to store the voicemessages in a database using odbc as >>>>> described >>>>> here <http://www.voip-info.org/wiki/view/Asterisk+RealTime+Voicemail>and >>>>> here<http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage> >>>>> . >>>>> I am using asterisk 1.4.2 with mysql. I also installed the proper odbc >>>>> driver for mysql on the server. I successfully completed the conversion >>>>> of a >>>>> lot of voicemail users into db yesterday. But today on the CLI thsi error >>>>> was showing; >>>>> >>>>> [Apr 28 11:40:54] WARNING[24676]: res_odbc.c:147 >>>>> ast_odbc_smart_execute: SQL Execute returned an error -1: 08S01: >>>>> [MySQL][ODBC 3.51 Driver][mysqld-5.0.68-log]MySQL server has gone away >>>>> (70) >>>>> [Apr 28 11:40:54] WARNING[24676]: res_odbc.c:147 >>>>> ast_odbc_smart_execute: SQL Execute returned an error -1: 08S01: >>>>> [MySQL][ODBC 3.51 Driver][mysqld-5.0.68-log]MySQL server has gone away >>>>> (70) >>>>> [Apr 28 11:40:54] WARNING[24676]: app_voicemail.c:2239 inboxcount: SQL >>>>> Execute error! >>>>> [SELECT COUNT(*) FROM voicemessages WHERE dir = >>>>> '/var/spool/asterisk/voicemail/default/1757XXXXXXX/INBOX'] >>>>> >>>>> I know that the error is caused due to stale odbc connection with >>>>> mysql. But i want to find out if there is a cure for it. Why the >>>>> connection >>>>> went stale in the first place also. >>>>> >>>>> Any ideas? >>>>> >>>>> -- >>>>> Best Ragards >>>>> Rizwan Qureshi >>>>> VoIP/Asterisk Engineer >>>>> Axvoice Inc. >>>>> >>>>> V: +92 (0) 3333 6767 26 >>>>> E: <[email protected]>[email protected] >>>>> W: <http://www.axvoice.com/>www.axvoice.com >>>>> >>>>> >>>>> -- >>>>> _____________________________________________________________________ >>>>> -- Bandwidth and Colocation Provided by <http://www.api-digital.com> >>>>> http://www.api-digital.com -- >>>>> New to Asterisk? Join us for a live introductory webinar every Thurs: >>>>> <http://www.asterisk.org/hello> >>>>> http://www.asterisk.org/hello >>>>> >>>>> asterisk-users mailing list >>>>> To UNSUBSCRIBE or update options visit: >>>>> <http://lists.digium.com/mailman/listinfo/asterisk-users> >>>>> http://lists.digium.com/mailman/listinfo/asterisk-users >>>>> >>>> >>>> >>>> do you have "sanitysql => select 1" configured in res_odbc.ini? >>>> >>>> -- >>>> Sherwood McGowan >>>> Telecommunications and VOIP Consultant >>>> >>>> >>>> -- >>>> _____________________________________________________________________ >>>> -- Bandwidth and Colocation Provided by <http://www.api-digital.com> >>>> http://www.api-digital.com -- >>>> New to Asterisk? Join us for a live introductory webinar every Thurs: >>>> <http://www.asterisk.org/hello> >>>> http://www.asterisk.org/hello >>>> >>>> asterisk-users mailing list >>>> To UNSUBSCRIBE or update options visit: >>>> <http://lists.digium.com/mailman/listinfo/asterisk-users> >>>> http://lists.digium.com/mailman/listinfo/asterisk-users >>>> >>> >>> >>> >>> -- >>> Best Ragards >>> Rizwan Qureshi >>> VoIP/Asterisk Engineer >>> Axvoice Inc. >>> >>> V: +92 (0) 3333 6767 26 >>> E: <[email protected]>[email protected] >>> W: <http://www.axvoice.com/>www.axvoice.com >>> >>> -- >>> _____________________________________________________________________ >>> -- Bandwidth and Colocation Provided by http://www.api-digital.com -- >>> New to Asterisk? Join us for a live introductory webinar every Thurs: >>> <http://www.asterisk.org/hello> >>> http://www.asterisk.org/hello >>> >>> asterisk-users mailing list >>> To UNSUBSCRIBE or update options visit: >>> <http://lists.digium.com/mailman/listinfo/asterisk-users> >>> http://lists.digium.com/mailman/listinfo/asterisk-users >>> >>> >>> -- >>> _____________________________________________________________________ >>> -- Bandwidth and Colocation Provided by http://www.api-digital.com -- >>> New to Asterisk? Join us for a live introductory webinar every Thurs: >>> http://www.asterisk.org/hello >>> >>> asterisk-users mailing list >>> To UNSUBSCRIBE or update options visit: >>> http://lists.digium.com/mailman/listinfo/asterisk-users >>> >> >> >> -- >> _____________________________________________________________________ >> -- Bandwidth and Colocation Provided by http://www.api-digital.com -- >> New to Asterisk? Join us for a live introductory webinar every Thurs: >> http://www.asterisk.org/hello >> >> asterisk-users mailing list >> To UNSUBSCRIBE or update options visit: >> http://lists.digium.com/mailman/listinfo/asterisk-users >> > > > > -- > Best Ragards > Rizwan Qureshi > VoIP/Asterisk Engineer > Axvoice Inc. > > V: +92 (0) 3333 6767 26 > E: [email protected] > W: www.axvoice.com > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > -- ----- Thanks and regards Virendra Bhati +91-9172341457
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
