Mysql Help / Error Thx
Dear Users I searched google, find alot of tips, but none of the them was successfully. After a db move with ibdata files, which cannot be dumped (cause of a table failure) we made a hardcopy of the files and moved it onto the new server. Eg. we copy ibdatafiles, the original my.cnf to the new server, we did NOT copy the ib_logfiles (2) and the old bin files like hostname.0001 ..(we tough its only for slave/master) After starting the new mysql server, this follows in *.err log all the time. The Database is runnning fine, but the log is to full after few seconds. Re-dumping is not possible Any ideas how i can fix it? Check Tables means all is ok. Thank you -matthias 080111 14:42:20 InnoDB: Error: page 158199 log sequence number 3 974369182 InnoDB: is in the future! Current system log sequence number 0 3271712681. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See http://dev.mysql.com/doc/mysql/en/backing-up.html for more information. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: There's not enough space in /var/lib/mysql/ ---help!!!!
I am using debian 4.0 and mysql-server-5.0 package. My server will not start because it states that there is not enough spaceCan someone assist? rider:~# df -h FilesystemSize Used Avail Use% Mounted on /dev/mapper/vg_house-lv_root 493G 468G 0 100% / tmpfs 1.5G 0 1.5G 0% /lib/init/rw udev 10M 96K 10M 1% /dev tmpfs 1.5G 0 1.5G 0% /dev/shm /dev/md0 274M 25M 235M 10% /boot I have a 500gb lvm partition...with hardly anything on it. I am new to lvm so i will need assistance..i think the package is failing because it is not reading lvm properly. I have removed the mysql package and now i can not re-install it on the partition...i would appriciate any help offered. thanks mjh
Re: There's not enough space in /var/lib/mysql/ ---help!!!!
Michael, it looks to me like your root partition is absolutely 100% chock full. Am I misunderstanding your request for help? Sounds like you are saying you think you have nothing in that partition - but your 'df -h' command is showing 0 bytes available in /. Dan On 8/13/07, Michael Habashy [EMAIL PROTECTED] wrote: I am using debian 4.0 and mysql-server-5.0 package. My server will not start because it states that there is not enough spaceCan someone assist? rider:~# df -h FilesystemSize Used Avail Use% Mounted on /dev/mapper/vg_house-lv_root 493G 468G 0 100% / tmpfs 1.5G 0 1.5G 0% /lib/init/rw udev 10M 96K 10M 1% /dev tmpfs 1.5G 0 1.5G 0% /dev/shm /dev/md0 274M 25M 235M 10% /boot I have a 500gb lvm partition...with hardly anything on it. I am new to lvm so i will need assistance..i think the package is failing because it is not reading lvm properly. I have removed the mysql package and now i can not re-install it on the partition...i would appriciate any help offered. thanks mjh
Re: There's not enough space in /var/lib/mysql/ ---help!!!!
On 8/13/07, Dan Buettner [EMAIL PROTECTED] wrote: Michael, it looks to me like your root partition is absolutely 100% chock full. Am I misunderstanding your request for help? Sounds like you are saying you think you have nothing in that partition - but your 'df -h' command is showing 0 bytes available in /. Dan On 8/13/07, Michael Habashy [EMAIL PROTECTED] wrote: I am using debian 4.0 and mysql-server-5.0 package. My server will not start because it states that there is not enough spaceCan someone assist? rider:~# df -h FilesystemSize Used Avail Use% Mounted on /dev/mapper/vg_house-lv_root 493G 468G 0 100% / tmpfs 1.5G 0 1.5G 0% /lib/init/rw udev 10M 96K 10M 1% /dev tmpfs 1.5G 0 1.5G 0% /dev/shm /dev/md0 274M 25M 235M 10% /boot I have a 500gb lvm partition...with hardly anything on it. I am new to lvm so i will need assistance..i think the package is failing because it is not reading lvm properly. I have removed the mysql package and now i can not re-install it on the partition...i would appriciate any help offered. thanks mjh thanks for your assistance..i found the answer...i am not that familiar iwht lvm ..but getting used to it now..and du -sh * ---great command...found my run away process. thanks mjh
an't connect to local MySQL -- Help me!
I am getting this message from mysql. We had our binlog directory full. What is the resolution? Error 2002 (HY000) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INstalling DBD for mysql--Help needed
Hello Guys, I was able to connect to mysql database using perl DBI. I was using the wrong version of Perl on HP-UX to install the DBI and DBD. There were two versions , 32 bit and 64 bit perl. by default the 32 bit perl was picked up. I changed the path to 64 bit perl interpreter and the DBI created 64 bit objects and I had to use right 64-bit flags for DBD::mysql installation. Thanks for all who helped Vinay - Original Message - From: Jake Peavy [EMAIL PROTECTED] To: MySQL mysql@lists.mysql.com Sent: Friday, March 03, 2006 5:38 PM Subject: Re: INstalling DBD for mysql--Help needed On 3/3/06, Vinay [EMAIL PROTECTED] wrote: Hello, I am trying to install DBI and mysql DBD for perl on HP-UX 11.23i. I have installed DBI successfully but having a hard time installing DBD for mysql on HP-UX. I am getting make errors while installing. I want to use perl to connect to mysql database. Any help appreciated, Thank you, vinay how do you think we're going to help? should I try to perform a Vulcan mind meld with your server? Or did you just want me to come over and fix it for you? I tell ya what - just give us your server IP, open up telnet, and provide the root password. we'll get that nasty DBD! -jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
INstalling DBD for mysql--Help needed
Hello, I am trying to install DBI and mysql DBD for perl on HP-UX 11.23i. I have installed DBI successfully but having a hard time installing DBD for mysql on HP-UX. I am getting make errors while installing. I want to use perl to connect to mysql database. Any help appreciated, Thank you, vinay
Re: INstalling DBD for mysql--Help needed
On 3/3/06, Vinay [EMAIL PROTECTED] wrote: Hello, I am trying to install DBI and mysql DBD for perl on HP-UX 11.23i. I have installed DBI successfully but having a hard time installing DBD for mysql on HP-UX. I am getting make errors while installing. I want to use perl to connect to mysql database. Any help appreciated, Thank you, vinay how do you think we're going to help? should I try to perform a Vulcan mind meld with your server? Or did you just want me to come over and fix it for you? I tell ya what - just give us your server IP, open up telnet, and provide the root password. we'll get that nasty DBD! -jp
[OT] Strange message from mysql-help@lists.mysql.com
Hello, I have just received this message from [EMAIL PROTECTED]: At 21:17 + 5-11-2004, [EMAIL PROTECTED] wrote: To confirm that you would like [EMAIL PROTECTED] removed from the mysql mailing list, please click on the following link: ... Received: (qmail 20876 invoked by uid 48); 5 Nov 2004 21:17:10 - Date: 5 Nov 2004 21:17:10 - Message-ID: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Unsubscribe request From: [EMAIL PROTECTED] This message was generated because of a request from 68.125.48.133. That ip is not my ip and I don't want to be removed. Please, can someone help me? Thanks Santino T -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Install MySQL Help Tables
I'm confused... The 4.1 alpha features says that MySQL now has help files installed with the server. I did a clean install (Win2K), following all directions to the best of my ability, and find no help files. I did discover a SQL file that purported to fill the help files: fill_help_tables.sql. All they seem to do, however, is create empty tables. What am I missing? It's not critical, of course, I seem to find most of the help I need either in the documentation or on the internet. But it would be nice to have the server based help when I just need a quick reminder of parameters or the exact name of a function or whatever. Also, I did a clean install using RPMs on a Redhat 9.0 machine. A straight install (rpm -Uvh) failed on a bunch of dependencies -- including the fact that apparently MySQL 3.2.? was installed with Redhat. I did an rpm -e on the existing installation, tried again on the new distributions and got failed dependencies for libcrypto 0.9.6 and libssl (don't remember the version number). The Redhat 9 installation has libcrypto 0.9.7a, so I'm not sure why the dependency check fails. I whent ahead with a --nodeps install and the basic server seems to run alright. However, when I then tried to install -Max, the service wouldn't start. I haven't pursued that problem -- simply went back to the basic server install. Actually, I had to do a complete reinstall of the server to get it to work. One question: do I need Max to get the transaction type capabilities for committing, roll back, etc? The documentation seems to imply yes in some places and no in others. Is the InnoDB in MySQL-server, enough to get these capabilities? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Install MySQL Help Tables
At 10:46 PM -0400 9/13/03, Randy_Chrismon/[EMAIL PROTECTED] wrote: Also, I did a clean install using RPMs on a Redhat 9.0 machine. A straight install (rpm -Uvh) failed on a bunch of dependencies -- including the fact that apparently MySQL 3.2.? was installed with Redhat. I did an rpm -e on the existing installation, tried again on the new distributions and got failed dependencies for libcrypto 0.9.6 and libssl (don't remember the version number). The Redhat 9 installation has libcrypto 0.9.7a, so I'm not sure why the dependency check fails. I whent ahead with a --nodeps install and the basic server seems to run alright. However, when I then tried to install -Max, the service wouldn't start. I haven't pursued that problem -- simply went back to the basic server install. Actually, I had to do a complete reinstall of the server to get it to work. One question: do I need Max to get the transaction type capabilities for committing, roll back, etc? The documentation seems to imply yes in some places and no in others. Is the InnoDB in MySQL-server, enough to get these capabilities? InnoDB is standard in MySQL precompiled distributions (including RPMs) as of MySQL 4. Before MySQL, you needed to install MySQL-Max to get InnoDB support. Note that you still need MySQL-Max if you want BDB support. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Simple MySQL help needed...
Hi * I'm running MySQl 3.23 and I'm trying to run a very simple command that basically finds the highest number in a column and then for all matching rows sets their card number to be current highest +1. The code looks like this: #cardnumb is actually a string of the form SNx so set @high=x as a number select @high:=convert( right( max( cardnumb ),5) , signed ) FROM Ops; #for all matching crtieria set cardnumb to be update Ops set cardnumb = @high, @[EMAIL PROTECTED] where newphoto =1 and tbprinted =1; Without the , @[EMAIL PROTECTED] part in the script runs fine but sets everyone matching the criteria to @high, rather than increasing it. This is so incredibly simple but it just won't work for me and is not giving me any clue in the logs of on the website. Does anyone see my glaring error? I guess it should really be done by using another table but my current database is only 10k rows and grows very very slowly. Thanks in advance, P h i l l -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple MySQL help needed...
Phill, I think the solution is simple, remove the part of the code you are having problems with, it's redundant. Instead, according to your statement, use this: UPDATE Ops SET [EMAIL PROTECTED] WHERE newphoto=1 AND tbprinted=1; As for myself, I would actually use the client implementing the statement to prepare the variables in advance. Your select statement should return 0 or more records. Assuming it has 1 or more returned, simply obtain the high value to a client stored variable, add one to it, and parse it as part of the UPDATE statement, instead of having it done on the SQL side. While it may or may not offer a benefit in a minor case like this, preparing your statements ahead of time on the client side for more complicated statements can alleviate some of the processing the MySQL server has to do. If I was using C, for a simple example, it would look as follows: char pSQL[256]; int iHighNum = ObtainHighestFromDB(void); iHighNum++; snprintf(pSQL, 256, UPDATE Ops SET cardnumb=%d WHERE newphoto=1 and tbprinted=1;, iHighNum); This in effect leaves any processing possible to the client side. Hope that helps, -Shane - Original Message - From: Phill Gillespie [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 15, 2003 1:53 PM Subject: Simple MySQL help needed... Hi * I'm running MySQl 3.23 and I'm trying to run a very simple command that basically finds the highest number in a column and then for all matching rows sets their card number to be current highest +1. The code looks like this: #cardnumb is actually a string of the form SNx so set @high=x as a number select @high:=convert( right( max( cardnumb ),5) , signed ) FROM Ops; #for all matching crtieria set cardnumb to be update Ops set cardnumb = @high, @[EMAIL PROTECTED] where newphoto =1 and tbprinted =1; Without the , @[EMAIL PROTECTED] part in the script runs fine but sets everyone matching the criteria to @high, rather than increasing it. This is so incredibly simple but it just won't work for me and is not giving me any clue in the logs of on the website. Does anyone see my glaring error? I guess it should really be done by using another table but my current database is only 10k rows and grows very very slowly. Thanks in advance, P h i l l -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple MySQL help needed...
Shane Bryldt wrote: I think the solution is simple, remove the part of the code you are having problems with, it's redundant. Instead, according to your statement, use this: UPDATE Ops SET [EMAIL PROTECTED] WHERE newphoto=1 AND tbprinted=1; Thanks for the response Shane. I don't think I explained my statement clearly as your corrected code would set all matching rows to be @high+1. What I am trying to achieve is if there are 20 matching rows to the WHERE clause, then I want cardnumb to be set to @high+1, @high+2, @[EMAIL PROTECTED] respectively for the 20 records (the order they are set is irrelevant). Is it possible to have an auto-incrementing variable in an update statement like this? P h i l l As for myself, I would actually use the client implementing the statement to prepare the variables in advance. Your select statement should return 0 or more records. Assuming it has 1 or more returned, simply obtain the high value to a client stored variable, add one to it, and parse it as part of the UPDATE statement, instead of having it done on the SQL side. While it may or may not offer a benefit in a minor case like this, preparing your statements ahead of time on the client side for more complicated statements can alleviate some of the processing the MySQL server has to do. If I was using C, for a simple example, it would look as follows: char pSQL[256]; int iHighNum = ObtainHighestFromDB(void); iHighNum++; snprintf(pSQL, 256, UPDATE Ops SET cardnumb=%d WHERE newphoto=1 and tbprinted=1;, iHighNum); This in effect leaves any processing possible to the client side. Hope that helps, -Shane - Original Message - From: Phill Gillespie [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 15, 2003 1:53 PM Subject: Simple MySQL help needed... Hi * I'm running MySQl 3.23 and I'm trying to run a very simple command that basically finds the highest number in a column and then for all matching rows sets their card number to be current highest +1. The code looks like this: #cardnumb is actually a string of the form SNx so set @high=x as a number select @high:=convert( right( max( cardnumb ),5) , signed ) FROM Ops; #for all matching crtieria set cardnumb to be update Ops set cardnumb = @high, @[EMAIL PROTECTED] where newphoto =1 and tbprinted =1; Without the , @[EMAIL PROTECTED] part in the script runs fine but sets everyone matching the criteria to @high, rather than increasing it. This is so incredibly simple but it just won't work for me and is not giving me any clue in the logs of on the website. Does anyone see my glaring error? I guess it should really be done by using another table but my current database is only 10k rows and grows very very slowly. Thanks in advance, P h i l l -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple MySQL help needed...
Ahh, yes, thank you for clarifying. My code would obviously have been no help. Hmm, I have not tested the theory, but I believe you could add to your SELECT statement, a declaration of the return and use it in the next INSERT. That is, SELECT @high:=convert(...) AS a FROM Ops; And then a refers to a record set populated as you needed. I am not really buff on my SQL syntax, because I typically do most processing client side, but I believe you could then set a temporary value to high, and through a loop of the records in a, increment the temp value, before assigning it to cardnum. I understand the logic, unfortunately my SQL knowledge is still a bit rusty. If it cannot be achieved with a temp value and loop on the MySQL side, the C code for it would be quite easy. However, it would involved a multiple UPDATE calls, using a transaction most likely. Lock tables too, for efficiency. Best of luck, -Shane - Original Message - From: Phill Gillespie [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 15, 2003 3:54 PM Subject: Re: Simple MySQL help needed... Shane Bryldt wrote: I think the solution is simple, remove the part of the code you are having problems with, it's redundant. Instead, according to your statement, use this: UPDATE Ops SET [EMAIL PROTECTED] WHERE newphoto=1 AND tbprinted=1; Thanks for the response Shane. I don't think I explained my statement clearly as your corrected code would set all matching rows to be @high+1. What I am trying to achieve is if there are 20 matching rows to the WHERE clause, then I want cardnumb to be set to @high+1, @high+2, @[EMAIL PROTECTED] respectively for the 20 records (the order they are set is irrelevant). Is it possible to have an auto-incrementing variable in an update statement like this? P h i l l As for myself, I would actually use the client implementing the statement to prepare the variables in advance. Your select statement should return 0 or more records. Assuming it has 1 or more returned, simply obtain the high value to a client stored variable, add one to it, and parse it as part of the UPDATE statement, instead of having it done on the SQL side. While it may or may not offer a benefit in a minor case like this, preparing your statements ahead of time on the client side for more complicated statements can alleviate some of the processing the MySQL server has to do. If I was using C, for a simple example, it would look as follows: char pSQL[256]; int iHighNum = ObtainHighestFromDB(void); iHighNum++; snprintf(pSQL, 256, UPDATE Ops SET cardnumb=%d WHERE newphoto=1 and tbprinted=1;, iHighNum); This in effect leaves any processing possible to the client side. Hope that helps, -Shane - Original Message - From: Phill Gillespie [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 15, 2003 1:53 PM Subject: Simple MySQL help needed... Hi * I'm running MySQl 3.23 and I'm trying to run a very simple command that basically finds the highest number in a column and then for all matching rows sets their card number to be current highest +1. The code looks like this: #cardnumb is actually a string of the form SNx so set @high=x as a number select @high:=convert( right( max( cardnumb ),5) , signed ) FROM Ops; #for all matching crtieria set cardnumb to be update Ops set cardnumb = @high, @[EMAIL PROTECTED] where newphoto =1 and tbprinted =1; Without the , @[EMAIL PROTECTED] part in the script runs fine but sets everyone matching the criteria to @high, rather than increasing it. This is so incredibly simple but it just won't work for me and is not giving me any clue in the logs of on the website. Does anyone see my glaring error? I guess it should really be done by using another table but my current database is only 10k rows and grows very very slowly. Thanks in advance, P h i l l -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
os X install mySQL help
This is a mac os X installation problem: When I download/install the pkg version of mysql 4.0.13, two directories seem to be missing in /usr/local/bin/mysql: var/ and run/. So, when I try to run mysqld_safe (or safe_mysqld), I get errors like: touch: /usr/local/mysql/var/myhostname.err: No such file or directory Starting mysqld daemon with databases from /usr/local/mysql/var... followed by alot more errors which basically say, you don't have a var/ directory or a run/ directory. Is this addressed anywhere in the manual? If I run sudo ./bin/mysqld_safe, I get the mysqld ended error, and this is what my .err file says about it: Can't start server : Bind on unix socket: No such file or directory 030605 10:59:08 Do you already have another mysqld server running on socket: /usr/local/mysql/run/mysql_socket ? 030605 10:59:08 Aborting what's going on here, I've been trying to install this for 10 hours??? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: os X install mySQL help
Go to the /usr/local/mysql directory and rename (mv) data to var. -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ From: gerald jones - Sun Microsystems - Broomfield United States [EMAIL PROTECTED] Reply-To: gerald jones - Sun Microsystems - Broomfield United States [EMAIL PROTECTED] Date: Thu, 5 Jun 2003 13:18:29 -0600 (MDT) To: [EMAIL PROTECTED] Subject: os X install mySQL help This is a mac os X installation problem: When I download/install the pkg version of mysql 4.0.13, two directories seem to be missing in /usr/local/bin/mysql: var/ and run/. So, when I try to run mysqld_safe (or safe_mysqld), I get errors like: touch: /usr/local/mysql/var/myhostname.err: No such file or directory Starting mysqld daemon with databases from /usr/local/mysql/var... followed by alot more errors which basically say, you don't have a var/ directory or a run/ directory. Is this addressed anywhere in the manual? If I run sudo ./bin/mysqld_safe, I get the mysqld ended error, and this is what my .err file says about it: Can't start server : Bind on unix socket: No such file or directory 030605 10:59:08 Do you already have another mysqld server running on socket: /usr/local/mysql/run/mysql_socket ? 030605 10:59:08 Aborting what's going on here, I've been trying to install this for 10 hours??? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: os X install mySQL help
A good reference, may help (or not): http://www.entropy.ch/software/macosx/mysql/ Ted Rogers On Thursday, June 5, 2003, at 03:18 PM, gerald jones - Sun Microsystems - Broomfield United States wrote: This is a mac os X installation problem: When I download/install the pkg version of mysql 4.0.13, two directories seem to be missing in /usr/local/bin/mysql: var/ and run/. So, when I try to run mysqld_safe (or safe_mysqld), I get errors like: touch: /usr/local/mysql/var/myhostname.err: No such file or directory Starting mysqld daemon with databases from /usr/local/mysql/var... followed by alot more errors which basically say, you don't have a var/ directory or a run/ directory. Is this addressed anywhere in the manual? If I run sudo ./bin/mysqld_safe, I get the mysqld ended error, and this is what my .err file says about it: Can't start server : Bind on unix socket: No such file or directory 030605 10:59:08 Do you already have another mysqld server running on socket: /usr/local/mysql/run/mysql_socket ? 030605 10:59:08 Aborting what's going on here, I've been trying to install this for 10 hours??? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: RE: MySQL Help Needed Please
On Sunday 05 January 2003 09:08, Anton Zavrin wrote: Well, I read, played around and updated it (I guess) Now, when I try to start mysql with this command (same as before), it gives me that: # /usr/local/bin/safe_mysqld --user=mysql [1] 71491 # Starting mysqld daemon with databases from /usr/local/var 030104 23:01:55 mysqld ended [1]Done /usr/local/bin/safe_mysqld --user=mysql How do I re-point mysql to look for my old database, I guess that's the problem right? Anton, look in the error log file to see the causes of failed start. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Help Needed Please
Anton, # Starting mysqld daemon with databases from /usr/local/var 030104 23:01:55 mysqld ended This symptom shows when the privilege tables (i.e. the mysql database) has not been installed. Under Unix/Linux, there's a script for this. You can find details here: http://www.mysql.com/doc/en/Post-installation.html Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, January 05, 2003 8:08 AM Subject: RE: MySQL Help Needed Please Well, I read, played around and updated it (I guess) Now, when I try to start mysql with this command (same as before), it gives me that: # /usr/local/bin/safe_mysqld --user=mysql [1] 71491 # Starting mysqld daemon with databases from /usr/local/var 030104 23:01:55 mysqld ended [1]Done /usr/local/bin/safe_mysqld --user=mysql How do I re-point mysql to look for my old database, I guess that's the problem right? Thank you Stefan Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 2:14 PM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, ps -ef | grep mysqld got nothing Because the MySQL SERVER isn't running! Though I can do: # mysql -u root -p With this command, you start the MySQL Monitor (that's the SQL command line CLIENT tool that comes along with MySQL) and tell it to connect to a MySQL SERVER running on localhost, as user root and willing to enter a password. Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) Can't connect - this means the CLIENT tool cannot connect because there is no server running! Start the server using the mysql_safe script (more info here: http://www.mysql.com/doc/en/safe_mysqld.html). For a test, you can simply start the server like this: # mysqld AFTER THAT you connect to the SERVER using the CLIENT tool mysql. Hope this gets you running, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:59 PM Subject: RE: MySQL Help Needed Please Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 8:01 AM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re
RE: MySQL Help Needed Please
I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Help Needed Please
Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Help Needed Please
Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 8:01 AM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Help Needed Please
Anton, ps -ef | grep mysqld got nothing Because the MySQL SERVER isn't running! Though I can do: # mysql -u root -p With this command, you start the MySQL Monitor (that's the SQL command line CLIENT tool that comes along with MySQL) and tell it to connect to a MySQL SERVER running on localhost, as user root and willing to enter a password. Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) Can't connect - this means the CLIENT tool cannot connect because there is no server running! Start the server using the mysql_safe script (more info here: http://www.mysql.com/doc/en/safe_mysqld.html). For a test, you can simply start the server like this: # mysqld AFTER THAT you connect to the SERVER using the CLIENT tool mysql. Hope this gets you running, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:59 PM Subject: RE: MySQL Help Needed Please Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 8:01 AM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Help Needed Please
Well, I read, played around and updated it (I guess) Now, when I try to start mysql with this command (same as before), it gives me that: # /usr/local/bin/safe_mysqld --user=mysql [1] 71491 # Starting mysqld daemon with databases from /usr/local/var 030104 23:01:55 mysqld ended [1]Done /usr/local/bin/safe_mysqld --user=mysql How do I re-point mysql to look for my old database, I guess that's the problem right? Thank you Stefan Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 2:14 PM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, ps -ef | grep mysqld got nothing Because the MySQL SERVER isn't running! Though I can do: # mysql -u root -p With this command, you start the MySQL Monitor (that's the SQL command line CLIENT tool that comes along with MySQL) and tell it to connect to a MySQL SERVER running on localhost, as user root and willing to enter a password. Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) Can't connect - this means the CLIENT tool cannot connect because there is no server running! Start the server using the mysql_safe script (more info here: http://www.mysql.com/doc/en/safe_mysqld.html). For a test, you can simply start the server like this: # mysqld AFTER THAT you connect to the SERVER using the CLIENT tool mysql. Hope this gets you running, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:59 PM Subject: RE: MySQL Help Needed Please Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 8:01 AM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton - Before
MySQL Help Needed Please
Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton
Re: MySQL Help Needed Please
Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Help - Initial Configuration
I'm fairly new to MySQL, and RDBMS's in general, but not to system administration nor linux. I'm running Gentoo, and I can't seem to get mySQL to work. Gallio root # /etc/init.d/mysql start * Starting mysqld... [ ok ] Then I: Gallio root # ps ax PID TTY STAT TIME COMMAND 1 ? S 0:04 init 2 ? SW 0:00 [keventd] 3 ? SWN 0:00 [ksoftirqd_CPU0] 4 ? SW 0:00 [kswapd] 5 ? SW 0:00 [bdflush] 6 ? SW 0:00 [kupdated] 7 ? SW 0:00 [khubd] 12 ? SW 0:02 [kjournald] 37 ? S 0:00 /sbin/devfsd /dev 1989 ? SW 0:00 [kjournald] 1990 ? SW 0:00 [kjournald] 1991 ? SW 0:00 [kjournald] 4711 ? SW 0:00 [eth0] 4907 ? S 0:00 /usr/sbin/smbd 4909 ? S 0:01 /usr/sbin/nmbd 4942 ? S 0:00 /usr/sbin/sshd 4996 ? S 0:00 /usr/sbin/syslogd -m 0 4999 ? S 0:00 /usr/sbin/klogd -c 3 -2 5001 ? S 0:00 /usr/sbin/cron 5007 vc/1 S 0:00 login -- root 5008 vc/2 S 0:00 login -- root 5010 vc/4 S 0:00 /sbin/agetty 38400 tty4 linux 5011 vc/5 S 0:00 /sbin/agetty 38400 tty5 linux 5012 vc/6 S 0:00 /sbin/agetty 38400 tty6 linux 5013 vc/1 S 0:00 -bash 5480 vc/2 S 0:00 -bash 1211 vc/3 S 0:00 /sbin/agetty 38400 tty3 linux 5487 ? S 0:00 /usr/sbin/sshd 5489 ? S 0:00 /usr/sbin/sshd 5490 pts/0 S 0:00 -sh 5497 pts/0 S 0:00 -bash 5604 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5605 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5606 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5607 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5608 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5570 pts/0 R 0:00 ps ax But it's not there. To make sure: Gallio root # nmap 10.10.10.10 Starting nmap V. 3.00 ( www.insecure.org/nmap/ ) Interesting ports on Gallio (10.10.10.10): (The 1599 ports scanned but not shown below are in state: closed) Port State Service 22/tcp open ssh 80/tcp open http 139/tcp open netbios-ssn Nmap run completed -- 1 IP address (1 host up) scanned in 2 seconds Gallio root # Nothin'. Nada. Nil. It's not starting. If I try to stop it... Gallio root # /etc/init.d/mysql stop * Stopping mysqld... [ !! ] My guess, it can't find the pid to stop it with. And the file /var/run/mysqld/mysqld.pid (or something like that) doesn't exist. Running 'safe_mysqld --user=mysql ' does the following: Gallio root # safe_mysqld --user=mysql [1] 5632 Gallio root # Starting mysqld daemon with databases from /var/lib/mysql 021213 11:47:23 mysqld ended When I escape out of that: [1]+ Done safe_mysqld --user=mysql I'm not sure what has gone wrong, but I'd like to get the mysql up and running. BTW, what would be a worthy book to get on mySQL? Ben -- __ http://www.linuxmail.org/ Now with POP3/IMAP access for only US$19.95/yr Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: MySQL Help - Initial Configuration
On Friday 13 December 2002 22:19, Benjamin Fisher wrote: I'm fairly new to MySQL, and RDBMS's in general, but not to system administration nor linux. I'm running Gentoo, and I can't seem to get mySQL to work. [skip] My guess, it can't find the pid to stop it with. And the file /var/run/mysqld/mysqld.pid (or something like that) doesn't exist. Running 'safe_mysqld --user=mysql ' does the following: Gallio root # safe_mysqld --user=mysql [1] 5632 Gallio root # Starting mysqld daemon with databases from /var/lib/mysql 021213 11:47:23 mysqld ended Look in the error log file to see what is wrong with MySQL start. When I escape out of that: [1]+ Done safe_mysqld --user=mysql I'm not sure what has gone wrong, but I'd like to get the mysql up and running. BTW, what would be a worthy book to get on mySQL? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[MySQL] HELP: Can MySQL run external programs... Sendmail for example
Greetings, I'm new to this list but not to MySQL. I've been using MySQL on Linux with PHP for the past year or two. I've always managed to sort out any problems by looking at the documentation on the website but my current problem has me perplexed. I need to be able to send Emails to people from MySQL command line. I'm importing a text file of users via a cronjob. MySQL process the data and segragates it into different tables. My problem is that I want MySQL to Email the plain text passwords to the users before it MD5's them. I cannot find any references that MySQL can run external programs [sendmail]. Any help or workarounds [no matter how crazy ;-)] would be appriciated, although I'd rather not do the Emailing and MD5'ing at the data source. Oh, if this isn't the correct mailing list to post this, just let me know. Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 460 3880 * * G6 * GSM : +353 86 600 4004 * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * Ireland * R a n g e R * ** * Lieutenant, Your men are already dead* ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
Keith Burke [Experience IT] wrote: Greetings, I'm new to this list but not to MySQL. I've been using MySQL on Linux with PHP for the past year or two. I've always managed to sort out any problems by looking at the documentation on the website but my current problem has me perplexed. I need to be able to send Emails to people from MySQL command line. I'm importing a text file of users via a cronjob. MySQL process the data and segragates it into different tables. My problem is that I want MySQL to Email the plain text passwords to the users before it MD5's them. I cannot find any references that MySQL can run external programs [sendmail]. Any help or workarounds [no matter how crazy ;-)] would be appriciated, although I'd rather not do the Emailing and MD5'ing at the data source. Oh, if this isn't the correct mailing list to post this, just let me know. Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 460 3880 * * G6 * GSM : +353 86 600 4004 * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * Ireland * R a n g e R * ** * Lieutenant, Your men are already dead* ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Keith, When you say Emailing and MD5'ing at the data source.. Are you saying you dont want to use PHP to insert and email the passwords? walt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
Write it in perl. Perl has modules for MySQl and Email. Keith Burke [Experience IT] wrote: Greetings, I'm new to this list but not to MySQL. I've been using MySQL on Linux with PHP for the past year or two. I've always managed to sort out any problems by looking at the documentation on the website but my current problem has me perplexed. I need to be able to send Emails to people from MySQL command line. I'm importing a text file of users via a cronjob. MySQL process the data and segragates it into different tables. My problem is that I want MySQL to Email the plain text passwords to the users before it MD5's them. I cannot find any references that MySQL can run external programs [sendmail]. Any help or workarounds [no matter how crazy ;-)] would be appriciated, although I'd rather not do the Emailing and MD5'ing at the data source. Oh, if this isn't the correct mailing list to post this, just let me know. Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 460 3880 * * G6 * GSM : +353 86 600 4004 * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * Ireland * R a n g e R * ** * Lieutenant, Your men are already dead* ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
Hi, I think youd should make an UDF which that execute in shell what you need. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Keith Burke [Experience IT] [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Sent: Friday, September 06, 2002 1:23 PM Subject: [MySQL] HELP: Can MySQL run external programs... Sendmail for example Greetings, I'm new to this list but not to MySQL. I've been using MySQL on Linux with PHP for the past year or two. I've always managed to sort out any problems by looking at the documentation on the website but my current problem has me perplexed. I need to be able to send Emails to people from MySQL command line. I'm importing a text file of users via a cronjob. MySQL process the data and segragates it into different tables. My problem is that I want MySQL to Email the plain text passwords to the users before it MD5's them. I cannot find any references that MySQL can run external programs [sendmail]. Any help or workarounds [no matter how crazy ;-)] would be appriciated, although I'd rather not do the Emailing and MD5'ing at the data source. Oh, if this isn't the correct mailing list to post this, just let me know. Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 460 3880 * * G6 * GSM : +353 86 600 4004 * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * Ireland * R a n g e R * ** * Lieutenant, Your men are already dead* ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL] HELP: Can MySQL run external programs... Sendmail forexample
Keith Burke [Experience IT] wrote: I need to be able to send Emails to people from MySQL command line. May I rephrase your comment? I need to send E-mails to people from MySQL data. I recommend just doing a SELECT on the data in question and generating the E-mails from PERL or PHP or whatever other language you are using. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
Hello! walt wrote: Keith Burke [Experience IT] wrote: Greetings, I'm new to this list but not to MySQL. I've been using MySQL on Linux with PHP for the past year or two. I've always managed to sort out any problems by looking at the documentation on the website but my current problem has me perplexed. I need to be able to send Emails to people from MySQL command line. I'm importing a text file of users via a cronjob. MySQL process the data and segragates it into different tables. My problem is that I want MySQL to Email the plain text passwords to the users before it MD5's them. I cannot find any references that MySQL can run external programs [sendmail]. You do it with a cronjob, so why not using some of the nice Unix commands on the file before importing it. I use bash or awk for such things...maybe like this (Assuming your file (the_file) looks like this: USERNAME PASSWORD ... Write an awk script, like this (mailsend) # #!/bin/awk -f { message( $1, $2 ) } function message( uid, pwd ) { print Dear uid ! /tmp/mail.txt; print /tmp/mail.txt; print Your username is: uid /tmp/mail.txt; print Your password is: pwd /tmp/mail.txt; print /tmp/mail.txt; print Be aware that your password will be saved in an encrypted format, so noone can read it! /tmp/mail.txt; close( /tmp/mail.txt); cmd = cat /tmp/mail.txt | mail -s 'Your password for xyz' uid @somewhere.com; system(cmd); } # chmod mailsend 700 mailsend the_file (BTW: in the above example might be syntax error, because I did not test it ;-) ) Greetings Ralf -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal einbinden? Wir zeigen es Ihnen - vom 3. bis 5.9. auf der Messe Essen Halle 3, Stand 3255 SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
Walt, Sorry, let me explain in a little more detail. I have an Access front end ODBC'd to a Foxpro database [I hate Foxpro :-p No choice, another company developed it for our customer.] on a Windows server. I get it to export the data to couple of files, tar, gzip, then ftp to my Internet server. I don't want to have to MD5 at this stage, it's so much easier to do it on the linux box. Emailing is not a problem on the Windows box. Will eventually go to VB scheduled job, or let Oracle handle the whole source data thing. Hope that clears it up a bit for ye ;-) Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 xxx xxx * * Unit G6 * GSM : +353 86 xxx xxx * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * * * Ireland * * ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of walt Sent: 06 September 2002 15:05 To: [EMAIL PROTECTED] Cc: MySQL Mailing List Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example *snip* Keith, When you say Emailing and MD5'ing at the data source.. Are you saying you dont want to use PHP to insert and email the passwords? walt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
...or a good alternative is PAGER. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: [EMAIL PROTECTED]; MySQL Mailing List [EMAIL PROTECTED] Sent: Friday, September 06, 2002 5:10 PM Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example Hi, I think youd should make an UDF which that execute in shell what you need. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Keith Burke [Experience IT] [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Sent: Friday, September 06, 2002 1:23 PM Subject: [MySQL] HELP: Can MySQL run external programs... Sendmail for example Greetings, I'm new to this list but not to MySQL. I've been using MySQL on Linux with PHP for the past year or two. I've always managed to sort out any problems by looking at the documentation on the website but my current problem has me perplexed. I need to be able to send Emails to people from MySQL command line. I'm importing a text file of users via a cronjob. MySQL process the data and segragates it into different tables. My problem is that I want MySQL to Email the plain text passwords to the users before it MD5's them. I cannot find any references that MySQL can run external programs [sendmail]. Any help or workarounds [no matter how crazy ;-)] would be appriciated, although I'd rather not do the Emailing and MD5'ing at the data source. Oh, if this isn't the correct mailing list to post this, just let me know. Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 460 3880 * * G6 * GSM : +353 86 600 4004 * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * Ireland * R a n g e R * ** * Lieutenant, Your men are already dead* ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
Michael T. Babcock wrote: May I rephrase your comment? I need to send E-mails to people from MySQL data. I recommend just doing a SELECT on the data in question and generating the E-mails from PERL or PHP or whatever other language you are using. No you may not ;-) *joke* It needs to be run automatically without user intervention [cronjob] so the PERL [not an option as I've never used it] or PHP would have to be of the CGI variety [if that's what you call the standalone version, not the API for the web server]. But it is an option and I'll consider. I'll probably try the suggestion by Ralf Narozny first. It seems to be exactly what I want, plus... It's relatively simple :-) I'll also have to read up on those UDF's. Sounds interesting. Cheers everyone. Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 xxx * * Unit G6 * GSM : +353 86 xxx * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * * * Ireland * * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
... I'll also have to read up on those UDF's. Sounds interesting. ...or PAGER. Try to do a test: \P mail root@localhost; select User,Host,Password from mysql.user; \n Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Keith Burke [Experience IT] [EMAIL PROTECTED] To: 'Michael T. Babcock' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 06, 2002 6:00 PM Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example Michael T. Babcock wrote: May I rephrase your comment? I need to send E-mails to people from MySQL data. I recommend just doing a SELECT on the data in question and generating the E-mails from PERL or PHP or whatever other language you are using. No you may not ;-) *joke* It needs to be run automatically without user intervention [cronjob] so the PERL [not an option as I've never used it] or PHP would have to be of the CGI variety [if that's what you call the standalone version, not the API for the web server]. But it is an option and I'll consider. I'll probably try the suggestion by Ralf Narozny first. It seems to be exactly what I want, plus... It's relatively simple :-) I'll also have to read up on those UDF's. Sounds interesting. Cheers everyone. Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 xxx * * Unit G6 * GSM : +353 86 xxx * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * * * Ireland * * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
Sorry, my bad. What is this PAGER and where do I run your test script from? Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 460 3880 * * Unit G6 * GSM : +353 86 600 4004 * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * * * Ireland * * ** -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Sent: 06 September 2002 16:39 To: [EMAIL PROTECTED]; 'Michael T. Babcock'; [EMAIL PROTECTED] Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example ... I'll also have to read up on those UDF's. Sounds interesting. ...or PAGER. Try to do a test: \P mail root@localhost; select User,Host,Password from mysql.user; \n Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Keith Burke [Experience IT] [EMAIL PROTECTED] To: 'Michael T. Babcock' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 06, 2002 6:00 PM Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example Michael T. Babcock wrote: May I rephrase your comment? I need to send E-mails to people from MySQL data. I recommend just doing a SELECT on the data in question and generating the E-mails from PERL or PHP or whatever other language you are using. No you may not ;-) *joke* It needs to be run automatically without user intervention [cronjob] so the PERL [not an option as I've never used it] or PHP would have to be of the CGI variety [if that's what you call the standalone version, not the API for the web server]. But it is an option and I'll consider. I'll probably try the suggestion by Ralf Narozny first. It seems to be exactly what I want, plus... It's relatively simple :-) I'll also have to read up on those UDF's. Sounds interesting. Cheers everyone. Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 xxx * * Unit G6 * GSM : +353 86 xxx * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * * * Ireland * * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
Hi Keith, It's very simple. type from console : mysql -u root -h your_hostor whatever you need to start mysql client and after this just type : mysql\P mail root@localhost; mysqlselect User,Host,Password from mysql.user; mysql\n; ...after this you can look in the root e-mail box and you can see the result of query. Indeed doesn't work with ENCAPSULATED(i don't know a better term in english...Ufff my english) SQL QUERY If this solution it's not what you need the alternative is UDF. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Keith Burke [Experience IT] [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; 'Michael T. Babcock' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 06, 2002 6:54 PM Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example Sorry, my bad. What is this PAGER and where do I run your test script from? Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 460 3880 * * Unit G6 * GSM : +353 86 600 4004 * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * * * Ireland * * ** -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Sent: 06 September 2002 16:39 To: [EMAIL PROTECTED]; 'Michael T. Babcock'; [EMAIL PROTECTED] Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example ... I'll also have to read up on those UDF's. Sounds interesting. ...or PAGER. Try to do a test: \P mail root@localhost; select User,Host,Password from mysql.user; \n Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Keith Burke [Experience IT] [EMAIL PROTECTED] To: 'Michael T. Babcock' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 06, 2002 6:00 PM Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example Michael T. Babcock wrote: May I rephrase your comment? I need to send E-mails to people from MySQL data. I recommend just doing a SELECT on the data in question and generating the E-mails from PERL or PHP or whatever other language you are using. No you may not ;-) *joke* It needs to be run automatically without user intervention [cronjob] so the PERL [not an option as I've never used it] or PHP would have to be of the CGI variety [if that's what you call the standalone version, not the API for the web server]. But it is an option and I'll consider. I'll probably try the suggestion by Ralf Narozny first. It seems to be exactly what I want, plus... It's relatively simple :-) I'll also have to read up on those UDF's. Sounds interesting. Cheers everyone. Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 xxx * * Unit G6 * GSM : +353 86 xxx * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * * * Ireland * * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting
Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
Might want to look at writing either a shell script or doing it in C, if it has to be non-interactive. Escapade can also do thos sort of thing interactively, and it's as simple as 4 lines of code. - Original Message - From: Keith Burke [Experience IT] [EMAIL PROTECTED] To: 'Michael T. Babcock' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 06, 2002 10:00 AM Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example Michael T. Babcock wrote: May I rephrase your comment? I need to send E-mails to people from MySQL data. I recommend just doing a SELECT on the data in question and generating the E-mails from PERL or PHP or whatever other language you are using. No you may not ;-) *joke* It needs to be run automatically without user intervention [cronjob] so the PERL [not an option as I've never used it] or PHP would have to be of the CGI variety [if that's what you call the standalone version, not the API for the web server]. But it is an option and I'll consider. I'll probably try the suggestion by Ralf Narozny first. It seems to be exactly what I want, plus... It's relatively simple :-) I'll also have to read up on those UDF's. Sounds interesting. Cheers everyone. Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 xxx * * Unit G6 * GSM : +353 86 xxx * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * * * Ireland * * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Jon Frisby---MySQL help needed
Hi Jon, Whatever you have suggested so far hasn't worked. I thought that maybe something is missing in my stating the problem and implementing your suggested solutions. So here is a more expanded picture of the queries: $sth=$dbh-prepare(INSERT INTO TABLE1 (id,var1,var2) VALUES (?,?,?)); $sth-execute(,$var1,$var2); $sth=$dbh-prepare(SELECT \@t1id:=LAST_INSERT_ID()); $sth-execute(); $sth=$dbh-prepare(INSERT INTO TABLE1A (Aid,id,var1) VALUES (?, @t1id, $var1); $sth-execute(,,$var1); Please take a note that in the last prepare statement I have also tried \@t1id ,\@t1id, LAST_INSERT_ID(). I have used these in 'execute' statement too with question marks (?) in the prepare statement. Any new idea please? Thanks, Aamer Try: $sth-execute(...); Sorry for the confusion. Of course I tried the above statement. I took it granted that we would mean the above when we say the following: execute(, \@t1id, $var1...); I still get the same result. I hope you don't quit on me. Thanks. Hrm... Ah! If your code is doing a prepare on a statement of the form: INSERT INTO x VALUES(@t1id, ...) Then you don't need to give @t1id as a parameter in the execute statement... You should only need to provide params to execute for each ? that appears in the INSERT statement... -JF sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Jon Frisby---MySQL help needed
On Mon, Jul 29, 2002 at 01:13:30PM -0400, Aamer Rauf wrote: Hi Jon, Whatever you have suggested so far hasn't worked. I thought that maybe something is missing in my stating the problem and implementing your suggested solutions. So here is a more expanded picture of the queries: $sth=$dbh-prepare(INSERT INTO TABLE1 (id,var1,var2) VALUES (?,?,?)); $sth-execute(,$var1,$var2); $sth=$dbh-prepare(SELECT \@t1id:=LAST_INSERT_ID()); $sth-execute(); $sth=$dbh-prepare(INSERT INTO TABLE1A (Aid,id,var1) VALUES (?, @t1id, $var1); $sth-execute(,,$var1); Doesn't this chain of events reuse the variable $sth, which essentially closes the old statement handler? Doesn't that lose state? I'm guessing... Please take a note that in the last prepare statement I have also tried \@t1id ,\@t1id, LAST_INSERT_ID(). I have used these in 'execute' statement too with question marks (?) in the prepare statement. Any new idea please? Try grabbing the new ID manually, before the second prepare: my $id = $dbh-{'mysql_insertid'}; Then, manually use that as a bind variable. Thanks, Aamer -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Jon Frisby---MySQL help needed
Whatever you have suggested so far hasn't worked. I thought that maybe something is missing in my stating the problem and implementing your suggested solutions. So here is a more expanded picture of the queries: $sth=$dbh-prepare(INSERT INTO TABLE1 (id,var1,var2) VALUES (?,?,?)); $sth-execute(,$var1,$var2); $sth=$dbh-prepare(SELECT \@t1id:=LAST_INSERT_ID()); $sth-execute(); After this, try the following: $sth2 = $dbh-prepare(SELECT \@t1id); $sth2-execute(); $tmp = $sth2-fetchrow_arrayref(); print ID: . $tmp-[0]; See if you're getting a number here or not... $sth=$dbh-prepare(INSERT INTO TABLE1A (Aid,id,var1) VALUES (?, @t1id, $var1); Note that using @t1id in double-quotes without escaping the @ will *never* work, because Perl will think you are trying to use a Perl variable, when in reality @t1id is a MySQL variable. $sth-execute(,,$var1); Why are you sending unused bound parameters? Try this: $sth = $dbh-prepare(INSERT INTO TABLE1A (Aid,id,var1) VALUES (0, \@t1id, $var1); $sth-execute(); -JF - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error in mysql - help!!!
I have tried to install mysql, but there is something wrong... When I start up my computer I get this error-message in a pop-up with a 'winmysqladmin.exe'-header: Error reading Memo2 - Lines.Strings: The parameter is incorrect. Does anybody know what this means, and what I can do to make mysql work? Php and Apache seems to be up and running. I'm using win98. I'm new to this game, so ALL help is apreciated!! jan henrik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySQL help
Hi, I am a student, I am due to return for my final year where I must complete a final year project. I have decided to develop a JSP website connected to a database. I have installed TomCat and have been recommended to use MySQL. I have downloaded MySQL but I would like help on how I would go about getting JSP to link up to MySQL so it can access data I create. Your help will be very much appreciated. Thanks, Yungster === URL: www.yungster.com www.yungster.co.uk === _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql help !! urgent
Hello, In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do anything as phpmyadmin wont work because root can't do anything at all... I have complete ssh access etc to the server, Please help me out what do i do to give root full privs again?!? please help me make mysql work again as I really need it. -- Jesse Angell PalaceUnlimited.com #1 Palace Host - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql help !! urgent
mysqld --skip-grant-tables -Original Message- From: Jesse Angell [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 3:38 AM To: [EMAIL PROTECTED] Subject: mysql help !! urgent Hello, In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do anything as phpmyadmin wont work because root can't do anything at all... I have complete ssh access etc to the server, Please help me out what do i do to give root full privs again?!? please help me make mysql work again as I really need it. -- Jesse Angell PalaceUnlimited.com #1 Palace Host - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL help please !
Hello, Try this ? function samp_db_connect() { $hostname = localhost; $username = joe; $password = user; $dbName = test; $link = @mysql_pconnect($hostname, $username, $password); if ($link mysql_select_db($dbName)) return $link; return FALSE; } samp_db_connect() or exit(); ? good luck Andrew Rich wrote: Further to this, I removed the @ symbol and got:- Fatal Error: Call to undefined function: mysql_connect() in /var/www/html/results.php @ $db = mysql_pconnect(localhost, user, password); $db = mysql_pconnect(localhost, user, password); Ideas ? Why is it now a undefined function ? Andrew -Original Message- From: Andrew Rich [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 April 2002 11:14 AM To: [EMAIL PROTECTED] Subject: PHP and MySQL help please ! + PHP Installed and going - I can write to files, retrieve flatfiles + Apache running servers outpages nop probes Trying to talk to SQL using PHP. -- html body h1Go to SQL now/h1 ? echo looking; @ $db = mysql_pconnect(localhost, user, password); if (!$db); { echo Error: Could not connect to database. Please try again later.; exit; } mysql_select_db(test); $query = select * from logbook ; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo pNumber of books found: .$num_results./p; ? /body /html - What gets me if I can do all this from the mysql prompt:- laptopmysql -u user -p (enterpassword gets me in) mysqluse test; OK mysqlselect * from logbook; OK (shows entries no probs); - What am I doing wrong ? It doesnt get past the @ $db = mysql_pconnect(localhost, user, password); in the code. ?? Andrew --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP and MySQL help please !
+ PHP Installed and going - I can write to files, retrieve flatfiles + Apache running servers outpages nop probes Trying to talk to SQL using PHP. -- html body h1Go to SQL now/h1 ? echo looking; @ $db = mysql_pconnect(localhost, user, password); if (!$db); { echo Error: Could not connect to database. Please try again later.; exit; } mysql_select_db(test); $query = select * from logbook ; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo pNumber of books found: .$num_results./p; ? /body /html - What gets me if I can do all this from the mysql prompt:- laptopmysql -u user -p (enterpassword gets me in) mysqluse test; OK mysqlselect * from logbook; OK (shows entries no probs); - What am I doing wrong ? It doesnt get past the @ $db = mysql_pconnect(localhost, user, password); in the code. ?? Andrew --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: PHP and MySQL help please !
Further to this, I removed the @ symbol and got:- Fatal Error: Call to undefined function: mysql_connect() in /var/www/html/results.php @ $db = mysql_pconnect(localhost, user, password); $db = mysql_pconnect(localhost, user, password); Ideas ? Why is it now a undefined function ? Andrew -Original Message- From: Andrew Rich [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 April 2002 11:14 AM To: [EMAIL PROTECTED] Subject: PHP and MySQL help please ! + PHP Installed and going - I can write to files, retrieve flatfiles + Apache running servers outpages nop probes Trying to talk to SQL using PHP. -- html body h1Go to SQL now/h1 ? echo looking; @ $db = mysql_pconnect(localhost, user, password); if (!$db); { echo Error: Could not connect to database. Please try again later.; exit; } mysql_select_db(test); $query = select * from logbook ; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo pNumber of books found: .$num_results./p; ? /body /html - What gets me if I can do all this from the mysql prompt:- laptopmysql -u user -p (enterpassword gets me in) mysqluse test; OK mysqlselect * from logbook; OK (shows entries no probs); - What am I doing wrong ? It doesnt get past the @ $db = mysql_pconnect(localhost, user, password); in the code. ?? Andrew --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: PHP and MySQL help please !
Fatal Error: Call to undefined function: mysql_connect() in /var/www/html/results.php + I think my PHP does not have mysql included, although I put in the ./configure --with mysql=/usr/local/mysql \ + When I type which mysql it says /usr/bin/msql + So should I put:- ./configure --with-mysql=/usr/local/mysql OR ./configure --with-mysql=/usr/bin/mysql ? I am not sure if the include statement is design to add mysql BINARIES or SOURCE CODE ?? Lost. Andrew -Original Message- From: Andrew Rich [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 April 2002 11:28 AM To: Andrew Rich; [EMAIL PROTECTED] Subject: RE: PHP and MySQL help please ! Further to this, I removed the @ symbol and got:- Fatal Error: Call to undefined function: mysql_connect() in /var/www/html/results.php @ $db = mysql_pconnect(localhost, user, password); $db = mysql_pconnect(localhost, user, password); Ideas ? Why is it now a undefined function ? Andrew -Original Message- From: Andrew Rich [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 April 2002 11:14 AM To: [EMAIL PROTECTED] Subject: PHP and MySQL help please ! + PHP Installed and going - I can write to files, retrieve flatfiles + Apache running servers outpages nop probes Trying to talk to SQL using PHP. -- html body h1Go to SQL now/h1 ? echo looking; @ $db = mysql_pconnect(localhost, user, password); if (!$db); { echo Error: Could not connect to database. Please try again later.; exit; } mysql_select_db(test); $query = select * from logbook ; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo pNumber of books found: .$num_results./p; ? /body /html - What gets me if I can do all this from the mysql prompt:- laptopmysql -u user -p (enterpassword gets me in) mysqluse test; OK mysqlselect * from logbook; OK (shows entries no probs); - What am I doing wrong ? It doesnt get past the @ $db = mysql_pconnect(localhost, user, password); in the code. ?? Andrew --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: PHP and MySQL help please !
I am not sure if the include statement is design to add mysql BINARIES or SOURCE CODE ?? Neither. It's eventually going to link the final php binary with the mysql shared libraries (probably libmysqlclient). I'm not too familiar with PHP, so I don't know if '--with-mysql=' wants the location of the MySQL root directory (typically /usr/local/mysql for source installations) or the directory that contains the libraries (like above, but /usr/local/mysql/lib). Check to see if /usr/local/mysql exists first. Better yet, try this: find /usr -name libmysqlclient* Hopefully, it will show you the location of one (or more) MySQL client libraries. Start there. Michael On Thu, 25 Apr 2002, Andrew Rich wrote: Fatal Error: Call to undefined function: mysql_connect() in /var/www/html/results.php + I think my PHP does not have mysql included, although I put in the ./configure --with mysql=/usr/local/mysql \ + When I type which mysql it says /usr/bin/msql + So should I put:- ./configure --with-mysql=/usr/local/mysql OR ./configure --with-mysql=/usr/bin/mysql ? I am not sure if the include statement is design to add mysql BINARIES or SOURCE CODE ?? Lost. Andrew -Original Message- From: Andrew Rich [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 April 2002 11:28 AM To: Andrew Rich; [EMAIL PROTECTED] Subject: RE: PHP and MySQL help please ! Further to this, I removed the @ symbol and got:- Fatal Error: Call to undefined function: mysql_connect() in /var/www/html/results.php @ $db = mysql_pconnect(localhost, user, password); $db = mysql_pconnect(localhost, user, password); Ideas ? Why is it now a undefined function ? Andrew -Original Message- From: Andrew Rich [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 April 2002 11:14 AM To: [EMAIL PROTECTED] Subject: PHP and MySQL help please ! + PHP Installed and going - I can write to files, retrieve flatfiles + Apache running servers outpages nop probes Trying to talk to SQL using PHP. -- html body h1Go to SQL now/h1 ? echo looking; @ $db = mysql_pconnect(localhost, user, password); if (!$db); { echo Error: Could not connect to database. Please try again later.; exit; } mysql_select_db(test); $query = select * from logbook ; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo pNumber of books found: .$num_results./p; ? /body /html - What gets me if I can do all this from the mysql prompt:- laptopmysql -u user -p (enterpassword gets me in) mysqluse test; OK mysqlselect * from logbook; OK (shows entries no probs); - What am I doing wrong ? It doesnt get past the @ $db = mysql_pconnect(localhost, user, password); in the code. ?? Andrew --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- /*-- * It might look like I'm doing nothing, but at the cellular level * I'm really quite busy. * ---anonymous * * * -BEGIN GEEK CODE BLOCK- * Version: 3.1 * GCS/P/H/L/O d- s-:-- a26 C++(+++) UL+++$ P++ L+++ !E W+++ N- o? K- * w--(---) !O M+ !V PS+ PE- Y-- PGP- t+ 5-(--) X(-) R* tv b+ DI-- D-- G e+++ * h+ r* y-- * --END GEEK CODE BLOCK-- --*/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http
Need MySQL help with tables and records
Hi, I need a little help as I am a beginner with db things. I'm building a database for technicians and help-desk problems where technical problem tickets are stored in one table, and technicians in another. Really I have two main questions. First, each problem may have more than one technician assigned. In the problems table were I have a technician column, should I build an array that holds all the primary keys for each technician assigned or should I build a third table that links multiple technicians to a single problem? And my second question is this, I select the technicians based on alphabetical order out of a list. Each time there is an occurrance of a problem,I go to the next tech in alpha order. How can I do this with MySQL? Or would I have to organize in alpha order using PHP and select my next record? I'd like to go with whatever doesn't absorb system resources too badly and it just seems like having 3 to 5 users accessing this system and having PHP alpha order the database over and over would do that for each occurrance. And how could I flag a record so that I would know where to get the next record once I have it in alpha order? Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need MySQL help with tables and records
On Sun, Mar 17, 2002 at 12:28:35AM -0500, Lionlike wrote: Hi, I need a little help as I am a beginner with db things. I'm building a database for technicians and help-desk problems where technical problem tickets are stored in one table, and technicians in another. Really I have two main questions. First, each problem may have more than one technician assigned. In the problems table were I have a technician column, should I build an array that holds all the primary keys for each technician assigned or should I build a third table that links multiple technicians to a single problem? And my second question is this, I select the technicians based on alphabetical order out of a list. Each time there is an occurrance of a problem,I go to the next tech in alpha order. How can I do this with MySQL? Or would I have to organize in alpha order using PHP and select my next record? I'd like to go with whatever doesn't absorb system resources too badly and it just seems like having 3 to 5 users accessing this system and having PHP alpha order the database over and over would do that for each occurrance. And how could I flag a record so that I would know where to get the next record once I have it in alpha order? Thanks, David Second question first: Create a little table that stores the ID for the last tech assigned a ticket. The next time a ticket is assigned, have your code retrieve the ID and search the tech table for the next ID. Your SELECT query can do any alpha ordering more efficiently than PHP. First question: Your tables are in a many-to-many relationship. Any tech is assigned one or more tickets, and any ticket is assigned to one or more techs. Use a join table to create the many-to-many relationship. The join table has only two columns: a tech ID column and a ticket ID column. Each time a new ticket is assigned, add one row to the join table for each tech assigned the ticket. Each row contains the tech ID and the ticket ID. This makes your SELECT queries a little more complicated, but in the long run it creates fewer problems than any other solution. Bob Hall - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some PHP - mySQL help please ... new to both
Thanx Lou, this really helps out. One question though and maybe this runs deeper then I think. When I start my machine, and run phpMyAdmin (VD in IIS5) it works fine. When I close the browser window after making changes to a user, and then try to re-open it, I PHP is no longer working. I am not sure what it is doing at this point. Seems like it left the connection open to the database and it tries to re-connect after re-opening a browser and shuts everything down. I just get a blank page. Other then that this works great. Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com Lou Picciano / Essex SystemsTo: MySQL List [EMAIL PROTECTED], [EMAIL PROTECTED] Omnis@comcast cc: .netSubject: Re: Some PHP - mySQL help please ... new to both 03/08/2002 07:14 PM Dan, Have you taken a look at phpMyAdmin? This very good tool not only administers your MySQL databases, but their php code is a good teaching tool, as well. Simply drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some PHP - mySQL help please ... new to both
A quick diagnostic? Try the page phpinfo.php in the phpMyAdmin directory - this will give you the 'whole picture' in terms of your php installation... Even easier? Any php page which contains the code: ? phpinfo(); Will give you this full info report. Very useful! Lou Picciano Thanx Lou, this really helps out. One question though and maybe this runs deeper then I think. When I start my machine, and run phpMyAdmin (VD in IIS5) it works fine. When I close the browser window after making changes to a user, and then try to re-open it, I PHP is no longer working. I am not sure what it is doing at this point. Seems like it left the connection open to the database and it tries to re-connect after re-opening a browser and shuts everything down. I just get a blank page. Other then that this works great. Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com Dan, Have you taken a look at phpMyAdmin? This very good tool not only administers your MySQL databases, but their php code is a good teaching tool, as well. Simply drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Some PHP - mySQL help please ... new to both
I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Some PHP - mySQL help please ... new to both
Daniel, Usually in PHP there are some sort of syntax error before the line that says failed. -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Some PHP - mySQL help please ... new to both
Is the syntax of the statement correct ? ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Todd | || Williamsen | || todd@williams| || en.net | ||| || 03/08/02 12:32| || PM| ||| |+ -| | | | To: 'Daniel Negron/KBE' [EMAIL PROTECTED], [EMAIL PROTECTED]| | cc: | | Subject: RE: Some PHP - mySQL help please ... new to both | -| Daniel, Usually in PHP there are some sort of syntax error before the line that says failed. -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Some PHP - mySQL help please ... new to both
Did you check the mysql db, host, and user tables to make sure that 'localhost' and 'administrator' have appropriate permissions to use your desired database? This issue caused me much frustration until I had things set right. You should see something like the following. I'm assuming that your PHP application and your mysql db live on the same box. If it's a PHP issue, then I don't know what to advise you since I don't know PHP. mysql use mysql; mysql select * from user; +-+--+--+-+- +-+-+-+---+- +---+--+---++--- --+++ | Host| User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+--+--+-+- +-+-+-+---+- +---+--+---++--- --+++ | localhost | administrator | | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | mysql select * from host; +-+---+-+-+- +-+-+---++-- ---+++ | Host| Db| Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+---+-+-+- +-+-+---++-- ---+++ | localhost | your_db_name | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | mysql select * from db; +-+-+--+-+-- ---+-+-+-+---++- +++ | Host| Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+-+--+-+-- ---+-+-+-+---++- +++ | localhost (you could try % if the box isn't visible to anyone but you) | your_db_name | administrator | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing
Some PHP - mySQL help please ... new to both (Along same lines)
Along the same lines, I have run some scripts that give a similar error that time out is there something in php.ini or mysql that will alow the timing to not stop after 60seconds or 30seconds or something. Had a script to run and pull keywords from a massive db, and it kept timing out. Hope that make since, thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some PHP - mySQL help please ... new to both
If you're going to post this much information please use: mysql SELECT * FROM user \G so that this is actually readable. Thanks # Nathan - Original Message - From: Brian Warn [EMAIL PROTECTED] To: 'Daniel Negron/KBE' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 08, 2002 10:51 AM Subject: RE: Some PHP - mySQL help please ... new to both Did you check the mysql db, host, and user tables to make sure that 'localhost' and 'administrator' have appropriate permissions to use your desired database? This issue caused me much frustration until I had things set right. You should see something like the following. I'm assuming that your PHP application and your mysql db live on the same box. If it's a PHP issue, then I don't know what to advise you since I don't know PHP. mysql use mysql; mysql select * from user; +-+--+--+-+- +-+-+-+---+- +---+--+---++--- --+++ | Host| User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+--+--+-+- +-+-+-+---+- +---+--+---++--- --+++ | localhost | administrator | | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | mysql select * from host; +-+---+-+-+- +-+-+---++-- ---+++ | Host| Db| Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+---+-+-+- +-+-+---++-- ---+++ | localhost | your_db_name | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | mysql select * from db; +-+-+--+-+-- ---+-+-+-+---++- +++ | Host| Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+-+--+-+-- ---+-+-+-+---++- +++ | localhost (you could try % if the box isn't visible to anyone but you) | your_db_name | administrator | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try
Re: Some PHP - mySQL help please ... new to both
Dan, Have you taken a look at phpMyAdmin? This very good tool not only administers your MySQL databases, but their php code is a good teaching tool, as well. Simply drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MYSQL HELP
Richard Shade Systems Administrator (936)559-2280 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 11:39 AM To: Shade, Richard Subject: Re: MYSQL HELP Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Does anyone know what is wrong with this syntax... Select H.FinishCode, L.RowID From CallHistory As H, BD2.CallList As L Where (H.CallTime in(Select MAX(CallTime) From CallHistory Where H.RowID = L.RowID) AND H.RowID = L.RowID); Richard Shade Systems Administrator (936)559-2280 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential, proprietary, and/or privileged material. Any review, retransmission, dissemination, or other use of, or taking of, any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all computers. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential, proprietary, and/or privileged material. Any review, retransmission, dissemination, or other use of, or taking of, any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all computers. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL HELP
Richard, Does anyone know what is wrong with this syntax... Select H.FinishCode, L.RowID From CallHistory As H, BD2.CallList As L Where (H.CallTime in(Select MAX(CallTime) From CallHistory Where H.RowID = L.RowID) AND H.RowID = L.RowID); Sub-selects not (yet) permitted by MySQL (RTFM: 1.7.4.1 Sub-SELECTs) Looks like a job for two SELECTs and a temporary table... Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MYSQL HELP
How would you use a temporary table? Is that the most efficient way? David -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 11:03 AM To: Shade, Richard; [EMAIL PROTECTED] Subject: Re: MYSQL HELP Richard, Does anyone know what is wrong with this syntax... Select H.FinishCode, L.RowID From CallHistory As H, BD2.CallList As L Where (H.CallTime in(Select MAX(CallTime) From CallHistory Where H.RowID = L.RowID) AND H.RowID = L.RowID); Sub-selects not (yet) permitted by MySQL (RTFM: 1.7.4.1 Sub-SELECTs) Looks like a job for two SELECTs and a temporary table... Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL HELP
David, How would you use a temporary table? Is that the most efficient way? Use SELECT INTO temp_tbl to replace the sub-select clause. Rewrite the existing SELECT into a join with the temp_tbl. Is there another way? =dn Richard, Does anyone know what is wrong with this syntax... Select H.FinishCode, L.RowID From CallHistory As H, BD2.CallList As L Where (H.CallTime in(Select MAX(CallTime) From CallHistory Where H.RowID = L.RowID) AND H.RowID = L.RowID); Sub-selects not (yet) permitted by MySQL (RTFM: 1.7.4.1 Sub-SELECTs) Looks like a job for two SELECTs and a temporary table... Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MYSQL HELP
You can also try: Select SUBSTRING( MAX( CONCAT(LPAD(calltime,6,'0'),finishcode) ), 7) AS finishcode, 0+LEFT( MAX( CONCAT(LPAD(calltime,6,'0'),finishcode )), 6) AS calltime From callhistory As H,calllist As L where H.rowid = L.rowid group by H.rowid This is from: http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html Although it's regarded as 'inefficient', but you can do it in one statement. Regards, Dan -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Thursday, 21 February 2002 11:18 a.m. To: David McInnis; 'Shade, Richard'; [EMAIL PROTECTED] Subject: Re: MYSQL HELP David, How would you use a temporary table? Is that the most efficient way? Use SELECT INTO temp_tbl to replace the sub-select clause. Rewrite the existing SELECT into a join with the temp_tbl. Is there another way? =dn Richard, Does anyone know what is wrong with this syntax... Select H.FinishCode, L.RowID From CallHistory As H, BD2.CallList As L Where (H.CallTime in(Select MAX(CallTime) From CallHistory Where H.RowID = L.RowID) AND H.RowID = L.RowID); Sub-selects not (yet) permitted by MySQL (RTFM: 1.7.4.1 Sub-SELECTs) Looks like a job for two SELECTs and a temporary table... Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql help required
Hi, Does the mysql support internationalisation?. If so, Kindly let me know what settings I need to configure to insert korean strings into the table and retrieve the same and show it in a browser(jsp page)?. Is there any GUI tool for mysql(like Toad for Oracle)?. if so where can I get that?. Thanks in advance, Raghu * Disclaimer: The information in this e-mail and any attachments is confidential / privileged. It is intended solely for the addressee or addressees. If you are not the addressee indicated in this message, you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DBD::mysql HElp
Hi, I'm trying to install DBD::MYSQL on Windows 2000 Pro. I've already install DBI Using ppm for ActivePerl I downloaded DBI and extracted it to a folder. Then i ran ppm intall DBI It installed fine. I did the exact same thing for DBD::MYSQL but i get the following error Error: Package 'DBD::mysql' not found. Please 'search' for ot first. Do you know why it is not finding it? Please help! Thank you Clinton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DBD::mysql HElp
Did you do install mysql or install DBD-mysql? Here's what the activestate page has to say: ActivePerl offers a PPM archive of DBD::mysql. All you need to do is typing ppm install DBI install DBD-mysql This will fetch the modules via HTTP and install them. If you need to use a WWW proxy server, the environment variable Now if you'll excuse me while i pull up my PHP soapbox. I find PHP a much more direct( and simpler) why to build dynamic web pages (if that's objective is?), and the user community *much* more helpful. http://php.net. As far as the Perl side goes: try the howto at http://perlmongs.org. -- David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DBD::mysql HElp
Hi, I'm trying to install DBD::MYSQL on Windows 2000 Pro. I've already install DBI Using ppm for ActivePerl I downloaded DBI and extracted it to a folder. Then i ran ppm intall DBI It installed fine. I did the exact same thing for DBD::MYSQL but i get the following error Error: Package 'DBD::mysql' not found. Please 'search' for ot first. Do you know why it is not finding it? Please help! Thank you Clinton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Some question about establish a Cluster for Mysql,Help!
Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Some question about establish a Cluster for Mysql,Help!
Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Some question about establish a Cluster for Mysql,Help!
Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: M$ SQL Export to Mysql Help
Curtis ... Do you have the database/table created on the MySQL server? If so, you can use MSAccess (need ODBC connections to both servers) to Link Tables and move the data acros that way. We did it that way until our programmers wrote a C++ app that replicates server-to-server. Gerald Jensen - Original Message - From: Curtis Spencer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 2:54 PM Subject: M$ SQL Export to Mysql Help I have a nicely sized database of about 40 records, which I have in MS SQL but I need to move it to my production server, which is Mysql. I was going to do it this way: Export MS SQL database into a file and then use LOAD DATA INFILE But I was wondering if there were a way to export into SQL and then just use \. Database.sql to import it very quickly. I am worried that the exporter will mess up the file because it is so large. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL HELP -- Unable to start Win2k service
Hi all, I have beening running mysql on my win2k for awhile. This afternoon, I have restarted my pc and the next thing I notice mysql service was unable to start. The following is the message I got: Could not start the Mysql service on Local Computer. Error 1067: The process terminated unexpectedly. I have tried to remove the service, uninstalled the mysql and reinstalled it. I got the same result. Any help would be appreciated. Regards, Michael
Re: MySQL HELP -- Unable to start Win2k service
At 03:45 03/07/2001 -0700, Michael Tam wrote: Hi, Take a look on \mysql\data\mysql.err file and see if exists a message error like that server doesn't find a grant tables. Otherwise, try to run the server standalone to see in the screen the error message: yourservername --standalone Fix the possible issues before to run the service. Regards, Miguel Hi all, I have beening running mysql on my win2k for awhile. This afternoon, I have restarted my pc and the next thing I notice mysql service was unable to start. The following is the message I got: Could not start the Mysql service on Local Computer. Error 1067: The process terminated unexpectedly. I have tried to remove the service, uninstalled the mysql and reinstalled it. I got the same result. Any help would be appreciated. Regards, Michael -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL HELP -- Unable to start Win2k service
I have tried to remove the service, uninstalled the mysql and reinstalled it. I got the same result. Looks like the problem may be with a dirty shutdown and problems in tables. Try to run isamchk. Maybe this helps. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL HELP -- Unable to start Win2k service
Hi guys, I have done the isamchk and nothing came up from there and the error log didn't reflect much to indicate any problem with the grant table. Where should I look into next ?? Thanks. Regrads, Michael - Original Message - From: Werner Stuerenburg [EMAIL PROTECTED] To: Michael Tam [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 9:10 AM Subject: Re: MySQL HELP -- Unable to start Win2k service I have tried to remove the service, uninstalled the mysql and reinstalled it. I got the same result. Looks like the problem may be with a dirty shutdown and problems in tables. Try to run isamchk. Maybe this helps. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL HELP -- Unable to start Win2k service
Hi all, Thank you for giving me direction to where I should look into the problem. I finally fix the problem which is coming from a mistake that I made in my.ini. Regards, Michael
Re: MySQL HELP -- Unable to start Win2k service
Only time I had this error on a NT4 server was when I attempted to get logging to work and I made a mistake editing the mycnf and myini files. When I cycled the mysql service, it would no come back up. Removing the offending edit allowed it to start. Pete Michael Tam wrote: Hi all, I have beening running mysql on my win2k for awhile. This afternoon, I have restarted my pc and the next thing I notice mysql service was unable to start. The following is the message I got: Could not start the Mysql service on Local Computer. Error 1067: The process terminated unexpectedly. I have tried to remove the service, uninstalled the mysql and reinstalled it. I got the same result. Any help would be appreciated. Regards, Michael -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DBD::MySQL Help!!
If this was the binary install, I had the same problemso I compiled from source.problem went away. Hi, Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I know this is prolly not the best list for this question, but its the only related list im currently subscribed to... When I do the install it askes me what db to test on and i put test, localhost for host, then i put root as the test user and my root sql users pw for the password, it does some stuff then it runs the make test and this is what happens... Any help?? Running make test PERL_DL_NONLAZY=1 /usr/local/bin/perl -I../blib/arch -I../blib/lib -I/usr/local/lib/perl5/5.6. 1/OpenBSD.i386-openbsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00base/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/00basedubious Test returned status 1 (wstat 256, 0x100) t/10dsnlist./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/10dsnlist.dubious Test returned status 1 (wstat 256, 0x100) t/20createdrop../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/20createdrop..dubious Test returned status 1 (wstat 256, 0x100) t/30insertfetch./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/30insertfetch.dubious Test returned status 1 (wstat 256, 0x100) t/40bindparam.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40bindparam...dubious Test returned status 1 (wstat 256, 0x100) t/40blobs.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40blobs...dubious Test returned status 1 (wstat 256, 0x100) t/40listfields../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40listfields..dubious Test returned status 1 (wstat 256, 0x100) t/40nulls.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40nulls...dubious Test returned status 1 (wstat 256, 0x100) t/40numrows./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40numrows.dubious Test returned status 1 (wstat 256, 0x100) t/50chopblanks../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50chopblanks..dubious Test returned status 1 (wstat 256, 0x100) t/50commit../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50commit..dubious Test returned status 1 (wstat 256, 0x100) t/60leaks...skipped test on this platform t/ak-dbd/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/ak-dbddubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-90 Failed 90/90 tests, 0.00% okay t/dbdadmin../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/dbdadmin..dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-20 Failed 20/20 tests, 0.00% okay Failed Test Status Wstat Total Fail Failed List of Failed --- - t/00base.t 1 256?? ?? % ?? t/10dsnlist.t 1 256?? ?? % ?? t/20createdrop.t 1 256?? ?? % ?? t/30insertfetch.t 1 256?? ?? % ?? t/40bindparam.t1 256?? ?? % ?? t/40blobs.t1 256?? ?? % ?? t/40listfields.t 1 256?? ?? % ?? t/40nulls.t1 256?? ?? % ?? t/40numrows.t 1 256?? ?? % ?? t/50chopblanks.t 1 256?? ?? % ?? t/50commit.t 1 256?? ?? % ?? t/ak-dbd.t 1 25690 90 100.00% 1-90 t/dbdadmin.t 1 25620 20 100.00% 1-20 1 test skipped. Failed 13/14 test scripts, 7.14% okay. 110/110 subtests failed, 0.00% okay. *** Error code 2 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216/mysql (line 737 of Makefile). *** Error code 1 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216 (line 732 of Makefile). /usr/bin/make test -- NOT OK Running make install make test had returned bad status, won't install without force Running install for module DBD::mysql Running make for J/JW/JWIED/Msql-Mysql-modules-1.2216.tar.gz Is already unwrapped into directory /root/.cpan/build/Msql-Mysql-modules-1.2216 Has already been processed within this session Running make test Won't repeat unsuccessful test during this command Running make install make test had returned bad
RE: DBD::MySQL Help!!
I had the same problem too. If you go to CPAN and then go to DBD::Mysql, click on the ftp site to Jochen Wiedmann's directory and scroll past the one that says DBD-Mysql-yada to the one that says Msql-Mysql-modules-1.2216.tar.gz and install that one instead, it should work. Worked like a charm for me - on RedHat. Megan Hi, Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I know this is prolly not the best list for this question, but its the only related list im currently subscribed to... When I do the install it askes me what db to test on and i put test, localhost for host, then i put root as the test user and my root sql users pw for the password, it does some stuff then it runs the make test and this is what happens... Any help?? Running make test PERL_DL_NONLAZY=1 /usr/local/bin/perl -I../blib/arch -I../blib/lib -I/usr/local/lib/perl5/5.6. 1/OpenBSD.i386-openbsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00base/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/00basedubious Test returned status 1 (wstat 256, 0x100) t/10dsnlist./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/10dsnlist.dubious Test returned status 1 (wstat 256, 0x100) t/20createdrop../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/20createdrop..dubious Test returned status 1 (wstat 256, 0x100) t/30insertfetch./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/30insertfetch.dubious Test returned status 1 (wstat 256, 0x100) t/40bindparam.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40bindparam...dubious Test returned status 1 (wstat 256, 0x100) t/40blobs.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40blobs...dubious Test returned status 1 (wstat 256, 0x100) t/40listfields../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40listfields..dubious Test returned status 1 (wstat 256, 0x100) t/40nulls.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40nulls...dubious Test returned status 1 (wstat 256, 0x100) t/40numrows./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40numrows.dubious Test returned status 1 (wstat 256, 0x100) t/50chopblanks../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50chopblanks..dubious Test returned status 1 (wstat 256, 0x100) t/50commit../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50commit..dubious Test returned status 1 (wstat 256, 0x100) t/60leaks...skipped test on this platform t/ak-dbd/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/ak-dbddubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-90 Failed 90/90 tests, 0.00% okay t/dbdadmin../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/dbdadmin..dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-20 Failed 20/20 tests, 0.00% okay Failed Test Status Wstat Total Fail Failed List of Failed -- - - t/00base.t 1 256?? ?? % ?? t/10dsnlist.t 1 256?? ?? % ?? t/20createdrop.t 1 256?? ?? % ?? t/30insertfetch.t 1 256?? ?? % ?? t/40bindparam.t1 256?? ?? % ?? t/40blobs.t1 256?? ?? % ?? t/40listfields.t 1 256?? ?? % ?? t/40nulls.t1 256?? ?? % ?? t/40numrows.t 1 256?? ?? % ?? t/50chopblanks.t 1 256?? ?? % ?? t/50commit.t 1 256?? ?? % ?? t/ak-dbd.t 1 25690 90 100.00% 1-90 t/dbdadmin.t 1 25620 20 100.00% 1-20 1 test skipped. Failed 13/14 test scripts, 7.14% okay. 110/110 subtests failed, 0.00% okay. *** Error code 2 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216/mysql (line 737 of Makefile). *** Error code 1 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216 (line 732 of Makefile). /usr/bin/make test -- NOT OK Running make install make test had returned bad status, won't install without force Running install for module
Re: MySQL Help
Salvador Casquero Algarra wrote: Hi, I am having a terrible problem with MySQL and I am desperated as nobody seems to find the source. I have a Web site ( www.genteirc.com ) whith MySQL database access. The problem is that those Mysql processes are growing continuously until they consume all of the memory ( 2 Gigas ). I include at the end of the message two files that we have captured just before the reboot of the machine. Somebody is saying that MySQL doesn´t work with Intel multiprocessors and his solutions is to remove one of the proccesors ¿¿??. Can you please help me ?. Thanks very much in advanced. Best regards, Salvador Hi, I ran into problems (index corruptions under high loads) on a bipro Intel server and the problem disappeared when I rebooted with a uniprocessor Linux kernel (hopefully, no need to physically remove a processor). I got this problems with MySQL 3.23.30. I haven't tried latest version yet. However, your problem seems totally different, my server has also 2G RAM and has never run out of memory (a little bit more than 1G is actually used) with more than 350 threads (active connections). Since you don't give much information on your server configuration and usage, it is hard to help you. What are your operating system, kernel version, MySQL version, my.cnf file ? Are you running other apps on this machine or is it dedicated to MySQL ? BTW, I have you tried to find out why your SELECT are Locked ? Regards -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Help
Hi, I am having a terrible problem with MySQL and I am desperated as nobody seems to find the source. I have a Web site ( www.genteirc.com ) whith MySQL database access. The problem is that those Mysql processes are growing continuously until they consume all of the memory ( 2 Gigas ). I include at the end of the message two files that we have captured just before the reboot of the machine. Somebody is saying that MySQL doesn´t work with Intel multiprocessors and his solutions is to remove one of the proccesors ¿¿??. Can you please help me ?. Thanks very much in advanced. Best regards, Salvador 6:47pm up 1 day, 23:05, 2 users, load average: 2.57, 3.04, 3.06 407 processes: 402 sleeping, 5 running, 0 zombie, 0 stopped CPU states: 33.9% user, 51.4% system, 0.0% nice, 14.6% idle Mem: 2074332K av, 2062048K used, 12284K free, 259320K shrd, 42224K buff Swap: 1052248K av, 752252K used, 26K free 47108K cached PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND 9035 cvsanon 12 0 832 796 324 R 0 15.2 0.0 7:15 top 11435 root 2 0 45536 42M 1044 S 0 5.5 2.0 0:03 mysqld 11448 root 1 0 45536 42M 1044 S 0 4.1 2.0 0:01 mysqld 11488 root 1 0 45536 42M 1044 S 0 4.0 2.0 0:00 mysqld 11437 root 1 0 45536 42M 1044 S 0 3.7 2.0 0:04 mysqld 11502 root 1 0 45536 42M 1044 S 0 3.7 2.0 0:00 mysqld 11459 root 1 0 45536 42M 1044 S 0 3.5 2.0 0:02 mysqld 11442 root 1 0 45536 42M 1044 S 0 3.4 2.0 0:00 mysqld 11450 root 1 0 45536 42M 1044 R 0 3.4 2.0 0:02 mysqld 11509 root 1 0 45556 42M 1044 S 0 3.4 2.0 0:00 mysqld 11470 root 1 0 45536 42M 1044 S 0 3.2 2.0 0:01 mysqld 11244 root 1 0 45536 42M 1044 S 0 3.1 2.0 0:05 mysqld 11407 root 1 0 45536 42M 1044 S 0 3.1 2.0 0:02 mysqld 11425 root 1 0 45536 42M 1044 S 0 3.1 2.0 0:02 mysqld 11455 root 1 0 45536 42M 1044 S 0 3.1 2.0 0:01 mysqld | 221860 | genteirc | localhost | genteirc | Query | 10| Locked | SELECT COUNT(*) as nregs FROM genteirc WHERE OK='1' | | 221861 | genteirc | localhost | genteirc | Query | 9 | Locked | SELECT COUNT(*) as nregs FROM genteirc WHERE OK='1' | | 221864 | genteirc | localhost | genteirc | Query | 9 | Locked | SELECT COUNT(*) as nregs FROM genteirc WHERE OK='1' | | 221893 | genteirc | localhost | genteirc | Query | 4 | Locked | update genteirc set novedad=0 where novedad=1 AND to_days(now())-to_days(Alta) 10 | | 221911 | genteirc | localhost | genteirc | Query | 2 | Locked | SELECT COUNT(*) as nregs FROM genteirc WHERE OK='1' | | 221917 | genteirc | localhost | genteirc | Query | 0 | Locked | update genteirc set novedad=0 where novedad=1 AND to_days(now())-to_days(Alta) 10 | | 221918 | root | localhost | | Query | 0 | | show processlist | ++--+---+--+-+---+--+--- ---+ Uptime: 69622 Threads: 231 Questions: 4679585 Slow queries: 2395 Opens: 320 Flush tables: 1 Open tables: 314 Queries per second avg: 67.214 ++--+---+--+-+---+-- --+- -+ | Id | User | Host | db | Command | Time | State | Info | ++--+---+--+-+---+-- --+- -+ | 15406 | genteirc | localhost | genteirc | Sleep | 14| | | | 111020 | genteirc | localhost | genteirc | Sleep | 3 | | | | 128653 | genteirc | localhost | genteirc | Sleep | 3 | | | | 129780 | genteirc | localhost | genteirc | Sleep | 2 | | | | 130243 | genteirc | localhost | genteirc | Sleep | 862 | | | | 131061 | genteirc | localhost | genteirc | Sleep | 44| | | | 131752 | nobody | localhost | | Sleep | 22713 | | | | 131842 | genteirc | localhost | genteirc | Sleep | 86| | | | 131935 | genteirc | localhost | genteirc | Sleep | 63| | | | 132576 | genteirc | localhost | genteirc | Sleep | 204 | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DBD::MySQL Help!!
Hi, Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I know this is prolly not the best list for this question, but its the only related list im currently subscribed to... When I do the install it askes me what db to test on and i put test, localhost for host, then i put root as the test user and my root sql users pw for the password, it does some stuff then it runs the make test and this is what happens... Any help?? Running make test PERL_DL_NONLAZY=1 /usr/local/bin/perl -I../blib/arch -I../blib/lib -I/usr/local/lib/perl5/5.6. 1/OpenBSD.i386-openbsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00base/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/00basedubious Test returned status 1 (wstat 256, 0x100) t/10dsnlist./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/10dsnlist.dubious Test returned status 1 (wstat 256, 0x100) t/20createdrop../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/20createdrop..dubious Test returned status 1 (wstat 256, 0x100) t/30insertfetch./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/30insertfetch.dubious Test returned status 1 (wstat 256, 0x100) t/40bindparam.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40bindparam...dubious Test returned status 1 (wstat 256, 0x100) t/40blobs.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40blobs...dubious Test returned status 1 (wstat 256, 0x100) t/40listfields../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40listfields..dubious Test returned status 1 (wstat 256, 0x100) t/40nulls.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40nulls...dubious Test returned status 1 (wstat 256, 0x100) t/40numrows./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40numrows.dubious Test returned status 1 (wstat 256, 0x100) t/50chopblanks../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50chopblanks..dubious Test returned status 1 (wstat 256, 0x100) t/50commit../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50commit..dubious Test returned status 1 (wstat 256, 0x100) t/60leaks...skipped test on this platform t/ak-dbd/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/ak-dbddubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-90 Failed 90/90 tests, 0.00% okay t/dbdadmin../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/dbdadmin..dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-20 Failed 20/20 tests, 0.00% okay Failed Test Status Wstat Total Fail Failed List of Failed t/00base.t 1 256?? ?? % ?? t/10dsnlist.t 1 256?? ?? % ?? t/20createdrop.t 1 256?? ?? % ?? t/30insertfetch.t 1 256?? ?? % ?? t/40bindparam.t1 256?? ?? % ?? t/40blobs.t1 256?? ?? % ?? t/40listfields.t 1 256?? ?? % ?? t/40nulls.t1 256?? ?? % ?? t/40numrows.t 1 256?? ?? % ?? t/50chopblanks.t 1 256?? ?? % ?? t/50commit.t 1 256?? ?? % ?? t/ak-dbd.t 1 25690 90 100.00% 1-90 t/dbdadmin.t 1 25620 20 100.00% 1-20 1 test skipped. Failed 13/14 test scripts, 7.14% okay. 110/110 subtests failed, 0.00% okay. *** Error code 2 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216/mysql (line 737 of Makefile). *** Error code 1 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216 (line 732 of Makefile). /usr/bin/make test -- NOT OK Running make install make test had returned bad status, won't install without force Running install for module DBD::mysql Running make for J/JW/JWIED/Msql-Mysql-modules-1.2216.tar.gz Is already unwrapped into directory /root/.cpan/build/Msql-Mysql-modules-1.2216 Has already been processed within this session Running make test Won't repeat unsuccessful test during this command Running make install make test had returned bad status, won't install without force Bundle summary: The following items in bundle Bundle::DBD::mysql had installation problems: Mysql DBD::mysql Thanks, Rick
Re: DBD::MySQL Help!!
Hi Rick, It looks similar to a problem I had on FreeBSD in not finding the shared library. I added this command to a startup file (mysql_server.sh) in rc.d directory. /sbin/ldconfig -m /usr/local/lib/mysql You may need to check if -m is the right option for openbsd but I am sure you need ldconfig! I hope this helps. Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: Rick Kukiela [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 2:19 AM Subject: DBD::MySQL Help!! Hi, Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I know this is prolly not the best list for this question, but its the only related list im currently subscribed to... When I do the install it askes me what db to test on and i put test, localhost for host, then i put root as the test user and my root sql users pw for the password, it does some stuff then it runs the make test and this is what happens... Any help?? Running make test PERL_DL_NONLAZY=1 /usr/local/bin/perl -I../blib/arch -I../blib/lib -I/usr/local/lib/perl 5/5.6. 1/OpenBSD.i386-openbsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00base/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/00basedubious Test returned status 1 (wstat 256, 0x100) t/10dsnlist./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/10dsnlist.dubious Test returned status 1 (wstat 256, 0x100) t/20createdrop../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/20createdrop..dubious Test returned status 1 (wstat 256, 0x100) t/30insertfetch./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/30insertfetch.dubious Test returned status 1 (wstat 256, 0x100) t/40bindparam.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40bindparam...dubious Test returned status 1 (wstat 256, 0x100) t/40blobs.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40blobs...dubious Test returned status 1 (wstat 256, 0x100) t/40listfields../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40listfields..dubious Test returned status 1 (wstat 256, 0x100) t/40nulls.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40nulls...dubious Test returned status 1 (wstat 256, 0x100) t/40numrows./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40numrows.dubious Test returned status 1 (wstat 256, 0x100) t/50chopblanks../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50chopblanks..dubious Test returned status 1 (wstat 256, 0x100) t/50commit../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50commit..dubious Test returned status 1 (wstat 256, 0x100) t/60leaks...skipped test on this platform t/ak-dbd/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/ak-dbddubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-90 Failed 90/90 tests, 0.00% okay t/dbdadmin../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/dbdadmin..dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-20 Failed 20/20 tests, 0.00% okay Failed Test Status Wstat Total Fail Failed List of Failed t/00base.t 1 256?? ?? % ?? t/10dsnlist.t 1 256?? ?? % ?? t/20createdrop.t 1 256?? ?? % ?? t/30insertfetch.t 1 256?? ?? % ?? t/40bindparam.t1 256?? ?? % ?? t/40blobs.t1 256?? ?? % ?? t/40listfields.t 1 256?? ?? % ?? t/40nulls.t1 256?? ?? % ?? t/40numrows.t 1 256?? ?? % ?? t/50chopblanks.t 1 256?? ?? % ?? t/50commit.t 1 256?? ?? % ?? t/ak-dbd.t 1 25690 90 100.00% 1-90 t/dbdadmin.t 1 25620 20 100.00% 1-20 1 test skipped. Failed 13/14 test scripts, 7.14% okay. 110/110 subtests failed, 0.00% okay. *** Error code 2 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216/mysql (line 737 of Makefile). *** Error code 1 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216