Home > Asterisk Unable > Asterisk Unable To Execute Query

Asterisk Unable To Execute Query

swcarrel Expand Collapse New Member Joined: Jan 25, 2009 Messages: 5 Likes Received: 0 I am having trouble getting odbc to work with Asterisk 11.6.0. Browse other questions tagged mysql search indexing solr or ask your own question. Moderators: WhiteRider, kraada, Flag_Hippo, morny Post a reply 3 posts • Page 1 of 1 error unable to execute query by pokerdealce » Sun Jan 18, 2015 5:46 pm hey , WhiteRider Moderator Posts: 52103Joined: Sat Jan 19, 2008 7:06 pmLocation: UK Top Re: Error: unable to execute query: Fatal Error by Biggetje » Sat Sep 24, 2016 2:29 pm Changing have a peek here

Sorry to hijack the thread, but I'm trying to do the exact same thing. What is in your odbc.ini, res_odbc.conf, and func_odbc.conf? My database is on the same machine. asked 5 years ago viewed 5108 times active 4 years ago Blog Stack Overflow Gives Back 2016 Developers, Webmasters, and Ninjas: What’s in a Job Title? read this article

I'm trying to configure func_odbc toERROR[24968] func_odbc.c: Unable to execute query [SELECT bloqueada FROMfunciones WHERE extension='750']What is the output of 'odbc show' from the Asterisk CLI? In my last build, I could say "odbc show" at the CLI, but when I try it with my new build, I get: odbc show No such command 'odbc show' (type Linked 0 solr data import handler working on localhost and not on server Related 0Indexing and searching MySQL with solr2Solr updates are very slow12What makes a good autowarming query in Solr FreePBX® is a registered trademark of Sangoma Technologies, Inc.

Posted 4 years 8 weeks ago 30 day free trialdownload now PT4 Supported Sites 888Poker Full Tilt iPoker Network Merge Network MPN (MicroGaming) OnGame Network partypoker PokerStars Revolution Gaming Network Winamax So I changed the url a bit and removed the 'http://' and that error seemed to go away. I'm trying to configure func_odbctoPost by arturo arturoERROR[24968] func_odbc.c: Unable to execute query [SELECT bloqueada FROMfunciones WHERE extension='750']What is the output of 'odbc show' from the Asterisk CLI? Learn More.

Asterisk®, Digium® and Asterisk logo are registered trademarks of Digium, Inc. Skip to content Wiki Blog Forums Mailing Lists Contact Us Advanced search Forums have moved to https://community.asterisk.org Board index RSS RSS Change font size FAQ Information The requested topic does not which mysql can't recognize. So did older versions of PIAF have ODBC installed?

ie out of the box #7 pbxtest, Dec 29, 2013 swcarrel Expand Collapse New Member Joined: Jan 25, 2009 Messages: 5 Likes Received: 0 Problem is finally solved. Terms of Service | Privacy Policy © 2003-2016 VOIP-Info.org LLC Powered by bitweaver LoadingLoading… [asterisk-users] func_odbc.c: Unable to execute query Tilghman Lesher tilghman at mail.jeffandtilghman.com Fri May 8 01:11:36 CDT 2009 Products Support Forums My Account Get-It-Free » Sign In Create Account Board index ‹ PokerTracker 4 (PT4) ‹ PokerTracker 4 Print view Advanced search Error: unable to execute query: Fatal Error pokerdealce Posts: 17Joined: Tue May 27, 2014 7:17 pm Top Re: error unable to execute query by WhiteRider » Mon Jan 19, 2015 4:31 am That suggests a problem with

I'd come across that article in my searches. see this TIA #5 pbxtest, Dec 29, 2013 lgaetz Expand Collapse Pundit Joined: Sep 15, 2009 Messages: 2,793 Likes Received: 524 I interpret that warning to apply to other non PIAF distros And just let me know if I need to clarify anything. Just trying to get a better understanding of what impact installing ODBC would have on future upgrades.

but every time I tried I got this message:ERROR[24968] func_odbc.c: Unable to execute query [SELECT bloqueada FROMfunciones WHERE extension='750']I'm sure the DSN is right because I can do this:[***@grupodelavega asterisk]# su navigate here Try following the two steps in this guide. Thus, 'localhost' gets resolved to "::1" instead of 127.0.0.1. Posted 3 years 44 weeks ago Answering The Question: "does...

pokerdealce Posts: 17Joined: Tue May 27, 2014 7:17 pm Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Post a It's related to Java using IPv6. Remember that the entry inodbc.ini is referenced by res_odbc.conf, and the entry in func_odbc.confreferences the entry in res_odbc.conf, not odbc.ini.--Tilghman_______________________________________________-- Bandwidth and Colocation Provided by http://www.api-digital.com --asterisk-users mailing listhttp://lists.digium.com/mailman/listinfo/asterisk-users 2 Replies Check This Out Useful Searches Recent Posts PIAF - Your own Linux-based PBX Forums Forum Topics Help This site uses cookies.

more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation but every time I tried I got this message: ERROR[24968] func_odbc.c: Unable to execute query [SELECT bloqueada FROM funciones WHERE extension='750'] I'm sure the DSN is right because I can do Board index The team • Delete all board cookies • All times are UTC - 6 hours Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group Home Main Page Quick

Jul 13, 2011 1:19:45 PM org.apache.solr.core.SolrCore execute INFO: [] webapp=/solr path=/dataimport params={} status=0 QTime=4 Jul 13, 2011 1:19:48 PM org.apache.solr.core.SolrCore execute INFO: [] webapp=/solr path=/dataimport params={command=full-import} status=0 QTime=4 Jul 13, 2011

By the way, my last build of asterisk (1.8) had ODBC as an installed function, but my new build (11.6.0) does not. Posted 4 years 8 weeks ago 30 day free trialdownload now PT4 Supported Sites 888Poker Full Tilt iPoker Network Merge Network MPN (MicroGaming) OnGame Network partypoker PokerStars Revolution Gaming Network Winamax What am I missing? #1 swcarrel, Dec 27, 2013 lgaetz Expand Collapse Pundit Joined: Sep 15, 2009 Messages: 2,793 Likes Received: 524 I think Asterisk has to be compiled w/ Does it mean PIAF updates will not work at all, that they might overwrite the ODBC functionality, ...?

share|improve this answer edited Mar 28 '12 at 14:00 mguymon 6,51322453 answered Mar 27 '12 at 23:03 a.zeidan 111 add a comment| Your Answer draft saved draft discarded Sign up ra-pt4.pngbe very frustrating to have to make a new database,and have fear that this happen again please need help for resolve this problem thanks! Remember that the entry in odbc.ini is referenced by res_odbc.conf, and the entry in func_odbc.conf references the entry in res_odbc.conf, not odbc.ini. -- Tilghman Previous message: [asterisk-users] func_odbc.c: Unable to execute this contact form The MySQL log shows no activity other than the cdr logging of the call when it ends.

Biggetje Posts: 25Joined: Mon Mar 24, 2008 6:06 pm Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Post a Forum owner bears no responsibility for accuracy of participant comments and bears no legal liability for posted discussion content. arturo arturo Reply via email to Search the site The Mail Archive home asterisk-users - all messages asterisk-users - about the list Expand Previous message Next message The Mail Archive home sql-statement help [tablename] quit SQL RowCount return 4 4 row fetchedIt seems ODBC is working/etc/asterisk/func_odbc.conf [INFO] prefix=HOTDESK readsql=SELECT ${ARG1} from asterisk.ast_hotdesk where extension '${SQL_ESC(${ARG2})}' -- OR -- I also tried readsql=SELECT

Forum content is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed However none of the information seems to be searchable through the admin. If the MySQL database is on the same machine, then use url="jdbc:mysql://localhost/mydb" If its on www.mysite.com, then use url="jdbc:mysql://www.mysite.com/mydb" Also, your log files may have more details regarding the error -

I thought I had combed them thoroughly but goofed on that one. What are these boxes mounted inline on each of the 3 phase wires of a high voltage power line in Miami? Strange are the ways of Solr/Lucene! Here is what solr prints to the log.

Get the weekly newsletter! Newer Than: Search this thread only Search this forum only Display results as threads More... My problem was the res_odbc.conf file was notconfigured... Tilghman Lesher Re: [asterisk-users] func_odbc.c: Unable to execu...

share|improve this answer answered Jul 13 '11 at 7:21 nikhil500 2,8621021 add a comment| up vote 2 down vote I faced a similar problem. What is in yourodbc.ini, res_odbc.conf, and func_odbc.conf? What is in yourodbc.ini, res_odbc.conf, and func_odbc.conf? Holidays for Christmas Do progress reports/logging information belong on stderr or stdout?

What encryption should I use: Blowfish, Twofish, or Threefish? Posted 3 years 44 weeks ago Answering The Question: "does...