Memory corrupting, while retrive the query generated

2009-05-07 Thread Ravi raj
Dear All, I want to connect MYSQL with following C application , while i'm trying to retrive the query generated , its corrupting the memory. Is there any solution , to retrive the query generated with out any memory crashes? Please help me to solve this problem. code

Re: Problems After MySql 5.1.34

2009-05-07 Thread walter harms
there is nothing you can make. Any (major)upgrade of mysql client requires the dependent subsystem to upgrade also. Anything else would be careless since you do not know if the interface has changed. basicly you can install both version of libraries and hope for the best. i would do this only

Re: Problems After MySql 5.1.34

2009-05-07 Thread Joerg Bruehe
Hi Johnny, all! Johnny Stork wrote: Typo, moved from 5.0.67 to 5.1.34 Ok, that helps - I checked the contents. Johnny Stork wrote: I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from 5.64. Access to the db seesm fine from the shell, phpmyadmin or even the Trixbox/FreePBX

Re: Problems After MySql 5.1.34

2009-05-07 Thread Joerg Bruehe
Hi Gary, all, Gary Smith wrote: Johnny, Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 = 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success trying to get it to work

Re: my.cnf file

2009-05-07 Thread Craig Dunn
michel wrote: I set up mysql and can't start it because I need to hard code the IP address parameter (bind-address) into my.cnf ... but I have three of them in different sub directories of /mysql/mysql-test/suite Should there not be one basic one?

RE: Problems After MySql 5.1.34

2009-05-07 Thread Mark
Gary wrote: Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 = 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success trying to get it to work otherwise. Well, you don't actually

Re: Memory corrupting, while retrive the query generated

2009-05-07 Thread walter harms
hi ravi, this works for me. it should help you to get a starting point re, wh /* simpple DB connect test gcc -L/usr/lib/mysql -lmysqlclient connect.c */ #define _GNU_SOURCE #include stdio.h #include stdlib.h #include mysql/mysql.h int main() { MYSQL *MySQL; MYSQL_ROW

RE: Problems After MySql 5.1.34

2009-05-07 Thread Mark
Depends on your OS, I guess. On FreeBSD you can just go to the 'php5-extensions' port, run a 'make config', and deselect everything but the MySQL extension. Then it will only build mysql.so for you. Very easy. :) - Mark From: Martin Gainty [mailto:mgai...@hotmail.com] Sent:

Re: grant user create privilege

2009-05-07 Thread Jim Lyons
It's hard to believe this to be the case since I assume you've created other databases in this instance, but the error on create database, which is essentially a mkdir in Unix, makes me wonder if you don't have a file permissions error on the datadir directory. On Wed, May 6, 2009 at 9:14 AM,

Re: grant user create privilege

2009-05-07 Thread Ian Simpson
Did you flush privileges after creating the user? On Thu, 2009-05-07 at 08:54 -0500, Jim Lyons wrote: It's hard to believe this to be the case since I assume you've created other databases in this instance, but the error on create database, which is essentially a mkdir in Unix, makes me wonder

RE: grant user create privilege

2009-05-07 Thread John Clement
You're right. As the root user, we've created dozens of databases on this server. I'm still not entirely sure what I was doing wrong but the lines from Sudhir mysql -u root -ppassword mysql create user 'user'@'localhost' identified by 'password' ; grant mysql create on *.* to

RE: grant user create privilege

2009-05-07 Thread John Clement
Oh, and yep I did flush privileges, and testdb wasn't actually the name of the db I was trying to create, the db I was trying to create didn't already exist. Thanks again for all the replies! jc -Original Message- From: Ian Simpson [mailto:i...@it.myjobgroup.co.uk] Sent: 07 May 2009

RE: Problems After MySql 5.1.34

2009-05-07 Thread Gary Smith
Typically we see the problems with RH/Cent when you upgrade through those channels and then do an install of the 5.1.x series on top of that. I tried it about 9 months ago, so the details are fuzzy. I do know that in attempts to recover we extracted the RPM contents and tried to copy them

RE: Problems After MySql 5.1.34

2009-05-07 Thread Gary Smith
You are right. I misspoke regarding mysql - php - apache hell. It happens anytime an interface changes. From: Mark [ad...@asarian-host.net] Sent: Thursday, May 07, 2009 5:57 AM To: mysql@lists.mysql.com Subject: RE: Problems After MySql 5.1.34 Gary

Query log for just one database

2009-05-07 Thread Scott Haneda
I am trying to monitor a specific issue, and I know it is related to only one database. There is a lot of other noise in the logs if I enable query logging. Is there any way to limit query logging to just one database? -- Scott * If you contact me off list replace talklists@ with scott@ *

innodb rollback 30x slower than commit normal?

2009-05-07 Thread Nikita Tovstoles
We have a java-based webapp that talks to MySQL 5.1 INNODB in READ_COMMITTED. We use Hibernate and optimistic concurrency, so periodically concurrent write attempts cause app-level Exceptions that trigger rollbacks (and then we retry tx). We've added app-level caching and turned down our tomcat