search for: mysql_error

...007/01/07/asterisk_modification_for_queu e_logging to patch logger.c and Makefile in Asterisk 1.4.* in order to write queue_log to mySQL database. When I ran make, it complained: In function `write_mysql_logger': [...] /usr/src/asterisk-1.4.21.2/main/logger-mysql.c:98: undefined reference to `mysql_error' [...] collect2: ld returned 1 exit status make[1]: *** [asterisk] Error 1 make: *** [main] Error 2 In my modified Makefile, I already had the line: ASTCFLAGS+=-I/usr/include/mysql and I found that mysql.h is already in /usr/include/mysql. I also already had mysql-client installed. In logger...

...WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%' AND src like '04%'"; // Connecting, selecting database $link = mysql_connect($mysql_host, $mysql_user, $mysql_password) or die('Could not connect: ' . mysql_error()); mysql_select_db($my_database) or die('Could not select database'); // Performing SQL query $result = mysql_query($query_calls) or die('Query failed: ' . mysql_error()); // Printing results in HTML while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { foreach ($line as...

...home/hearme/radio/src/client.c:283: undefined reference to `mysql_init' /home/hearme/radio/src/client.c:297: undefined reference to `mysql_real_connect' /home/hearme/radio/src/client.c:305: undefined reference to `mysql_query' /home/hearme/radio/src/client.c:307: undefined reference to `mysql_error' /home/hearme/radio/src/client.c:308: undefined reference to `mysql_close' /home/hearme/radio/src/client.c:293: undefined reference to `mysql_error' /home/hearme/radio/src/client.c:312: undefined reference to `mysql_close' It?s obviously a linking problem with MySQL, but how do I go...

...mysql.c:142: undefined reference to `ast_log' res_config_mysql.o(.text+0x36d):/usr/local/src/asterisk-addons-1.4.1/res_config_mysql.c:143: undefined reference to `ast_log' res_config_mysql.o(.text+0x382):/usr/local/src/asterisk-addons-1.4.1/res_config_mysql.c:144: undefined reference to `mysql_error' res_config_mysql.o(.text+0x3a7):/usr/local/src/asterisk-addons-1.4.1/res_config_mysql.c:144: undefined reference to `ast_log' res_config_mysql.o(.text+0x3da):/usr/local/src/asterisk-addons-1.4.1/res_config_mysql.c:149: undefined reference to `mysql_store_result' res_config_mysql.o(.t...

...SQL.o:RS-MySQL.c:(.text+0x305): undefined reference to `mysql_options' RS-MySQL.o:RS-MySQL.c:(.text+0x338): undefined reference to `mysql_real_connect' RS-MySQL.o:RS-MySQL.c:(.text+0x399): undefined reference to `mysql_close' RS-MySQL.o:RS-MySQL.c:(.text+0x3d1): undefined reference to `mysql_error' RS-MySQL.o:RS-MySQL.c:(.text+0x7a2): undefined reference to `mysql_close' RS-MySQL.o:RS-MySQL.c:(.text+0x80f): undefined reference to `mysql_fetch_fields' RS-MySQL.o:RS-MySQL.c:(.text+0x823): undefined reference to `mysql_field_count' RS-MySQL.o:RS-MySQL.c:(.text+0xae7): undefine...

...;TRUNCATE TABLE zzsys_variable"; mysql_query($sql); /************************************************************** Deleting temp tables **************************************************************/ $result=mysql_query("SHOW TABLES FROM $DBName ") or die(mysql_error()); if(mysql_num_rows($result)>0) { while($row=mysql_fetch_row($result)) { if(substr($row[0], 0, 3) === '___' && strrev(substr($row[0], 0, 3) === '___')) { $sql = "DROP TABLE $row[0]"; mysql_qu...

...;:/home/hearme/radio/src/client.c:283: undefined reference to `mysql_init'/home/hearme/radio/src/client.c:297: undefined reference to `mysql_real_connect'/home/hearme/radio/src/client.c:305: undefined reference to `mysql_query'/home/hearme/radio/src/client.c:307: undefined reference to `mysql_error'/home/hearme/radio/src/client.c:308: undefined reference to `mysql_close'/home/hearme/radio/src/client.c:293: undefined reference to `mysql_error'/home/hearme/radio/src/client.c:312: undefined reference to `mysql_close' It?s obviously a linking problem with MySQL, but how do I go a...

...it" /> </form> <div id="thanks"></div> </body> </html> < insert.php > <?php $con = mysql_connect("localhost","<hidden>","<hidden>"); if (!$con) { die(''Could not connect: '' . mysql_error()); } mysql_select_db("<hidden>", $con); $sql="INSERT INTO RSVP (firstname, lastname, rsvp, number) VALUES (''$_POST[firstname]'',''$_POST[lastname]'',''$_POST[age]'',''$_POST[number]'')"; if (!mysql_quer...

...ysqld standalone daemon [mysqld] #wait_timeout=28800 #interactive_timeout = 28800 max_allowed_packet=512M #General Query Log general_log_file = /var/log/mysql/mysql_query.log general_log = 1 #Error Log log_error = /var/log/mysql/mysql_error.log #Slow Query Log slow_query_log = 1 slow_query_log_file = /var/log/mysql/mysql_slow.log long_query_time = 2 log-queries-not-using-indexes collation-server = utf8_general_ci init-connect='SET NAMES utf8' character-set-server = utf8...

Hi Most of our customers have generic names like "Hospital", so I need to rewrite their caller ID name by looking up the number in a database on the Asterisk server, and rewriting the name such as "Reading Hospital" so that we know who's calling. Any idea if this can be done with Asterisk, and how to do it? Thank you.

...tabase to use */ 0, /* port (use default) */ NULL, /* socket (use default) */ 0) /* flags (none) */ == NULL) { fprintf (stderr, "mysql_real_connect() failed:\nError %u (%s)\n", mysql_errno (h), mysql_error (h)); exit (1); }

Hi, I'm trying to setup a mailserver running postfix and dovecot with mysql as database backend. Postfix is already running and delivers mails just fine. Unfortunately, dovecot has great problems connecting to the database (using username + password). Found that two threads about the same issue but none of them solves the problem http://dovecot.org/list/dovecot/2005-April/006770.html

...nable-force-cgi-redirect --with-bz2 --enable-ftp --with-apxs2 --with-iconv \ --with-freetype-dir=/usr --with-ttf --with-jpeg-dir=/usr --with-xpm-dir=/usr --with-png \ --with-mysql=/usr --prefix=/usr/local and all i'm getting is this: checking for mysql_close in -lmysqlclient... no checking for mysql_error in -lmysqlclient... no configure: error: mysql configure failed. Please check config.log for more information. this is what is going on in config.log: /usr/bin/ld: skipping incompatible /usr/lib/mysql/libmysqlclient.so when searching for -lmysqlclient /usr/bin/ld: skipping incompatible /usr/lib/my...

...I wrote to check the connection: int main() { MYSQL mysql; mysql_init(&mysql); if (mysql_real_connect(&mysql, NULL, "root", "asd2sdf3", "ccc", 0, "/var/lib/mysql/mysql.sock", 0) == NULL) printf("connection failed: %s\n", mysql_error(&mysql)); else printf("nos problemos\n"); return 0; } This program executed says "nos problemos" --> connection works The same data in dovecot.conf brings up this: Sep 15 03:08:38 suse10064lamp dovecot: auth-worker(default): ok... connecting to mysql: hos...

...AIL (unexpected result '$res')\n"); fflush(STDERR); return -1; }}$agivar = init();$hostname= 'xxxx'; $database= 'xxxxx'; $username= 'xxxxx'; $password= 'xxxx'; $dbprotect = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR); mysql_select_db($database, $dbprotect);$result = mysql_query("SELECT * FROM user_table WHERE user_age>12");while($entry = mysql_fetch_array($result)) {fwrite(STERR, "Name : $entry['name'], Age: $entry['age'] \n");fflush(STDOUT);$result = trim...

Hello I am anirudh, I need help to write script to fetch detail like ips, speedlimit from mysql and add htb rules at the starting of the server. it is for a small isp i am working for. can any one help me out!, i had tried but fail to limit speed -- Anirudh Chowdary _______________________________________________ LARTC mailing list LARTC@mailman.ds9a.nl

...to use */ 0, /* port (use default) */ NULL, /* socket (use default) */ 0) /* flags (none) */ == NULL) { fprintf (stderr, "mysql_real_connect() failed:\nError %u (%s)\n", mysql_errno (h), mysql_error (h)); exit (1); } } This program is working outsine of dovecot. So its one of the library or the compilation itself that cause the problem of access denied. Any idea??? Thanks

i upgraded dovecot from 0.99 to the last version and it doesnt seem to work anymore.. im using vpopmail userdb and i get this in the logs : dovecot: Dec 18 03:42:08 Info: auth(default): client in: AUTH 1 PLAIN service=POP3 lip=81.x.x.x rip=81.x.x.x resp= dovecot: Dec 18 03:42:08 Info: auth(default): client out: CONT 1 dovecot: Dec 18 03:42:08 Info: auth(default): client in: CONT 1

...tivity wp_bp_activity_meta wp_bp_chat_channel_users wp_bp_chat_channels Also, I created a basic php script to see if it could connect to the database <?php $link = mysql_connect('db.example.com', 'admin_ssl', 'secret'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); ?> And to my surprise it can't connect! php testconnect.php Could not connect: Access denied for user 'admin_ssl'@'ec2-54-86-143-49.compute-1.amazonaws.com' (using password: YES) Why am I surprised that it ca...

Hi, I would like to figure out how to determine what the id of the last element in a table is. Is there an equivalent to the Table.find() method which will tell me the number of elements in a table? also, maybe more importantly, where are the available methods on tables documented? What i am trying to do is to increment the id and work through a table and check whether the id i am currently