Re: rpm install error
kernel version 2.2 how do i find out my Red Hat version? its not installed through rpm...i think... MySQL-3.23.42-1.i386.rpm MySQL-client-3.23.42-1.i386.rpm MySQL-shared-3.23.42-1.i386.rpm installing shared : no problem when installing client i get : group man does not exist - using root (13 times) installing server : mysqld restarted Number of processes running now: 2 mysqld process hanging, pid 28666 - killed mysqld process hanging, pid 28665 - killed 010919 11:27:22 mysqld restarted /usr/bin/safe_mysqld: line 273: 28693 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 restart process number keeps changing, and message keeps repeating... please help!! thanks -paulo - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 2:14 PM Subject: Re: rpm install error On Tuesday 18 September 2001 03:16, powlow wrote: latest rpm on redhat MySQL-3.23.42-1.i386.rpm any ideas? i've installed and compile mysql on other machines before and never had any problems (appart from sock file which was easily solved). Provide the output of mysqlbug... Also, what version of RedHat? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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: rpm install error
oops. its suse...damn still...any ideas? -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 11:17 AM Subject: Re: rpm install error kernel version 2.2 how do i find out my Red Hat version? its not installed through rpm...i think... MySQL-3.23.42-1.i386.rpm MySQL-client-3.23.42-1.i386.rpm MySQL-shared-3.23.42-1.i386.rpm installing shared : no problem when installing client i get : group man does not exist - using root (13 times) installing server : mysqld restarted Number of processes running now: 2 mysqld process hanging, pid 28666 - killed mysqld process hanging, pid 28665 - killed 010919 11:27:22 mysqld restarted /usr/bin/safe_mysqld: line 273: 28693 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 restart process number keeps changing, and message keeps repeating... please help!! thanks -paulo - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 2:14 PM Subject: Re: rpm install error On Tuesday 18 September 2001 03:16, powlow wrote: latest rpm on redhat MySQL-3.23.42-1.i386.rpm any ideas? i've installed and compile mysql on other machines before and never had any problems (appart from sock file which was easily solved). Provide the output of mysqlbug... Also, what version of RedHat? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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: rpm install error
its actually not an installation problem. just starting the server. if i try to run mysqld (not safe-mysqld) i get this message : linux:/var/lib/mysql # mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 010919 12:35:58 Aborting 010919 12:35:58 mysqld: Shutdown Complete i'm looking at the manual now. any comments on this. some stuff seems to be owned by mysql, some by root... -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 11:48 AM Subject: Re: rpm install error oops. its suse...damn still...any ideas? -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 11:17 AM Subject: Re: rpm install error kernel version 2.2 how do i find out my Red Hat version? its not installed through rpm...i think... MySQL-3.23.42-1.i386.rpm MySQL-client-3.23.42-1.i386.rpm MySQL-shared-3.23.42-1.i386.rpm installing shared : no problem when installing client i get : group man does not exist - using root (13 times) installing server : mysqld restarted Number of processes running now: 2 mysqld process hanging, pid 28666 - killed mysqld process hanging, pid 28665 - killed 010919 11:27:22 mysqld restarted /usr/bin/safe_mysqld: line 273: 28693 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 restart process number keeps changing, and message keeps repeating... please help!! thanks -paulo - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 2:14 PM Subject: Re: rpm install error On Tuesday 18 September 2001 03:16, powlow wrote: latest rpm on redhat MySQL-3.23.42-1.i386.rpm any ideas? i've installed and compile mysql on other machines before and never had any problems (appart from sock file which was easily solved). Provide the output of mysqlbug... Also, what version of RedHat? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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
can't find my my.cnf or data directory
i can't find my my.cnf or data directory. i am going nuts here...these may seem like stupid questions but i'm not even thinking logically any more... any help is much appreciated. tahnks -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 12:25 PM Subject: Re: rpm install error its actually not an installation problem. just starting the server. if i try to run mysqld (not safe-mysqld) i get this message : linux:/var/lib/mysql # mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 010919 12:35:58 Aborting 010919 12:35:58 mysqld: Shutdown Complete i'm looking at the manual now. any comments on this. some stuff seems to be owned by mysql, some by root... -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 11:48 AM Subject: Re: rpm install error oops. its suse...damn still...any ideas? -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 11:17 AM Subject: Re: rpm install error kernel version 2.2 how do i find out my Red Hat version? its not installed through rpm...i think... MySQL-3.23.42-1.i386.rpm MySQL-client-3.23.42-1.i386.rpm MySQL-shared-3.23.42-1.i386.rpm installing shared : no problem when installing client i get : group man does not exist - using root (13 times) installing server : mysqld restarted Number of processes running now: 2 mysqld process hanging, pid 28666 - killed mysqld process hanging, pid 28665 - killed 010919 11:27:22 mysqld restarted /usr/bin/safe_mysqld: line 273: 28693 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 restart process number keeps changing, and message keeps repeating... please help!! thanks -paulo - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 2:14 PM Subject: Re: rpm install error On Tuesday 18 September 2001 03:16, powlow wrote: latest rpm on redhat MySQL-3.23.42-1.i386.rpm any ideas? i've installed and compile mysql on other machines before and never had any problems (appart from sock file which was easily solved). Provide the output of mysqlbug... Also, what version of RedHat? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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 - 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: rpm install error
i upgraded to 2.2.16. still same problem. can't seem to find a data directory. just installing from rpm all standard. this really bugs me... thanks for your words so far -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 3:29 PM Subject: Re: rpm install error do you mean upgrade to 2.2.16? -paulo - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 2:21 PM Subject: Re: rpm install error On Wednesday 19 September 2001 04:48, powlow wrote: oops. its suse...damn still...any ideas? -powlow uname -a Does it show kernel 2.2.14? If yes, upgrade the kernel. SuSE introduced a special safety feature into their 2.2.14 kernel that makes our binary coredump right away. They got rid of it it later versions. And while I am on the subject - we are aware of an I/O bug in 2.2.14 kernel even without the special safety patch from SuSE) that make MySQL corrupt tables under heavy load. Two of our users were running 2.2.14 kernel and were getting their tables randomly corrupted. The problems went away after upgrade to 2.2.10. So if you are running 2.2.14 SuSE kernel, you have two reasons to upgrade. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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: rpm install error
okay. the problem was still the same one. i was just adding that i couldn't find a data directory. i'll try upgrading to 2.2.19 but i'm not sure if i can cause i'm running suse 6.4 - that might be a completely stupid statement - i'm not sure yet! any pointers anyone? -powlow - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 6:52 PM Subject: Re: rpm install error On Wednesday 19 September 2001 09:38, powlow wrote: i upgraded to 2.2.16. still same problem. can't seem to find a data directory. just installing from rpm all standard. this really bugs me... No, that is not the same problem. You were getting a segfault. If it cannot find datadir, start debugging the start-up script - read the error log then go from there. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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: rpm install error
latest rpm on redhat MySQL-3.23.42-1.i386.rpm any ideas? i've installed and compile mysql on other machines before and never had any problems (appart from sock file which was easily solved). -powlow - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 17, 2001 6:42 PM Subject: Re: rpm install error On Monday 17 September 2001 08:59, powlow wrote: when installing with rpm i get: Number of processes running now: 2 mysqld process hanging, pid 30887 - killed mysqld process hanging, pid 30886 - killed 010917 16:04:06 mysqld restarted /usr/bin/safe_mysqld: line 273: 30916 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 and it just keeps going and going and going... Which RPM are you using, and what distribution? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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
socket
I just upgraded to latest mysql. there was an error when starting the demon or using the client about not finding the socket file. i found it in /tmp/mysql.sock and moved it to the directory where it was looking for it. /var/lib/mysql/mysql.sock now i get : ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) can anyone help me out? -Paulo - a.k.a. powlow - 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
rpm install error
when installing with rpm i get: Number of processes running now: 2 mysqld process hanging, pid 30887 - killed mysqld process hanging, pid 30886 - killed 010917 16:04:06 mysqld restarted /usr/bin/safe_mysqld: line 273: 30916 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 and it just keeps going and going and going... any ideas? -powlow - 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
creating tables using a number
Hi, first posting to the list so hello. My name is Paulo. I live and work in lisbon, portugal. question : i want to create a table each month. want to call it somehting like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is fine. d122001 is also fine. is it not possible to create tables with only a number as the name? is there a way round this? 2 days of work wasted here!! thanks for any help -paulo - 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
