RE: 2013 Error
mysql wrote: - Having a problem with accessing the mysql database from a remote machine. I am typing in mysql -h ???.??.???.?? -u ?? -p. It asked for password .. do that then the reply message is ERROR 2013: Lost connection to MySQL server during query. Have even tryed replacing IP with a host name and get the same error. - What version of MySQL and Linux are you running? Not that this is really important, but if you can upgrade to a newer version of MySQL, that might be your quickest road to getting it working. I had this problem to and ultimately upgrade the server to the latest RedHat rpm which I think was 3.23.49-3. If you want (or can) go down this road then it's really easy. Search archives for a message from me in December 2002 where I list what I did to copy the data over to the new server without dumping. When I sent my initial message about my 2013 failure, I never got a response. Google turned up some suggestions but none that really match my problem. I found the shortest road to recovery was upgrading. HTH - 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
Sanity on restore
Moving a server (RH6.2 w/ 3.23.43) to a temporary system (RH7.3 w/ 3.23.49-3) and I have a mysql dump file created using: mysqldump -A my-move.sql Just installed the server rpm on the temp system and any attempt to connect gives error because of a password, guessing that's because I've got a blank database. The sanity check is: User auth is done by ldap so the users entered in the mysql database should be ok. Anyone having done a restore, could you please tell me the process you used. The database is very large and I don't want to find out I frigged up hours later. - 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: Sanity on restore
Patrick Nelson wrote: - Moving a server (RH6.2 w/ 3.23.43) to a temporary system (RH7.3 w/ 3.23.49-3) and I have a mysql dump file created using: mysqldump -A my-move.sql Just installed the server rpm on the temp system and any attempt to connect gives error because of a password, guessing that's because I've got a blank database. The sanity check is: User auth is done by ldap so the users entered in the mysql database should be ok. Anyone having done a restore, could you please tell me the process you used. The database is very large and I don't want to find out I frigged up hours later. - I ultimately just did a cold directory copy of /var/lib/mysql. I was then able to login using: mysql -h localhost -u root -p mysql and restarted the mysqld. Then I changed the specific system names from the old system to new within mysql client with: UPDATE user SET host='new-system-name' WHERE host='old-system-name'; FLUSH PRIVILEGES; then on the DNS I changed the CNAME of where mydb pointed to and reloaded the zone. Then tested on a few clients... everything worked great. No one even noticed the change. Easier than restoring? I'm not sure, but this was very easy. - 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
Server Connection Lost
Have been running mysql 3.23.43 on a RH 6.2 system and things have worked fine for the last year. However, we run a mysqldump daily and this failed yesterday. Looking into the problem I found that mysqld is having some problems. running: mysqldump --defaults-file=default file -A dump file results: mysqldump: Got error 2013: Lost connection to MySQL server during query when trying to connect on the server I see an error: Number of processes running now: 1 mysqld process hanging, pid pid - killed 021216 time mysqld restarted did a search for this type of error but, didn't see any that resemble it. Anyone have any ideas of how to solve this problem? - 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: SSH Replication
Melvyn Sopacua wrote: - Does MySQL have any facility for using SSH to tunnel ports for use in replication? Has anyone implemented anything like this? We can't just assume if we create an SSH tunnel manually that the connection will stay up. There was an excellent piece in August 2001's Sysadmin, that described just that - for an intrusion detection system - but the principals remain the same. Unfortunately, it's not been published online: http://sysadminmag.com/articles/2001/0108/ Distributed Intrusion Detection with Open Source Tools Jason Chan Chan presents an example of an intrusion detection system comprising open source tools such as Snort, OpenSSL, Stunnel, and MySQL. I remember that Stunnel is used to provide the tunneling and looking at that site, there's a complete example available: http://www.stunnel.org/examples/mysql.html - Although I have not done this, couldn't you could use ssh port forwarding? ssh -L local port:mysql host:hostport then use mysql -h local host -P local port - 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
cron mysqldump
I want to run a daily cron dump of my MySql system using something like mysqldump -A File.sql I have a .my.cnf file that specifies host user and password, but this is not available to the cron script when it is run. I would prefer using the config files (sa .my.cnf) than hard coding the user and password in the script. Is this because .my.cnf is not available to cron when it loads (I think as root) or some other thing I may be missing. Just typing mysqldump -A file.sql works as root user, but not in the cron.daily script mydump.cron that has that exact line in it. - 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: cron mysqldump SOLVED
Patrick Nelson wrote: - I want to run a daily cron dump of my MySql system using something like mysqldump -A File.sql I have a .my.cnf file that specifies host user and password, but this is not available to the cron script when it is run. I would prefer using the config files (sa .my.cnf) than hard coding the user and password in the script. Is this because .my.cnf is not available to cron when it loads (I think as root) or some other thing I may be missing. Just typing mysqldump -A file.sql works as root user, but not in the cron.daily script mydump.cron that has that exact line in it. - found the --default-file= command line in the --help of mysqldump which is just what I needed. - 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: What do I need for Perl
Ken Kinder wrote: - The mysql-perl had something called the Perl DBI. Go to this url: http://www.mysql.com/downloads/api-dbi.html Get the DBI and the Mysql-Perl tarballs. They are funny to install, but basicly you untar them: tar zxvf file then, in the directory created by that: perl Makefile.PL make make install You can optionally stick make test inbetween make and make install. I don't know of a decent MySQL Perl DBI in RPM format that keeps up with the latest and greatest MySQL. On Thursday 15 November 2001 03:46 pm, Patrick Nelson wrote: I'm sorry but I have tried to solved this on my own, but I'm unable to. I have a RH system and I installed the (at the time) most current stable mysql system 3.23.43-1 and have it up and running. The problem that I have is that I want to start working with Perl and MySQL, but don't know what I really need. The Powertools of RH6.2 had an rpm called mysql-perl-3.20.32a-3.i386.rpm which seems to match the mysql server, client, and shared versions that came on the powertools cd. I've tried to installed the mysql-perl-3.20.32a-3.i386.rpm but it fails wanting libmysqlclient.so.4 to be installed and I have libmysqlclient.so.10 installed with the 3.23.43 server, client, and shared rpms. I've been to rpmfind.org and have searched extensively for mysql-perl (which gives me the mysql-perl-3.20.32a-3.i386.rpm and that's about it), a search for mysql gives a bunch of files but I'm really not sure what I need having never used modules in perl before. I feel like an idiot here, but this is what I have: RH 6.2 mysql 3.23.43-1 mysql-client-3.23.43-1 mysql-shared-3.23.43-1 mysql-devel-3.23.43-1 perl 5.6.1 installed from CPAN With this system what do I need to do to utilize Perl with MySQL? - Well thanks to Ken that did it. Downloaded the two tarballs and did the perl Makefile.PL, make, make test, make install on them doing dbi first and then msql-mysql-modules. Also installed the Data-Show tarball. Then went in the README of msql-mysql-modules dir and it has a script to test things out. Changed a few values an hit me table just like I knew what I was doing... - 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
Bench come to me...
Trying to get the benchmark 3.23.43 installed but it says I need MYSQL-DBI-perl-bin which I can't seem to locate. Looked at cpan.org and there was no module named that. I found plenty of modules when I did a search on mysql, but nothing named specifically that, so I'm confused on what to get. Anyone know which module I need that includes MYSQL-DBI-perl-bin? - 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
Perl Module Help
Trying to get the benchmark 3.23.43 installed but it says I need MYSQL-DBI-perl-bin which I can't seem to locate. Looked at cpan.org and there was no module named that. I found plenty of modules when I did a search on mysql, but nothing named specifically that, so I'm confused on what to get. Anyone know which module I need that includes MYSQL-DBI-perl-bin? - 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: Anyone worked with the new 4.0 on RH6.2?
Patrick Nelson wrote: - Having problems getting the server started. First mysql_install_db reported that resolveip can't resolve my servers host name (of cowa) bla bla bla but this means I only have to use ip addresses in my grant stuff. Fine but the problem is that mysql_safe --user=mysql starts then stops... that's about it. No fanfare... not entries in the cowa.log file (except of course the start and stop lines) I ran resolveip cowa and it core dumps. I checked /var/lib/mysql and wow the mysql and test dirs are empty. Ok seeing the documentation says safe_mysqld rather than the actual mysqld_safe maybe, I just need to be direct to the correct process. Please help! - I dropped back to the 3.23.43 version by uninstalling 4.0 alpha and then installing 3.23.43 server, client, shared. After the rpm process was done... The server was up and working. Guess I'll wait for later release of 4.x! - 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
Anyone worked with the new 4.0 on RH6.2?
Having problems getting the server started. First mysql_install_db reported that resolveip can't resolve my servers host name (of cowa) bla bla bla but this means I only have to use ip addresses in my grant stuff. Fine but the problem is that mysql_safe --user=mysql starts then stops... that's about it. No fanfare... not entries in the cowa.log file (except of course the start and stop lines) I ran resolveip cowa and it core dumps. I checked /var/lib/mysql and wow the mysql and test dirs are empty. Ok seeing the documentation says safe_mysqld rather than the actual mysqld_safe maybe, I just need to be direct to the correct process. Please help! - 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