search for: mysql_real_connect

Hi there, I tried to setup a passwddb with mysql, but it wont connect to my database, even if I patch the driver-mysql.c Here a test program 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...

Hi, I need help with modifying cdr_addon_mysql.c I want to have more fields in cdr table in asterisk. I've tried to modify cdr_addon_mysql.c and replace userfield with ex team (sed -e 's/userfield/team/g' ). When I try to recomplie menuselect/menuselect --check-deps menuselect.makeopts Generating embedded module rules ... make[1]: Nothing to be done for `all'.

...password_query = CALL user_pass_check('%n', '%d', '%w') user_query = CALL user_info('%n', '%d') This failed with the message: User query failed: PROCEDURE imap.user_info can't return a result set in the given context The root of this problem is that mysql_real_connect() needs to be called with option CLIENT_MULTI_RESULTS and mysql_next_result() called to retrieve extra results (that will not exist in the way that we use it). I attach a patch that fixes this problem -- the patch is against dovecot-1.2.10. This works for me ... but could probably do with testing b...

...ithin driver-mysql.c and it failed!!! My question is do you set up anything (SSL?) that could explain this failure. thanks. Here is the code MYSQL *h; h = mysql_init (NULL); if (h == NULL) { fprintf (stderr, "mysql_init() failed (probably out of memory)\n"); exit(1); } if (mysql_real_connect ( h, /* pointer to connection handler */ "localhost", /* host to connect to */ "lyra", /* user name */ "xxxxxxx", /* password */ "lyra&quot...

Hello, The following patch adds support for enabling MYSQL_OPT_SSL_VERIFY_SERVER_CERT. It makes the mysql client library check that the commonName in the server's SSL certificate matches the host name provided to mysql_real_connect() and aborts the connection if the name doesn't match. An example connect string would look something like: connect = ... ssl-ca=/path/to/ca.cert ssl-verify-server-cert=yes By default the mysql client library does not perform this check. -------------- next part -------------- A non-text att...

...orker: Error: /usr/lib/libmysqlclient.so.18(free_defaults+0x4b)[0x7f22d3796e6b] Jun 7 23:02:09 localhost dovecot: auth-worker: Error: /usr/lib/libmysqlclient.so.18(mysql_read_default_options+0x13c)[0x7f22d377d00c] Jun 7 23:02:09 localhost dovecot: auth-worker: Error: /usr/lib/libmysqlclient.so.18(mysql_real_connect+0x8e)[0x7f22d377eb4e] Jun 7 23:02:09 localhost dovecot: auth-worker: Error: /usr/lib/dovecot/modules/auth/libdriver_mysql.so(+0x1fc6)[0x7f22d3c52fc6] Jun 7 23:02:09 localhost dovecot: auth-worker: Error: dovecot/auth worker: waiting for connection(+0x2be1d)[0x7f22d515be1d] Jun 7 23:02:09 localho...

...Icecast with the additional logging functionality, using ./configure & make, I received the following errors: client.o: In function `logSingleMessage': /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...

Anyone know if the MySQL() application has a configurable timeout? If it tries to connect to a bogus IP, it's timeout seems to be a few minutes. I'd like to cut it down to a few seconds. Doug. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -------------- next part --------------

...ALSE, worker = FALSE; time_t process_start_time; static struct auth *auth; static struct auth_worker_client *worker_client; main() { MYSQL *h; h = mysql_init (NULL); if (h == NULL) { fprintf (stderr, "mysql_init() failed (probably out of memory)\n"); exit(1); } if (mysql_real_connect ( h, /* pointer to connection handler */ "localhost", /* host to connect to */ "lyra", /* user name */ "teSIVIkY", /* password */ "lyr...

...ge class mysql-vm-routines.h: In function `mysql_login': mysql-vm-routines.h:18: warning: implicit declaration of function `mysql_init' mysql-vm-routines.h:18: warning: assignment makes pointer from integer without a cast mysql-vm-routines.h:19: warning: implicit declaration of function `mysql_real_connect' mysql-vm-routines.h: In function `mysql_logout': mysql-vm-routines.h:29: warning: implicit declaration of function `mysql_close' mysql-vm-routines.h: In function `find_user': mysql-vm-routines.h:35: `MYSQL_RES' undeclared (first use in this function) mysql-vm-routines.h:35: (E...

...le Icecast with the additional logging functionality, using ./configure & make, I received the following errors: client.o: In function `logSingleMessage':/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 `mys...

Hello, I've uploaded version 0.5-11 of RMySQL into CRAN, and it should be available soon. >From the NEWS file: Version 0.5-11 * Fixed a bug that would crash R with a failed mysql_real_connect(). * dbApply() is now working again (but still experimentally). * Re-formatted the C code. [0.5-9 through 0.5-10 were maintanance releases that Seth Falcon kindly put out.] Regards, -- David _______________________________________________ R-packages mailing list R-packages at stat.math.ethz.c...

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

...R 'db_user'@'localhost' = OLD_PASSWORD('db_pw'); now, dovecot CAN connect to mysql-server and everything work fine i patched src/lib-sql/driver-mysql.c to test, use something like: i_error("host(%s), db->user(%s), db->password(%s), db->dbname(%s) ....); before mysql_real_connect(), then see the maillog, the db->user/password/dbname is correct maillog: auth-worker(default): conn->mysql is NOT NULL auth-worker(default): host((null)), db->user(db_user), db->password(db_pw), db->dbname(dbname), db->port(0), unix_socket(/mysql.sock), db->client_flags(0) au...

...81 in my_strcasecmp_8bit () from /usr/local/lib/mysql/libmysqlclient_r.so.14 #1 0x0000002a96075e71 in get_charset_number () from /usr/local/lib/mysql/libmysqlclient_r.so.14 #2 0x0000002a960761a6 in get_charset_by_csname () from /usr/local/lib/mysql/libmysqlclient_r.so.14 #3 0x0000002a960909a2 in mysql_real_connect () from /usr/local/lib/mysql/libmysqlclient_r.so.14 #4 0x0000002a95f28ba3 in SQLConnect () from /usr/local/lib/libmyodbc3_r.so #5 0x0000002a95baf4e9 in SQLConnect (connection_handle=0x655380, server_name=0x6007f0 "asterisk", name_length1=-4992, user_name=0x770300 "asterisk&quo...

...order to provide cross-compiling/linking support - add 'rmem' configuration key to set the netlink socket rmem buffsize - don't use kernel header files for IP/TCP header definitions - various cosmetic cleanup to compile with -Wall - fix usage of libmysqlclient: call mysql_init() before mysql_real_connect() - don't have LOGEMU read the system time, ulogd_LOCAL.so does this already Please direct any questions / bug reports to the ulogd@lists.gnumonks.org mailinglist. Thanks for all your patience with my not-so-frequend release cycle. --=20 - Harald Welte <laforge@gnumonks.org>...

...und the problem connecting like that: drv <- dbDriver("MySQL") con <- dbConnect(drv,user=MyUser, password=MyPasswd, dbname=MyDBName, host=MyHost, client.flag="196608" ) where 196608 is a combination of CLIENT_MULTI_RESULTS and CLIENT_MULTI_STATEMENTS as mentioned in the mysql_real_connect() documentation. Without these flags stored procedures calls do not run at all. I also do fetching the results in a loop - as suggested in the doc, so: doStoredProcedureFetch <- function( connection, sql ) { res <- dbSendQuery( connection, sql ) data <- fetch( res, n=-1 ) repeat...

...orage class mysql-vm-routines.h: In function `mysql_login': mysql-vm-routines.h:18: warning: implicit declaration of function `mysql_init' mysql-vm-routines.h:18: warning: assignment makes pointer from integer without a cast mysql-vm-routines.h:19: warning: implicit declaration of function `mysql_real_connect' mysql-vm-routines.h: In function `mysql_logout': mysql-vm-routines.h:29: warning: implicit declaration of function `mysql_close' mysql-vm-routines.h: In function `find_user': mysql-vm-routines.h:35: `MYSQL_RES' undeclared (first use in this function) mysql-vm-routines.h:35: (Ea...

...recording system on debian 4.0 with asterisk and mysql db> for handling user information (accessible over the net for users). My> asterisk is running on one machine and the mysql on another. The connection> is over lan. Now I have a problem and a question.> > My problem is:> When mysql_real_connect doesn't get connection to the mysql server asterisk> pretty much freezes and doesn't let any info go in or out, even the CLI> freezes. I've seen a bug report on this but no solution(?)> Although this might be a bug with asterisk when I have the connection set to> a hosted my...

...-MySQL.o:RS-MySQL.c:(.text+0x2d9): undefined reference to `mysql_options' RS-MySQL.o:RS-MySQL.c:(.text+0x2ef): undefined reference to `mysql_options' RS-MySQL.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...