Home > Asterisk Unable > Asterisk Unable To Execute Query

Asterisk Unable To Execute Query

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 And, of course, you can add ODBC functionality to pure Asterisk systems as well.Click to expand... Can three +1/+1 counters be considered one +3/+3 counter? I'm trying to configure func_odbc to read some mysql tables... navigate here

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 Check the Tomcat folder for errors (Catalina file). 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.Click to expand... The connector is functioning for isql, as seen here: echo "select username from cc_card where id=1" | isql -v mya2billing-connector someuser somepassword [email protected]:~ $ echo "select username from cc_card where id=1" http://forums.asterisk.org/viewtopic.php?f=1&t=79162

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. Forum content is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Jul 13, 2011 1:19:49 PM org.apache.solr.update.DirectUpdateHandler2 commit INFO: end_commit_flush Jul 13, 2011 1:19:49 PM org.apache.solr.core.SolrCore registerSearcher INFO: [] Registered new searcher [email protected] main Jul 13, 2011 1:19:49 PM org.apache.solr.search.SolrIndexSearcher close INFO: Where should a galactic capital be?

Menu Home Home Quick Links Recent Posts Recent Activity Authors Download Download Quick Links Download ISO Get your FREE license key Getting Started Forums Forums Quick Links Search Forums Recent Posts 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? My problem was the res_odbc.conf file was notconfigured... which mysql can't recognize.

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 Stay logged in PIAF - Your own Linux-based PBX Forums Forum Topics Help Style PBX in a Flash Forum - Class Home Contact Us Help Top Downloads Download PBX in a 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 http://lists.digium.com/pipermail/asterisk-users/2009-May/231530.html Get the weekly newsletter!

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 VOIP Event Calendar PBX Internet Speed Test About Voip-info.org Business VOIP Business Voip Providers IP PBX Asterisk Based PBX Hosted PBX Virtual PBX VOIP Billing PBX Phone System SBCs / Softswitch 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 The error message you're seeing may be different from the one shown there, but this is the same type of issue.

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 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 Thanks much to all. #8 swcarrel, Dec 30, 2013 pbxtest Expand Collapse Member Joined: Nov 29, 2013 Messages: 49 Likes Received: 6 So you got it to work without recompiling 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? http://popupjammer.com/asterisk-unable/chan-dongle-asterisk-13.html I must sheepishly admit that it was apparently caused by an error in res_odbc.conf. Useful Searches Recent Posts PIAF - Your own Linux-based PBX Forums Forum Topics Help This site uses cookies. 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'] What is the output of 'odbc show'

Mind if I ask which files you updated and the "good" settings used? #9 pbxtest, Dec 30, 2013 (You must log in or sign up to post here.) Show Ignored I'd come across that article in my searches. Big O Notation "is element of" or "is equal" Can cheese in hand luggage be mistaken for plastic explosive? his comment is here 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?

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 Not sure how to check that and I'm on a tablet at the moment. #2 lgaetz, Dec 27, 2013 wardmundy Expand Collapse Nerd Uno Joined: Oct 12, 2007 Messages: 12,547 I am confident Ward will correct me if I'm wrong. #6 lgaetz, Dec 29, 2013 pbxtest Expand Collapse Member Joined: Nov 29, 2013 Messages: 49 Likes Received: 6 Ok, I'll

What is in your odbc.ini, res_odbc.conf, and func_odbc.conf?

It's related to Java using IPv6. In it, you'll get: The week's top questions and answers Important community announcements Questions that need answers see an example newsletter By subscribing, you agree to the privacy policy and terms However none of the information seems to be searchable through the admin. Alerts Alert Preferences Show All...

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 , 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 arturo arturo 2009-05-08 17:16:21 UTC PermalinkRaw Message Thank you very much.... 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 http://popupjammer.com/asterisk-unable/asterisk-unable-to-get-your-ip-address.html I'm able to use the admin interface and have gotten the example xml files indexed, but whenever I try to import one of my database tables, I get the error SEVERE:

So I changed the url a bit and removed the 'http://' and that error seemed to go away. Holidays for Christmas Do progress reports/logging information belong on stderr or stdout? ElasticSearch0Solr, Unable to execute query during dataimport0SOLR Index & search on multiple datasource0solr indexing taking long time-solr search0Solr DataImport “unable to execute query”1HTTP ERROR 500 prbm accessing /solr/dataimport unable to configuring Forum owner bears no responsibility for accuracy of participant comments and bears no legal liability for posted discussion content.

Thus, 'localhost' gets resolved to "::1" instead of 127.0.0.1. WhiteRider Moderator Posts: 52103Joined: Sat Jan 19, 2008 7:06 pmLocation: UK Top Re: error unable to execute query by pokerdealce » Mon Jan 19, 2015 10:29 am solved!thanks!!!!!!!!! Here is what solr prints to the log. 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

I'm trying to configure func_odbc to > read some mysql tables... Strange are the ways of Solr/Lucene! current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. I had similar problems setting up odbc (isql query works fine) and am wondering what I did wrong.

I also added the dataimporthandler to the solrconfig.xml file. So did older versions of PIAF have ODBC installed? Posted 3 years 44 weeks ago Answering The Question: "does... as soon as I enable the DSN it worked....Post by Tilghman LesherPost by arturo arturoI have an asterisk 1.6.2 installation.

Newer Than: Search this thread only Search this forum only Display results as threads More... 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 - 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 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

Beginner's JavaScript calculator Snowman Bowling Does hearing fatigue? "newfangled", "fandangle" and "fandango" Bayes regression: how is it done in comparison to standard regression? By continuing to use this site, you are agreeing to our use of cookies. Learn More.