RE: installation problem of MySQL on OS Lion
Share error log file -Original Message- From: Martin Mueller martinmuel...@northwestern.edu Sent: 29-07-2015 21:05 To: mysql@lists.mysql.com mysql@lists.mysql.com Subject: installation problem of MySQL on OS Lion I installed MySQL on a Mac Pro running OS Lion. The installation was successful, but starting the mysql server generated the following error message: Martin-Muellers-Mac-Pro:~ martin$ sudo /usr/local/mysql/support-files/mysql.server start Starting MySQL ... ERROR! Manager of pid-file quit without updating file. I'll be grateful for any help Martin Mueller Professor emeritus of English and Classics Northwestern University
installation problem of MySQL on OS Lion
I installed MySQL on a Mac Pro running OS Lion. The installation was successful, but starting the mysql server generated the following error message: Martin-Muellers-Mac-Pro:~ martin$ sudo /usr/local/mysql/support-files/mysql.server start Starting MySQL ... ERROR! Manager of pid-file quit without updating file. I'll be grateful for any help Martin Mueller Professor emeritus of English and Classics Northwestern University
Help: Installation problem
I am a novice with Unix and user of MySQL on windows….. I have a problem, i.e. I want to install MySQL5.0 at my FreeBSD 6.1 box with following configurations: --prefix=/usr/local/mysql --with-mysqld-user=mysql --with-unix-socket-path=/tmp/mysql.sock --with-mysqld-ldflags=-all-static How and at What place, can I configure the Makefile under /usr/ports/databases/mysql50-server/ to have MySQL server working with above mentioned configurations? I have spent 7 days trying to solve this problem please help!!! -- Thanks! BR / vj -- Thanks! BR / vj
Re: Help: Installation problem
VeeJay wrote: I am a novice with Unix and user of MySQL on windows….. I have a problem, i.e. I want to install MySQL5.0 at my FreeBSD 6.1 box with following configurations: --prefix=/usr/local/mysql --with-mysqld-user=mysql --with-unix-socket-path=/tmp/mysql.sock --with-mysqld-ldflags=-all-static How and at What place, can I configure the Makefile under /usr/ports/databases/mysql50-server/ to have MySQL server working with above mentioned configurations? Wouldn't it be more appropriate to ask a FreeBSD list this question? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Rpm installation problem
Hello. It is a bug: http://bugs.mysql.com/bug.php?id=15223 Like temporary workaroud I use on my FC4 system MySQL-shared-compat-4.1.13-0 rpm. Logg, Connie A. wrote: I am trying to install the following rpm on a red hat linux machine.=20 MySQL-client-standard-5.0.16-0.rhel3.i386.rpm MySQL-devel-standard-5.0.16-0.rhel3.i386.rpm MySQL-server-standard-5.0.16-0.rhel3.i386.rpm MySQL-shared-standard-5.0.16-0.rhel3.i386.rpm MySQL-standard-debuginfo-5.0.16-0.rhel3.i386.rpm All work fine except one: [EMAIL PROTECTED] cal]# rpm -i = MySQL-shared-standard-5.0.16-0.rhel3.i386.rpm warning: MySQL-shared-standard-5.0.16-0.rhel3.i386.rpm: V3 DSA = signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libz.so.0 is needed by MySQL-shared-standard-5.0.16-0.rhel3 Is this libz something that should have been installed with the redhat = installation, and didn't? Also, where is the perl MYSQL bundle that matched this release of Mysql? Thanks, Connie Connie Logg, Network Analyst Stanford Linear Accelerator Center ph: 650-926-2879=20 Happiness is found along the way, not at the end of the road, and 'IF' = is the middle word in life. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Rpm installation problem
I am trying to install the following rpm on a red hat linux machine. MySQL-client-standard-5.0.16-0.rhel3.i386.rpm MySQL-devel-standard-5.0.16-0.rhel3.i386.rpm MySQL-server-standard-5.0.16-0.rhel3.i386.rpm MySQL-shared-standard-5.0.16-0.rhel3.i386.rpm MySQL-standard-debuginfo-5.0.16-0.rhel3.i386.rpm All work fine except one: [EMAIL PROTECTED] cal]# rpm -i MySQL-shared-standard-5.0.16-0.rhel3.i386.rpm warning: MySQL-shared-standard-5.0.16-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libz.so.0 is needed by MySQL-shared-standard-5.0.16-0.rhel3 Is this libz something that should have been installed with the redhat installation, and didn't? Also, where is the perl MYSQL bundle that matched this release of Mysql? Thanks, Connie Connie Logg, Network Analyst Stanford Linear Accelerator Center ph: 650-926-2879 Happiness is found along the way, not at the end of the road, and 'IF' is the middle word in life. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP installation problem
I am having a hard time compiling php 5.0.5 on solaris 10. I have already installed mysql 5.0.15 (Binary) 64-bit. ./configure --prefix=/PATH/php505 --with-apxs2=/PATH/apache/bin/apxs --with-mysql=/PATH/mysql/ --enable-dbase --with-zlib-dir=/path/php505/ --with-pear This ends with - error: mysql config failed I have attached part of the config.log file: ld: warning: file /apps/mysql//lib/libmysqlclient.a(client.o): wrong ELF class: ELFCLASS64 Undefined first referenced symbol in file mysql_error /var/tmp//cciQfQiO.o ld: fatal: Symbol referencing errors. No output written to conftest collect2: ld returned 1 exit status configure: failed program was: #line 61645 configure #include confdefs.h /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char mysql_error(); int main() { mysql_error() ; return 0; } * I am installing php 5.0.5 on a solaris 10 server 64-bit. I have already installed mysql 5.0.15 (Binary) 64-Bit. I already have Apache 2.0.54 running on this server. All the applications are installed in a non-global zone in Solaris 10. I am not sure if the problem installing php is because of 64-Bit Mysql. I would really appreciate some help. Thank You UR.
mysql-standar aix 4.3.3 powerpc binary download / INSTALLATION PROBLEM
after gunzipping and untarring i get to point in instructions to run script mysql_install_db i get the following error: # cd /convert # cd mysql # scripts/mysql_install_db exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the foll owing errors: Symbol resolution failed for my_print_defaults because: Symbol stpcpy (number 52) is not exported from dependent module /usr/lib/libc.a(shr.o). Symbol isinf (number 53) is not exported from dependent module /usr/lib/libc.a(shr.o). Examine .loader section symbols with the 'dump -Tv' command. Neither host '?' nor 'localhost' could be looked up with ./bin/resolveip Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option # in need of hand holding, first timeer on mysql. heres the mysqlbug output. Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-4.1.11-standard (MySQL Community Edition - Standard (GPL)) C compiler: VisualAge C++ Professional / C for AIX Compiler, Version 6 C++ compiler:VisualAge C++ Professional / C for AIX Compiler, Version 6 Environment: machine, os, target, libraries (multiple lines) System: AIX concord1 3 4 000C55BD4C00 Some paths: /usr/bin/make Compilation info: CC='xlc_r' CFLAGS='-ma -O2 -qstrict -qoptimize=2 -qmaxmem=819 2' CXX='xlC_r' CXXFLAGS='-ma -O2 -qstrict -qoptimize=2 -qmaxmem=8192' LDFLAGS ='' ASFLAGS='' LIBC: lrwxrwxrwx 1 bin bin 19 Sep 07 2004 /lib/libc.a - /usr/ccs/li b/libc.a lrwxrwxrwx 1 bin bin 19 Sep 07 2004 /usr/lib/libc.a - /usr/cc s/lib/libc.a Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr /local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Com munity Edition - Standard (GPL)' '--with-extra-charsets=complex' '--with-server- suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--with- named-z-libs=no' '--disable-shared' '--with-readline' '--with-embedded-server' ' --with-archive-storage-engine' '--with-innodb' 'CC=xlc_r' 'CFLAGS=-ma -O2 -qstri ct -qoptimize=2 -qmaxmem=8192' 'CXXFLAGS=-ma -O2 -qstrict -qoptimize=2 -qmaxmem= 8192' 'CXX=xlC_r' # # Yours Sincerely, Damian McMenamin Analyst Programmer Melbourne Australia Cell: (61)040-0064107 Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 4.1.8 client installation problem
Hello. We want only mysql 4.1.8 client version RPMs with 4.1.8 client programs for Linux on x86, IA64, AMD64 are aviable from: http://downloads.mysql.com/archives.php?p=mysql-4.1v=4.1.8 But MySQL Server 4.1.9 would be a better choice. sirisha gnvg [EMAIL PROTECTED] wrote: [-- text/plain, encoding 8bit, charset: iso-8859-1, 6 lines --] We want only mysql 4.1.8 client version .How to get only client installed without server being installed? Thanking you, yours sincerely, sirisha. Yahoo! India Matrimony: Find your life partneronline. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql 4.1.8 client installation problem
We want only mysql 4.1.8 client version .How to get only client installed without server being installed? Thanking you, yours sincerely, sirisha. Yahoo! India Matrimony: Find your life partneronline.
4.1.7 installation problem. libcprts.so.5
Gents, Upgrading to Mysql 4.1.7 from 4.0.18... I get the following error when trying to start: ./bin/my_print_defaults: error while loading shared libraries: libcprts.so.5: cannot open shared object file: No such file or directory OS = Mandrake 9.2 Which RPM am I missing? THANKS!! -- - Vasiliy Boulytchev Colorado Information Technologies Inc. http://www.coinfotech.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
super-smack installation problem
I'm trying to configure and install super-smack-1.2 and get a problem on configure. it's looking for mysql_real_connect and can't find it...where would this be located? I'm assuming it is in libmysqlclient.so, and I have that file in my /usr/lib/mysql folder, among other places...but it doesn't find it... the error it actually gives is this: checking for libmysqlclient... checking for mysql_real_connect in -lmysqlclient... no configure: error: Could not find libmysqlclient in ' /usr/lib /usr/lib/mysql /usr/local/lib /usr/local/lib/mysql/usr/local/mysql/lib' and when I do a find: [EMAIL PROTECTED] super-smack-1.2]# find / -name libmysqlclient* /usr/lib/mysql/libmysqlclient.a /usr/lib/mysql/libmysqlclient.la /usr/lib/mysql/libmysqlclient_r.a /usr/lib/mysql/libmysqlclient_r.la /usr/lib/libmysqlclient.so.10 /usr/lib/libmysqlclient.so /usr/lib/libmysqlclient.so.10.0.0 /usr/lib/libmysqlclient.so.12 /usr/lib/libmysqlclient.so.12.0.0 /usr/lib/libmysqlclient_r.so /usr/lib/libmysqlclient_r.so.10 /usr/lib/libmysqlclient_r.so.10.0.0 /usr/lib/libmysqlclient_r.so.12 /usr/lib/libmysqlclient_r.so.12.0.0 /usr/local/mysql/lib/mysql/libmysqlclient.so.12.0.0 /usr/local/mysql/lib/mysql/libmysqlclient.so.12 /usr/local/mysql/lib/mysql/libmysqlclient.so /usr/local/mysql/lib/mysql/libmysqlclient.la /usr/local/mysql/lib/mysql/libmysqlclient.a /mysqlsource/mysql-4.0.20/libmysql/.libs/libmysqlclient.so.12.0.0 /mysqlsource/mysql-4.0.20/libmysql/.libs/libmysqlclient.so.12 /mysqlsource/mysql-4.0.20/libmysql/.libs/libmysqlclient.so /mysqlsource/mysql-4.0.20/libmysql/.libs/libmysqlclient.a /mysqlsource/mysql-4.0.20/libmysql/.libs/libmysqlclient.lai /mysqlsource/mysql-4.0.20/libmysql/.libs/libmysqlclient.la /mysqlsource/mysql-4.0.20/libmysql/libmysqlclient.la I have installed the MySQL-compat and the MySQL-devel for 4.0.20 any ideas? thanks, -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]
RE: Installation Problem with 4.0.20
Thanks very much Michael, you were right. I spent hours worrying about this yesterday. The documentation implied that you don't have to log on at all. Cheers Dave -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: 02 August 2004 05:11 To: Prout,DA,Dave,XSJ67 PROUTDA R Cc: [EMAIL PROTECTED] Subject: Re: Installation Problem with 4.0.20 Which mysql username did you use to log in? I've not used mysql on Windows, but I expect that if you simply ran mysqlshow on a new install, you'd connect as the anonymous user. The anonymous user only has rights to the test db, so that's all you'd see. Try mysqlshow -u root or, if you've set the root password, mysqlshow -u root -p instead. Michael [EMAIL PROTECTED] wrote: I've just downloaded 4.0.20 for windows Installed on the D: drive. Set up an .ini pointing at D: drive Ran D:\mysql\bin\mysqld When I then ran mysqlshow I only had the test database, not the mysql database as the documentation said I should. I then deleted everything and installed again, and got the same result. Does this mean the installation has failed ? Dave UK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Problem with 4.0.20
When I then ran mysqlshow I only had the test database, not the mysql database as the documentation said I should. I then deleted everything and installed again, and got the same result. Does this mean the installation has failed ? When this happens on Linux, it means you're running mysqlshow as a regular user who doesn't have rights to the mysql database. I think there's a corrolary in Windows (anonymous user?) -- Whil Moving to Linux: Freedom, Choice, Security, Opportunity http://www.hentzenwerke.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation Problem with 4.0.20
I've just downloaded 4.0.20 for windows Installed on the D: drive. Set up an .ini pointing at D: drive Ran D:\mysql\bin\mysqld When I then ran mysqlshow I only had the test database, not the mysql database as the documentation said I should. I then deleted everything and installed again, and got the same result. Does this mean the installation has failed ? Dave UK
Re: Installation Problem with 4.0.20
Which mysql username did you use to log in? I've not used mysql on Windows, but I expect that if you simply ran mysqlshow on a new install, you'd connect as the anonymous user. The anonymous user only has rights to the test db, so that's all you'd see. Try mysqlshow -u root or, if you've set the root password, mysqlshow -u root -p instead. Michael [EMAIL PROTECTED] wrote: I've just downloaded 4.0.20 for windows Installed on the D: drive. Set up an .ini pointing at D: drive Ran D:\mysql\bin\mysqld When I then ran mysqlshow I only had the test database, not the mysql database as the documentation said I should. I then deleted everything and installed again, and got the same result. Does this mean the installation has failed ? Dave UK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Installation Problem
First, you'll get more help if you post to the list (Mysql General mailing list [EMAIL PROTECTED]) All the --console does is directs error messages to the console, i.e., the dos window you have open. If you leave it off the error messages go to a file. What you describe below without --console as para I'm able to start the server. is _not_ the server starting correctly. It's _not_ starting and the error message is going to file when you do it without the --console. If it had started you would not have gotten back to the prompt, it would just never come back until the server was stopped elsewhere. - Original Message - From: Chukkala Bhaskar [EMAIL PROTECTED] To: Kofirowster [EMAIL PROTECTED] Sent: Thursday, June 17, 2004 10:28 PM Subject: Re: MySQL Installation Problem Hi guys, I'm new to MySQL. I tried the following on my test pc with Win98. It gave me error if I use --console as para. Any clue? without --console as para I'm able to start the server. Regards D:\MySQL\binmysqld --console 040618 13:11:07 InnoDB: Operating system error number 32 in a file operation. InnoDB: See http://www.innodb.com/ibman.php for installation help. InnoDB: See section 13.2 at http://www.innodb.com/ibman.php InnoDB: about operating system error numbers. InnoDB: File name .\ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. D:\MySQL\binmysqld D:\MySQL\bin --- Kofirowster [EMAIL PROTECTED] wrote: I have a windows installation of myql. The links Michael gave give correct info. Here's a synopsis: To test a mysql install on windows open the mysql/bin dir in a dos window. At the prompt type mysqld --console you should get a message back that indicates the server is running, such as mysqld: ready for connections open a second dos window at the same location and at the prompt type mysql you should get a message back similar to this where the x's are replaced by the version you are running: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: x.xx.xx-debug Type 'help' for help. mysql HTH, Johnny - Original Message - From: Michael Stassen [EMAIL PROTECTED] To: Singh, Bijay [EMAIL PROTECTED] Cc: Mysql General mailing list [EMAIL PROTECTED] Sent: Thursday, June 17, 2004 11:01 AM Subject: Re: MySQL Installation Problem I'm including the list on this. In general, you will get better and faster responses if you keep threads on the list. I've never run the mysql server under Windows, but I assume the manual is accurate http://dev.mysql.com/doc/mysql/en/Windows_server_first_start.html and http://dev.mysql.com/doc/mysql/en/NT_start.html. You must configure phpmyadmin so that when it attempts to connect to mysql, it uses a username-password combination that mysql will accept. If you have a mysql user with no password, you can use that, but I wouldn't recommend allowing any unauthenticated connections to mysql. See the manual for more http://dev.mysql.com/doc/mysql/en/Default_privileges.html. Michael Singh, Bijay wrote: I am using localhost with no password. how do check whether MySQL is running or not. If not how do I start the MySQL on Windows ? -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 1:29 PM To: [EMAIL PROTECTED] Cc: Singh, Bijay; [EMAIL PROTECTED] Subject: Re: MySQL Installation Problem First, make sure mysql server is running. Second, make sure you have properly configured phpmyadmin in file config.inc.php. In particular, you have to set how phpmyadmin will connect to mysql (user and pass). Michael Daniel Clark wrote: After the phpmyadmin login I got the same error. In the phpmyadmin config files I had to set the local IP address that phpmyadmin was on. Strange. Didn't it default to localhost? Dear Michael, I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not able to get this rite. I am trying to instal MySQL with phpMyAdmin and i get the error when view from : http://localhost/phpMyAdmin/ #2003 - Can't connect to MySQL server on 'localhost' (10061) OS - WinXP Pro Apache phpMyAdmin 2.5.7 I tried reinstalling but not able to get. I checked Apache and php they work fine except mySQL. Any help will be appreciated. Feel free to email or contact me on phone # below. -- 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
MySQL Installation Problem
Dear Michael, I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not able to get this rite. I am trying to instal MySQL with phpMyAdmin and i get the error when view from : http://localhost/phpMyAdmin/ #2003 - Can't connect to MySQL server on 'localhost' (10061) OS - WinXP Pro Apache phpMyAdmin 2.5.7 I tried reinstalling but not able to get. I checked Apache and php they work fine except mySQL. Any help will be appreciated. Feel free to email or contact me on phone # below. Thanks, Bijay K. Singh (757) 664-6808 Information Technology City of Norfolk, VA. www.norfolk.gov http://www.norfolk.gov/
Re: MySQL Installation Problem
After the phpmyadmin login I got the same error. In the phpmyadmin config files I had to set the local IP address that phpmyadmin was on. Dear Michael, I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not able to get this rite. I am trying to instal MySQL with phpMyAdmin and i get the error when view from : http://localhost/phpMyAdmin/ #2003 - Can't connect to MySQL server on 'localhost' (10061) OS - WinXP Pro Apache phpMyAdmin 2.5.7 I tried reinstalling but not able to get. I checked Apache and php they work fine except mySQL. Any help will be appreciated. Feel free to email or contact me on phone # below. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Installation Problem
First, make sure mysql server is running. Second, make sure you have properly configured phpmyadmin in file config.inc.php. In particular, you have to set how phpmyadmin will connect to mysql (user and pass). Michael Daniel Clark wrote: After the phpmyadmin login I got the same error. In the phpmyadmin config files I had to set the local IP address that phpmyadmin was on. Strange. Didn't it default to localhost? Dear Michael, I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not able to get this rite. I am trying to instal MySQL with phpMyAdmin and i get the error when view from : http://localhost/phpMyAdmin/ #2003 - Can't connect to MySQL server on 'localhost' (10061) OS - WinXP Pro Apache phpMyAdmin 2.5.7 I tried reinstalling but not able to get. I checked Apache and php they work fine except mySQL. Any help will be appreciated. Feel free to email or contact me on phone # below. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Installation Problem
I'm including the list on this. In general, you will get better and faster responses if you keep threads on the list. I've never run the mysql server under Windows, but I assume the manual is accurate http://dev.mysql.com/doc/mysql/en/Windows_server_first_start.html and http://dev.mysql.com/doc/mysql/en/NT_start.html. You must configure phpmyadmin so that when it attempts to connect to mysql, it uses a username-password combination that mysql will accept. If you have a mysql user with no password, you can use that, but I wouldn't recommend allowing any unauthenticated connections to mysql. See the manual for more http://dev.mysql.com/doc/mysql/en/Default_privileges.html. Michael Singh, Bijay wrote: I am using localhost with no password. how do check whether MySQL is running or not. If not how do I start the MySQL on Windows ? -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 1:29 PM To: [EMAIL PROTECTED] Cc: Singh, Bijay; [EMAIL PROTECTED] Subject: Re: MySQL Installation Problem First, make sure mysql server is running. Second, make sure you have properly configured phpmyadmin in file config.inc.php. In particular, you have to set how phpmyadmin will connect to mysql (user and pass). Michael Daniel Clark wrote: After the phpmyadmin login I got the same error. In the phpmyadmin config files I had to set the local IP address that phpmyadmin was on. Strange. Didn't it default to localhost? Dear Michael, I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not able to get this rite. I am trying to instal MySQL with phpMyAdmin and i get the error when view from : http://localhost/phpMyAdmin/ #2003 - Can't connect to MySQL server on 'localhost' (10061) OS - WinXP Pro Apache phpMyAdmin 2.5.7 I tried reinstalling but not able to get. I checked Apache and php they work fine except mySQL. Any help will be appreciated. Feel free to email or contact me on phone # below. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Installation Problem
I have a windows installation of myql. The links Michael gave give correct info. Here's a synopsis: To test a mysql install on windows open the mysql/bin dir in a dos window. At the prompt type mysqld --console you should get a message back that indicates the server is running, such as mysqld: ready for connections open a second dos window at the same location and at the prompt type mysql you should get a message back similar to this where the x's are replaced by the version you are running: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: x.xx.xx-debug Type 'help' for help. mysql HTH, Johnny - Original Message - From: Michael Stassen [EMAIL PROTECTED] To: Singh, Bijay [EMAIL PROTECTED] Cc: Mysql General mailing list [EMAIL PROTECTED] Sent: Thursday, June 17, 2004 11:01 AM Subject: Re: MySQL Installation Problem I'm including the list on this. In general, you will get better and faster responses if you keep threads on the list. I've never run the mysql server under Windows, but I assume the manual is accurate http://dev.mysql.com/doc/mysql/en/Windows_server_first_start.html and http://dev.mysql.com/doc/mysql/en/NT_start.html. You must configure phpmyadmin so that when it attempts to connect to mysql, it uses a username-password combination that mysql will accept. If you have a mysql user with no password, you can use that, but I wouldn't recommend allowing any unauthenticated connections to mysql. See the manual for more http://dev.mysql.com/doc/mysql/en/Default_privileges.html. Michael Singh, Bijay wrote: I am using localhost with no password. how do check whether MySQL is running or not. If not how do I start the MySQL on Windows ? -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 1:29 PM To: [EMAIL PROTECTED] Cc: Singh, Bijay; [EMAIL PROTECTED] Subject: Re: MySQL Installation Problem First, make sure mysql server is running. Second, make sure you have properly configured phpmyadmin in file config.inc.php. In particular, you have to set how phpmyadmin will connect to mysql (user and pass). Michael Daniel Clark wrote: After the phpmyadmin login I got the same error. In the phpmyadmin config files I had to set the local IP address that phpmyadmin was on. Strange. Didn't it default to localhost? Dear Michael, I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not able to get this rite. I am trying to instal MySQL with phpMyAdmin and i get the error when view from : http://localhost/phpMyAdmin/ #2003 - Can't connect to MySQL server on 'localhost' (10061) OS - WinXP Pro Apache phpMyAdmin 2.5.7 I tried reinstalling but not able to get. I checked Apache and php they work fine except mySQL. Any help will be appreciated. Feel free to email or contact me on phone # below. -- 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]
MySQL Administrator Installation problem on Solaris
Hi, I am trying to install MySQL Administrator 1.0.2.b-alpha on Solaris 7 operating system, (since it seems I can manage almost nothing from a remote PC thru MySQL Administrator) When I try to do what suggested (linux section) in the MySQL Administrator FAQ on MySQL website that is === *Q:* How can I build MySQL Administrator myself? *A:* The following BitKeeper modules can be downloaded from http://mysql.bkbits.net/, using the BitKeeper http://www.bitmover.com/ version management system: * mysql-gui-common * mysql-adminstrator Alternatively, download the source code package from our download page http://www.mysql.com/downloads/administrator.html. For each directory, execute the following commands: sh autogen.sh ./configure make make install If everything went well, you should have the |mysql-administrator| binary built and installed in |/usr/local/bin|. == When I try to issue the command: sh autogen.sh I get: --- centauri# sh autogen.sh **Warning**: I am going to run `configure' with no arguments. If you wish to pass any to it, please specify them on the `autogen.sh' command line. find: bad option -path find: path-list predicate-list Running ./configure --enable-maintainer-mode ... autogen.sh: ./configure: not found --- Whats the problem? (Solaris?) thanks in advance, Claudio Nanni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation problem!!!
No change. Any other suggestion? Thanks. Kirti -Original Message- From: Victor Medina [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 7:26 AM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]' Subject: Re: Installation problem!!! Hi! try using the one installed in /usr/local/mysql/bin/mysql_install_db Best Regards! On Wed, 2004-02-25 at 18:45, Kirti S. Bajwa wrote: Hello List: I have installed MySQL Master Server from Binaries 4-5 times without problem. Now I am installing MySQL CLIENT from source and have run into problem, as explained below: Download mysql-5.0.0-alpha.tar.gz in /usr/local % cd /usr/local % gunzip mysql-5.0.0-alpha.tar.gz | tar -xvf - % cd mysql-5.0.0-alpha % ./configure --without-server --prefix=/usr/local/mysql % make % make install % scripts/mysql_install_db When I run the last line scripts/mysql_install_db, I get an error message No such file or directory. I have looked into scripts folder and ther is mysql_install_db.sh. Has anybody else experienced the same problem? What is causing this error? Thanks in advance. Kirti -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation problem!!!
Hi! try using the one installed in /usr/local/mysql/bin/mysql_install_db Best Regards! On Wed, 2004-02-25 at 18:45, Kirti S. Bajwa wrote: Hello List: I have installed MySQL Master Server from Binaries 4-5 times without problem. Now I am installing MySQL CLIENT from source and have run into problem, as explained below: Download mysql-5.0.0-alpha.tar.gz in /usr/local % cd /usr/local % gunzip mysql-5.0.0-alpha.tar.gz | tar -xvf - % cd mysql-5.0.0-alpha % ./configure --without-server --prefix=/usr/local/mysql % make % make install % scripts/mysql_install_db When I run the last line scripts/mysql_install_db, I get an error message No such file or directory. I have looked into scripts folder and ther is mysql_install_db.sh. Has anybody else experienced the same problem? What is causing this error? Thanks in advance. Kirti -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...|
Installation problem!!!
Hello List: I have installed MySQL Master Server from Binaries 4-5 times without problem. Now I am installing MySQL CLIENT from source and have run into problem, as explained below: Download mysql-5.0.0-alpha.tar.gz in /usr/local % cd /usr/local % gunzip mysql-5.0.0-alpha.tar.gz | tar -xvf - % cd mysql-5.0.0-alpha % ./configure --without-server --prefix=/usr/local/mysql % make % make install % scripts/mysql_install_db When I run the last line scripts/mysql_install_db, I get an error message No such file or directory. I have looked into scripts folder and ther is mysql_install_db.sh. Has anybody else experienced the same problem? What is causing this error? Thanks in advance. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation Problem - PLEASE HELP
Hi all. I am trying to install mySql on Solaris 2.6. I am getting the following error during 'make': ld: fatal: library -lz: not found ld: fatal: File processing errors. No output written to .libs/libmysqlclient.so.10.0.0 make[2]: *** [libmysqlclient.la] Error 1 make[2]: Leaving directory `/virtual/mysql-3.23.58/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/virtual/mysql-3.23.58' make: *** [all] Error 2 This has happened with this and more recent versions of mySql at the same point. What do I need to do to fix this problem? Thanks
Re: Installation Problem - PLEASE HELP
Hi all. I am trying to install mySql on Solaris 2.6. I am getting the following error during 'make': ld: fatal: library -lz: not found ld: fatal: File processing errors. No output written to .libs/libmysqlclient.so.10.0.0 make[2]: *** [libmysqlclient.la] Error 1 make[2]: Leaving directory `/virtual/mysql-3.23.58/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/virtual/mysql-3.23.58' make: *** [all] Error 2 (from http://curl.haxx.se/mail/archive-2003-11/0018.html) It means that it didn't find the zlib library at link time. The configure script found it and enabled the use of it, but when it came to linking it somehow doesn't find it. You can fix this by setting up your LD_LIBRARY_PATH (or similar) to include the path of your zlib. -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Problem - PLEASE HELP
Alex Greg wrote: Hi all. I am trying to install mySql on Solaris 2.6. I am getting the following error during 'make': ld: fatal: library -lz: not found ld: fatal: File processing errors. No output written to .libs/libmysqlclient.so.10.0.0 make[2]: *** [libmysqlclient.la] Error 1 make[2]: Leaving directory `/virtual/mysql-3.23.58/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/virtual/mysql-3.23.58' make: *** [all] Error 2 (from http://curl.haxx.se/mail/archive-2003-11/0018.html) It means that it didn't find the zlib library at link time. The configure script found it and enabled the use of it, but when it came to linking it somehow doesn't find it. You can fix this by setting up your LD_LIBRARY_PATH (or similar) to include the path of your zlib. -- Alex Presumably, you are using gcc to compile and Solaris ld to link. That's fine, but the problem is that Solaris ld doesn't looks in /usr/local/lib (I'm assuming that's where you put zlib) by default. You can set LD_LIBRARY_PATH, but that really isn't the Solaris way. It works, sometimes, but not quite in the same way as other systems (e.g. Linux). In any case, it isn't needed if you pass the proper flags. It's been a while since I built anything under Solaris 2.6, but my memory is that you need to set the -L and -R flags. So, assuming your zlib is in /usr/local/lib, you need to set LDFLAGS=-L/usr/local/lib -R/usr/local/lib before you run configure. -L sets the link time library path and -R sets the run time library path. This way, both ld and the program you build will look in /usr/local/lib in addition to /usr/lib, without the need to set LD_LIBRARY_PATH. See `man ld` for details. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation Problem - PLEASE HELP
Thanks all.. that worked perfectly! -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 12:17 PM To: Morgan, Andrew R. Cc: [EMAIL PROTECTED] Subject: Re: Installation Problem - PLEASE HELP Alex Greg wrote: Hi all. I am trying to install mySql on Solaris 2.6. I am getting the following error during 'make': ld: fatal: library -lz: not found ld: fatal: File processing errors. No output written to .libs/libmysqlclient.so.10.0.0 make[2]: *** [libmysqlclient.la] Error 1 make[2]: Leaving directory `/virtual/mysql-3.23.58/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/virtual/mysql-3.23.58' make: *** [all] Error 2 (from http://curl.haxx.se/mail/archive-2003-11/0018.html) It means that it didn't find the zlib library at link time. The configure script found it and enabled the use of it, but when it came to linking it somehow doesn't find it. You can fix this by setting up your LD_LIBRARY_PATH (or similar) to include the path of your zlib. -- Alex Presumably, you are using gcc to compile and Solaris ld to link. That's fine, but the problem is that Solaris ld doesn't looks in /usr/local/lib (I'm assuming that's where you put zlib) by default. You can set LD_LIBRARY_PATH, but that really isn't the Solaris way. It works, sometimes, but not quite in the same way as other systems (e.g. Linux). In any case, it isn't needed if you pass the proper flags. It's been a while since I built anything under Solaris 2.6, but my memory is that you need to set the -L and -R flags. So, assuming your zlib is in /usr/local/lib, you need to set LDFLAGS=-L/usr/local/lib -R/usr/local/lib before you run configure. -L sets the link time library path and -R sets the run time library path. This way, both ld and the program you build will look in /usr/local/lib in addition to /usr/lib, without the need to set LD_LIBRARY_PATH. See `man ld` for details. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0 Installation Problem -- trying again
OK I was wrong: those files are mentioned in the doc, but I strictly followed the manual and I still got those errors. The first problem is host.frm cannot be found while starting mysqld (when starting InnoDB) (in the mysqld.log file), and the server start aborted. The manual says script/mysql_install_db will set the initial grant tables for me and I don't need to worrry about that before the server starts. But I still get that error. I am logged in as root. I installed Mysql on NT a long time ago and that was easy. Any help? Thanks. -Original Message- From: Zhao, Charles Sent: Wednesday, January 07, 2004 5:14 PM To: '[EMAIL PROTECTED]' Subject: RE: MySQL 4.0 Installation Problem Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... Well, since I failed to use RPM to install MySQL 4.0 over 3.23 -- I am not sure if I have to unstall the latter before I install the former, the manual does not mention that, I went ahead to do a fresh binary installation of it on my Linux 7, under usr/local/ directory. Followed the manual step by step until I started the server: /bin/mysqld_safe (also tried it with parameter user=mysql), but I got mysql ended ... [1]+ Done./bin/mysqld_safe msg, and I could not run any further commands, failing with msgs like Can't connect to local MySQL server though socket '/tmp/mysql.sock', Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! then I found in the sql log file: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... when starting the InnoDB tables. Both files mysql.sock and host.frm are not mentioned in the manual, and not found in my file system. Any one can point out the problem? Thanks. -Original Message- From: Zhao, Charles Sent: Tuesday, January 06, 2004 4:53 PM To: '[EMAIL PROTECTED]' Subject: MySQL 4.0 Installation Problem I have 3.23 that comes with my Linux distribution, now when I tried to do a rpm installation of 4.0, I got messages like: warning: MySQL-server-4.0.17 ... .rpm: V3 DSA signature: NOKEY, key ID ..., file /usr/bin/mysql from install of MySQL-client-4.0.17.0 conflicts with file from package mysql-3.23.52-3 ... file /usr/shar/man/man1/ ... from install of ... conflicts with file from package mysql-3.23... ... and the conflict list goes on. The installation manual does not seem to discuss about such issues. Do I need to remove my 3.23 before I run the installation? -- but that's not what the manual says, though. The first warning msg, is that a problem, too? Thanks.
RE: MySQL 4.0 Installation Problem -- trying again
Thanks ... but yeas, I have done both and still got that ... that's why I was asking the questions. I have 3.23 that came with my Linux distribution and it's not uninstalled -- but I don't think that should be the cause, though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 10:36 AM To: [EMAIL PROTECTED] Subject: RE: MySQL 4.0 Installation Problem -- trying again Charles, First, you need to run the mysql_install_db script. That will create the initial mysql database tables which is where security is tracked. Next, you will need to use the chown command to change the ownership of your mysql data directory (and I would include the logging directory, too) to be owned by mysql both as user and group. Once these two steps are finished, it should run for you. Dave David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 12:22 PM To: [EMAIL PROTECTED] Subject: MySQL 4.0 Installation Problem -- trying again OK I was wrong: those files are mentioned in the doc, but I strictly followed the manual and I still got those errors. The first problem is host.frm cannot be found while starting mysqld (when starting InnoDB) (in the mysqld.log file), and the server start aborted. The manual says script/mysql_install_db will set the initial grant tables for me and I don't need to worrry about that before the server starts. But I still get that error. I am logged in as root. I installed Mysql on NT a long time ago and that was easy. Any help? Thanks. -Original Message- From: Zhao, Charles Sent: Wednesday, January 07, 2004 5:14 PM To: '[EMAIL PROTECTED]' Subject: RE: MySQL 4.0 Installation Problem Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... Well, since I failed to use RPM to install MySQL 4.0 over 3.23 -- I am not sure if I have to unstall the latter before I install the former, the manual does not mention that, I went ahead to do a fresh binary installation of it on my Linux 7, under usr/local/ directory. Followed the manual step by step until I started the server: /bin/mysqld_safe (also tried it with parameter user=mysql), but I got mysql ended ... [1]+ Done ./bin/mysqld_safe msg, and I could not run any further commands, failing with msgs like Can't connect to local MySQL server though socket '/tmp/mysql.sock', Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! then I found in the sql log file: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... when starting the InnoDB tables. Both files mysql.sock and host.frm are not mentioned in the manual, and not found in my file system. Any one can point out the problem? Thanks. -Original Message- From: Zhao, Charles Sent: Tuesday, January 06, 2004 4:53 PM To: '[EMAIL PROTECTED]' Subject: MySQL 4.0 Installation Problem I have 3.23 that comes with my Linux distribution, now when I tried to do a rpm installation of 4.0, I got messages like: warning: MySQL-server-4.0.17 ... .rpm: V3 DSA signature: NOKEY, key ID ..., file /usr/bin/mysql from install of MySQL-client-4.0.17.0 conflicts with file from package mysql-3.23.52-3 ... file /usr/shar/man/man1/ ... from install of ... conflicts with file from package mysql-3.23... ... and the conflict list goes on. The installation manual does not seem to discuss about such issues. Do I need to remove my 3.23 before I run the installation? -- but that's not what the manual says, though. The first warning msg, is that a problem, too? Thanks.
RE: MySQL 4.0 Installation Problem -- trying again
What does the hostname.err file tell you? -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 12:39 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MySQL 4.0 Installation Problem -- trying again Thanks ... but yeas, I have done both and still got that ... that's why I was asking the questions. I have 3.23 that came with my Linux distribution and it's not uninstalled -- but I don't think that should be the cause, though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 10:36 AM To: [EMAIL PROTECTED] Subject: RE: MySQL 4.0 Installation Problem -- trying again Charles, First, you need to run the mysql_install_db script. That will create the initial mysql database tables which is where security is tracked. Next, you will need to use the chown command to change the ownership of your mysql data directory (and I would include the logging directory, too) to be owned by mysql both as user and group. Once these two steps are finished, it should run for you. Dave David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Thursday, January 08, 2004 12:22 PM To: [EMAIL PROTECTED] Subject: MySQL 4.0 Installation Problem -- trying again OK I was wrong: those files are mentioned in the doc, but I strictly followed the manual and I still got those errors. The first problem is host.frm cannot be found while starting mysqld (when starting InnoDB) (in the mysqld.log file), and the server start aborted. The manual says script/mysql_install_db will set the initial grant tables for me and I don't need to worrry about that before the server starts. But I still get that error. I am logged in as root. I installed Mysql on NT a long time ago and that was easy. Any help? Thanks. -Original Message- From: Zhao, Charles Sent: Wednesday, January 07, 2004 5:14 PM To: '[EMAIL PROTECTED]' Subject: RE: MySQL 4.0 Installation Problem Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... Well, since I failed to use RPM to install MySQL 4.0 over 3.23 -- I am not sure if I have to unstall the latter before I install the former, the manual does not mention that, I went ahead to do a fresh binary installation of it on my Linux 7, under usr/local/ directory. Followed the manual step by step until I started the server: /bin/mysqld_safe (also tried it with parameter user=mysql), but I got mysql ended ... [1]+ Done./bin/mysqld_safe msg, and I could not run any further commands, failing with msgs like Can't connect to local MySQL server though socket '/tmp/mysql.sock', Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! then I found in the sql log file: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... when starting the InnoDB tables. Both files mysql.sock and host.frm are not mentioned in the manual, and not found in my file system. Any one can point out the problem? Thanks. -Original Message- From: Zhao, Charles Sent: Tuesday, January 06, 2004 4:53 PM To: '[EMAIL PROTECTED]' Subject: MySQL 4.0 Installation Problem I have 3.23 that comes with my Linux distribution, now when I tried to do a rpm installation of 4.0, I got messages like: warning: MySQL-server-4.0.17 ... .rpm: V3 DSA signature: NOKEY, key ID ..., file /usr/bin/mysql from install of MySQL-client-4.0.17.0 conflicts with file from package mysql-3.23.52-3 ... file /usr/shar/man/man1/ ... from install of ... conflicts with file from package mysql-3.23... ... and the conflict list goes on. The installation manual does not seem to discuss about such issues. Do I need to remove my 3.23 before I run the installation? -- but that's not what the manual says, though. The first warning msg, is that a problem, too? Thanks.
Re: MySQL 4.0 Installation Problem -- trying again
In one message you say you've run mysql_install_db, in another you say you're logged in as root. In your second message, you say you got the error Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... You can use perror to translate the error number (13) to text. # perror 13 Error code 13: Permission denied I expect you ran mysql_install_db as root, so root owns the data directory and files. Hence, the mysql user cannot read them. I know you say that you've used chown to reset the ownership, but I think the most likely explanation is that you've missed something. As root, cd to the mysql data directory and run chown -R mysql:mysql . Then try mysqld_safe again. Michael Zhao, Charles wrote: Thanks ... but yeas, I have done both and still got that ... that's why I was asking the questions. I have 3.23 that came with my Linux distribution and it's not uninstalled -- but I don't think that should be the cause, though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 10:36 AM To: [EMAIL PROTECTED] Subject: RE: MySQL 4.0 Installation Problem -- trying again Charles, First, you need to run the mysql_install_db script. That will create the initial mysql database tables which is where security is tracked. Next, you will need to use the chown command to change the ownership of your mysql data directory (and I would include the logging directory, too) to be owned by mysql both as user and group. Once these two steps are finished, it should run for you. Dave David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 12:22 PM To: [EMAIL PROTECTED] Subject: MySQL 4.0 Installation Problem -- trying again OK I was wrong: those files are mentioned in the doc, but I strictly followed the manual and I still got those errors. The first problem is host.frm cannot be found while starting mysqld (when starting InnoDB) (in the mysqld.log file), and the server start aborted. The manual says script/mysql_install_db will set the initial grant tables for me and I don't need to worrry about that before the server starts. But I still get that error. I am logged in as root. I installed Mysql on NT a long time ago and that was easy. Any help? Thanks. -Original Message- From: Zhao, Charles Sent: Wednesday, January 07, 2004 5:14 PM To: '[EMAIL PROTECTED]' Subject: RE: MySQL 4.0 Installation Problem Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... Well, since I failed to use RPM to install MySQL 4.0 over 3.23 -- I am not sure if I have to unstall the latter before I install the former, the manual does not mention that, I went ahead to do a fresh binary installation of it on my Linux 7, under usr/local/ directory. Followed the manual step by step until I started the server: /bin/mysqld_safe (also tried it with parameter user=mysql), but I got mysql ended ... [1]+ Done ./bin/mysqld_safe msg, and I could not run any further commands, failing with msgs like Can't connect to local MySQL server though socket '/tmp/mysql.sock', Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! then I found in the sql log file: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... when starting the InnoDB tables. Both files mysql.sock and host.frm are not mentioned in the manual, and not found in my file system. Any one can point out the problem? Thanks. -Original Message- From: Zhao, Charles Sent: Tuesday, January 06, 2004 4:53 PM To: '[EMAIL PROTECTED]' Subject: MySQL 4.0 Installation Problem I have 3.23 that comes with my Linux distribution, now when I tried to do a rpm installation of 4.0, I got messages like: warning: MySQL-server-4.0.17 ... .rpm: V3 DSA signature: NOKEY, key ID ..., file /usr/bin/mysql from install of MySQL-client-4.0.17.0 conflicts with file from package mysql-3.23.52-3 ... file /usr/shar/man/man1/ ... from install of ... conflicts with file from package mysql-3.23... ... and the conflict list goes on. The installation manual does not seem to discuss about such issues. Do I need to remove my 3.23 before I
RE: MySQL 4.0 Installation Problem
Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... Well, since I failed to use RPM to install MySQL 4.0 over 3.23 -- I am not sure if I have to unstall the latter before I install the former, the manual does not mention that, I went ahead to do a fresh binary installation of it on my Linux 7, under usr/local/ directory. Followed the manual step by step until I started the server: /bin/mysqld_safe (also tried it with parameter user=mysql), but I got mysql ended ... [1]+ Done./bin/mysqld_safe msg, and I could not run any further commands, failing with msgs like Can't connect to local MySQL server though socket '/tmp/mysql.sock', Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! then I found in the sql log file: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... when starting the InnoDB tables. Both files mysql.sock and host.frm are not mentioned in the manual, and not found in my file system. Any one can point out the problem? Thanks. -Original Message- From: Zhao, Charles Sent: Tuesday, January 06, 2004 4:53 PM To: '[EMAIL PROTECTED]' Subject: MySQL 4.0 Installation Problem I have 3.23 that comes with my Linux distribution, now when I tried to do a rpm installation of 4.0, I got messages like: warning: MySQL-server-4.0.17 ... .rpm: V3 DSA signature: NOKEY, key ID ..., file /usr/bin/mysql from install of MySQL-client-4.0.17.0 conflicts with file from package mysql-3.23.52-3 ... file /usr/shar/man/man1/ ... from install of ... conflicts with file from package mysql-3.23... ... and the conflict list goes on. The installation manual does not seem to discuss about such issues. Do I need to remove my 3.23 before I run the installation? -- but that's not what the manual says, though. The first warning msg, is that a problem, too? Thanks.
MySQL 4.0 Installation Problem
I have 3.23 that comes with my Linux distribution, now when I tried to do a rpm installation of 4.0, I got messages like: warning: MySQL-server-4.0.17 ... .rpm: V3 DSA signature: NOKEY, key ID ..., file /usr/bin/mysql from install of MySQL-client-4.0.17.0 conflicts with file from package mysql-3.23.52-3 ... file /usr/shar/man/man1/ ... from install of ... conflicts with file from package mysql-3.23... ... and the conflict list goes on. The installation manual does not seem to discuss about such issues. Do I need to remove my 3.23 before I run the installation? -- but that's not what the manual says, though. The first warning msg, is that a problem, too? Thanks.
MySQL installation problem
Hello, I have made a fresh installation of SuSE Linux 9.0. Now I try to install MySQL, but I cannot start mysqld, it always terminates. These are the two installation commands I used after installing with YaST: LPC:~ # mysql_install_db - all tables have been created in /var/lib/mysql/mysql/ including host.frm LPC:~ # mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 031206 15:05:20 mysqld ended The msqld.log file shows: 031206 15:05:20 mysqld started 031206 15:05:20 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031206 15:05:20 Aborting 031206 15:05:20 /usr/sbin/mysqld: Shutdown Complete What is wrong? What can I do now? Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation problem
On Sat, Dec 06, 2003 at 03:52:05PM +0100, Franz Edler wrote: The msqld.log file shows: 031206 15:05:20 mysqld started 031206 15:05:20 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031206 15:05:20 Aborting 031206 15:05:20 /usr/sbin/mysqld: Shutdown Complete What is wrong? Errno 13 is Permission Denied. Is the mysql daemon running with sufficient privileges to read the directory and files within it? All the database files should be owned by the mysql user, and are generally in the mysql group, mode 660. Check that's the case. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MAC OS X installation problem
On Dec 05, 2003, at 17:00, Lost Idols wrote: A newbie here, with a simple question (I guess). I just installed MySQL on my OS X 10.2 But failed pretty quick. Please help me... I wanna get started. This it what it looks like after following the description in the ReadMe file. Last login: Fri Dec 5 22:41:28 on ttyp1 Welcome to Darwin! [COVERMAN:~] staffan% sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server [COVERMAN:~] staffan% /usr/local/mysql/bin/mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [COVERMAN:~] staffan% It sounds like you have to install the permissions tables. Run this command: /usr/local/mysql/bin/mysql_install_db And then do as it says. After that, you should be able to start MySQL with the StartupItems script. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL installation problem
From: Chris Elsworth Sent: Saturday, December 06, 2003 5:09 PM The msqld.log file shows: 031206 15:05:20 mysqld started 031206 15:05:20 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031206 15:05:20 Aborting 031206 15:05:20 /usr/sbin/mysqld: Shutdown Complete Errno 13 is Permission Denied. Is the mysql daemon running with sufficient privileges to read the directory and files within it? All the database files should be owned by the mysql user, and are generally in the mysql group, mode 660. Check that's the case. All mysql-database files in /var/lib/mysql/mysql/ are owned by user=root and group=root, mode =660. There is no mysql group. I installed as user root (using YaST) and created the database-files with mysql_install_db also as user root. Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation problem
On Sat, Dec 06, 2003 at 08:20:57PM +0100, Franz Edler wrote: Errno 13 is Permission Denied. Is the mysql daemon running with sufficient privileges to read the directory and files within it? All the database files should be owned by the mysql user, and are generally in the mysql group, mode 660. Check that's the case. All mysql-database files in /var/lib/mysql/mysql/ are owned by user=root and group=root, mode =660. There is no mysql group. I installed as user root (using YaST) and created the database-files with mysql_install_db also as user root. During normal operation, mysql should run as the user mysql, so it can't read those. You'll want to chown them. Not having a mysql group isn't critical, but if you haven't got a mysql user then I dare say you need to check the installation process, because it probably hasn't worked correctly. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Problem
Hi. Thanks for the prompt reply. It seems strange that the installation procedure should include an instruction that requires a password with no indication that one is required (i.e. there is no -p in the command sequence). Reading through Mark Liyanage's installation instructions, I notice that the second command ( /usr/local/mysql/bin/mysqladmin -u root -h localhost password mysql) is not included. Your recommended instruction to set the password from inside MySQL (GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword') worked fine. My (perceived) problem with the PowerBook is that when at work the PowerBook is connected to a server via an Ethernet connection - the server then gives the PowerBook a hostname which is different from that when I have the PowerBook at home (and not networked): in both locations `hostname` gives different results. Could I set-up a root user (or any other user) with the '@%' hostname ? I would hope to read through the Reference Manual, but at 800 - 1000 pages, I thought I might wait for the video :) Many thanks, Cheers, Alex Brown MRC-T. On Wednesday, December 3, 2003, at 09:39 PM, Michael Stassen wrote: Alex Brown wrote: Hi. I installed MySQL on a Mac (OS 10.1) a while ago with the good intension of learning to use, and using, MySQL, but other things got in the way. However, I have finally found some time (so far) and I am now trying to install the latest version of MySQL (4.0.16) onto OSX 10.2 (on an iMAC G4), and I must admit to having run into a problem ( I have a vague recollection of having problems before). I have a similar setup: 4.0.16 on 10.2.8 on an iMac G3. I downloaded the installation file mysql-standard-4.0.16.dmg from the MySQl web site as recommended by Mark Liyanage, and followed the installation instructions given in the README. All was fine until I reached the point where the root password is set - the following is what happened [blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root password mysql This set the password for [EMAIL PROTECTED] to mysql. (I hope that's not the real password.) [blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password mysql /usr/local/mysql/bin/mysqladmin: connect to server at 'blah.local.' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' The error says that you are connecting as [EMAIL PROTECTED], but you didn't supply the password, which is needed because you just set it in the first step. [blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h localhost password mysql /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' Same here. The last command I got from the searchable Reference Manual, from a posting made by briantrino. Could someone please explain. I must admit that the program is running, and I have four users, two of whom are 'root', one on 'localhost' with a password and the other on 'blah.local.' with no password. The other two users have no user-name or password. Can I set the password for the other 'root' (on 'blah.local.') fromiside MySQL ? What are the other two unnamed users ? Yes, you can do this within mysql. Use mysql -u root -p mysql to log into mysql as [EMAIL PROTECTED] You'll be prompted for the password. Use the one you set in step 1. Then enter GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword' Replace newpassword with the password you want for [EMAIL PROTECTED] The two users with empty username and password fields are the anonymous user, one for localhost, one for external access. If you do not need them, you can safely delete them. (I'd definitely get rid of the external anonymous user.) For more detailed info, see MySQL User Account Management http://www.mysql.com/doc/en/User_Account_Management.html in the manual. I am hoping to install MySL onto a PowerBook G4. The above problem may more obvious here as the 'host' can appear to change depending on whether the PowerBook is on the internet or not. Note that you don't actually need a [EMAIL PROTECTED] account if you connect from localhost. You only need a [EMAIL PROTECTED] account if you want that user to be able to connect from the named external host. I hope this all make some sense, and that someone can help. Many thanks in advance, You're welcome. Alex Brown MRC-T. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Problem
Alex Brown wrote: Hi. Thanks for the prompt reply. It seems strange that the installation procedure should include an instruction that requires a password with no indication that one is required (i.e. there is no -p in the command sequence). Reading through Mark Liyanage's installation instructions, I notice that the second command ( /usr/local/mysql/bin/mysqladmin -u root -h localhost password mysql) is not included. I assume you are talking about the directions given at the end of the run of mysql_install_db. That script uses /bin/hostname to look up your mmachine's hostname. When setting up the user table, it creates an entry for [EMAIL PROTECTED] with no password and an entry for [EMAIL PROTECTED] with no password. At the end, it gives the instructions PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: $bindir/mysqladmin -u root password 'new-password' $bindir/mysqladmin -u root -h your_hostname password 'new-password' See the manual for more instructions. where $bindir is the path to the mysql executables (/usr/local/mysql/bin, in our case). In theory, when you run the second command given, you will be connecting as [EMAIL PROTECTED] rather than [EMAIL PROTECTED], so no password will be needed because you haven't set it yet. (So far you've only set the password for [EMAIL PROTECTED], in the first command). I gather from your description that the second command was given to you as mysqladmin -u root -h localhost password 'new-password' This is redundant (it's equivalent to the first command) and won't work without the password you set in the first step. I have a suspicion that your /bin/hostname command is returning localhost instead of blah.local, or at least did so back when you ran mysql_install_db. The other possible complication here is that mysql_install_db won't mess with your user table if you already have one. This is a very good thing, but it sometimes bites people who, like you, installed mysql once before but didn't get very far, as the instructions assume the user table looks the way mysql_install_db creates it. Your recommended instruction to set the password from inside MySQL (GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword') worked fine. My (perceived) problem with the PowerBook is that when at work the PowerBook is connected to a server via an Ethernet connection - the server then gives the PowerBook a hostname which is different from that when I have the PowerBook at home (and not networked): in both locations `hostname` gives different results. Could I set-up a root user (or any other user) with the '@%' hostname ? You shouldn't need a [EMAIL PROTECTED] account in mysql to connect to the mysql server on the same machine. Simply leave out the -h hostname when you connect, like this: mysql -u username -p This will prompt you for the password to connect as [EMAIL PROTECTED] You usually use the [EMAIL PROTECTED] account(s) to allow connections from other hosts. That said, you can set up mysql to work with your changing hostname if you want/need to. You can, as you suggest, use the wildcard '%' for the hostname, but that allows that user access from EVERYWHERE, leaving only the password as protection. A better idea would be to create [EMAIL PROTECTED] accounts with the hostname specified or constrained, so as to limit access to the named machines. Some possibilities: * If your PowerBook has 2 separate hostnames (1 at home, 1 at work), or you want to allow access from 2 specific external hosts, say host1 and host2, you can create a [EMAIL PROTECTED] account and a [EMAIL PROTECTED] account. * If your hostname varies somewhat (using DHCP, for example), or you want to give a user access from any machine in your domain, say 1.2.3.x, where x varies, you can create a [EMAIL PROTECTED] account. See section 4.4 in the manual for more details. http://www.mysql.com/doc/en/User_Account_Management.html I would hope to read through the Reference Manual, but at 800 - 1000 pages, I thought I might wait for the video :) It is huge, but I find reading the section relevant to my current task is usually quicker than figuring out what I did wrong. YMMV. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MAC OS X installation problem
A newbie here, with a simple question (I guess). I just installed MySQL on my OS X 10.2 But failed pretty quick. Please help me... I wanna get started. This it what it looks like after following the description in the ReadMe file. Last login: Fri Dec 5 22:41:28 on ttyp1 Welcome to Darwin! [COVERMAN:~] staffan% sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server [COVERMAN:~] staffan% /usr/local/mysql/bin/mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [COVERMAN:~] staffan% I'm on a Mac with different users able to login and also a swedish os (if that could be a problem?). Staffan _ Hitta rätt köpare på MSN Köp Sälj http://www.msn.se/koposalj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation Problem
Hi. I installed MySQL on a Mac (OS 10.1) a while ago with the good intension of learning to use, and using, MySQL, but other things got in the way. However, I have finally found some time (so far) and I am now trying to install the latest version of MySQL (4.0.16) onto OSX 10.2 (on an iMAC G4), and I must admit to having run into a problem ( I have a vague recollection of having problems before). I downloaded the installation file mysql-standard-4.0.16.dmg from the MySQl web site as recommended by Mark Liyanage, and followed the installation instructions given in the README. All was fine until I reached the point where the root password is set - the following is what happened [blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root password mysql [blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password mysql /usr/local/mysql/bin/mysqladmin: connect to server at 'blah.local.' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' [blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h localhost password mysql /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' The last command I got from the searchable Reference Manual, from a posting made by briantrino. Could someone please explain. I must admit that the program is running, and I have four users, two of whom are 'root', one on 'localhost' with a password and the other on 'blah.local.' with no password. The other two users have no user-name or password. Can I set the password for the other 'root' (on 'blah.local.') fromiside MySQL ? What are the other two unnamed users ? I am hoping to install MySL onto a PowerBook G4. The above problem may more obvious here as the 'host' can appear to change depending on whether the PowerBook is on the internet or not. I hope this all make some sense, and that someone can help. Many thanks in advance, Alex Brown MRC-T. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Problem
Alex Brown wrote: Hi. I installed MySQL on a Mac (OS 10.1) a while ago with the good intension of learning to use, and using, MySQL, but other things got in the way. However, I have finally found some time (so far) and I am now trying to install the latest version of MySQL (4.0.16) onto OSX 10.2 (on an iMAC G4), and I must admit to having run into a problem ( I have a vague recollection of having problems before). I have a similar setup: 4.0.16 on 10.2.8 on an iMac G3. I downloaded the installation file mysql-standard-4.0.16.dmg from the MySQl web site as recommended by Mark Liyanage, and followed the installation instructions given in the README. All was fine until I reached the point where the root password is set - the following is what happened [blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root password mysql This set the password for [EMAIL PROTECTED] to mysql. (I hope that's not the real password.) [blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password mysql /usr/local/mysql/bin/mysqladmin: connect to server at 'blah.local.' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' The error says that you are connecting as [EMAIL PROTECTED], but you didn't supply the password, which is needed because you just set it in the first step. [blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h localhost password mysql /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' Same here. The last command I got from the searchable Reference Manual, from a posting made by briantrino. Could someone please explain. I must admit that the program is running, and I have four users, two of whom are 'root', one on 'localhost' with a password and the other on 'blah.local.' with no password. The other two users have no user-name or password. Can I set the password for the other 'root' (on 'blah.local.') fromiside MySQL ? What are the other two unnamed users ? Yes, you can do this within mysql. Use mysql -u root -p mysql to log into mysql as [EMAIL PROTECTED] You'll be prompted for the password. Use the one you set in step 1. Then enter GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword' Replace newpassword with the password you want for [EMAIL PROTECTED] The two users with empty username and password fields are the anonymous user, one for localhost, one for external access. If you do not need them, you can safely delete them. (I'd definitely get rid of the external anonymous user.) For more detailed info, see MySQL User Account Management http://www.mysql.com/doc/en/User_Account_Management.html in the manual. I am hoping to install MySL onto a PowerBook G4. The above problem may more obvious here as the 'host' can appear to change depending on whether the PowerBook is on the internet or not. Note that you don't actually need a [EMAIL PROTECTED] account if you connect from localhost. You only need a [EMAIL PROTECTED] account if you want that user to be able to connect from the named external host. I hope this all make some sense, and that someone can help. Many thanks in advance, You're welcome. Alex Brown MRC-T. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation problem
I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is the server won't start and there don't seem to be any logs available to help diagnose the problem. I've tried both sudo safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/data sudo /Library/StartupItems/MySQL start Starting MySQL database server Any help greatly appreciated! jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation problem
James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v enter password sudo mysqld_safe --user=mysql However, from looking at the output you pasted. It doesn't look like MySQL isn't starting up (nothing about the daemon shutting down). How are you seeing its not up? Use the ampersand at the end of the line or you'll lose the terminal session. Once you've kicked off mysql type mysqladmin version to confirm the server is online. If you downloaded the absolute most recent version, you should see the result 4.0.15-standard (or something like it). Drop me a note. Let me know the 411. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: Installation problem I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is the server won't start and there don't seem to be any logs available to help diagnose the problem. I've tried both sudo safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/data sudo /Library/StartupItems/MySQL start Starting MySQL database server Any help greatly appreciated! jim -- 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: Installation problem
Adam, Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's not running: 1. when I issue mysql -h localhost test I get this msg: ERROR 2002: Can' connect to local MySQL server through socket '/tmp/mysql.sock' (61) 2. when I issue ps -auxww|grep mysql I get no results other than the grep job Just to be sure, I did this: su (to root) mysqld_safe --user=mysql and got there msgs: Starting mysqld daemon with databases from /usr/local/mysql/data mysqld ended -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:54 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v enter password sudo mysqld_safe --user=mysql However, from looking at the output you pasted. It doesn't look like MySQL isn't starting up (nothing about the daemon shutting down). How are you seeing its not up? Use the ampersand at the end of the line or you'll lose the terminal session. Once you've kicked off mysql type mysqladmin version to confirm the server is online. If you downloaded the absolute most recent version, you should see the result 4.0.15-standard (or something like it). Drop me a note. Let me know the 411. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: Installation problem I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is the server won't start and there don't seem to be any logs available to help diagnose the problem. I've tried both sudo safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/data sudo /Library/StartupItems/MySQL start Starting MySQL database server Any help greatly appreciated! jim -- 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: Installation problem
James, Yea, I have to agree its not starting. Alright, you're probably already in the /usr/local/mysql or you would've seen a nasty message reminding you to execute the mysqld_safe script from mysql's directory. Ugh, (whatelse could it be).. if your running OS X Server.. the scripts name is mysql_safed not mysqld_safe. If it were that you'd probably get a script doesn't exist or something. If you were running as something other than root, you'd get a permission error. Hmm.. Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a look in the /usr/local/mysql/data/ directory. Look for a file named hostname.err. That log gets input from the mysqld_safe script. This is an interesting problem! I'm running 4.0.13-standard on my laptop; however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the issue, and if not, I can tell you what I've done not to get it - make sense? Take a look at the error log and let us know what is says. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:15 AM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's not running: 1. when I issue mysql -h localhost test I get this msg: ERROR 2002: Can' connect to local MySQL server through socket '/tmp/mysql.sock' (61) 2. when I issue ps -auxww|grep mysql I get no results other than the grep job Just to be sure, I did this: su (to root) mysqld_safe --user=mysql and got there msgs: Starting mysqld daemon with databases from /usr/local/mysql/data mysqld ended -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:54 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v enter password sudo mysqld_safe --user=mysql However, from looking at the output you pasted. It doesn't look like MySQL isn't starting up (nothing about the daemon shutting down). How are you seeing its not up? Use the ampersand at the end of the line or you'll lose the terminal session. Once you've kicked off mysql type mysqladmin version to confirm the server is online. If you downloaded the absolute most recent version, you should see the result 4.0.15-standard (or something like it). Drop me a note. Let me know the 411. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: Installation problem I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is the server won't start and there don't seem to be any logs available to help diagnose the problem. I've tried both sudo safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/data sudo /Library/StartupItems/MySQL start Starting MySQL database server Any help greatly appreciated! jim -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation problem
Adam, Well, you were right about there being logs :) (I hadn't looked into the data dir since it required root and I was reluctant to setup a root user--live and learn.) 031009 11:12:10 mysqld started 031009 11:12:11 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 031009 11:12:11 mysqld ended Presumably this is due to the permissions on the data dir which are set to drwrxr-x--- What's the best way to solve this? Change the directory permissions or change the characteristics of the mysql user? jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:53 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] Subject: RE: Installation problem James, Yea, I have to agree its not starting. Alright, you're probably already in the /usr/local/mysql or you would've seen a nasty message reminding you to execute the mysqld_safe script from mysql's directory. Ugh, (whatelse could it be).. if your running OS X Server.. the scripts name is mysql_safed not mysqld_safe. If it were that you'd probably get a script doesn't exist or something. If you were running as something other than root, you'd get a permission error. Hmm.. Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a look in the /usr/local/mysql/data/ directory. Look for a file named hostname.err. That log gets input from the mysqld_safe script. This is an interesting problem! I'm running 4.0.13-standard on my laptop; however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the issue, and if not, I can tell you what I've done not to get it - make sense? Take a look at the error log and let us know what is says. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:15 AM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's not running: 1. when I issue mysql -h localhost test I get this msg: ERROR 2002: Can' connect to local MySQL server through socket '/tmp/mysql.sock' (61) 2. when I issue ps -auxww|grep mysql I get no results other than the grep job Just to be sure, I did this: su (to root) mysqld_safe --user=mysql and got there msgs: Starting mysqld daemon with databases from /usr/local/mysql/data mysqld ended -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:54 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v enter password sudo mysqld_safe --user=mysql However, from looking at the output you pasted. It doesn't look like MySQL isn't starting up (nothing about the daemon shutting down). How are you seeing its not up? Use the ampersand at the end of the line or you'll lose the terminal session. Once you've kicked off mysql type mysqladmin version to confirm the server is online. If you downloaded the absolute most recent version, you should see the result 4.0.15-standard (or something like it). Drop me a note. Let me know the 411. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: Installation problem I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is the server won't start and there don't seem to be any logs available to help diagnose the problem. I've tried both sudo safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/data sudo /Library/StartupItems/MySQL start Starting MySQL database server Any help greatly appreciated! jim -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation problem
Adam, Knowing that Mac OS comes with a version of MySQL pre-installed, I didn't do anything special when I downloaded and installed the latest version. I assumed that anything in need of doing would be taken care of during package install. I guess that was just wishful thinking. I'll make the ownership/group changes you suggest below and let you know the results. Thanks! jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:49 PM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James: Yea, you can enable root or just use sudo. Sometimes sudo'ing can be a pain with the timeout and all. Anyway, at first blush I agree with you. When you installed mysql did you give mysql (or whatever account that runs MySQL) rights to the /usr/local/mysql/data directory? Make root the owner of the MySQL directory and place the directory under mysql (or whatever account that runs MySQL) group permissions? Assuming you're running MySQL as user 'mysql' in group 'mysql'. Do the following: chown -R root /usr/local/mysql chgrp -R mysql /usr/local/mysql chwon -R mysql /usr/local/mysql/data Then try mysqld_safe --user=mysql from the /usr/local/mysql directory. Got to run to lunch. Be back in about 45 min. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:21 PM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Well, you were right about there being logs :) (I hadn't looked into the data dir since it required root and I was reluctant to setup a root user--live and learn.) 031009 11:12:10 mysqld started 031009 11:12:11 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 031009 11:12:11 mysqld ended Presumably this is due to the permissions on the data dir which are set to drwrxr-x--- What's the best way to solve this? Change the directory permissions or change the characteristics of the mysql user? jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:53 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] Subject: RE: Installation problem James, Yea, I have to agree its not starting. Alright, you're probably already in the /usr/local/mysql or you would've seen a nasty message reminding you to execute the mysqld_safe script from mysql's directory. Ugh, (whatelse could it be).. if your running OS X Server.. the scripts name is mysql_safed not mysqld_safe. If it were that you'd probably get a script doesn't exist or something. If you were running as something other than root, you'd get a permission error. Hmm.. Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a look in the /usr/local/mysql/data/ directory. Look for a file named hostname.err. That log gets input from the mysqld_safe script. This is an interesting problem! I'm running 4.0.13-standard on my laptop; however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the issue, and if not, I can tell you what I've done not to get it - make sense? Take a look at the error log and let us know what is says. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:15 AM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's not running: 1. when I issue mysql -h localhost test I get this msg: ERROR 2002: Can' connect to local MySQL server through socket '/tmp/mysql.sock' (61) 2. when I issue ps -auxww|grep mysql I get no results other than the grep job Just to be sure, I did this: su (to root) mysqld_safe --user=mysql and got there msgs: Starting mysqld daemon with databases from /usr/local/mysql/data mysqld ended -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:54 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v enter password sudo mysqld_safe --user=mysql However, from looking at the output you pasted. It doesn't look like MySQL isn't starting up (nothing about the daemon shutting down). How are you seeing its not up? Use the ampersand at the end of the line
RE: Installation problem
Sounds like a plan. Actually, MySQL ships with OS X Server - sounds like your using the desktop version, which doesn't include it. Over lunch I threw 4.0.15 on a G4 running 10.2.6 - love that new installer. I had no issues. - Downloaded it. - Ran the installation package - kicked-off MySQL via mysqld_safe script I was able to rock and roll. It went even quicker than that ol'tar ball installation, which I thought was pretty easy. Let me know if the permission changes work. I'm curious to see what the issue is. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:02 PM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Knowing that Mac OS comes with a version of MySQL pre-installed, I didn't do anything special when I downloaded and installed the latest version. I assumed that anything in need of doing would be taken care of during package install. I guess that was just wishful thinking. I'll make the ownership/group changes you suggest below and let you know the results. Thanks! jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:49 PM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James: Yea, you can enable root or just use sudo. Sometimes sudo'ing can be a pain with the timeout and all. Anyway, at first blush I agree with you. When you installed mysql did you give mysql (or whatever account that runs MySQL) rights to the /usr/local/mysql/data directory? Make root the owner of the MySQL directory and place the directory under mysql (or whatever account that runs MySQL) group permissions? Assuming you're running MySQL as user 'mysql' in group 'mysql'. Do the following: chown -R root /usr/local/mysql chgrp -R mysql /usr/local/mysql chwon -R mysql /usr/local/mysql/data Then try mysqld_safe --user=mysql from the /usr/local/mysql directory. Got to run to lunch. Be back in about 45 min. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:21 PM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Well, you were right about there being logs :) (I hadn't looked into the data dir since it required root and I was reluctant to setup a root user--live and learn.) 031009 11:12:10 mysqld started 031009 11:12:11 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 031009 11:12:11 mysqld ended Presumably this is due to the permissions on the data dir which are set to drwrxr-x--- What's the best way to solve this? Change the directory permissions or change the characteristics of the mysql user? jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:53 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] Subject: RE: Installation problem James, Yea, I have to agree its not starting. Alright, you're probably already in the /usr/local/mysql or you would've seen a nasty message reminding you to execute the mysqld_safe script from mysql's directory. Ugh, (whatelse could it be).. if your running OS X Server.. the scripts name is mysql_safed not mysqld_safe. If it were that you'd probably get a script doesn't exist or something. If you were running as something other than root, you'd get a permission error. Hmm.. Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a look in the /usr/local/mysql/data/ directory. Look for a file named hostname.err. That log gets input from the mysqld_safe script. This is an interesting problem! I'm running 4.0.13-standard on my laptop; however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the issue, and if not, I can tell you what I've done not to get it - make sense? Take a look at the error log and let us know what is says. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:15 AM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's not running: 1. when I issue mysql -h localhost test I get this msg: ERROR 2002: Can' connect to local MySQL server through socket '/tmp/mysql.sock' (61) 2. when I issue ps -auxww|grep mysql I get no results other than the grep job Just to be sure, I did this: su (to root) mysqld_safe --user=mysql and got there msgs: Starting mysqld daemon with databases from /usr/local/mysql/data mysqld ended -Original
RE: Installation problem
Adam, It works! I also had to run the initialization script... Thanks very much for the help. jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:49 PM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James: Yea, you can enable root or just use sudo. Sometimes sudo'ing can be a pain with the timeout and all. Anyway, at first blush I agree with you. When you installed mysql did you give mysql (or whatever account that runs MySQL) rights to the /usr/local/mysql/data directory? Make root the owner of the MySQL directory and place the directory under mysql (or whatever account that runs MySQL) group permissions? Assuming you're running MySQL as user 'mysql' in group 'mysql'. Do the following: chown -R root /usr/local/mysql chgrp -R mysql /usr/local/mysql chwon -R mysql /usr/local/mysql/data Then try mysqld_safe --user=mysql from the /usr/local/mysql directory. Got to run to lunch. Be back in about 45 min. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:21 PM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Well, you were right about there being logs :) (I hadn't looked into the data dir since it required root and I was reluctant to setup a root user--live and learn.) 031009 11:12:10 mysqld started 031009 11:12:11 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 031009 11:12:11 mysqld ended Presumably this is due to the permissions on the data dir which are set to drwrxr-x--- What's the best way to solve this? Change the directory permissions or change the characteristics of the mysql user? jim -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:53 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] Subject: RE: Installation problem James, Yea, I have to agree its not starting. Alright, you're probably already in the /usr/local/mysql or you would've seen a nasty message reminding you to execute the mysqld_safe script from mysql's directory. Ugh, (whatelse could it be).. if your running OS X Server.. the scripts name is mysql_safed not mysqld_safe. If it were that you'd probably get a script doesn't exist or something. If you were running as something other than root, you'd get a permission error. Hmm.. Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a look in the /usr/local/mysql/data/ directory. Look for a file named hostname.err. That log gets input from the mysqld_safe script. This is an interesting problem! I'm running 4.0.13-standard on my laptop; however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the issue, and if not, I can tell you what I've done not to get it - make sense? Take a look at the error log and let us know what is says. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:15 AM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's not running: 1. when I issue mysql -h localhost test I get this msg: ERROR 2002: Can' connect to local MySQL server through socket '/tmp/mysql.sock' (61) 2. when I issue ps -auxww|grep mysql I get no results other than the grep job Just to be sure, I did this: su (to root) mysqld_safe --user=mysql and got there msgs: Starting mysqld daemon with databases from /usr/local/mysql/data mysqld ended -Original Message- From: Fortuno, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:54 AM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] (E-mail) Subject: RE: Installation problem James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v enter password sudo mysqld_safe --user=mysql However, from looking at the output you pasted. It doesn't look like MySQL isn't starting up (nothing about the daemon shutting down). How are you seeing its not up? Use the ampersand at the end of the line or you'll lose the terminal session. Once you've kicked off mysql type mysqladmin version to confirm the server is online. If you downloaded the absolute most recent version, you should see the result 4.0.15-standard (or something like it). Drop me a note. Let me know the 411
MySQL Installation problem
To whom it may concern, We are having some trouble installing a MySQL database onto one of our servers and would appreciate some assistance, details are below. Installing MySQL v4.0.14 on a Solaris 8 (Sparc) system on a Netra X1. We have downloaded the source files from your website and have had a go at trying to install the software following the instructions on the user manual. We get to the point of configure and we get the following output: [EMAIL PROTECTED] ./configure --prefix=/usr/local/mysql NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables 030818 10:39:06 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h stats1 password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [EMAIL PROTECTED] Starting mysqld daemon with databases from /opt/clients/stats/mark/mysql-standard-4.0.14-sun-solaris2.8-sparc/data 030818 10:39:07 mysqld ended This seems to be all ok, but then I try to compile the program using the 'make' command and I get this message: [EMAIL PROTECTED] make make: *** No targets specified and no makefile found. Stop. Has this error ever happened before and how could we go further on this. A point to note would be that in the directory /usr/local/ there is no mysql directory created! Regards, Mark A. Cauchi
Re: MySQL Installation problem
Andrew, One, it sound like you have downloaded a binary distro, and this does not require a make. If your want to compile from source, you will need to grab the source distro instead. If you would like to continue with the binary, you can untar the package under /usr/local , and then add the group mysql, add a user mysql with membership to the mysql group, cd to the mysql dir(this should have been created when you untar'd the file under /usr/local, run scripts/mysql_install_db, which sets up all the mysql databases for privledges and stuff, chown -R root . , chown -R mysql data, chgrp -R mysql . , then start the server with bin/mysqld_safe --user=mysql This should let your db server start, after which you will need to run shell mysqladmin password 'your_new_password' if you try to do the same command again, it should complain about auth errors. If you need any other help, just ask. --James Hughbanks Mikro-Data Engineering Dept. [EMAIL PROTECTED] 1-866-457-6287 http://www.mikro-data.net On Monday, Aug 18, 2003, at 05:49 America/New_York, Andrew Keating wrote: To whom it may concern, We are having some trouble installing a MySQL database onto one of our servers and would appreciate some assistance, details are below. Installing MySQL v4.0.14 on a Solaris 8 (Sparc) system on a Netra X1. We have downloaded the source files from your website and have had a go at trying to install the software following the instructions on the user manual. We get to the point of configure and we get the following output: [EMAIL PROTECTED] ./configure --prefix=/usr/local/mysql NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables 030818 10:39:06 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h stats1 password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [EMAIL PROTECTED] Starting mysqld daemon with databases from /opt/clients/stats/mark/mysql-standard-4.0.14-sun-solaris2.8-sparc/data 030818 10:39:07 mysqld ended This seems to be all ok, but then I try to compile the program using the 'make' command and I get this message: [EMAIL PROTECTED] make make: *** No targets specified and no makefile found. Stop. Has this error ever happened before and how could we go further on this. A point to note would be that in the directory /usr/local/ there is no mysql directory created! Regards, Mark A. Cauchi --James Hughbanks Mikro-Data Engineering Dept. [EMAIL PROTECTED] 1-866-457-6287 http://www.mikro-data.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql installation problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 6 Aug 2003, Anil Garg wrote: I am trying to install myql on redhat. Red Hat Linux? mysql package used: mysql-3.23.52-unknown-freebsdelf4.6-i386.tar.gz This is the wrong package - this one is for FreeBSD! Please use the Linux binaries instead. scripts/mysql_install_db: ./bin/my_print_defaults: /usr/libexec/ld-elf.so.1: bad ELF interpreter: No such file or directory scripts/mysql_install_db: ./bin/mysqld: /usr/libexec/ld-elf.so.1: bad ELF interpreter: No such file or directory FreeBSD binaries do not run on Linux. Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany For technical support contracts, visit https://order.mysql.com/?ref=mlgr -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE/MhEhSVDhKrJykfIRAqNGAJkBJYbw9uzsIOv48A+wQ9ol/BWOHQCfeAu7 yXzHGHVLi4tLINiXyomftLM= =3+9Z -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql installation problem
Hi, I am trying to install myql on redhat. mysql package used: mysql-3.23.52-unknown-freebsdelf4.6-i386.tar.gz While following the instructions in install document..when i run the follwing command.. scripts/mysql_install_db following errors appear: - scripts/mysql_install_db: ./bin/my_print_defaults: /usr/libexec/ld-elf.so.1: bad ELF interpreter: No such file or directory WARNING: The host 'njsupport.niksun.com' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables scripts/mysql_install_db: ./bin/mysqld: /usr/libexec/ld-elf.so.1: bad ELF interpreter: No such file or directory Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! -- As i am new bie to mysql ..please tell how can i make mysql work. Thanks and Regards Anil. p.s.(Can i get precomplied package (.tgz) to which i can directly pkg_add?). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2
I used the coammand rpm -i also.Like that rpm -i MySQL-server-4.0.13-0.i386.rpm but it gives the mesaage error : MySQL-server-4.0.13-0.i386.rpm cannot be installed please help - Original Message - From: Matthew [EMAIL PROTECTED] To: sanjay gupta [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 4:51 PM Subject: Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2 rpm -ivt MySQL-server-4.0.13-0.i386.rpm returns Only one major mode may be specified this message is from the rpm utility and means that is it not being used correctly, there is no problem with mysql. maybe just try rpm -i MySQL-server-4.0.13-0.i386.rpm - Original Message - From: sanjay gupta [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 6:52 AM Subject: installation problem Mysql 4.0.13 on Red Hat linux 6.2 Dear All , I am facing problem in installing the mysql 4.0.13 on my linux 6.2 machine . I have pentium III server. When i give the command rpm -ivt MySQL-server-4.0.13-0.i386.rpm it give the message Only one major mode may be specified I tried lot to install the mysql ver 4 on my machine but could not succeed . please help Thanks in advance. sanjay -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installation problem Mysql on Red Hat linux 6.2
Hi, i have download all the versions of mysql from 3 to 4 in rpm format . but could not install any of them on my red hat 6.2 machine When i installing using rpm -i it gives me the message error MySQL-server-version number .rpm cannot be installed do anybody have installed the mysql on Red Hat 6.2 machine please help thanks in advance - Original Message - From: sanjay gupta [EMAIL PROTECTED] To: Matthew [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 1:10 PM Subject: Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2 I used the coammand rpm -i also.Like that rpm -i MySQL-server-4.0.13-0.i386.rpm but it gives the mesaage error : MySQL-server-4.0.13-0.i386.rpm cannot be installed please help - Original Message - From: Matthew [EMAIL PROTECTED] To: sanjay gupta [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 4:51 PM Subject: Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2 rpm -ivt MySQL-server-4.0.13-0.i386.rpm returns Only one major mode may be specified this message is from the rpm utility and means that is it not being used correctly, there is no problem with mysql. maybe just try rpm -i MySQL-server-4.0.13-0.i386.rpm - Original Message - From: sanjay gupta [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 6:52 AM Subject: installation problem Mysql 4.0.13 on Red Hat linux 6.2 Dear All , I am facing problem in installing the mysql 4.0.13 on my linux 6.2 machine . I have pentium III server. When i give the command rpm -ivt MySQL-server-4.0.13-0.i386.rpm it give the message Only one major mode may be specified I tried lot to install the mysql ver 4 on my machine but could not succeed . please help Thanks in advance. sanjay -- 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] -- 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: installation problem Mysql 4.0.13 on Red Hat linux 6.2
rpm -ivt MySQL-server-4.0.13-0.i386.rpm returns Only one major mode may be specified this message is from the rpm utility and means that is it not being used correctly, there is no problem with mysql. maybe just try rpm -i MySQL-server-4.0.13-0.i386.rpm - Original Message - From: sanjay gupta [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 6:52 AM Subject: installation problem Mysql 4.0.13 on Red Hat linux 6.2 Dear All , I am facing problem in installing the mysql 4.0.13 on my linux 6.2 machine . I have pentium III server. When i give the command rpm -ivt MySQL-server-4.0.13-0.i386.rpm it give the message Only one major mode may be specified I tried lot to install the mysql ver 4 on my machine but could not succeed . please help Thanks in advance. sanjay -- 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]
installation problem Mysql 4.0.13 on Red Hat linux 6.2
Dear All , I am facing problem in installing the mysql 4.0.13 on my linux 6.2 machine . I have pentium III server. When i give the command rpm -ivt MySQL-server-4.0.13-0.i386.rpm it give the message Only one major mode may be specified I tried lot to install the mysql ver 4 on my machine but could not succeed . please help Thanks in advance. sanjay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2
i am unable to install mysql 4.0 on my Rh. 6.2 box. i have glib 1.2.6. When try to install the mysql it gives the message Mysql-server-version no.cannot be installed May i know what are the minimum requirment for installtion of mysql 4.0 on 6.2. Is it possible to install the mysql 4.0 on 6.2 thanks in advance sankalap - Original Message - From: sanjay gupta [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:22 AM Subject: installation problem Mysql 4.0.13 on Red Hat linux 6.2 Dear All , I am facing problem in installing the mysql 4.0.13 on my linux 6.2 machine . I have pentium III server. When i give the command rpm -ivt MySQL-server-4.0.13-0.i386.rpm it give the message Only one major mode may be specified I tried lot to install the mysql ver 4 on my machine but could not succeed . please help Thanks in advance. sanjay -- 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: post installation problem
Nick Keeling [EMAIL PROTECTED] wrote: I am a MySQL newbie with a post installation problem. I have Linux Red Hat 9 with MySQL 4.0. After installing MySQL, I can not for the life of me get the mysql daemon to run. My installation directory is /usr/local/mysql but it wants to open a database from /var/lib/mysql. Obviously something is not set right. Any help would be greatly appreciated. Nick Oh, and I can not find ANY log files anywhere (/var/lib or /usr/local/mysql/data). Here are some messages: [EMAIL PROTECTED] mysql]# pwd /usr/local/mysql [EMAIL PROTECTED] mysql]# bin/safe_mysqld --console Starting mysqld daemon with databases from /var/lib/mysql 030710 20:52:14 mysqld ended [EMAIL PROTECTED] mysql]# support-files/mysql.server start Can't execute ./bin/mysqld_safe from dir /var/lib Look into error log file in the MySQL data dir. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
post installation problem
I am a MySQL newbie with a post installation problem. I have Linux Red Hat 9 with MySQL 4.0. After installing MySQL, I can not for the life of me get the mysql daemon to run. My installation directory is /usr/local/mysql but it wants to open a database from /var/lib/mysql. Obviously something is not set right. Any help would be greatly appreciated. Nick Oh, and I can not find ANY log files anywhere (/var/lib or /usr/local/mysql/data). Here are some messages: [EMAIL PROTECTED] mysql]# pwd /usr/local/mysql [EMAIL PROTECTED] mysql]# bin/safe_mysqld --console Starting mysqld daemon with databases from /var/lib/mysql 030710 20:52:14 mysqld ended [EMAIL PROTECTED] mysql]# support-files/mysql.server start Can't execute ./bin/mysqld_safe from dir /var/lib [EMAIL PROTECTED] mysql]# env HOSTNAME=localhost.localdomain TERM=xterm SHELL=/bin/bash HISTSIZE=1000 SSH_CLIENT=216.221.96.219 38781 22 OLDPWD=/usr/local/mysql/bin SSH_TTY=/dev/pts/2 USER=root LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;0 1:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.b tm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31: *.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:* .bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;3 5:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35: LD_LIBRARY_PATH=/usr/local/BerkeleyDB.4.1/lib USERNAME=root MAIL=/var/spool/mail/root PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin :/root/bin INPUTRC=/etc/inputrc PWD=/usr/local/mysql LANG=en_US.UTF-8 SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass SHLVL=1 HOME=/root BASH_ENV=/root/.bashrc LOGNAME=root SSH_CONNECTION=216.221.96.219 38781 192.168.0.2 22 LESSOPEN=|/usr/bin/lesspipe.sh %s G_BROKEN_FILENAMES=1 _=/bin/env
installation problem from tarball
hello mysql users. i have lately joined the wonderful world of mysql. i downloaded tarball mysqla-3.23.54a. ./configure is not giving me any problem. however on executing make to compile the source file i am getting error _ make[2]: Entering directory `/gaurav/mysql-3.23.54a/client' source='mysql.cc' object='mysql.o' libtool=no \ depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \ depmode=gcc3 /bin/sh ../depcomp \ g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I ..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c -o m ysql.o `test -f mysql.cc || echo './'`mysql.cc /bin/sh ../libtool --mode=link g++ -O3 -DDBUG_OFF -fno-implicit-templates -fn o-exceptions -fno-rtti -rdynamic -o mysql mysql.o readline.o sql_string.o com pletion_hash.o ../readline/libreadline.a -lncurses ../libmysql/libmysqlclient.la -lz -lcrypt -lnsl -lm g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic - o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/lib readline.a -lncurses ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm - Wl,--rpath -Wl,/usr/local/lib/mysql mysql.o(.text+0x189c): In function `com_source(String*, char*)': : undefined reference to `errno' collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/gaurav/mysql-3.23.54a/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/gaurav/mysql-3.23.54a' make: *** [all] Error 2 [EMAIL PROTECTED] mysql-3.23.54a]# __ plz help __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installation problem from tarball
What kind of system is this? If you put this line near the top of client/mysql.cc (say, after the line that includes signal.h), does the compile proceed? #include errno.h (I'm assuming that you have an errno.h somewhere on your system.) At 8:43 -0700 6/14/03, Gaurav Kumar wrote: hello mysql users. i have lately joined the wonderful world of mysql. i downloaded tarball mysqla-3.23.54a. ./configure is not giving me any problem. however on executing make to compile the source file i am getting error _ make[2]: Entering directory `/gaurav/mysql-3.23.54a/client' source='mysql.cc' object='mysql.o' libtool=no \ depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \ depmode=gcc3 /bin/sh ../depcomp \ g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I ..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c -o m ysql.o `test -f mysql.cc || echo './'`mysql.cc /bin/sh ../libtool --mode=link g++ -O3 -DDBUG_OFF -fno-implicit-templates -fn o-exceptions -fno-rtti -rdynamic -o mysql mysql.o readline.o sql_string.o com pletion_hash.o ../readline/libreadline.a -lncurses ../libmysql/libmysqlclient.la -lz -lcrypt -lnsl -lm g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic - o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/lib readline.a -lncurses ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm - Wl,--rpath -Wl,/usr/local/lib/mysql mysql.o(.text+0x189c): In function `com_source(String*, char*)': : undefined reference to `errno' collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/gaurav/mysql-3.23.54a/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/gaurav/mysql-3.23.54a' make: *** [all] Error 2 [EMAIL PROTECTED] mysql-3.23.54a]# __ plz help __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- 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]
Re: installation problem from tarball
i am using red hat linux 9 on x86 i have copied that the errno.h file from /usr/include and put #include errno.h at the top of the file here it is what it looke like.. __ /* mysql command tool * Commands compatible with mSQL by David J. Hughes * * Written by: * Michael 'Monty' Widenius * Andi Gutmans [EMAIL PROTECTED] * Zeev Suraski [EMAIL PROTECTED] * Jani Tolonen [EMAIL PROTECTED] * **/ #include errno.h #include client_priv.h #include m_ctype.h #include my_dir.h #ifndef __GNU_LIBRARY__ #define __GNU_LIBRARY__ // Skip warnings in getopt.h #endif #include my_readline.h #include signal.h still i am getting the same error. plz help. --- Paul DuBois [EMAIL PROTECTED] wrote: What kind of system is this? If you put this line near the top of client/mysql.cc (say, after the line that includes signal.h), does the compile proceed? #include errno.h (I'm assuming that you have an errno.h somewhere on your system.) At 8:43 -0700 6/14/03, Gaurav Kumar wrote: hello mysql users. i have lately joined the wonderful world of mysql. i downloaded tarball mysqla-3.23.54a. ./configure is not giving me any problem. however on executing make to compile the source file i am getting error _ make[2]: Entering directory `/gaurav/mysql-3.23.54a/client' source='mysql.cc' object='mysql.o' libtool=no \ depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \ depmode=gcc3 /bin/sh ../depcomp \ g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I ..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c -o m ysql.o `test -f mysql.cc || echo './'`mysql.cc /bin/sh ../libtool --mode=link g++ -O3 -DDBUG_OFF -fno-implicit-templates -fn o-exceptions -fno-rtti -rdynamic -o mysql mysql.o readline.o sql_string.o com pletion_hash.o ../readline/libreadline.a -lncurses ../libmysql/libmysqlclient.la -lz -lcrypt -lnsl -lm g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic - o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/lib readline.a -lncurses ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm - Wl,--rpath -Wl,/usr/local/lib/mysql mysql.o(.text+0x189c): In function `com_source(String*, char*)': : undefined reference to `errno' collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/gaurav/mysql-3.23.54a/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/gaurav/mysql-3.23.54a' make: *** [all] Error 2 [EMAIL PROTECTED] mysql-3.23.54a]# __ plz help __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- 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] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
installation problem on XP again...
Okay I have installed mysql on windows XP-home, and cannot get round the Error cant connect to mysql server on localhost 10061. I have read the manual again and again and again...I have read the public mailing list again and again and again...I have tweaked the `ini` file using the winmysqladmin tool again and again and again...I have installed and re-installed again and again and again... what must I do next to get it to run again and again and again __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.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 Installation Problem
I'm having difficulty installing MySQL 3.23.54 on a Windows 2000 server. I downloaded the file mysql-3.23.54-win.zip. It unzipped and installed smoothly on my Windows 2000 PC, but when I tried to install on the server Setup failed with the Windows message: 'Cannot find file C:\...SETUP.EXE (or one of its components)' etc. I currently have version 3.23.49-nt installed. There were no problems installing it. Can anyone suggest what might be wrong? John R. Porter I.T.Services University of Strathclyde Jordanhill Campus 76 Southbrae Drive Glasgow G13 1PP e-mail: [EMAIL PROTECTED] Tel. 0141 950 3289 - 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
Mac OS X installation problem...
I installed the MySQL (mysql-3.23.51) package from VersionTracker.com on my Titanium PowerBook running Mac OS X 10.2. Whenever I execute any mysql command I get the following error: dyld: ./mysql Undefined symbols: ./mysql undefined reference to _BC expected to be defined in /usr/lib/libSystem.B.dylib ./mysql undefined reference to _PC expected to be defined in /usr/lib/libSystem.B.dylib ./mysql undefined reference to _UP expected to be defined in /usr/lib/libSystem.B.dylib Trace/BPT trap Does anyone know how I might solve this problem? Thanks, Michael- - 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: Mac OS X installation problem...
Try mark linayage's package at: http://www.entropy.ch/software/macosx/welcome.html It is very easy to install and it works great. PSA On 11/26/02 11:28 AM, Michael Burbidge [EMAIL PROTECTED] wrote: I installed the MySQL (mysql-3.23.51) package from VersionTracker.com on my Titanium PowerBook running Mac OS X 10.2. Whenever I execute any mysql command I get the following error: dyld: ./mysql Undefined symbols: ./mysql undefined reference to _BC expected to be defined in /usr/lib/libSystem.B.dylib ./mysql undefined reference to _PC expected to be defined in /usr/lib/libSystem.B.dylib ./mysql undefined reference to _UP expected to be defined in /usr/lib/libSystem.B.dylib Trace/BPT trap Does anyone know how I might solve this problem? Thanks, Michael- - 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: newbie really need help mysql binary installation problem
David, Monday, November 18, 2002, 2:53:33 AM, you wrote: DW I am trying to install mysql-3.23.53a-pc-linux-gnu-i686 to my linux kernel DW 2.2.14(Caldera OpenLinux 2.4). I follow throught the installation porcess DW in the documentation in the mysql.com web site. DW I am using bash shell, here is the list of commands i went through: DW shell groupadd mysql DW shell useradd -g mysql mysql DW shell cd /usr/local DW shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - DW shell ln -s full-path-to-mysql-VERSION-OS mysql DW shell cd mysql DW shell scripts/mysql_install_db DW shell chown -R root . DW shell chown -R mysql data DW shell chgrp -R mysql . DW shell bin/safe_mysqld --user=mysql DW after the last command, I am in /usr/local/mysql directory, I got the following:shell Starting mysqld daemon with database from DW /usr/local/mysql-3.23.53a-pc-linux-gnu-i686/data DW 021117 17:43:49 mysqld ended DW [1] + Done bin/safe_mysqld --user=mysql Check error log file, that is located in the MySQL data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
newbie really need help mysql binary installation problem
Hi guys, I am trying to install mysql-3.23.53a-pc-linux-gnu-i686 to my linux kernel 2.2.14(Caldera OpenLinux 2.4). I follow throught the installation porcess in the documentation in the mysql.com web site. I am using bash shell, here is the list of commands i went through: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s full-path-to-mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/safe_mysqld --user=mysql after the last command, I am in /usr/local/mysql directory, I got the following:shell Starting mysqld daemon with database from /usr/local/mysql-3.23.53a-pc-linux-gnu-i686/data 021117 17:43:49 mysqld ended [1] + Done bin/safe_mysqld --user=mysql shell so apparently i am not running mysql since i dont get mysql prompt whats the problem?.. I had tried many resources! Thanks for any input on this, guys! - 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: Installation problem: mysql.sock missing (??)
Do a locate mysql.sock it's there. Do a search on the newsgroup at http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b On mysql.sock M;) On Sat, 2002-08-24 at 21:34, Roger Young wrote: I'm trying to install the binary mysql-3.23.52 under Linux (Slackware 8.2 distribution, kernel 2.4.18). I have followed the installation steps suggested in the INSTALL-BINARY file. However the daemon will not start, or rather it startd and immediately exits, and there is this message in the error log 020825 11:03:14 mysqld started 020825 11:03:14 Can't start server : Bind on unix socket: No such file or directory 020825 11:03:14 Do you already have another mysqld server running on socket: /var/run/mysql/mysql.sock ? 020825 11:03:14 Aborting In fact neither the socket nor the socket directory /var/run/mysql have been created. I created the directory but still got the same error. How do I properly install mysql? Thanks for your help, Roger Young - 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: Installation problem: mysql.sock missing (??)
Thanks for your reply. Do a locate mysql.sock it's there. For some reason on my machine the mysql install procedure does not create the socket. The locate utility (after updatedb) does not find mysql.sock and the socket directory /var/run/mysql is not established. I must be omitting some vital step but what is it? The mysql package is untarred in /usr/local The scripts/mysql_install_db is run. But the socket is missing... Do a search on the newsgroup at http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b On mysql.sock Didn't have much luck with this either: Sorry, but search returned no results. I did go through the August messages but couldn't find anything relevant. What part of the install procedure sets up the socket? Would it be better to compile from the source rather than from the binary package? Thanks for any further help or comment. Roger Young Do a locate mysql.sock it's there. Do a search on the newsgroup at http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b On mysql.sock M;) On Sat, 2002-08-24 at 21:34, Roger Young wrote: I'm trying to install the binary mysql-3.23.52 under Linux (Slackware 8.2 distribution, kernel 2.4.18). I have followed the installation steps suggested in the INSTALL-BINARY file. However the daemon will not start, or rather it startd and immediately exits, and there is this message in the error log 020825 11:03:14 mysqld started 020825 11:03:14 Can't start server : Bind on unix socket: No such file or directory 020825 11:03:14 Do you already have another mysqld server running on socket: /var/run/mysql/mysql.sock ? 020825 11:03:14 Aborting In fact neither the socket nor the socket directory /var/run/mysql have been created. I created the directory but still got the same error. How do I properly install mysql? Thanks for your help, Roger Young - 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: Installation problem: mysql.sock missing (??)
Hi, MySQL install do not create socket.This socket it's created when MySQL daemon it's started. My suggestion : 1.check if you have already mysqld processes. 2. - Change the owner of directory which is created for mysql.sock from root to mysql ...or - Change in /etc/my.cnf(in [mysqld] section) the name of directory where you wish to mysqld create the socket.You must be sure that directory is *mysql* owner. 3.Start mysqld under init.d directory (/etc/rc.d/init.d...from what i remember.I don't have Slackware installed in this moment) Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Roger Young [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 25, 2002 1:44 PM Subject: Re: Installation problem: mysql.sock missing (??) Thanks for your reply. Do a locate mysql.sock it's there. For some reason on my machine the mysql install procedure does not create the socket. The locate utility (after updatedb) does not find mysql.sock and the socket directory /var/run/mysql is not established. I must be omitting some vital step but what is it? The mysql package is untarred in /usr/local The scripts/mysql_install_db is run. But the socket is missing... Do a search on the newsgroup at http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b On mysql.sock Didn't have much luck with this either: Sorry, but search returned no results. I did go through the August messages but couldn't find anything relevant. What part of the install procedure sets up the socket? Would it be better to compile from the source rather than from the binary package? Thanks for any further help or comment. Roger Young Do a locate mysql.sock it's there. Do a search on the newsgroup at http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b On mysql.sock M;) On Sat, 2002-08-24 at 21:34, Roger Young wrote: I'm trying to install the binary mysql-3.23.52 under Linux (Slackware 8.2 distribution, kernel 2.4.18). I have followed the installation steps suggested in the INSTALL-BINARY file. However the daemon will not start, or rather it startd and immediately exits, and there is this message in the error log 020825 11:03:14 mysqld started 020825 11:03:14 Can't start server : Bind on unix socket: No such file or directory 020825 11:03:14 Do you already have another mysqld server running on socket: /var/run/mysql/mysql.sock ? 020825 11:03:14 Aborting In fact neither the socket nor the socket directory /var/run/mysql have been created. I created the directory but still got the same error. How do I properly install mysql? Thanks for your help, Roger Young - 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: Installation problem: mysql.sock missing (??)
MySQL install do not create socket.This socket it's created when MySQL daemon it's started. My suggestion : 1.check if you have already mysqld processes. 2. - Change the owner of directory which is created for mysql.sock from root to mysql ...or - Change in /etc/my.cnf(in [mysqld] section) the name of directory where you wish to mysqld create the socket.You must be sure that directory is *mysql* owner. 3.Start mysqld under init.d directory (/etc/rc.d/init.d...from what i remember.I don't have Slackware installed in this moment) Thanks, I understand now. Almost certainly this will solve my problem. I think some additional explanation could be included in the INSTALL_BINARY help file for the benefit of mysql newbies like myself...:-) Roger Young - 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
Installation problem, help! help!
I'm having a devil of a time installing mysql 3.23.51 on SuSE 8 from the source tarball. I did ./config, then make. There are the last few lines from make: libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/home/perl/downloads/db/mysql-3.23.51/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/perl/downloads/db/mysql-3.23.51' make: *** [all-recursive-am] Error 2 Here's some info from the mysql debug tool: Submitter-Id: [EMAIL PROTECTED] Originator: [EMAIL PROTECTED] Organization: MySQL support: none Synopsis: Configure/Make problem, SuSE 8.0, mysql-3.23.51 Severity: non-critical Priority: low Category: mysql Class:support Release: mysql-3.23.51 (Source distribution) Environment: machine: Dell Optiplex GX1, os: SuSE Linux 2.4.18-4GB, target: ? libraries ? System: Linux hdeteam 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1394238 Mar 23 12:34 /lib/libc.so.6 -rw-r--r--1 root root 25361424 Mar 23 12:05 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 23 12:05 /usr/lib/libc.so Configure command: CFLAGS=-O3 CC=gcc CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions \ -fno-rtti ./configure --prefix=/usr/local/mysql --enable-assembler \ --with-named-curses-libs=/usr/lib/curses \ --with-mysqld-ldflags=-all-static I've read docs until my eyes are popping out. I need a bit of a rescue here. TIA. /dennis - 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
Installation problem, please help
I'm having a devil of a time installing mysql 3.23.51 on SuSE 8 from the source tarball. I did ./config, then make. There are the last few lines from make: libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/home/perl/downloads/db/mysql-3.23.51/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/perl/downloads/db/mysql-3.23.51' make: *** [all-recursive-am] Error 2 Here's some info from the mysql debug tool: Submitter-Id: [EMAIL PROTECTED] Originator: [EMAIL PROTECTED] Organization: MySQL support: none Synopsis: Configure/Make problem, SuSE 8.0, mysql-3.23.51 Severity: non-critical Priority: low Category: mysql Class:support Release: mysql-3.23.51 (Source distribution) Environment: machine: Dell Optiplex GX1, os: SuSE Linux 2.4.18-4GB, target: ? libraries ? System: Linux hdeteam 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1394238 Mar 23 12:34 /lib/libc.so.6 -rw-r--r--1 root root 25361424 Mar 23 12:05 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 23 12:05 /usr/lib/libc.so Configure command: CFLAGS=-O3 CC=gcc CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions \ -fno-rtti ./configure --prefix=/usr/local/mysql --enable-assembler \ --with-named-curses-libs=/usr/lib/curses \ --with-mysqld-ldflags=-all-static I've read docs until my eyes are popping out. I need a bit of a rescue here. TIA. /dennis - 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: Re: IBM-AIX 4.3 MySQL Binnary Installation Problem: libz ismissing.
Francisco writes: Also, when I try to compile mysql-3.23.51.tar.gz, I get the following error executing the make command: my_gethostbyname.c, line 81.5: 1506-068 (S) Operation between types struct hostent* and int is not allowed. You need to modify the config file, since you are using the VisualAge compiler, to change the #define for the GETHOST stuff : /* In OSF 4.0f the 3'd argument to gethostname_r is hostent_data * */ #define HAVE_GETHOSTBYNAME_R_RETURN_INT 1 more than likely, this is commented out in your version of config.h You should also read the following : http://groups.google.com/groups?hl=enselm=9s779b%24o9a%241%40FreeBSD.csie. NCTU.edu.twrnum=4 - 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: IBM-AIX 4.3 MySQL Binnary Installation Problem: libz is missing.
Francisco, Thursday, July 25, 2002, 2:46:39 AM, you wrote: FR When I try to execute scripts/mysql_install_db, I get FR some errors about some libraries missing: FR exec(): 0509-036 Cannot load program FR ./bin/my_print_defaults because of the following FR errors: FR 0509-150 Dependent module libz.a(shr.o) could not be FR loaded. FR 0509-022 Cannot load module libz.a(shr.o). FR 0509-026 System error: A file or directory in the path FR name does not exist. FR How can I get those libraries and what should I do FR once I get them? What version did you install? This problem was in 3.23.49, 3.23.50, 3.23.51 for AIX because of wrong build. MySQL developers are still working on a new build. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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: Re: IBM-AIX 4.3 MySQL Binnary Installation Problem: libz is missing.
Victoria, I am using mysql-3.23.49-ibm-aix4.3.3.0-rs6000.tar.gz, which is the latest version posted on your site. Also, when I try to compile mysql-3.23.51.tar.gz, I get the following error executing the make command: my_gethostbyname.c, line 81.5: 1506-068 (S) Operation between types struct hostent* and int is not allowed. make: 1254-004 The error code from the last command is 1. I am using GNU Make 3.79.1 Thanks in advance. Francisco, Thursday, July 25, 2002, 2:46:39 AM, you wrote: FR When I try to execute scripts/mysql_install_db, I get FR some errors about some libraries missing: FR exec(): 0509-036 Cannot load program FR ./bin/my_print_defaults because of the following FR errors: FR 0509-150 Dependent module libz.a(shr.o) could not be FR loaded. FR 0509-022 Cannot load module libz.a(shr.o). FR 0509-026 System error: A file or directory in the path FR name does not exist. FR How can I get those libraries and what should I do FR once I get them? What version did you install? This problem was in 3.23.49, 3.23.50, 3.23.51 for AIX because of wrong build. MySQL developers are still working on a new build. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.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
IBM-AIX 4.3 MySQL Binnary Installation Problem: libz is missing.
Hi, When I try to execute scripts/mysql_install_db, I get some errors about some libraries missing: exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. How can I get those libraries and what should I do once I get them? Thanks in advance. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.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: Installation Problem
... yes checking for stdint.h... no checking for unistd.h... yes checking for size_t... yes checking for dirent.h that defines DIR... yes checking for opendir in -ldir... no checking for ANSI C header files... (cached) yes checking for sys/wait.h that is POSIX.1 compatible... yes checking for fcntl.h... yes checking for float.h... yes checking for floatingpoint.h... yes checking for ieeefp.h... yes checking for limits.h... yes checking for memory.h... (cached) yes checking for pwd.h... yes checking for select.h... no checking for stdlib.h... (cached) yes checking for stddef.h... yes checking for strings.h... (cached) yes checking for string.h... (cached) yes checking for synch.h... yes checking for sys/mman.h... yes checking for sys/socket.h... yes checking for netinet/in.h... yes checking for arpa/inet.h... yes checking for sys/timeb.h... yes checking for sys/types.h... (cached) yes checking for sys/un.h... yes checking for sys/vadvise.h... no checking for sys/wait.h... (cached) yes checking for term.h... yes checking for unistd.h... (cached) yes checking for utime.h... yes checking for sys/utime.h... yes checking for termio.h... yes checking for termios.h... yes checking for sched.h... yes checking for crypt.h... yes checking for alloca.h... yes checking for sys/ioctl.h... yes checking for floor in -lm... yes checking for gethostbyname_r in -lnsl_r... no checking for gethostbyname_r in -lnsl... yes checking for gethostbyname_r... yes checking for setsockopt... no checking for setsockopt in -lsocket... yes checking for yp_get_default_domain... yes checking for p2open... no checking for p2open in -lgen... yes checking for bind... yes checking for crypt in -lcrypt... yes checking for crypt... yes checking if libz with compress... no checking for int8... no Fixing broken include files for sun-solaris2.8 - Creating local copy of widec.h checking LinuxThreads... Not found checking DEC threads... no checking DEC 3.2 threads... no checking SCO threads... no checking SCO UnixWare7 native threads... no checking OpenUNIX8 native threads... no checking Siemens threads... no checking Solaris threads... yes checking named thread libs:... -lpthread -lthread checking for strtok_r in -lpthread... yes checking for strtok_r... yes checking for dlopen in -ldl... yes checking for unistd.h... (cached) yes checking for restartable system calls... no checking need of special linking flags... none checking for /usr/local/compiler/GNUgcc/root/usr/local/bin/c++ option to accept ANSI C... none needed checking for an ANSI C-conforming const... yes checking for inline... inline checking for off_t... yes checking for struct stat.st_rdev... yes checking whether time.h and sys/time.h may both be included... yes checking whether struct tm is in sys/time.h or time.h... time.h checking for char... yes checking size of char... 1 checking for int... yes checking size of int... 4 checking for long... yes checking size of long... 4 checking for long long... yes checking size of long long... 8 checking size of off_t... 8 checking whether byte ordering is bigendian... yes checking base type of last arg to accept... socklen_t checking stack direction for C alloca... -1 checking for working alloca.h... (cached) yes checking for alloca... yes checking if struct timespec has a ts_sec member... no checking if we have tzname variable... yes checking for type ulong... yes checking for type uchar... no checking for type uint... yes checking for type fp_except... yes checking if /usr/local/compiler/GNUgcc/root/usr/local/bin/c++ supports bool types... yes checking if conversion of longlong to float works... no configure: error: Your compiler cannot convert a longlong value to a float! If you are using gcc 2.8.# you should upgrade to egcs 1.0.3 or newer and try again Thank you very much.. Dexter - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Dexter S. Tan [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 22, 2002 11:11 AM Subject: Re: Installation Problem In the last episode (Jul 22), Dexter S. Tan said: _ command i entered CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler [...] checking for C compiler default output... configure: error: C compiler cannot create executables [...] configure:1948: checking for C compiler default output configure:1951: gcc -O3conftest.c 5 ./configure: gcc: not found Configure can't find gcc. Either make sure it's in your PATH, or put the pull path to gcc and c++ in your configure command. Note, CXX=gcc will *not* work. gcc is not a c++ compiler; g++ is. Use CXX=g++. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http
Re: MySQL newcomer: Installation problem
Tor R. Skoglund (NextG) [EMAIL PROTECTED] writes: Dan, thanks for your reply. I will first try to do a 'clean' install from the source. That link below is seems to be the 3.23.51 source... not the 4.0.2-Max that I want. I have searched the web for a full tarball source distribution of 4.0.2-Max but have not be able to find one. Am I missing something here? Apparently, yes. The mirror closest to you would probably be ftp://ftp.uninett.no/pub/databases/mysql/Downloads/MySQL-4.0/mysql-4.0.2-alpha.tar.gz I'm guessing the reason you didn't find the MySQL-Max source distribution is because there isn't one :) MySQL-Max and regular MySQL is the same source code that has been compiled with different features. -- - håkon - 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 newcomer: Installation problem
Tor R. Skoglund (NextG) [EMAIL PROTECTED] writes: Dan, thanks for your reply. I will first try to do a 'clean' install from the source. That link below is seems to be the 3.23.51 source... not the 4.0.2-Max that I want. I have searched the web for a full tarball source distribution of 4.0.2-Max but have not be able to find one. Am I missing something here? Apparently, yes. The mirror closest to you would probably be ftp://ftp.uninett.no/pub/databases/mysql/Downloads/MySQL-4.0/mysql-4.0.2-alpha.tar.gz I'm guessing the reason you didn't find the MySQL-Max source distribution is because there isn't one :) MySQL-Max and regular MySQL is the same source code that has been compiled with different features. -- - h åkon - 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 newcomer: Installation problem
Tor R. Skoglund (NextG) [EMAIL PROTECTED] writes: Dan, thanks for your reply. I will first try to do a 'clean' install from the source. That link below is seems to be the 3.23.51 source... not the 4.0.2-Max that I want. I have searched the web for a full tarball source distribution of 4.0.2-Max but have not be able to find one. Am I missing something here? Apparently, yes. The mirror closest to you would probably be ftp://ftp.uninett.no/pub/databases/mysql/Downloads/MySQL-4.0/mysql-4.0.2-alpha.tar.gz I'm guessing the reason you didn't find the MySQL-Max source distribution is because there isn't one :) MySQL-Max and regular MySQL is the same source code that has been compiled with different features. -- - h åkon - 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: MySQL newcomer: Installation problem
Tor R. Skoglund (NextG) [EMAIL PROTECTED] writes: Dan, thanks for your reply. I will first try to do a 'clean' install from the source. That link below is seems to be the 3.23.51 source... not the 4.0.2-Max that I want. I have searched the web for a full tarball source distribution of 4.0.2-Max but have not be able to find one. Am I missing something here? Apparently, yes. The mirror closest to you would probably be ftp://ftp.uninett.no/pub/databases/mysql/Downloads/MySQL-4.0/mysql-4.0.2-alpha.tar.gz I'm guessing the reason you didn't find the MySQL-Max source distribution is because there isn't one :) MySQL-Max and regular MySQL is the same source code that has been compiled with different features. -- - h åkon - 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: Installation Problem
Dan, Hi, good news.. =) I've already successfully installed mysql... Thank you very much to you and georg :) Thanks for helping me out. I'm quite new here... My last problem was solved by fixing my path... ok... Dexter... - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Dexter S. Tan [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 22, 2002 10:53 PM Subject: Re: Installation Problem In the last episode (Jul 22), Dexter S. Tan said: Hi, I've tried it and I still encountered this. btw, my compiler version is 2.95.2 Here is the result. [...] checking for gcc... /usr/local/compiler/GNUgcc/root/usr/local/bin/c++ Heh. You don't want to set CC=g++. :) You want CC=gcc, CXX=g++. -- Dan Nelson [EMAIL PROTECTED] - 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: Installation Problem
Hi Georg, I have tried to change the zero to letter O and still have this problem. I'll paste below the config.log file and the output. Thank you very much for your help. _ command i entered CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler _ screen output: checking build system type... sparc-sun-solaris2.8 checking host system type... sparc-sun-solaris2.8 checking target system type... sparc-sun-solaris2.8 checking for a BSD compatible install... ./install-sh -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... ./configure: make: not found no checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) no checking for mawk... no checking for gawk... no checking for nawk... nawk checking for gcc... gcc checking for C compiler default output... configure: error: C compiler cannot create executables _ config.log file This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistake. It was created by configure, which was generated by GNU Autoconf 2.52. Invocation command line was $ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler ## -- ## ## Platform. ## ## -- ## hostname = bigbird uname -m = sun4u uname -r = 5.8 uname -s = SunOS uname -v = Generic_108528-13 /usr/bin/uname -p = sparc /bin/uname -X = System = SunOS Node = bigbird Release = 5.8 KernelID = Generic_108528-13 Machine = sun4u BusType = unknown Serial = unknown Users = unknown OEM# = 0 Origin# = 1 NumCPU = 1 /bin/arch = sun4 /usr/bin/arch -k = sun4u /usr/convex/getsysinfo = unknown hostinfo = unknown /bin/machine = unknown /usr/bin/oslevel = unknown /bin/universe = unknown PATH = /usr/sbin:/usr/bin ## ## ## Core tests. ## ## ## configure:1044: PATH=.;.; conftest.sh ./configure: conftest.sh: not found configure:1047: $? = 1 configure:1087: checking build system type configure:1105: result: sparc-sun-solaris2.8 configure:1115: checking host system type configure:1129: result: sparc-sun-solaris2.8 configure:1139: checking target system type configure:1153: result: sparc-sun-solaris2.8 configure:1182: checking for a BSD compatible install configure:1231: result: ./install-sh -c configure:1242: checking whether build environment is sane configure:1260: result: yes configure:1275: checking whether make sets ${MAKE} configure:1299: result: no configure:1323: checking for working aclocal configure:1334: result: missing configure:1338: checking for working autoconf configure:1349: result: missing configure:1353: checking for working automake configure:1364: result: missing configure:1368: checking for working autoheader configure:1379: result: missing configure:1383: checking for working makeinfo configure:1394: result: missing configure:1473: checking whether to enable maintainer-specific portions of Makefiles configure:1482: result: no configure:1495: checking whether build environment is sane configure:1513: result: yes configure:1516: checking whether make sets ${MAKE} configure:1540: result: no configure:1585: checking for mawk configure:1611: result: no configure:1585: checking for gawk configure:1611: result: no configure:1585: checking for nawk configure:1600: found /usr/bin/nawk configure:1608: result: nawk configure:1661: checking for gcc configure:1684: result: gcc configure:1912: checking for C compiler version configure:1915: gcc --version /dev/null 5 ./configure: gcc: not found configure:1918: $? = 1 configure:1920: gcc -v /dev/null 5 ./configure: gcc: not found configure:1923: $? = 1 configure:1925: gcc -V /dev/null 5 ./configure: gcc: not found configure:1928: $? = 1 configure:1948: checking for C compiler default output configure:1951: gcc -O3conftest.c 5 ./configure: gcc: not found configure:1954: $? = 1 configure: failed program was: #line 1932 configure #include confdefs.h int main () { ; return 0; } configure:1977: error: C compiler cannot create executables ## - ## ## Cache variables. ## ## - ## ac_cv_build='sparc-sun-solaris2.8' ac_cv_build_alias='sparc-sun-solaris2.8' ac_cv_env_CC_set='set' ac_cv_env_CC_value='gcc' ac_cv_env_CFLAGS_set='set' ac_cv_env_CFLAGS_value='-O3' ac_cv_env_CPPFLAGS_set='' ac_cv_env_CPPFLAGS_value='' ac_cv_env_CPP_set=''
Re: Installation Problem
In the last episode (Jul 22), Dexter S. Tan said: _ command i entered CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler [...] checking for C compiler default output... configure: error: C compiler cannot create executables [...] configure:1948: checking for C compiler default output configure:1951: gcc -O3conftest.c 5 ./configure: gcc: not found Configure can't find gcc. Either make sure it's in your PATH, or put the pull path to gcc and c++ in your configure command. Note, CXX=gcc will *not* work. gcc is not a c++ compiler; g++ is. Use CXX=g++. -- Dan Nelson [EMAIL PROTECTED] - 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: Installation Problem
Dan, Thank you very much. I'll try it again and update you as soon as i got the result... Dexter. - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Dexter S. Tan [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 22, 2002 11:11 AM Subject: Re: Installation Problem In the last episode (Jul 22), Dexter S. Tan said: _ command i entered CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler [...] checking for C compiler default output... configure: error: C compiler cannot create executables [...] configure:1948: checking for C compiler default output configure:1951: gcc -O3conftest.c 5 ./configure: gcc: not found Configure can't find gcc. Either make sure it's in your PATH, or put the pull path to gcc and c++ in your configure command. Note, CXX=gcc will *not* work. gcc is not a c++ compiler; g++ is. Use CXX=g++. -- Dan Nelson [EMAIL PROTECTED] - 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: Installation Problem
Georg, Here is the content of the config.log file.. config.log This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistake. It was created by configure, which was generated by GNU Autoconf 2.52. Invocation command line was $ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler ## -- ## ## Platform. ## ## -- ## hostname = bigbird uname -m = sun4u uname -r = 5.8 uname -s = SunOS uname -v = Generic_108528-13 /usr/bin/uname -p = sparc /bin/uname -X = System = SunOS Node = bigbird Release = 5.8 KernelID = Generic_108528-13 Machine = sun4u BusType = unknown Serial = unknown Users = unknown OEM# = 0 Origin# = 1 NumCPU = 1 /bin/arch = sun4 /usr/bin/arch -k = sun4u /usr/convex/getsysinfo = unknown hostinfo = unknown /bin/machine = unknown /usr/bin/oslevel = unknown /bin/universe = unknown PATH = /usr/sbin:/usr/bin:/opt/DCT2000/GNU-C:/usr/ccs/bin:/usr/openwin/bin ## ## ## Core tests. ## ## ## configure:1044: PATH=.;.; conftest.sh ./configure: conftest.sh: not found configure:1047: $? = 1 configure:1087: checking build system type configure:1105: result: sparc-sun-solaris2.8 configure:1115: checking host system type configure:1129: result: sparc-sun-solaris2.8 configure:1139: checking target system type configure:1153: result: sparc-sun-solaris2.8 configure:1182: checking for a BSD compatible install configure:1231: result: ./install-sh -c configure:1242: checking whether build environment is sane configure:1260: result: yes configure:1275: checking whether make sets ${MAKE} configure:1295: result: yes configure:1323: checking for working aclocal configure:1334: result: missing configure:1338: checking for working autoconf configure:1349: result: missing configure:1353: checking for working automake configure:1364: result: missing configure:1368: checking for working autoheader configure:1379: result: missing configure:1383: checking for working makeinfo configure:1394: result: missing configure:1473: checking whether to enable maintainer-specific portions of Makefiles configure:1482: result: no configure:1495: checking whether build environment is sane configure:1513: result: yes configure:1516: checking whether make sets ${MAKE} configure:1536: result: yes configure:1585: checking for mawk configure:1611: result: no configure:1585: checking for gawk configure:1611: result: no configure:1585: checking for nawk configure:1600: found /usr/bin/nawk configure:1608: result: nawk configure:1661: checking for gcc configure:1684: result: gcc configure:1912: checking for C compiler version configure:1915: gcc --version /dev/null 5 2.95.2 configure:1918: $? = 0 configure:1920: gcc -v /dev/null 5 Using builtin specs. gcc version 2.95.2 19991024 (release) configure:1923: $? = 0 configure:1925: gcc -V /dev/null 5 gcc: argument to `-V' is missing configure:1928: $? = 1 configure:1948: checking for C compiler default output configure:1951: gcc -03conftest.c 5 gcc: unrecognized option `-03' cpp: Internal compiler error: program cpp got fatal signal 9 configure:1954: $? = 1 configure: failed program was: #line 1932 configure #include confdefs.h int main () { ; return 0; } configure:1977: error: C compiler cannot create executables ## - ## ## Cache variables. ## ## - ## ac_cv_build='sparc-sun-solaris2.8' ac_cv_build_alias='sparc-sun-solaris2.8' ac_cv_env_CC_set='set' ac_cv_env_CC_value='gcc' ac_cv_env_CFLAGS_set='set' ac_cv_env_CFLAGS_value='-03' ac_cv_env_CPPFLAGS_set='' ac_cv_env_CPPFLAGS_value='' ac_cv_env_CPP_set='' ac_cv_env_CPP_value='' ac_cv_env_CXXFLAGS_set='set' ac_cv_env_CXXFLAGS_value='-03 -felide-constructors -fno-exceptions -fno-rtti ' ac_cv_env_CXX_set='set' ac_cv_env_CXX_value='gcc' ac_cv_env_LDFLAGS_set='' ac_cv_env_LDFLAGS_value='' ac_cv_env_build_alias_set='' ac_cv_env_build_alias_value='' ac_cv_env_host_alias_set='' ac_cv_env_host_alias_value='' ac_cv_env_target_alias_set='' ac_cv_env_target_alias_value='' ac_cv_host='sparc-sun-solaris2.8' ac_cv_host_alias='sparc-sun-solaris2.8' ac_cv_prog_AWK='nawk' ac_cv_prog_ac_ct_CC='gcc' ac_cv_prog_make_make_set='yes' ac_cv_target='sparc-sun-solaris2.8' ac_cv_target_alias='sparc-sun-solaris2.8' ## ## ## confdefs.h. ## ## ## #define PACKAGE mysql #define VERSION 3.23.51 #define PROTOCOL_VERSION 10 #define DOT_FRM_VERSION 6 #define SYSTEM_TYPE sun-solaris2.8 #define MACHINE_TYPE sparc configure: exit 77 Thank you for your quick response.. =) Dexter - Original Message - From: Georg Richter [EMAIL PROTECTED] To: Dexter S. Tan [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, July 19, 2002 1:38 PM Subject: Re: Installation Problem On Friday, 19. July 2002 07:03, Dexter S. Tan wrote: Hello Dexter, would be interesting to know the content from your config.log file. Regards
Re: Installation Problem
Hi Dexter, configure:1948: checking for C compiler default output configure:1951: gcc -03conftest.c 5 gcc: unrecognized option `-03' cpp: Internal compiler error: program cpp got fatal signal 9 configure:1954: $? = 1 configure: failed program was: #line 1932 configure #include confdefs.h Hi Dexter, Hmm.. looks like that you have specified CC=gcc -03 ?! Should be gcc -O3 (Letter O, not zero). Regards Georg mysql,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
Installation Problem
Hi, I would like to ask how come the installation won't work on my system. Here are the details. Specifications: Sun Sparc Ultra-5_10 Generic_108528-13 mysql-3.23.51 gcc version 2.95.2 19991024 What I did: shell groupadd mysql shell useradd -g mysql mysql unzip the files using gtar with no error. shell CC=gcc CFLAGS=-03 \ CXX=gcc CXXFLAGS=-03 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-lowmemory --enable-assembler This is the result: checking build system type... sparc-sun-solaris2.8 checking host system type... sparc-sun-solaris2.8 checking target system type... sparc-sun-solaris2.8 checking for a BSD compatible install... ./install-sh -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for mawk... no checking for gawk... no checking for nawk... nawk checking for gcc... gcc checking for C compiler default output... configure: error: C compiler cannot create executables Can someone please help me with this. Thank you very much Dexter Tan - 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: Installation Problem
On Friday, 19. July 2002 07:03, Dexter S. Tan wrote: Hello Dexter, would be interesting to know the content from your config.log file. Regards Georg mysql,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
MySQL installation problem
Hi guys, I am trying to install MySql on Linux (Mandrake 8). And everytime when I try to start the server. like this [mysql@127 support-files]# ./mysql.server start I get the message like: ./mysql.server: @hostname@ command not found ./mysql.server: my_print_defaults command not found [mysql@127 support-files]# Starting mysqld daemon with database from /usr/local/mysql/data 020709 09:07:03 mysqld ended Anybody can give me a hint? I really appreciate it! Tang --- Tang, Lianhong Vanderbilt University Email: [EMAIL PROTECTED] - 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
Installation problem
Hi I am pretty new to linux and I was trying to setup and use mysql, I followed the directions you provided about compiling it and installing it, but when I try to start the server the mysql daemon fail right away : saying mysqld ended. I looked at the error log and this is what it says : /usr/local/mysql/bin/mysqld: Can't find file : './mysql/host.frm' (errno : 13). Now the file host.frm is in the directory /var/lib/mysql/mysql/host.frm, I was gonna put this somewhere in the msqld file but it is not in human readeable form. Thank you. John - 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: Installation problem
Mysql does not own the database and its tables; chown -R mysql /usr/local/mysql/var ( or whatever the database location is. ) Kariuki, JohnX K wrote: Hi I am pretty new to linux and I was trying to setup and use mysql, I followed the directions you provided about compiling it and installing it, but when I try to start the server the mysql daemon fail right away : saying mysqld ended. I looked at the error log and this is what it says : /usr/local/mysql/bin/mysqld: Can't find file : './mysql/host.frm' (errno : 13). Now the file host.frm is in the directory /var/lib/mysql/mysql/host.frm, I was gonna put this somewhere in the msqld file but it is not in human readeable form. Thank you. John - 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