Re: Installation Problems
Hi Roland, I wanted to know if you face the sae problems that i've faced or u get somethng else. @ Ian I've already done that. I will do what Roland told me to, lets hope i have some luck this time around. On Wed, Mar 25, 2009 at 2:15 AM, Rolando Edwards redwa...@logicworks.netwrote: Ever since MySQL 5.0.27, I have never been able to install the MySQL Service either. I think this has something to do with the way Microsoft compiles its OS Services. I use the no installer version now. 1. Go to a DOS Window and create a directory called C:\ MySQL_5.1.32 2. Click Start, Run, and type Open : C:\ MySQL_5.1.32. This will open a Windows Explorer Window in that new empty Folder. 3. Download mysql-noinstall-5.1.32.zip to the Windows Desktop 4. Open the mysql-noinstall-5.1.32.zip and another Windows Explorer window opens up containing the folder 'mysql-noinstall-5.1.32-win32' 5. Double click that 'mysql-noinstall-5.1.32-win32' folder and another window shows the folders 'bin','data','Docs' and so forth. 6. Select all files and folders by hitting Ctrl-A 7. Drag and Drop those selected files and folders into the 'C:\ MySQL_5.1.32' Window 8. Right-click on 'My Computer', and click on 'Properties' 9. Click on the Advanced Tab 10. Click the Environment Variables button 11. Scroll the bottom listbox to the PATH variable 12. Double Click the PATH variable 13. Append ';C:\MySQL_5.1.32' to the PATH variable 14. Click OK 3 times 15. In the 'C:\MySQL_5.1.32' Window, copy 'my-small' to 'my' (In other words, copy mysql-small.ini to my.ini) If you do not do this, you will be starting mysqld with all server defaults 16. Create a DOS Batch File called start_mysqld.bat with the following lines@echo off set MYSQL_HOME=C:\MySQL_5.1.32 set MYSQL_BIN=%MYSQL_HOME%\bin echo %MYSQL_BIN% cd %MYSQL_BIN% pause (This line is optional) start mysqld 17. Create a DOS Batch File called stop_mysqld.bat with the following lines @echo off set MYSQL_HOME=C:\MySQL_5.1.32 set MYSQL_BIN=%MYSQL_HOME%\bin %MYSQL_BIN%\mysqladmin -uroot shutdown 18. Create a ShortCut for both batch files and place them on the Desktop 19. Double Click the ShortCut for start_mysqld.bat This should start up mysqld Open the task manager and look for 'mysqld.exe' 20. Goto a new DOS Window and type 'mysql -uroot' You should be mysql now. If you got to this point successfully, have fun from here !!! Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM : RolandoLogicWorx Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: Manish Gupta [mailto:manish.in@gmail.com] Sent: Tuesday, March 24, 2009 4:05 PM To: mysql@lists.mysql.com Subject: Installation Problems I had MySQL 4.0. Today i downloaded the recent version, mysql5.12.32-Win32 installer. I deleted the older verison of mysql that i had. I didnt have any data there and thus no upgrade was needed as such. I used typical install option and after the install i used the standard configuration for the server configuration wizard. i typed the password required and the problems started. 1. It couldnot install mysql as a service, named MySQL, although there is no service with that name. i checked with the service option in control panel. 2. I went back and installed it with the service name MySQL5. This time, it installed the service, but could not apply the security setting and terminated with the error, saying root doesnot have the permission to log on from localhost. 3. I opened the command line clien from the start menu. It asked for the password, i typed it in and the interface disappeared. I uninstalled and then installed it again a couple of times, but one or the other erroe kept reccuring. I'm still havent been able to use MySQL. Please Help.
Installation Problems
I had MySQL 4.0. Today i downloaded the recent version, mysql5.12.32-Win32 installer. I deleted the older verison of mysql that i had. I didnt have any data there and thus no upgrade was needed as such. I used typical install option and after the install i used the standard configuration for the server configuration wizard. i typed the password required and the problems started. 1. It couldnot install mysql as a service, named MySQL, although there is no service with that name. i checked with the service option in control panel. 2. I went back and installed it with the service name MySQL5. This time, it installed the service, but could not apply the security setting and terminated with the error, saying root doesnot have the permission to log on from localhost. 3. I opened the command line clien from the start menu. It asked for the password, i typed it in and the interface disappeared. I uninstalled and then installed it again a couple of times, but one or the other erroe kept reccuring. I'm still havent been able to use MySQL. Please Help.
RE: Installation Problems
Ever since MySQL 5.0.27, I have never been able to install the MySQL Service either. I think this has something to do with the way Microsoft compiles its OS Services. I use the no installer version now. 1. Go to a DOS Window and create a directory called C:\ MySQL_5.1.32 2. Click Start, Run, and type Open : C:\ MySQL_5.1.32. This will open a Windows Explorer Window in that new empty Folder. 3. Download mysql-noinstall-5.1.32.zip to the Windows Desktop 4. Open the mysql-noinstall-5.1.32.zip and another Windows Explorer window opens up containing the folder 'mysql-noinstall-5.1.32-win32' 5. Double click that 'mysql-noinstall-5.1.32-win32' folder and another window shows the folders 'bin','data','Docs' and so forth. 6. Select all files and folders by hitting Ctrl-A 7. Drag and Drop those selected files and folders into the 'C:\ MySQL_5.1.32' Window 8. Right-click on 'My Computer', and click on 'Properties' 9. Click on the Advanced Tab 10. Click the Environment Variables button 11. Scroll the bottom listbox to the PATH variable 12. Double Click the PATH variable 13. Append ';C:\MySQL_5.1.32' to the PATH variable 14. Click OK 3 times 15. In the 'C:\MySQL_5.1.32' Window, copy 'my-small' to 'my' (In other words, copy mysql-small.ini to my.ini) If you do not do this, you will be starting mysqld with all server defaults 16. Create a DOS Batch File called start_mysqld.bat with the following lines @echo off set MYSQL_HOME=C:\MySQL_5.1.32 set MYSQL_BIN=%MYSQL_HOME%\bin echo %MYSQL_BIN% cd %MYSQL_BIN% pause (This line is optional) start mysqld 17. Create a DOS Batch File called stop_mysqld.bat with the following lines @echo off set MYSQL_HOME=C:\MySQL_5.1.32 set MYSQL_BIN=%MYSQL_HOME%\bin %MYSQL_BIN%\mysqladmin -uroot shutdown 18. Create a ShortCut for both batch files and place them on the Desktop 19. Double Click the ShortCut for start_mysqld.bat This should start up mysqld Open the task manager and look for 'mysqld.exe' 20. Goto a new DOS Window and type 'mysql -uroot' You should be mysql now. If you got to this point successfully, have fun from here !!! Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM : RolandoLogicWorx Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: Manish Gupta [mailto:manish.in@gmail.com] Sent: Tuesday, March 24, 2009 4:05 PM To: mysql@lists.mysql.com Subject: Installation Problems I had MySQL 4.0. Today i downloaded the recent version, mysql5.12.32-Win32 installer. I deleted the older verison of mysql that i had. I didnt have any data there and thus no upgrade was needed as such. I used typical install option and after the install i used the standard configuration for the server configuration wizard. i typed the password required and the problems started. 1. It couldnot install mysql as a service, named MySQL, although there is no service with that name. i checked with the service option in control panel. 2. I went back and installed it with the service name MySQL5. This time, it installed the service, but could not apply the security setting and terminated with the error, saying root doesnot have the permission to log on from localhost. 3. I opened the command line clien from the start menu. It asked for the password, i typed it in and the interface disappeared. I uninstalled and then installed it again a couple of times, but one or the other erroe kept reccuring. I'm still havent been able to use MySQL. Please Help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Installation problems with MySql 5.0.41 (source distribution)
Hi, You're running MySQL with a mysql linux user, verify that he have write access on mysql datadir. You should specify it with --datadir= at command line invoking mysql_install_db too. 2007/6/16, [EMAIL PROTECTED] [EMAIL PROTECTED]: Hi everybody, I am trying to compile/configure MySQl 5.0.41 on a Mandrake 10 linux box. In doing so, I am getting some errors with mysql_install_db (ERROR: 1049 Unknown database 'mysql', Installation of system tables failed!) Please let me know how to solve the problem. Thanks in advance for your time and help. Anand Here are the details pertaining to my problem: I used this as a guide: http://dev.mysql.com/doc/refman/5.0/en/quick-install.html: and followed all the steps. The following error(s) comes when I try using mysql_install_db /usr/local/mysql/bin/mysql_install_db --user=mysql Installing MySQL system tables... ERROR: 1049 Unknown database 'mysql' 070616 1:24:38 [ERROR] Aborting 070616 1:24:38 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /usr/local/mysql/var for more information. You can try to start the mysqld daemon with: /usr/local/mysql/libexec/mysqld --skip-grant and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/local/mysql/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /usr/local/mysql/var that may be helpful. --- And then, when I do /usr/local/mysql/libexec/mysqld --skip-grant as suggested in the above error message, it just aborts. Here is the architecture info. from mysqlbug -- Release: mysql-5.0.41 (Source distribution) C compiler:gcc (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk) C++ compiler: g++ (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk) Environment: machine, os, target, libraries (multiple lines) System: Linux 2.6.3-7mdk #1 Wed Mar 17 15:56:42 CET 2004 i686 unknown unknown GNU/Linux 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/i586-mandrake-linux-gnu/3.3.2/specs Configured with: ../configure --prefix=/usr --libdir=/usr/lib --with-slibdir=/lib --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --enable-long-long --enable-__cxa_atexit --enable-clocale=gnu --enable-languages=c,c++,ada,f77,objc,java,pascal --host=i586-mandrake-linux-gnu --with-system-zlib Thread model: posix gcc version 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Sep 13 2004 /lib/libc.so.6 - libc-2.3.3.so -rwxr-xr-x 1 root root 1281788 Feb 16 2004 /lib/libc-2.3.3.so -rw-r--r-- 1 root root 204 Feb 16 2004 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/local/mysql' '--with-unix\ -socket-path=/usr/local/mysql/tmp/mysql.sock' -- -- 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 problems with MySql 5.0.41 (source distribution)
Hi everybody, I am trying to compile/configure MySQl 5.0.41 on a Mandrake 10 linux box. In doing so, I am getting some errors with mysql_install_db (ERROR: 1049 Unknown database 'mysql', Installation of system tables failed!) Please let me know how to solve the problem. Thanks in advance for your time and help. Anand Here are the details pertaining to my problem: I used this as a guide: http://dev.mysql.com/doc/refman/5.0/en/quick-install.html: and followed all the steps. The following error(s) comes when I try using mysql_install_db /usr/local/mysql/bin/mysql_install_db --user=mysql Installing MySQL system tables... ERROR: 1049 Unknown database 'mysql' 070616 1:24:38 [ERROR] Aborting 070616 1:24:38 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /usr/local/mysql/var for more information. You can try to start the mysqld daemon with: /usr/local/mysql/libexec/mysqld --skip-grant and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/local/mysql/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /usr/local/mysql/var that may be helpful. --- And then, when I do /usr/local/mysql/libexec/mysqld --skip-grant as suggested in the above error message, it just aborts. Here is the architecture info. from mysqlbug -- Release: mysql-5.0.41 (Source distribution) C compiler:gcc (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk) C++ compiler: g++ (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk) Environment: machine, os, target, libraries (multiple lines) System: Linux 2.6.3-7mdk #1 Wed Mar 17 15:56:42 CET 2004 i686 unknown unknown GNU/Linux 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/i586-mandrake-linux-gnu/3.3.2/specs Configured with: ../configure --prefix=/usr --libdir=/usr/lib --with-slibdir=/lib --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --enable-long-long --enable-__cxa_atexit --enable-clocale=gnu --enable-languages=c,c++,ada,f77,objc,java,pascal --host=i586-mandrake-linux-gnu --with-system-zlib Thread model: posix gcc version 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Sep 13 2004 /lib/libc.so.6 - libc-2.3.3.so -rwxr-xr-x 1 root root 1281788 Feb 16 2004 /lib/libc-2.3.3.so -rw-r--r-- 1 root root 204 Feb 16 2004 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/local/mysql' '--with-unix\ -socket-path=/usr/local/mysql/tmp/mysql.sock' -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation problems.
Hello. Is this a clean new install of MySQL, or you have already installed MySQL instance? Please provide more information about your OS version (I guess it is Windows, isn't it?). May be some tips from the manual could be helpful: http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooting.html http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html Kevin Pollard wrote: Today I downloaded and installed MySQL 5.0 (the Complete Package). Everything seemed to go with the install until it got to the Processing configuration... stage. It successfully completed Prepare configuration, and Write configuration file, and Start service. But it failed when it got to Apply security settings with the error message The security settings could not be applied. Error number 2003. Can't connect ot MySQL server on 'locahost' (10061) What can I do about that? Kevin -- 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 installation problems.
Today I downloaded and installed MySQL 5.0 (the Complete Package). Everything seemed to go with the install until it got to the Processing configuration... stage. It successfully completed Prepare configuration, and Write configuration file, and Start service. But it failed when it got to Apply security settings with the error message The security settings could not be applied. Error number 2003. Can't connect ot MySQL server on 'locahost' (10061) What can I do about that? Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql4.0 installation problems.
Hello, I have been running mysql3.23 on FreeBSD server for a long time.Lately i decided to upgrade mysql3.23 to mysql4 using ports. So i first did make uninstall in usr/ports/databases/mysql323-client and mysql323-server. Than, from /usr/ports/databases/mysql40-server i gave make install command. mysql-client installed properly but mysql-server did not. I got the followling error: shared library mysqlclient.12 is not found. Goolging for this error did not help me much.Having had no success in installation, I uninstalled mysql-client again and from /usr/ports/databases/mysql40-server i gave make reinstall. This has worsten the situation. The installation process was going on going on and going on.. and i had to give ctrl-C to stop it. I guess it went on to some kind of loop. Now I am totally lost. Any help is greatly appreciated. Thanks, Naveen. Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time.
?config/installation problems
installed mysql on gentoo linux. [EMAIL PROTECTED] etc # mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' [EMAIL PROTECTED] etc # mysqladmin -p version Enter password: mysqladmin Ver 8.40 Distrib 4.0.14, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license [EMAIL PROTECTED] etc # mysqladmin variables mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' [EMAIL PROTECTED] etc # mysqladmin -p variables Enter password: +-+ --- + | Variable_name | Value Am I going to have problems further down the line if I dont sort this? Sort what?| not clear in this when or if I should edit my.cnf /mysqlaccess.cnf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql 4.1 installation problems
Hi, I have mysql 4.0 installed on redhat 9.0.I want to install mysql 4.1 and keep 4.0 as it is.I get the follownig message whent I try to install 4.1 mysql_install_db : line 166:0:command not found. Installing privilege tables mysqld :ERROR :unknown option --log-bin # required for replication. mysql_install_db : line 443 :9596 broken pipe ... how do I fix this problem thanx phani -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation Problems
Hello! I am new to the world of Linux and MySQL, I have been working with it for about a month now. We decided to upgrade the 4.1Alpha instead of the current release because we wanted to test sub Select statements. After having some problems and hosing up the Red Hat machine, I re-installed RedHat (version 9) and am now installing MySQL. However, 3 of the RPM packages are giving similar dependency errors. All of the rpm packages produce the signature warnings which I'm assuming exist because this is Alpha, but these three produce dependcies errors. Is there a page with information on what to do in these cases that someone can point me to, I will appreciate any and all help. Thanks -- John (command line and errors follow) # rpm -i MySQL-Max-4.1.0-0.i386.rpm warning: MySQL-Max-4.1.0-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libcrypto.so.0.9.6 is needed by MySQL-Max-4.1.0-0 libssl.so.0.9.6 is needed by MySQL-Max-4.1.0-0 # rpm -i MySQL-shared-4.1.0-0.i386.rpm warning: MySQL-shared-4.1.0-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libcrypto.so.0.9.6 is needed by MySQL-shared-4.1.0-0 libssl.so.0.9.6 is needed by MySQL-shared-4.1.0-0 # rpm -i MySQL-bench-4.1.0-0.i386.rpm warning: MySQL-bench-4.1.0-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: perl-DBI is needed by MySQL-bench-4.1.0-0 John Stacy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql installation problems (RPM errors)
Hey Folks Hi there! My first post to the list ... I am installing mysql 4.0.1-2 on a Redhat 8.0 workalike. I've installed the MySQL server software, client software, but when I try to install the MySQL-bench...rpm, I get the failed dependencies error, MySQL-DBI-perl-bin is needed. I did a search and found Mysql-DBI-perl-bin-1.1825-1.i386.rpm, and I installed it. But when I rpm -install the MySQL-bench...rpm package I still get a failed dependencies error. Is this a problem caused by Mysql-DBI-perl...rpm) not having capitals in all the right places? I dont understand enough about how rpm works, to troubleshoot this! Can anyone help point me to the right MySQL-DBI-perl...rpm file? thanks, Gale -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql installation problems (RPM errors)
First off to maybe make this easy on you, you do not need the MySQL-bench rpm if you do not plan on using the benchmarking tools. It is an optional install. Otherwise, I do not think rpm cares about capitalization. I believe this problem is discussed in the MySQL manual, and might have the solution, but then I am sure others on this list can help out. Most important thing to remember, is that you don't need benchmarking to run the MySQL server. In the past, I always used a tarball of the perl DBI and it worked fine. Gale Stafford wrote: Hey Folks Hi there! My first post to the list ... I am installing mysql 4.0.1-2 on a Redhat 8.0 workalike. I've installed the MySQL server software, client software, but when I try to install the MySQL-bench...rpm, I get the failed dependencies error, MySQL-DBI-perl-bin is needed. I did a search and found Mysql-DBI-perl-bin-1.1825-1.i386.rpm, and I installed it. But when I rpm -install the MySQL-bench...rpm package I still get a failed dependencies error. Is this a problem caused by Mysql-DBI-perl...rpm) not having capitals in all the right places? I dont understand enough about how rpm works, to troubleshoot this! Can anyone help point me to the right MySQL-DBI-perl...rpm file? thanks, Gale -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation problems with W2K
Hi I'm unclear whether the address I'm using here (referenced on page 29 of the manual) is the correct one but I hope one of them may either get me an answer or a reference to where else I might seek help. DETAILS OS: Windows 2000 Professional, 5.0.2195 SP3 build 2195 MySQL version 4.0.13 for Windows, binary (mysql-4.0.13-win.zip) System: self constructed with AMD750MHz Athlon on Biostar M7MKE system board with VIA VT8371 and Award BIOS v6.00PG; 785,904KB RAM; ATI All-in-Wonder Pro video card; part of an Ethernet LAN on a 192.168.1 subnet, connecting to the internet through a Vigor 2000 router using ISDNe. TCP/IP is installed and working. There are two physical HDD, Disc0 of 12.66GB and Disc1 of 12.64GB. These are divided into logical drives C: (Windows, 2.00GB), D: (programs, 3.00GB), E: (Data, 4.00GB), F: (Backup_Store, 3.65GB) [Disc0], G: (Large_Data, 1.95GB) and F: (Recordings, 10.69GB). There is also a DVD drive designated as Z:. All HDDs are formatted as NTFS. PROBLEM The binary download was unzipped to a temporary file and setup run. This appeared to work correctly and the installation was made to D:\Program Files\MySQL with the data directory being set to e:\MySQL\data (and everything from the original ..\data directory moved to there). I then followed the instructions and created a file My.ini containing the installation address and data location addresses and placed this in C:\winnt. I then followed the instructions in the manual at 2.1.2, brought up a DOS box, changed to the ..\bin directory and entered mysqld --standalone. This gave some disc activity, the cursor moved to the next line and nothing else happened. I was unable to move the cursor or to enter anything further but I could close the command line window. Checking showed that the mysqld process had run for one second and could duly be removed. I have: renamed the my.ini file my.cnf and moved it to c:\ reinstalled from the exisitng zip file redownloaded the zipped binaries and reinstalled moved the ..\data directory back to the default (and duly edited the configuration files) getting in each case identical results. If I run mysqld.exe from the Windows desktop then the command window flashes up briefly and nothing further happens. Suggestions, help or pointers elsewhere here would be much appreciated. Secondly, I'm somewhat unclear (and can find nothing particular relevant on the site or in the manual) as to whether MySQL functions merely as an engine or whether there is an associated UI. That is, can it be used with ordinary desktop clients and, if so how, or is it intended purely for use through appropriate programmed interfaces? Thanks in advance Regards Murdoch Mactaggart mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation problems with W2K
Murdoch Mactaggart , The WINDOWS Environment needs the --console switch in order to output the return of mysqld to DOS commands. Please ref to: http://lists.mysql.com/list.php?list=win32#b my.cnf will never be looked for by the WINDOWS Binary. Return to using my.ini from the C:\%Windows Directory% WinMySqlAdmin is an administration GUI automatically installed in the mysql\bin subdirectory. The 'Control Center', MySQL Control Center, can be downloaded and installed as the Operational GUI. Several Others are available. RE: I'm somewhat unclear (and can find nothing particular relevant on the site or in the manual) as to whether MySQL functions merely as an engine or whether there is an associated UI. That is, can it be used with ordinary desktop clients and, if so how, or is it intended purely for use through appropriate programmed interfaces? That depends on your installation. Your options are explained at the MySQL Products WWW Site page. David M Friscia friscia.rootsweb.com http://friscia.rootsweb.com [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Murdoch Mactaggart [mailto:[EMAIL PROTECTED] Sent: Sunday, June 15, 2003 8:54 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Installation problems with W2K Hi I'm unclear whether the address I'm using here (referenced on page 29 of the manual) is the correct one but I hope one of them may either get me an answer or a reference to where else I might seek help. DETAILS OS: Windows 2000 Professional, 5.0.2195 SP3 build 2195 MySQL version 4.0.13 for Windows, binary (mysql-4.0.13-win.zip) System: self constructed with AMD750MHz Athlon on Biostar M7MKE system board with VIA VT8371 and Award BIOS v6.00PG; 785,904KB RAM; ATI All-in-Wonder Pro video card; part of an Ethernet LAN on a 192.168.1 subnet, connecting to the internet through a Vigor 2000 router using ISDNe. TCP/IP is installed and working. There are two physical HDD, Disc0 of 12.66GB and Disc1 of 12.64GB. These are divided into logical drives C: (Windows, 2.00GB), D: (programs, 3.00GB), E: (Data, 4.00GB), F: (Backup_Store, 3.65GB) [Disc0], G: (Large_Data, 1.95GB) and F: (Recordings, 10.69GB). There is also a DVD drive designated as Z:. All HDDs are formatted as NTFS. PROBLEM The binary download was unzipped to a temporary file and setup run. This appeared to work correctly and the installation was made to D:\Program Files\MySQL with the data directory being set to e:\MySQL\data (and everything from the original ..\data directory moved to there). I then followed the instructions and created a file My.ini containing the installation address and data location addresses and placed this in C:\winnt. I then followed the instructions in the manual at 2.1.2, brought up a DOS box, changed to the ..\bin directory and entered mysqld --standalone. This gave some disc activity, the cursor moved to the next line and nothing else happened. I was unable to move the cursor or to enter anything further but I could close the command line window. Checking showed that the mysqld process had run for one second and could duly be removed. I have: renamed the my.ini file my.cnf and moved it to c:\ reinstalled from the exisitng zip file redownloaded the zipped binaries and reinstalled moved the ..\data directory back to the default (and duly edited the configuration files) getting in each case identical results. If I run mysqld.exe from the Windows desktop then the command window flashes up briefly and nothing further happens. Suggestions, help or pointers elsewhere here would be much appreciated. Secondly, I'm somewhat unclear (and can find nothing particular relevant on the site or in the manual) as to whether MySQL functions merely as an engine or whether there is an associated UI. That is, can it be used with ordinary desktop clients and, if so how, or is it intended purely for use through appropriate programmed interfaces? Thanks in advance Regards Murdoch Mactaggart mailto:[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: MySQL 4.0 Installation Problems
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Sat, 24 May 2003, Egor Egorov wrote: DAVID CLARK [EMAIL PROTECTED] wrote: OK, I messed up. I've been running MySQL 3.23, and I wanted to upgrade to 4.0 so I could use the new boolean functions. So I downloaded the 4.0 RPM, and then tried to install it using -U. I received this message: libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1017-3 libmysqlclient.so.10 is needed by (installed) php-mysql-4.2.2-8.0.7 I already had these files in /usr/lib/mysql, so I tried installing again using --nodeps. Now I can't connect at all, and I've tried both --oldpackage ing and -erase ing with no luck. What can I do to either get 3.23 back and running or get 4.0 working? A dirty trick: 1. Do rpm --upgrade for MySQL-server, MySQL-client, MySQL-devel but not for MySQL-shared. 2. Save /usr/lib/libmysqlclient.so.10* into somewhere 3. Do rpm --erase --force MySQL-shared 4. Do rpm --install MySQL-shared 5. Move saved files back to /usr/lib 6. Run ldconfig as root. In result, you will have the older v10 libs intact for various software. Or you could simply use the newly added MySQL-shared-compat RPM, that already includes both versions of the shared libs... http://www.mysql.com/doc/en/Linux-RPM.html Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE+0woUSVDhKrJykfIRAgkYAJ0VHiRel1eQJOcZ/GxSJvh+1/xGGwCeJBv1 OespXrFlAM9Nj7nOWQT5Pqw= =qm1M -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] I'm having problems installing certain packages on my RH8 distro. I ended up using CPAN to install the DBI, CGI and DBD::mysql perl portions. That solved one set of problems; however, when I try to install the MySQL-MAX and MySQL-SHARED I get the following errors: rpm -Uvh MySQL-shared-4.1.0-0.i386.rpm warning: MySQL-shared-4.1.0-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5error: Failed dependencies: libcrypto.so.0.9.6 is needed by MySQL-shared-4.1.0-0 libssl.so.0.9.6 is needed by MySQL-shared-4.1.0-0 I went to the /lib directory and found libcrypto.so.0.9.6b: ll libcrypto.so* -rwxr-xr-x1 root root 983407 Mar 19 15:07 libcrypto.so.0.9.6b lrwxrwxrwx1 root root 19 May 26 07:04 libcrypto.so.2 - libcrypto.so.0.9.6b The same goes for the libssl: ll libssl.so* -rwxr-xr-x1 root root 224733 Mar 19 15:07 libssl.so.0.9.6b lrwxrwxrwx1 root root 16 May 26 07:04 libssl.so.2 - libssl.so.0.9.6b Is the answer as easy as creating a link to the b files? Thanks for any help, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation problems
Thanks you I didn't see this client as I installed MySQL-MAX from http://www.mysql.com/downloads/mysql-max-3.23.html (no client here) :) instead of http://www.mysql.com/downloads/mysql-3.23.html Best regards and thank you again Sherif - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 23, 2002 6:59 AM Subject: re: Installation problems Sherif, Tuesday, September 24, 2002, 2:16:13 AM, you wrote: SDM I installed it on Redhat Linux 7.3 using MySQL-Max-3.23.52-1.i386.rpm SDM While installation it asked me to change DB root password using mysqladmin SDM I looked for mysqladmin and didn't find it !! not all the files were SDM installed. SDM I looked into the documentation and it said for linux, using RPM, install SDM these 2 files MySQL-VERSION.i386.rpm and MySQL-client-VERSION.i386.rpm SDM I have the rpm for the server but I looked on www.mysql.com for SDM MySQL-client-VERSION.i386.rpm but could not find any RPMs for the client (or SDM any installation files to install clinet) Yes, you need to install MySQL-client-VERSION.i386.rpm, too. Take a look carefully here: http://www.mysql.com/downloads/mysql-3.23.html -- 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 - 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 problems
Hi All, I am new to mySQL. I installed it on Redhat Linux 7.3 using MySQL-Max-3.23.52-1.i386.rpm While installation it asked me to change DB root password using mysqladmin I looked for mysqladmin and didn't find it !! not all the files were installed. I looked into the documentation and it said for linux, using RPM, install these 2 files MySQL-VERSION.i386.rpm and MySQL-client-VERSION.i386.rpm I have the rpm for the server but I looked on www.mysql.com for MySQL-client-VERSION.i386.rpm but could not find any RPMs for the client (or any installation files to install clinet) I feel I am doing something wrong so hope you can help me. Best Regards Sherif - 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 problems
Sherif, Tuesday, September 24, 2002, 2:16:13 AM, you wrote: SDM I installed it on Redhat Linux 7.3 using MySQL-Max-3.23.52-1.i386.rpm SDM While installation it asked me to change DB root password using mysqladmin SDM I looked for mysqladmin and didn't find it !! not all the files were SDM installed. SDM I looked into the documentation and it said for linux, using RPM, install SDM these 2 files MySQL-VERSION.i386.rpm and MySQL-client-VERSION.i386.rpm SDM I have the rpm for the server but I looked on www.mysql.com for SDM MySQL-client-VERSION.i386.rpm but could not find any RPMs for the client (or SDM any installation files to install clinet) Yes, you need to install MySQL-client-VERSION.i386.rpm, too. Take a look carefully here: http://www.mysql.com/downloads/mysql-3.23.html -- 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: Windows XP Installation Problems
Well, I finally figured out the problem, it was a corrupt installation package. Funny thing is I downloaded three different times from different sites. Working now, thanks. -=Bryan=- -Original Message- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 7:22 PM To: Lukoni, Bryan AG:EX; 'Michael Bunzel' Cc: '[EMAIL PROTECTED]' Subject: RE: Windows XP Installation Problems At 16:40 10/9/2002 -0700, Lukoni, Bryan AG:EX wrote: Hi, Thanks Michel: Enabled the error reporting, but no luck. I'm stumped why I am not seeing any error messages when it fails to install. Do you know if the MYSQL installation makes any modifications to the registry or adds files to the system directory. Nothing is copied to registry. If not I could probably just copy the complete directory from the other computer onto a CD and recopy to the problem computer. The above will works. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Windows XP Installation Problems
Thanks, I have the installation files on the HD, not using the CD. I do have admin access to the machine, never had a problem installing programs before. Can you explain how to make XP can run in 16 bit mode. -=Bryan=- -Original Message- From: b.ware [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 5:27 PM To: Lukoni, Bryan AG:EX; '[EMAIL PROTECTED]' Subject: Re: Windows XP Installation Problems If it installed on Pro at home, it should do the same on another pc running Pro.(in a perfect world maybe) try these troubleshooting steps. FIRST: check you Privileges. Make sure you are authorized to install software on the system. 2ND: instead of double clicking the setup.exe, use XP's add software app, and let XP find the setup.exe and auto install it. 3RD: check the settings, i.e. DMA, Disconnect, etc. of the CD Rom Drive you are using to install the software. Some large apps dont install properly due to the CD Drive's buffer not being large enough to handle a continueous feed of data to the HD. 4TH: copy the complete CD to the HD and install from the hard drive, if necessary. 5TH: Try to install it while in 16-bit mode. (XP option) good luck dude... --- Lukoni, Bryan AG:EX [EMAIL PROTECTED] wrote: I am unable to install either version MySQL 4.03 or the release MySQL 3.23 on a XP professional operating system. No error message is produced, double clicking the setup.exe file only produces a flashing hourglass for a second and then nothing, no error messages. Suggestions anyone. Stange thing, is it installed fine on my home computer which is running XP professional. -=Bryan=- - 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 __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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: Windows XP Installation Problems
Hi Bryan, could it be that you deactivated the Windows XP error reporting function? Activate it for the Windows Operating System and All Programs and try installing MySQL again. If an error message occurs the provided data might help you track down the problem... If not don't forget to deactivate it again ;-) -- Michael Bunzel LintraNex Systems Vienna, Austria Lukoni, Bryan AG:EX wrote: I am unable to install either version MySQL 4.03 or the release MySQL 3.23 on a XP professional operating system. No error message is produced, double clicking the setup.exe file only produces a flashing hourglass for a second and then nothing, no error messages. Suggestions anyone. Stange thing, is it installed fine on my home computer which is running XP professional. -=Bryan=- - 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: Windows XP Installation Problems
Thanks Michel: Enabled the error reporting, but no luck. I'm stumped why I am not seeing any error messages when it fails to install. Do you know if the MYSQL installation makes any modifications to the registry or adds files to the system directory. If not I could probably just copy the complete directory from the other computer onto a CD and recopy to the problem computer. -=Bryan=- -Original Message- From: Michael Bunzel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 3:49 PM To: Lukoni, Bryan AG:EX Cc: [EMAIL PROTECTED] Subject: Re: Windows XP Installation Problems Hi Bryan, could it be that you deactivated the Windows XP error reporting function? Activate it for the Windows Operating System and All Programs and try installing MySQL again. If an error message occurs the provided data might help you track down the problem... If not don't forget to deactivate it again ;-) -- Michael Bunzel LintraNex Systems Vienna, Austria Lukoni, Bryan AG:EX wrote: I am unable to install either version MySQL 4.03 or the release MySQL 3.23 on a XP professional operating system. No error message is produced, double clicking the setup.exe file only produces a flashing hourglass for a second and then nothing, no error messages. Suggestions anyone. Stange thing, is it installed fine on my home computer which is running XP professional. -=Bryan=- - 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: Windows XP Installation Problems
At 16:40 10/9/2002 -0700, Lukoni, Bryan AG:EX wrote: Hi, Thanks Michel: Enabled the error reporting, but no luck. I'm stumped why I am not seeing any error messages when it fails to install. Do you know if the MYSQL installation makes any modifications to the registry or adds files to the system directory. Nothing is copied to registry. If not I could probably just copy the complete directory from the other computer onto a CD and recopy to the problem computer. The above will works. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Windows XP Installation Problems
I am unable to install either version MySQL 4.03 or the release MySQL 3.23 on a XP professional operating system. No error message is produced, double clicking the setup.exe file only produces a flashing hourglass for a second and then nothing, no error messages. Suggestions anyone. Stange thing, is it installed fine on my home computer which is running XP professional. -=Bryan=- - 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: Windows XP Installation Problems
If it installed on Pro at home, it should do the same on another pc running Pro.(in a perfect world maybe) try these troubleshooting steps. FIRST: check you Privileges. Make sure you are authorized to install software on the system. 2ND: instead of double clicking the setup.exe, use XP's add software app, and let XP find the setup.exe and auto install it. 3RD: check the settings, i.e. DMA, Disconnect, etc. of the CD Rom Drive you are using to install the software. Some large apps dont install properly due to the CD Drive's buffer not being large enough to handle a continueous feed of data to the HD. 4TH: copy the complete CD to the HD and install from the hard drive, if necessary. 5TH: Try to install it while in 16-bit mode. (XP option) good luck dude... --- Lukoni, Bryan AG:EX [EMAIL PROTECTED] wrote: I am unable to install either version MySQL 4.03 or the release MySQL 3.23 on a XP professional operating system. No error message is produced, double clicking the setup.exe file only produces a flashing hourglass for a second and then nothing, no error messages. Suggestions anyone. Stange thing, is it installed fine on my home computer which is running XP professional. -=Bryan=- - 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 __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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
3.23.51.src.rpm installation problems
I downloaded a copy of MySQL-3.23.51-1.src.rpm to my /home/steve directory. I executed rpm --rebuild MySQL-3.23.51-1.src.rpm When it was finished it performed several wrote commands... according to the quick installation Overview...doc at www.mysql.com/doc/Q/u/Quick_install...para 2.3.1 I need to change to the default directory generated during the rpm rebuild and that directory being...? I cannot find a new directory anywhere on my system named.../mysql- 3.23.51-1 ...whatever. This step is step 6 of the document. NOTE: I did not need to execute gunzip or tar as the file I down loaded was not zipped or tar'ed I hope someone will be able to get me where I need to be. Thanks for the help. Steve - 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 problems on AIX 4.3.3
I have picked up the 3.23.51 binary install and I am getting the same errors as with 3.23.50. What's next? Morris Ford --- Victoria Reznichenko [EMAIL PROTECTED] wrote: Morris, Thursday, June 06, 2002, 6:17:57 AM, you wrote: MF I am having a problem installing version 3.23.50 MF on AIX 4.3.3. When I execute mysql_install_db or MF try to start mysqld I get errors like MF 0509-036 Cannot load program MF ./bin/my_print_defaults because of the following MF errors: [skip] MF I have chased through the mail archives and found MF messages with errors like this but found no fix MF but to try 2.23.50 (the one I am loading). Has MF this been resolved? Any help would be greatly MF appreciated. It's because of our wrong build. It's fixed in 3.23.51 which should be out soon. MF Morris Ford -- 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 __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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: Newbie MySQL installation problems (specific)
Have you tried .../bin/safe_mysqld start to start the DB first? This is what will create /tmp/mysql.sock socket file start the DB server. Then you can use the 'mysql' client for connecting to the DB. Also, if you don't want to use transactional database, meaning, if you don't want support for rollback and stuff, which I am guessing you might not, then you can download the 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc Liyanage's site). Since it's giving errors regarding innodb, my guess is that the server is configured to create inno db tables and not myisam tables, which is what the default binaries/rpm are configured to do (i.e. create myisam tables, but they are non-transactional). Regards, Bhavin. - Original Message - From: Colin Cooler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 3:55 PM Subject: Newbie MySQL installation problems (specific) Buying Paul DuBois' most excellent book MySQL has made me more comfortable with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the web database for a redesigneed site at Right Moves For Youth (trying to keep at risk kids in school). After running his cleanup instructions and then downloading and installing the mysql package from Marc Liyanage's site, I tried to run the following command (as per instructions): sudo ./scripts/mysql_install_db; I then get the following results: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 020609 0:35:05 ./bin/mysqld: Shutdown Complete When I try to start mysql from the command line, I then get the ubiquitous error message: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I also discovered a localhost.err file in my data directory which yields the following information: 020609 01:09:50 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 01:09:52 mysqld ended Finally, when I try the following: mysqladmin -u root status I also get the can't connect through /tmp/myssql.sock error message. No matter what I try, I can't seem to connect to mysql so that I can even BEGIN to figure out how to correct the 1062 problem! Can anyone tell me how to what the ERROR: 1062 message means and how to resolve this mess? I've searched the archives, and this error appears to have occurred occasionally, but being a newbie to MySQL, I can't understand the solutions to the problem. Usually this problem has occurred AFTER someone has been able to successfully connect to mysql. Oh Woe is me, Colin - 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 MySQL installation problems (specific)
Thanks Bhavin, I tried your suggestion (safe_mysqld start) and get a lot of Permission denied errors. So, I su to root and try it, and it appears that it does start (Starting mysqld daemon with databases from /usr/local/mysql/data). However, when I try to connect, either as root (which I understand is not a good idea) or under my normal login, I get the same error, i.e., that the socket can't be found. Very puzzling and I'm quickly approaching the point of concluding that the amount of time trying to troubleshoot this mess not warranting the potential benefits. Colin Have you tried .../bin/safe_mysqld start to start the DB first? This is what will create /tmp/mysql.sock socket file start the DB server. Then you can use the 'mysql' client for connecting to the DB. Also, if you don't want to use transactional database, meaning, if you don't want support for rollback and stuff, which I am guessing you might not, then you can download the 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc Liyanage's site). Since it's giving errors regarding innodb, my guess is that the server is configured to create inno db tables and not myisam tables, which is what the default binaries/rpm are configured to do (i.e. create myisam tables, but they are non-transactional). Regards, Bhavin. - Original Message - From: Colin Cooler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 3:55 PM Subject: Newbie MySQL installation problems (specific) Buying Paul DuBois' most excellent book MySQL has made me more comfortable with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the web database for a redesigneed site at Right Moves For Youth (trying to keep at risk kids in school). After running his cleanup instructions and then downloading and installing the mysql package from Marc Liyanage's site, I tried to run the following command (as per instructions): sudo ./scripts/mysql_install_db; I then get the following results: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 020609 0:35:05 ./bin/mysqld: Shutdown Complete When I try to start mysql from the command line, I then get the ubiquitous error message: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I also discovered a localhost.err file in my data directory which yields the following information: 020609 01:09:50 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 01:09:52 mysqld ended Finally, when I try the following: mysqladmin -u root status I also get the can't connect through /tmp/myssql.sock error message. No matter what I try, I can't seem to connect to mysql so that I can even BEGIN to figure out how to correct the 1062 problem! Can anyone tell me how to what the ERROR: 1062 message means and how to resolve this mess? I've searched the archives, and this error appears to have occurred occasionally, but being a newbie to MySQL, I can't understand the solutions to the problem. Usually this problem has occurred AFTER someone has been able to successfully connect to mysql. Oh Woe is me, Colin - 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 MySQL installation problems (specific)
Ah...give up not for we have been using mysql for quite a long time and it is pretty stable. Try this... instead of trouble shooting this install and getting it work... go to www.mysql.com, download an rpm if you are on Red hat linux (or Mandrake) and do an rpm -i mysql...rpm and rpm -i mysq..client..rpm (this file is for insalling the client). If not, just download the binary and follow the instructions. We haven't had any trouble at all installing mysql and this might be a system specific problem. Let me know how it works out. Regards, Bhavin. - Original Message - From: Colin Cooler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 6:42 PM Subject: Re: Newbie MySQL installation problems (specific) Thanks Bhavin, I tried your suggestion (safe_mysqld start) and get a lot of Permission denied errors. So, I su to root and try it, and it appears that it does start (Starting mysqld daemon with databases from /usr/local/mysql/data). However, when I try to connect, either as root (which I understand is not a good idea) or under my normal login, I get the same error, i.e., that the socket can't be found. Very puzzling and I'm quickly approaching the point of concluding that the amount of time trying to troubleshoot this mess not warranting the potential benefits. Colin Have you tried .../bin/safe_mysqld start to start the DB first? This is what will create /tmp/mysql.sock socket file start the DB server. Then you can use the 'mysql' client for connecting to the DB. Also, if you don't want to use transactional database, meaning, if you don't want support for rollback and stuff, which I am guessing you might not, then you can download the 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc Liyanage's site). Since it's giving errors regarding innodb, my guess is that the server is configured to create inno db tables and not myisam tables, which is what the default binaries/rpm are configured to do (i.e. create myisam tables, but they are non-transactional). Regards, Bhavin. - Original Message - From: Colin Cooler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 3:55 PM Subject: Newbie MySQL installation problems (specific) Buying Paul DuBois' most excellent book MySQL has made me more comfortable with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the web database for a redesigneed site at Right Moves For Youth (trying to keep at risk kids in school). After running his cleanup instructions and then downloading and installing the mysql package from Marc Liyanage's site, I tried to run the following command (as per instructions): sudo ./scripts/mysql_install_db; I then get the following results: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 020609 0:35:05 ./bin/mysqld: Shutdown Complete When I try to start mysql from the command line, I then get the ubiquitous error message: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I also discovered a localhost.err file in my data directory which yields the following information: 020609 01:09:50 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 01:09:52 mysqld ended Finally, when I try the following: mysqladmin -u root status I also get the can't connect through /tmp/myssql.sock error message. No matter what I try, I can't seem to connect to mysql so that I can even BEGIN to figure out how to correct the 1062 problem! Can anyone tell me how to what the ERROR: 1062 message means and how to resolve this mess? I've searched the archives, and this error appears to have occurred occasionally, but being a newbie to MySQL, I can't understand the solutions to the problem. Usually this problem has occurred AFTER someone has been able
Re: Installation problems on AIX 4.3.3
Borus, Thanks for responding. I am attempting to install a binary release not build from source. Do you have any information regarding the errors in my original post? Thanks Morris Ford --- é¾?æf æ¨?(Borus.Kung) [EMAIL PROTECTED] wrote: FYI this may help Borus - Original Message - å¯?件è??: Morris Ford [EMAIL PROTECTED] æ?¶ä»¶è??: [EMAIL PROTECTED] å,³é??æ-¥æ?Y: 2002å¹´6æ?^6æ-¥ AM 11:17 主æ-¨: Installation problems on AIX 4.3.3 I am having a problem installing version 3.23.50 on AIX 4.3.3. When I execute mysql_install_db or try to start mysqld I get errors like 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-130 Symbol resolution failed for my_print_defaults because: 0509-136 Symbol stpcpy (number 45) is not exported from dependent module /usr/lib/libc.a(shr.o) 0509-136 Symbol strnlen (number 46) is not exported from dependent module /usr/lib/libc.a(shr.o) I have chased through the mail archives and found messages with errors like this but found no fix but to try 2.23.50 (the one I am loading). Has this been resolved? Any help would be greatly appreciated. Morris Ford __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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 ATTACHMENT part 2 message/rfc822 name=Re_ Bug_ -_ AIX 4.3.3 ML10, IBM C_C++ 5.0.2.eml From: é¾?æf æ¨?(Borus.Kung) [EMAIL PROTECTED] To: morgan henning [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Bug? - AIX 4.3.3 ML10, IBM C/C++ 5.0.2 Date: Tue, 21 May 2002 09:17:14 +0800 I encountered the same problem, then I simply commented the line in the system header file curses.h. but the error I got is a bit different, it said: declaration is not declaring anything something like this... another header I modified is the pthread.h but there is a problem with the AIX version, MySQL cannot shutdown I must use kill -9 [PID] to kill the safe_mysqld script and mysql processes. my AIX version is 4.3.3 but the good news is the binary compiled in 4.3.3 machine can run in 4.3.1 my way is absolutely not good, but it seems work. I used this to configure: CC=gcc CXX=gcc CXXFLAGS=-O3 ./configure --prefix=/mysql/mysql \ --with-extra-charsets=complex --with-low-memory and you? Borus - Original Message - å¯?件è??: morgan henning [EMAIL PROTECTED] æ?¶ä»¶è??: [EMAIL PROTECTED] å,³é??æ-¥æ?Y: 2002å¹´5æ?^21æ-¥ AM 08:49 主æ-¨: Bug? - AIX 4.3.3 ML10, IBM C/C++ 5.0.2 Hi. I am trying to build MySQL 3.23.49, and I am having some problems. If anyone has any suggestions, they would be **much** appreciated :) I have tried to compile MySQL 3.23.49 a couple of ways under AIX, and I have gotten this twice (more info below): xlC -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -Wa,-many -DUNDEF_HAVE_INITGROUPS -DSIGNALS_DONT_BREAK_READ -c mysql.cc /usr/include/curses.h, line 1751.14: 1540-0063 (S) The text bool is unexpected. gmake[2]: *** [mysql.o] Error 1 gmake[2]: Leaving directory `/home/morgan/mysql-3.23.49/client' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/home/morgan/mysql-3.23.49' gmake: *** [all-recursive-am] Error 2 I got this on both AIX 4.3.3 (maintenance level 10 applied), and AIX 5.1.0 (maintenance level 2 applied). Both times I got the error, I was using the IBM C Compiler v5.0.2 and IBM C++ Compiler v5.0.2 (Visual Age C++ packages). The configure command line was CC=xlc CXX=xlC ./configure --prefix=/opt/mysql. I am using GNU make 3.79.1. The machine both times was an RS6000 43P-132 (type 7248-132). I can provide all kinds of more information if you like :) I tried gcc-3.0.4, but that failed also, although I forget the exact error. I am build gcc-2.95.3 in an effort to try the recommended gcc now. Nothing on that front yet. Am I just missing something with IBM C/C++ ?? The compiler is not patched to the latest level, although I can patch it. It's just a big download ( 500 MB). Please advise if you think that's the solution. Thanks!! :) -- Morgan Henning [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
Re: Installation problems on AIX 4.3.3
Morris, Thursday, June 06, 2002, 6:17:57 AM, you wrote: MF I am having a problem installing version 3.23.50 MF on AIX 4.3.3. When I execute mysql_install_db or MF try to start mysqld I get errors like MF 0509-036 Cannot load program MF ./bin/my_print_defaults because of the following MF errors: [skip] MF I have chased through the mail archives and found MF messages with errors like this but found no fix MF but to try 2.23.50 (the one I am loading). Has MF this been resolved? Any help would be greatly MF appreciated. It's because of our wrong build. It's fixed in 3.23.51 which should be out soon. MF Morris Ford -- 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
Installation problems on AIX 4.3.3
I am having a problem installing version 3.23.50 on AIX 4.3.3. When I execute mysql_install_db or try to start mysqld I get errors like 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-130 Symbol resolution failed for my_print_defaults because: 0509-136 Symbol stpcpy (number 45) is not exported from dependent module /usr/lib/libc.a(shr.o) 0509-136 Symbol strnlen (number 46) is not exported from dependent module /usr/lib/libc.a(shr.o) I have chased through the mail archives and found messages with errors like this but found no fix but to try 2.23.50 (the one I am loading). Has this been resolved? Any help would be greatly appreciated. Morris Ford __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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 problems on freebsd
I have started all over again on a fresh Freebsd installation. I have all the files in my /usr/local/mysql directory and I run Scripts/mysql_install_db After that I take the following action $ chown -R root /usr/local/mysql $ chgrp -R mysql /usr/local/mysql $ chown -R mysql /usr/local/mysql/data Than something happens that I don't really understand When I run bin/safe_mysqld -user=mysql The daemon starts followed by the message that mysqld ended. This does not seem to happen when I run bin/safe_mysqld . I don't know the difference but the service keeps on running with the latter I have copied support-files/mysql.server to /usr/local/etc/rc.d (the startup directory) but when I reboot I have to start mysqld manual again The ./bin/mysqladmin -p password does not seem to let me update the password. Any ideas? Cheers -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, 6 May 2002 8:27 a.m. To: Defryn NZ Cc: [EMAIL PROTECTED] Subject: Re: installation problems on freebsd On Mon, May 06, 2002 at 08:12:30AM +1200, Defryn NZ wrote: Is /tmp/mysql.sock missing after you start the MySQL server using `bin/safe_mysqld'? When I run bin/safe_mysqld I get the message that it is unable to connect to 'hostname' through /tmp/mysql.sock and that it is missing That's really strange. Starting a MySQL server shouldn't ever result in it attempting to contact itself via /tmp/mysql.sock. It sounds like something is rather messed up in your configuration. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 87 days, processed 2,267,702,000 queries (300/sec. avg) - 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 problems on freebsd
Is /tmp/mysql.sock missing after you start the MySQL server using `bin/safe_mysqld'? When I run bin/safe_mysqld I get the message that it is unable to connect to 'hostname' through /tmp/mysql.sock and that it is missing Cheers - 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 problems on freebsd
On Mon, May 06, 2002 at 08:12:30AM +1200, Defryn NZ wrote: Is /tmp/mysql.sock missing after you start the MySQL server using `bin/safe_mysqld'? When I run bin/safe_mysqld I get the message that it is unable to connect to 'hostname' through /tmp/mysql.sock and that it is missing That's really strange. Starting a MySQL server shouldn't ever result in it attempting to contact itself via /tmp/mysql.sock. It sounds like something is rather messed up in your configuration. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 87 days, processed 2,267,702,000 queries (300/sec. avg) - 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 problems on freebsd
I have been trying to install mysql on my freebsd box but it won't work. When I use a freebsd package it works but it does not put it where I want it. It seems like there is little control over it The freebsd package is also an older version (3.23.42) I have downloaded the binary for freebsd from the mysql website. I followed the instructions from the o'reilly book ,the mysql manual and the php/mysql web applications. Everything seems to work until I run ./mysqladmin or I want to start mysql. I get the error that /tmp/mysql.sock cannot be found. I can't see it there either. It was there when installed it as a package Any ideas? Guy - 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 problems on freebsd
On Sun, May 05, 2002 at 04:02:44PM +1200, Defryn NZ wrote: I have been trying to install mysql on my freebsd box but it won't work. When I use a freebsd package it works but it does not put it where I want it. It seems like there is little control over it The freebsd package is also an older version (3.23.42) I have downloaded the binary for freebsd from the mysql website. I followed the instructions from the o'reilly book ,the mysql manual and the php/mysql web applications. Everything seems to work until I run ./mysqladmin or I want to start mysql. I get the error that /tmp/mysql.sock cannot be found. I can't see it there either. It was there when installed it as a package Is /tmp/mysql.sock missing after you start the MySQL server using `bin/safe_mysqld'? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 86 days, processed 2,253,883,132 queries (301/sec. avg) - 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 problems
I purchased a book entitled PHP3 programming browser-based Applications it came with a cd that contained a copy of MySql-3.22.16a-gamma for any linux distribution. Anyhow, I am having problems installing the software on my SuSe 7.1 linux box. Basically, there are eleven steps that the author david medinets requires in order to properly install the software, but of those eleven, I am having problems with step 8. From root directory linux: ~ # - 1 cd /usr/local/src/mysql-3.22.16a-gamma 2 ./configure --prefix=/usr/local/mysql 3 make 4 make install 5 echo /usr/local/mysql/lib/mysql /etc/ld.so.conf 6 ldconfig -v | grep libmysqlclient 7 echo /usr/local/mysql/bin/safe_mysqld /dev/null /etc/rc.d/rc.local 8 ./scripts/mysql_install_db 9 /usr/local/mysql/bin/safe_mysqld /dev/null 10 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql 11 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysqlshow after this, the author gives you a sample code to test the database. _ step 8 after entering this at the prompt: linux: usr/local/src/mysql-3.22.16a-gamma # ./scripts/mysql_install_db an error message ( did'nt find /usr/local/mysql/libexec/mysql ) ( You should do a make install before executing this script ) I tryed to run the sample code with out this being installed correctly, but no luck. I would really like any help from anyone on solving this problem. As far as libexec not be found, well there is a lib directory with a subdirectory of mysql. Why its looking for libexec? Well, I simply don't know. Thanks [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
Post installation problems in MySQL
srividya, Friday, March 22, 2002, 9:55:50 PM, you wrote: ss I installed the binary version of (MySQL) ss mysql-3.23.49a-pc-linux-gnu-i686.tar.gz. ss The steps followed to install are: ss tar xvzf mysql-3.23.49a-pc-linux-gnu-i686.tar.gz. ss cd mysql-3.23.49a-pc-linux-gnu-i686 ss ./configure ss scripts/mysql_install_db ss cp support-files/my_medium.cnf/etc/my.cnf ss ./bin/safe_mysqld ss After installing, I tried to start mysqld daemon using the command ss ./bin/safe_mysqld. The message obtained is given below. ss Starting mysqld daemon with the databases from ss /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data ss 020322 13:31:50 mysqld ended ss Then directly I tried to start the mysqld with the command ./bin/mysqld ss In this case the error message obtained is: ss ./bin/mysqld: Fatal error: Can't find message file ss '/usr/local/mysql/share/mysql/english/errmsg.sys' ss Actually the errmsg.sys file is located in the path ss '/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/share/mysql/english/errmsg.sys' ss and not in '/usr/local/mysql/share/mysql/english/errmsg.sys'. You should specify path to your message file using '--language' option of mysqld: safe_mysqld --language=/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/share/mysql/english ss I need help to resolve this problem ss Thanks ss -Sri -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Post installation problems in MySQL
Or simply create a symbolic link as suggested in the documentation: ln -s /usr/local/mysql-3.23.49a-pc-linux-gnu-i686 /usr/local/mysql cd /usr/local/mysql ./bin/safe_mysqld -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 2:46 AM To: [EMAIL PROTECTED] Subject: Post installation problems in MySQL srividya, Friday, March 22, 2002, 9:55:50 PM, you wrote: ss I installed the binary version of (MySQL) ss mysql-3.23.49a-pc-linux-gnu-i686.tar.gz. ss The steps followed to install are: ss tar xvzf mysql-3.23.49a-pc-linux-gnu-i686.tar.gz. ss cd mysql-3.23.49a-pc-linux-gnu-i686 ss ./configure ss scripts/mysql_install_db ss cp support-files/my_medium.cnf/etc/my.cnf ss ./bin/safe_mysqld ss After installing, I tried to start mysqld daemon using the command ss ./bin/safe_mysqld. The message obtained is given below. ss Starting mysqld daemon with the databases from ss /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data ss 020322 13:31:50 mysqld ended ss Then directly I tried to start the mysqld with the command ss ./bin/mysqld In this case the error message obtained is: ss ./bin/mysqld: Fatal error: Can't find message file ss '/usr/local/mysql/share/mysql/english/errmsg.sys' ss Actually the errmsg.sys file is located in the path ss '/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/share/mysql/english/err ss msg.sys' ss and not in '/usr/local/mysql/share/mysql/english/errmsg.sys'. You should specify path to your message file using '--language' option of mysqld: safe_mysqld --language=/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/share/mysql/engli sh ss I need help to resolve this problem ss Thanks ss -Sri -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Post installation problems in MySQL
Sir/Madam I installed the binary version of (MySQL) mysql-3.23.49a-pc-linux-gnu-i686.tar.gz. The steps followed to install are: tar xvzf mysql-3.23.49a-pc-linux-gnu-i686.tar.gz. cd mysql-3.23.49a-pc-linux-gnu-i686 ./configure scripts/mysql_install_db cp support-files/my_medium.cnf/etc/my.cnf ./bin/safe_mysqld After installing, I tried to start mysqld daemon using the command ./bin/safe_mysqld. The message obtained is given below. Starting mysqld daemon with the databases from /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data 020322 13:31:50 mysqld ended Then directly I tried to start the mysqld with the command ./bin/mysqld In this case the error message obtained is: ./bin/mysqld: Fatal error: Can't find message file '/usr/local/mysql/share/mysql/english/errmsg.sys' Actually the errmsg.sys file is located in the path '/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/share/mysql/english/errmsg.sys' and not in '/usr/local/mysql/share/mysql/english/errmsg.sys'. I need help to resolve this problem Thanks -Sri - 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 Problems
I'm having trouble with the installation of MySQL. The database was installed on the C drive. After installation, I performed the following tests to ensure that the database was properly installed: I execute the mysqlshow command and the names of the test and mysql databases were displayed. The errors at the bottom of this message were generated in Windows NT 4.0 (Service Pack 6) after just rebooting Windows three or four times. I never executed mysqld. I read the documentation at the following URL: http://www.mysql.com/doc/C/o/Communication_errors.html. But it did not help. I would appreciate any help with this problem. MySql: ready for connections 011218 13:10:54 MySql: Shutdown Complete 011218 13:10:54 MySql: Normal shutdown 011218 13:10:34 Aborted connection 1 to db: 'unconnected' user: 'ODBC' host: `localhost' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html MySql: ready for connections 011215 18:21:43 MySql: Shutdown Complete 011215 18:21:43 MySql: Normal shutdown 011215 18:21:42 Aborted connection 1 to db: 'unconnected' user: 'ODBC' host: `localhost' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html MySql: ready for connections 011215 12:17:26 MySql: Shutdown Complete - 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 Problems
At 16:46 12/01/02 -0800, Mark Peterson wrote: I'm having trouble with the installation of MySQL. The database was installed on the C drive. cut Please follow the steps below: - The instructions below assume that you have opened a prompt screen at c:\mysql\bin directory. - After a boot, open the Task Manager (ALT+CTRL+DEL) and verify if exists a process for an MySQL server (mysqld.exe, mysqld-max.exe, mysqld-nt.exe, mysqld-max-nt.exe, mysqld-opt.exe). If yes, stop it with the following command at the prompt: net stop mysql (if the server was started as service) or mysqladmin shutdown (if the server was started as standalone mode). For NT server is necessary to make twice this command due a bug which should be fixed in the next release. - If you had installed the service before, type the command: mysqld-max-nt --remove - Type: mysqld-max-nt --install - Go to c:\winnt directory and create a file named my.ini. Edit the lines below: [mysqld] basedir=c:\mysql datadir=c:\mysql\data skip-innodb Save the file and close it. - Start the server: net start mysql NOTE If you want the support of InnoDB tables (I recommend to test), you should need to read the Manual and remove the line skip-innodb from the my.ini file. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ARGH! Installation Problems
A novice-level question... i've just installed the binary version of mySQL 4.0.1-Max for darwin ... but gives me the following error when i try to run the mysql_install_db script: sorry the host 'myhostname' could not be looked up. .etc. hints? - 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
New binary installation problems.
For some reason the binary install install of mysql on redhat linux is putting the database files in /var/lib/mysql instead of /usr/local/mysql/data. The data dir is present and holds mysql and test databases, but when we populated the data base the new databases where put into /var/lib/mysql. Will this cause problems? If so how can we change the default data directory to /usr/local/mysql/data? Any assistance would be greatly appreciated. Please reply to [EMAIL PROTECTED] Thanks very much. David Hudgins Code 935 System Administrator NASA Goddard Space flight center Code 935 Bld 28 Rm 196a Greenbelt MD 20771 [EMAIL PROTECTED]
Re: New binary installation problems.
On Wed, Dec 05, 2001 at 04:28:58PM -0500, David Hudgins wrote: : For some reason the binary install install of mysql on redhat linux is : putting the database files in /var/lib/mysql instead of : /usr/local/mysql/data. The data dir is present and holds mysql and test : databases, but when we populated the data base the new databases where put : into /var/lib/mysql. Will this cause problems? If so how can we change the : default data directory to /usr/local/mysql/data? Any assistance would be : greatly appreciated. Please reply to [EMAIL PROTECTED] Thanks very much. That's just how redhat does things. They're crazy like that. They also have more money than you or I, so they can do what they please. You should have an /etc/my.cnf file. You can edit the location of various files/directories in that file. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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
AIX Binary Installation Problems
Right, It seems to be good to be tried but your server is down I thing. -- Cyrille Bollu - Software Development Engineer AWTCE - Navigation Department Tel. +32 2 389 25 14 Fax. +32 2 389 12 13 mailto:[EMAIL PROTECTED] I haven't read through any of the MySQL mailing lists in a while. Now that I do I see that lots of the AIX related questions involve problems with /usr/local/lib/libz.a as part of the ZLib compression library. The pre-compiled ZLib on http://www.bull.de/pub/ fails for me with the [shr.o] missing problems others have spoken of, etc... What I did was to download the source for ZLib and compile/install it and MySQL works just fine now. So, if it will help anyone the libz.a file which is working fine for me is downloadable at: http://216.98.81.199/libz.a I'd install zlib-1.1.3.2.exe from the Bull AIX Binary site and then replace libz.a with this one. Have done so on a half dozen machines and it's running fine everywhere. ... You're welcome - 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
AIX Binary Installation Problems
Hi dear mysql-users, Just to inform you that this solution still works (today the 21th november 2001). Just note that the address has changed to http://216.184.67.245/libz.a Regards, Cyrille mailto:[EMAIL PROTECTED] I haven't read through any of the MySQL mailing lists in a while. Now that I do I see that lots of the AIX related questions involve problems with /usr/local/lib/libz.a as part of the ZLib compression library. The pre-compiled ZLib on http://www.bull.de/pub/ fails for me with the [shr.o] missing problems others have spoken of, etc... What I did was to download the source for ZLib and compile/install it and MySQL works just fine now. So, if it will help anyone the libz.a file which is working fine for me is downloadable at: http://216.98.81.199/libz.a I'd install zlib-1.1.3.2.exe from the Bull AIX Binary site and then replace libz.a with this one. Have done so on a half dozen machines and it's running fine everywhere. ... You're welcome - 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 Problems - HP-UX 10.20
We have exactly the same problems running ./scripts/mysql_install_db. Did you already come to a solution? Please let me know how you solved this . -- Nancy - 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 Problems - HP-UX 10.20
When I run ./scripts/mysql_install_db I get the following error message, any help resolving this issue would be greatly appreciated. /usr/local/mysql # ./scripts/mysql_install_db 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[292]: 12773 Memory fault(coredump) Installation of grant tables failed! -- Eric White System Administrator [EMAIL PROTECTED] http://www.open.org/community.html - 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: Win98 Installation problems
Mathew, if you do not want to use transactional InnoDB tables, add skip-innodb to the [mysqld] section of your my.cnf or my.ini. However, your startup parameters for InnoDB look right. If you have created the directories \ibdata and \iblogs, it should start (unless you are using mysqld.exe in 3.23.38 which was compiled with __NT__ defined, in which case you should use mysqld-max.exe). Maybe you have several my.cnf or my.ini files in C:\ or the system directories, and one is overshadowing the other? Regards, Heikki http://www.innodb.com Hello, I am having a problem installing mysql on Win98. I am getting an error mesage when trying to start the serversomething to do with the innodb_data_file_path I have the following in a my.cnf file off of c: innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 i have no idea what I'm supposed to be doing with innodbis it possible to disable it? Any help would be most appreciated... thanks, Mathew --- - - 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: Win98 Installation problems
Mathew: Under the [mysqld] section of c:\my.cnf, make sure there is a line that reads: skip-innodb Unless, of course, you intend to use innodb. Since you are new with MySQL, there are some excellent resources you should check before posting ... http://www.mysql.com/manual.php (the manual), and http://lists.mysql.com/ (the list archive). Gerald Jensen - Original Message - From: Mathew Hamilton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, September 01, 2001 8:49 PM Subject: RE: Win98 Installation problems Hello, I am having a problem installing mysql on Win98. I am getting an error mesage when trying to start the serversomething to do with the innodb_data_file_path I have the following in a my.cnf file off of c: innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 i have no idea what I'm supposed to be doing with innodbis it possible to disable it? Any help would be most appreciated... thanks, Mathew - 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: Win98 Installation problems
Hello, I am having a problem installing mysql on Win98. I am getting an error mesage when trying to start the serversomething to do with the innodb_data_file_path I have the following in a my.cnf file off of c: innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 i have no idea what I'm supposed to be doing with innodbis it possible to disable it? Any help would be most appreciated... thanks, Mathew - 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 Problems on Solaris 8 box
I have been trying to install Mysql on a Solaris 8 box. Would anyone know what I need to install prier to installing Mysql??? The Solaris box is a fresh install. Thanks in advance, [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
Newbie installation problems with Apache/MySQL/PHP under Linux
Rather than tell me my question is too far off-topic from MySQL list, would you please suggest another list that you know of? Thanks, but if you are willing to help, here is my problem: I'm attempting to get Apache, MySQL, and PHP working together on a RedHat Linux system that I have total control of. My PHP fasteasy book by Meloni and its associated CD-ROM have been anything but fasteasy. MySQL and Apache installations go beautifully. It's not till I try to rebuild PHP to use MySQL and to work with Apache as a dynamic server object (DSO) that everything falls apart. I've tried numerous distributions/versions, source versus RPMs, and every FAQ suggestion that I can find. Here is my latest error, and one that has surfaced under several variations of installations I've tried: After error-free rebuilds and installations of MySQL, Apache, and PHP, I attempt to restart apache (it worked before rebuilding PHP) using ./sbin/apachectl start command. I get this error message: Syntax error on line 26 of /usr/local/apache_1.3.3/etc/httpd.conf: Cannot load /usr/local/apache_1.3.3/libexec/libphp4.so int server: /usr/local/apache_1.3.3/libexec/libphp4so: undefined symbol: uncompress. ./sbin/apachectl start: httpd could not be started Line 26 just tells location of libphp4.so file. It's where it's supposed to be and seems OK except that it appears to have one (or more?) unresolved symbols. * Do I need to locate a pre-built version of libphp4.so and download it? If so, where might I find that? * Do I need to learn to rebuild libphp4.so from its source? If so, where might I learn to do that? And how come *I* need to do this when (according to PHP book and FAQs) other persons trying the same thing apparently don't have to do it? I know I'm going to love MySQL if I can just get it to start working with Apache and PHP. I would deeply appreciate any help you could offer. Thanks in advance! Kelly D. Carter // Director, Web Management Mercer University // Langdale // 1400 Coleman Avenue // Macon, GA 31207 478-301-5525 voice // 478-301-2313 fax [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: Solaris Installation problems
I think I remember getting around it by installing binutils from the GNU site. That's generaly the problem with solaris. Open source is GNU centric, Solaris prior to 2.8 is definately NOT. EXT-Chung, Kenneth wrote: Thanks. I got the gtar from the download page. Now I have unpacked it with mysql-3.23.37-sun-solaris2.7-sparc directory But I have another problems with running scripts/mysql_install_db % scripts/mysql_install_db ld.so.1: ./bin/my_print_defaults: fatal: libcrypt_i.so.1: open failed: No such file or directory ld.so.1: ./bin/mysqld: fatal: libcrypt_i.so.1: open failed: No such file or directory Killed Installation of grant tables failed! Looks like I am missing a libcrypt_i.so.1, where am I supposed to get it ? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Solaris Installation problems
Thanks. I got the gtar from the download page. Now I have unpacked it with mysql-3.23.37-sun-solaris2.7-sparc directory But I have another problems with running scripts/mysql_install_db % scripts/mysql_install_db ld.so.1: ./bin/my_print_defaults: fatal: libcrypt_i.so.1: open failed: No such file or directory ld.so.1: ./bin/mysqld: fatal: libcrypt_i.so.1: open failed: No such file or directory Killed Installation of grant tables failed! Looks like I am missing a libcrypt_i.so.1, where am I supposed to get it ? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AIX Binary Installation Problems
I haven't read through any of the MySQL mailing lists in a while. Now that I do I see that lots of the AIX related questions involve problems with /usr/local/lib/libz.a as part of the ZLib compression library. The pre-compiled ZLib on http://www.bull.de/pub/ fails for me with the [shr.o] missing problems others have spoken of, etc... What I did was to download the source for ZLib and compile/install it and MySQL works just fine now. So, if it will help anyone the libz.a file which is working fine for me is downloadable at: http://216.98.81.199/libz.a I'd install zlib-1.1.3.2.exe from the Bull AIX Binary site and then replace libz.a with this one. Have done so on a half dozen machines and it's running fine everywhere. ... You're welcome - 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: ZipSlack 486 installation problems
MY PROBLEMS SO FAR All versions of MySQL I have tried so far have come in RPM format which I have rpm2targz to set up. Then I have gunzip/tar or tar xzf to unpack the archive. The archive unpacks in different folders to those that the scripts expect and this is a problem for a start. Also some files seem to be missing, in particular mysql.sock . In summary, I am not sure if this unpacking process is working correctly and maybe this explains my problems. I've compiled several 3.23.36 on Slackware 7.1.0 without any problem at all. I don't like RPM stuff.. always compile from source. Missing mysql.sock is caused by settings in /etc/my.cnf (of the top of my head). Or by rights issues (not correct user/group) or cause it's just not running. Nice tutor on www.devshed.com Bye, B. - 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
ZipSlack 486 installation problems
Hi, I am trying to set up Mysql on the following system (its only a test bed for home useage, for a small scale internet based project) Ideally, this system will be a MySQL, Apache, PHP setup. Low powered I know, but I am assured possible and OK for my purposes Proc: 486 DX2 66 Mem: 40MB HD: 8.4GB Linux: Slackware 7.1- ZipSlack to be more exact MY QUESTION I WOULD LIKE TO KNOW WHAT OTHER USERS RECOMMEND FOR SUCH A SETUP. WHAT VERSIONS TO USE AND SO FORTH. I am having big problems and although I have looked at the scripts etc and changed paths, I can not get the system up and running. I would say I am a beginner at these sysadmin jobs and therefore any advice would be welcome. MY PROBLEMS SO FAR All versions of MySQL I have tried so far have come in RPM format which I have rpm2targz to set up. Then I have gunzip/tar or tar xzf to unpack the archive. The archive unpacks in different folders to those that the scripts expect and this is a problem for a start. Also some files seem to be missing, in particular mysql.sock . In summary, I am not sure if this unpacking process is working correctly and maybe this explains my problems. MYSQL_INSTALL_DB fails to create the grant tables When I setup in an alternative fashion mysql_install_db works, I then find that I can not find the mysql.sock. All advice is welcome.. Duncan - 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 problems on sparc-sun-solaris8
I downloaded the solaris 8 mysql package from ftp://ftp.sunfreeware.com/pub/freeware/sparc/8/mysql-3.22.26a-sol8-sparc-local.gz and installed it, but when i try to run /usr/local/mysql/bin/safe_mysqld, it reports the following error to /usr/local/mysql/var/wakko.err: mysqld started on Thu Apr 12 15:29:39 PDT 2001 ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.2.10.0: open failed: No such file or directory mysqld ended on Thu Apr 12 15:29:39 PDT 2001 any idea how to fix this? i tried looking for the libstdc++.so.2.10.0 library, but to no avail. Should i compile mysql from scratch or look more for the library. any ideas/experiences would be greatly appreciated. thanks, ethan [EMAIL PROTECTED]
Installation problems
I have installed MySQL on Linux Redhat 7.0. When I try and run a MySQL command, I get the following error: "Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)" What can I do to rectify this? Rudi von Fintel N Dip Electrical Engineering Light Current Sugar Milling Research Institute Durban (tel) 031 2616882 ext 210 (fax) 031 2616886 - 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 problems
Hi You need to start the server first, using the safe_mysqld daemon -Original Message- From: Rudi von Fintel [mailto:[EMAIL PROTECTED]] Sent: 26 January 2001 13:30 To: [EMAIL PROTECTED] Subject: Installation problems I have installed MySQL on Linux Redhat 7.0. When I try and run a MySQL command, I get the following error: "Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)" What can I do to rectify this? Rudi von Fintel N Dip Electrical Engineering Light Current Sugar Milling Research Institute Durban (tel) 031 2616882 ext 210 (fax) 031 2616886 - 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