PostgreSQL or mySQL
Hello List: I hope my question does not start war of the posts. This question is genuine. Please answer objectively: I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS, DNS, Apache, (mySQL PostgreeSQL), PHP, Postfix, etc. This Master Server will have all the software I we need for our operation. We will copy MS to each server and setup a load balancing servers. I have very little knowledge of either PostgreeSQL or mySQL. Please advise me as to which of these two software package to use? I need some specific examples as to superiority of one package over the other. I prefer using the package which has a goof GUI database design. Please help. I am posting this message to both lists. I am specifically interested in opinion of system analysts who have used both of these packages. Thanks. Kirti
RE: Low-end SATA vs. SCSI
Which SATA drive works under LINUX O/S? Kirti -Original Message- From: Larry Lowry [mailto:[EMAIL PROTECTED] Sent: Friday, November 12, 2004 4:06 PM To: Fagyal Csongor; [EMAIL PROTECTED] Subject: Re: Low-end SATA vs. SCSI For cost reasons I use SATA. Does the machine already have a SCSI card in it? If so I would use SCSI. If not I would give one of the newer 10k SATA drives a spin. Larry - Original Message - From: Fagyal Csongor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 12, 2004 12:03 PM Subject: Low-end SATA vs. SCSI Hi List, I am putting in a separate disk for our MySQL (4.1.7) server. I have some MyISAM, some InnoDB tables. Lots of reads, lots of writes (mostly atomic ones, insert/update one row), a few million rows per table, approx. 100-400 queries per second. What would you say is better (with respect to performance): a small SCSI disk (say 18G, 10kRPM) or a bigger SATA (say 120G, 7200RPM)? Thank you for your feeback, - Csongor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: RAID Question
Paul: Thank you for your response. Another question: Would it cause a problem if I configure --with-raid and then never use it in any programming? Will it add any overhead? It would help if this feature is available for future use. Thanks 2nd time. Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 10, 2004 8:18 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: RE: RAID Question At 15:19 -0500 11/10/04, Kirti S. Bajwa wrote: Hello List: System: RH9, MySQL 4.1.7 I am in the process of re-setting up (I have test setup 4-5 times) a data server with the above software. This server consists of 2-CPU (Intel) RAID-1, 1-40GB IDE HDD for O/S 2-250GB IDE HDD for storing data. 250 GB IDE HDD are mirrored (RAID-1). Previously, I setup RAID while setting up RH9. Recently, while reviewing the MySQL, documentation, I noticed the following directive for configure command: # ./configure -prefix=/usr/local/mysql -with-raid While researching on GOOGLE, I did find quite a bit of information on MySQL RAID HOWTO search, but nothing to answer my question. Can someone explain how the aboce directive in configure works? In my setup, do I need the above directive as shown? It doesn't have anything to do with hardware raid. It enables support for the RAID table options that allow you to split the data file for MyISAM tables into several files. See the description for RAID_TYPE, RAID_CHUNKS, and RAID_CHUNKSIZE options at: http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- 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: RAID Question
Hello List: System: RH9, MySQL 4.1.7 I am in the process of re-setting up (I have test setup 4-5 times) a data server with the above software. This server consists of 2-CPU (Intel) RAID-1, 1-40GB IDE HDD for O/S 2-250GB IDE HDD for storing data. 250 GB IDE HDD are mirrored (RAID-1). Previously, I setup RAID while setting up RH9. Recently, while reviewing the MySQL, documentation, I noticed the following directive for configure command: # ./configure prefix=/usr/local/mysql with-raid While researching on GOOGLE, I did find quite a bit of information on MySQL RAID HOWTO search, but nothing to answer my question. Can someone explain how the aboce directive in configure works? In my setup, do I need the above directive as shown? Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Configure Statement
Hello: While reading Red Hat / Apache 2 + SSL /PHP /mySQL http://www.suteki.nu/howto.html, I came across the following configure state (Page 3 Section 2): ./configure --with-openssl --with-isam --prefix=/usr/local/mysql As you all know this configures the mySQL. My question is; what does --with-openssl does? Why it is needed? How when it becomes useful? This is a handful of a question but I sure like to learn!! Hope somebody give a clear (with example if possible) answer. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Clean Reinstall
I do not know if this is the right way or not but this is how I have done it: Delete Mysql-Version folder, from where you installed MySQL. It is normally in '/usr/local' folder. Then re-install MySQL. Hope it works. Kirti -Original Message- From: FayeC SQL [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 12:39 PM To: MySQL List Subject: Clean Reinstall I am extremely frustrated with the root passwordproblem. I read the manual and followed the instructions but it just won't work. I tried setting a newpassword but then when I insert the new passoword it says the password it wrong. In any case...I want to uninstall MySQL and try a new clean install. What would be the procedure to do a VERY clean install? Thanks in advance, FayeC -- 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
I have tried installing on LINUX syste got errors. Kirti -Original Message- From: Nathan Mealey [mailto:[EMAIL PROTECTED] Sent: Monday, September 20, 2004 3:34 PM To: [EMAIL PROTECTED] Subject: DBD::MySQL Has anyone out there had any trouble installing DBD::MySQL for MySQL 4.1.x on Mac OS X 10.3? I have tried it on several machines in my company's office, but it fails on all that are running 4.1.x, and installs fine on those running 4.0.x Thoughts? Thanks, Nathan -- Nathan Mealey Director of Operations Cycle-Smart, Inc. P.O. Box 1482 Northampton, MA 01061-1482 [EMAIL PROTECTED] (413) 587-3133 (413) 210-7984 Mobile (512) 681-7043 Fax -- 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: PERL Module installation
Hello: For the last couple of months I have been learning installing LINUX, MySQL opther software. Until last week I installed mysql-4.0.20 and then installed PERL modules without problem. Last week the new MySQL verion became available I started installing it. Now when I install PERL modules, I get the following error: % perl -MCPAN -e shell Note: Answer no to auto-configure perl. cpan install Bundle::CPAN cpan install Data::Dumper cpan install Bundle::DBI cpan install Bundle::DBD::mysql After I enter the last/above cpan command, there are number of output lines then this error: --- Using DBI 1.43 (for perl 5.08 on i386-linux-thread-multi) installed /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI Writing Makefile for DBD::mysql Makefile:89: *** missing seprator. Stop /usr/bin/make --NOT OK Running make test Can't test without successful make Running make install make had returned bad status, install seems impossible Running install for module DBD::mysql Running make for R/RU/RUDY/DBD-mysql-2.9004.tar.gz is already unrapped into directory /root/.cpan/build/DBD-mysql-2.9004 Has already been processed within this session Running make test Can't test without successful make Running make install make had return bad status, install seems impossible Bundle summary: The following items in bundle Bundle::DBD::mysql had installation problems: Mysql DBD::mysql cpan --- I have posted this message on the PERL list with no resulution. Is it possible that the problem is somewhere in the new MySQL Version mysql-4.0.21? Is there a change from mysql-4.0.20 to mysql-4.0.21 which is causing the problem? Has anyone installed PERL modules on mysql-4.0.21 if yes please email the commands sequence (just like the one I have listed above)you used to install PERL modules? Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Perl with MySQL
Hello: I am trying to install Perl support with MySQL. After installing MySQL (v4.0.20)I run the following commands: % echo $PATH % perl -MCPAN -e shell Note: Answer no to auto-configure perl. cpan install Data::Dumper (Upto this point. Following commands are not run yet.) cpan install Bundle::DBI cpan install Bundle::DBD::mysql cpan quit Today, when I tried to install Perl using the above sequence of commands. However, after I entered the third command cpan install Data::Dumper;, a message was displayed indicating that there is a new version of perl it canbe installed by using the command cpan install Bundle::CPAN. Well, I changed the commands to as follows: % echo $PATH % perl -MCPAN -e shell Note: Answer no to auto-configure perl. cpan install Data::Dumper cpan install Bundle::CPAN cpan install Bundle::DBI cpan install Bundle::DBD::mysql cpan quit I am not sure if the above command sequence is correct or not? I know about Perl as much as I know about brain surgery. However, I am willing to read if I know where. Thanks in advance. Kirti PS: I have no idea id I posted this or not. So if it is duplicate, please ignore. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Perl with MySQL
Hello: I am trying to install Perl support with MySQL. After installing MySQL (v4.0.20)I run the following commands: % echo $PATH % perl -MCPAN -e shell Note: Answer no to auto-configure perl. cpan install Data::Dumper (Upto this point. Following commands are not run yet.) cpan install Bundle::DBI cpan install Bundle::DBD::mysql cpan quit Today, when I tried to install Perl using the above sequence of commands. However, after I entered the third command cpan install Data::Dumper;, a message was displayed indicating that there is a new version of perl it canbe installed by using the command cpan install Bundle::CPAN. Well, I changed the commands to as follows: % echo $PATH % perl -MCPAN -e shell Note: Answer no to auto-configure perl. cpan install Data::Dumper cpan install Bundle::CPAN cpan install Bundle::DBI cpan install Bundle::DBD::mysql cpan quit I am not sure if the above command sequence is correct or not? I know about Perl as much as I know about brain surgery. However, I am willing to read if I know where. Thanks in advance. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GUI for MySQL
This is my first attempt to design and test MySQL. I have used MS SQL for number of years. I do appreciate if members of this list can recommend a good GUI application for MySQL. I want the GUI application to design DB, design Quiries, etc. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
User ID Password
Hello: I am posting this message on freeRADIUS, vpopmail mysql lists. This may get few people upset but please read I am trying to install (on RH9), qmail, vpopmail, mysql, Courier-IMAP, squirrelmail, etc., with backend data on MySQL. On another computer I have installed RH9 freeRADIUS server. vpopmail is used to add UID PW and the data is stored in vpopmail DB in MySQL. Now freeRADIUS also uses UID PW to authenticate and has its own data structure. I like to know if there is a way so that user data is stored in one table in MySQL so vpopmail and freeRADIUS can access the same information?? Thanks in advance. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: vpopmail installed on MySQL Client
Hello List: I had posted this message on vpopmail list but no one can help. I am posting this message on MySQL hoping that someone on this list is using vpopmail MySQL!!! Please consider me a newbie in the area of LINUX, MySQL, vpopmail, etc. I have setup two servers as follows: (1) A master mysql server: data.tib.com Master MySQL server has RH9 MySQL 4.0.20 installed. (2) A mail server: mail.tib.com For the mail server, I want to install RH9, Apache, qmail, vpopmail, etc., by following the toaster: http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htm There is only one exception: On the data.tib.com server, I have setup MySQL as Master Server on the mail.tib.com server. I have setup MySQL as Client MySQL server. I have tested the MySQL connection from the MAIL (Client MySQL) to the DATA (Master MySQL) server it connects without problem. When I installed vpopmail software, I changed the reference to MySQL from localhost to Master MySQL Server (data.tib.com). I added the vpopmail user/pw/db from the MAIL Server without problem. However; when I tried to add a domain on the MAIL server, I get an error (it seems that it does not find the MySQL data). I can list the error if needed. My question is: Has anyone installed vpopmail client mysql where all the data resides on a master mysql server? Is it even possible? If it is not possible, then what are the alternatives? FYI, I have looked in vpopmail/mysql archives GOOGLE, without success. HELP, I have spent over 10 days reading, researching pulling my hair. Kirti TIB P. O. Box 49 Mountain City, TN 37683 Tel: (423) 727-30001 Fax: (423) 727-3002 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL sharing data over NFS ??
Hello List: I want to setup two servers (later more servers added) sharing mysql data as a NFS Server Client relationship; Server-A: -- RH9, mysql-4.0.20, NFS Master This server is a DATA server. All data for the entire site is kept on this server in /usr/local/mysql/var which is symbolically linked to /rad folder. /rad folder consists of two IDE disks mirrored under RAID1. Everything is working fine on this server. Server-B: - RH9, mysql-4.0.20, NFS Client. This server is a MAIL server. I am following http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htm to install various ( qmail, vpopmail, courier-map, qmail-scanner, clam, etc.) mail server software. Question: - I want to setup Server-B so that all mysql data lies on and shared from the DATA (Server-A) server. I know how to create a mount point /rad on server-B. I would like to know how the /rad mount point is incorporated as location of mysql data during the mysql installation on Server-B. For Example: When I install mysql software on Server-B as follows: % cd /usr/local % gunzipmysql-4.0.20.tar.gz | tar -xvf - % cd mysql-version % ./configure -prefix=/usr/local/mysql % make % make install % scripts/mysql_install_db % ... At this point the mysql data is in /usr/local/mysql/var. What do I need to do so that the Server-B points to Server-A for all mysql data retrieval and/or updates. I have to do a full installation of MySQL because other software on Server-B has dependency on mysql software! If somebody has done such an installation, please direct me to a solution. I researched GOOGLE extensively have read the official mysql documentation have not found an answer. It has been a chore to explain this problem. If my explanation is confusing, please let me know and I will answer your question. It seems to be very simple, but it is beyond me. I need help badly. Thanks in advance. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Restrict connection to MySQL Server
Hello: I am trying to setup a client mysql server to connect to a Master MySQL server by MUST using a PASSWORD!! CURRENT SYSTEM: Master MySQL Server: - Name: datam IP: 192.168.10.21 O/S:RH9 MySQL:4.0.18 (Source) Client MySQL Server: - Name: datac IP: 192.168.10.22 O/S:RH9 MySQL:4.0.18 (Source/Client installation) WHAT ELSE I HAVE DONE: == All installation was done using official MySQL documentation by consulting MySQL by DuBois book. On Master MySQL server, I setup a user account mysql. I also setup PW for root and mysql (PW is mysql123). Both root mysql can connect to Master MySQL server datam locally are forced to use PW. I also setup /etc/my.cnf. Then I granted privileges to all Client MySQL machine to connect to Master MySQL server as follows: mysql GRANT ALL PRIVILEGES ON db.* - TO mysql@'192.168.10.0/255.255.255.0'; So far so good. I connected from Client MySQL server: %mysql -u mysql -h datam No problem. Client MySQL connects fine. QUESTION/SUGGESTION/PROBLEM: = I want to force Client MySQL servers to use a PASSWORD to connect to the Master MySQL Server datam. Right now any Client on 192.168.10.X can connect without using password. To further investigate, I changed the /etc/my.cnf file as follows: [client] password = mysql123 Well, it did not make any difference. So, please let me know what am I doing wrong? What changes should I make so the client machines must use a PW to connect to the Master server? Thanks. Kirt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Restrict connection to MySQL Server
Ritter: What is the effect of enter the following in /etc/my.cnf: [client] password = mysql123 Kirt -Original Message- From: Jason K Larson [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 2:48 PM To: Kirti S. Bajwa Cc: [EMAIL PROTECTED] Subject: Re: Restrict connection to MySQL Server http://dev.mysql.com/doc/mysql/en/Adding_users.html mysql GRANT ALL PRIVILEGES ON db.* - TO mysql@'192.168.10.0/255.255.255.0' - IDENTIFIED BY 'mysql123'; -- Ritter Kirti S. Bajwa wrote: Hello: I am trying to setup a client mysql server to connect to a Master MySQL server by MUST using a PASSWORD!! CURRENT SYSTEM: Master MySQL Server: - Name: datam IP: 192.168.10.21 O/S: RH9 MySQL:4.0.18 (Source) Client MySQL Server: - Name: datac IP: 192.168.10.22 O/S: RH9 MySQL:4.0.18 (Source/Client installation) WHAT ELSE I HAVE DONE: == All installation was done using official MySQL documentation by consulting MySQL by DuBois book. On Master MySQL server, I setup a user account mysql. I also setup PW for root and mysql (PW is mysql123). Both root mysql can connect to Master MySQL server datam locally are forced to use PW. I also setup /etc/my.cnf. Then I granted privileges to all Client MySQL machine to connect to Master MySQL server as follows: mysql GRANT ALL PRIVILEGES ON db.* - TO mysql@'192.168.10.0/255.255.255.0'; So far so good. I connected from Client MySQL server: %mysql -u mysql -h datam No problem. Client MySQL connects fine. QUESTION/SUGGESTION/PROBLEM: = I want to force Client MySQL servers to use a PASSWORD to connect to the Master MySQL Server datam. Right now any Client on 192.168.10.X can connect without using password. To further investigate, I changed the /etc/my.cnf file as follows: [client] password = mysql123 Well, it did not make any difference. So, please let me know what am I doing wrong? What changes should I make so the client machines must use a PW to connect to the Master server? Thanks. Kirt -- 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]
Simple questions!!
Hello List: RH 9 MySQL 4.0.18 Just did a fresh Binary install of MySQL. Also installed support for Perl/DBI/DBD: Question: (1) I am going to setup a MySQL Client machine on a different Server. I notice I can't install a Client MySQL from Binary MySQL distro. Is it correct? (2) On a Client MySQL machine, it it necessary to START MySQL or just connecting to the MySQL Server does the job? (3) On a Client MySQL machine, is there any need to install support for Perl/DBI/DBD or support comes from the MySQL Server? (4) After I installed Perl/DBI/DBD, the cursor was still on cpan. How do I get out of this shell? Forexample: When one is in mysql shell, QUIT takes out of the mysql shwll. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL does not automatically start at BOOT time??
Hello List: Few days ago I posted MySQL does not automatically start at BOOT time?? on this list. Several people responded but the problem was not resolved. I did a fresh install of RH9 MySQL 4.0.18 (Binary) on a DUAL CPU 1.5 GB Mem server. After reading the MySQL documentation MySQL book by Paul DUBois, I found the problem. Problem: Size of log file in /etc/my.cnf /usr/local/mysql/data/ is different. Here is the actual error msg: InnoDB: Error: log file /usr/local/mysql/data/ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 67108864! - I commented the InnoDB_log_file_size in /etc/my.cnf file and MySQL started like a PRO. I have the following questions: Q1: === My setup is all from default settings. Therefore size of log file, both in /etc/my.cnf /usr/local/mysql/data/ are set by the default. Why default setting for one parameter are different in locations? Q2: === How to fix this problem? If there is an explanation in the MySQL documentation, I sure like to read about it if someone responds with the Section Number. Thanks Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL does not automatically start at BOOT time??
Hello List: I have spent the entire weekend solving this problem without success. PLEASE HELP. After the last response from Paul, and MySQL not starting at BOOT time, I thought that I may have done something wrong. So I went ahead and did a fresh install of RH9 MySQL Source Distro with one difference. This time I installed mysql-4.0.18. I followed the installation script as noted below, still MySQL does not automatically re-start at BOOT time. For those who did not follow this posting; previously I have installed MySQL and followed the same installation script. Each time MySQL started at BOOT time. The only major difference is that in previous cases, I installed from the binaries this time I installed from source. I can start the MySQL by mysqld_safe. Paul had suggested looking into the MySQL error logs. Since I am new, I can't find where are error logs are kept. I have looked in /var/log /usr/local/mysql and have not found any error logs for MySQL. I sure need help!! Thanks. Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, May 08, 2004 6:44 PM To: Kirti S. Bajwa Subject: RE: MySQL does not automatically start at BOOT time?? Paul: Did what you said. Here is the response: % chkconfig --list mysql.server mysql.server 0:off 1:off 2:on 3:on 4:on 5:on 6:off That looks correct. If you did chkconfig mysql.server on, *and then restarted*, and the server still doesn't start automatically, check the MySQL error log to see if it has a clue. If it doesn't, I dunno. What next? Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, May 08, 2004 2:24 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: Re: MySQL does not automatically start at BOOT time?? At 14:08 -0400 5/8/04, Kirti S. Bajwa wrote: Hello List: I have been learning MySQL. I have installed tested MySQL server 3-4 times without problem. This time I used the an alpha-nightly snapshot and have run into problems. My current Installation: -- LINUX RH9 Source Installaion: mysql-5.0.1-alpha-nightly-20040504.tar.gz DUAL Pentium 1GHz CPU 1.5 GB Memory Installation Procedure: -- I follow the installation procedure is as described in MySQL documentation a doze of consulting MySQL by Paul DuBois book: % cd /usr/local % gunzip -dc mysql-5.0.1-alpha-nightly-20040504.tar.gz | tar xvf - % cd mysql-5.0.1-alpha-nightly-20040504 % ./configure -prefix=/usr/local/mysql % make % make install % scripts/mysql_install_db % chown -R mysqladm.mysqlgrp/usr/local/mysql/var % chown -R mysqladm.mysqlgrp/rad/var % chmod -R go-rwx /usr/local/mysql/var * It is a good idea to first see if the MySQL can be started: % /usr/local/mysql/bin/mysqld_safe -user=mysqladm % ps -aux | grep mysql There should be 4-5 lines showing how MySQL is running. Wonderful, MySQL is running. % reboot Setup to start MySQL automatically % cp /usr/local/mysql Version No/mysql.server /etc/init.d % cd /etc/init.d % chmod 500 mysql.server % chkconfig - -add mysql.server Try adding: chkconfig mysql.server on Then run this to see if it's been enabled for the appropriate runlevels: chkconfig --list mysql.server % reboot Check if MySQL is running: % ps -aux | grep mysql Problem: - Well, MySQL does not start automatically. -- - - -- As I said, I have used a similar installation script before without proble. This time, the only modifications made to the instalation script are: (1) Few hints from Paul DuBois book (2) Different version of MySQL. Can somebody point me to the problem? Is in the script I am using is missing something? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL does not automatically start at BOOT time??
Brian: No. From where I copy this file from? Is it stright copy or something else? You might be my savior!! Thanks. Kirti -Original Message- From: Brian Duke [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 5:44 PM To: 'Kirti S. Bajwa'; [EMAIL PROTECTED] Subject: RE: MySQL does not automatically start at BOOT time?? I know that feeling. perhaps I can help. do you have an /etc/rc.d/init.d/mysqld file? -Original Message- From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 3:29 PM To: '[EMAIL PROTECTED]' Subject: RE: MySQL does not automatically start at BOOT time?? Hello List: I have spent the entire weekend solving this problem without success. PLEASE HELP. After the last response from Paul, and MySQL not starting at BOOT time, I thought that I may have done something wrong. So I went ahead and did a fresh install of RH9 MySQL Source Distro with one difference. This time I installed mysql-4.0.18. I followed the installation script as noted below, still MySQL does not automatically re-start at BOOT time. For those who did not follow this posting; previously I have installed MySQL and followed the same installation script. Each time MySQL started at BOOT time. The only major difference is that in previous cases, I installed from the binaries this time I installed from source. I can start the MySQL by mysqld_safe. Paul had suggested looking into the MySQL error logs. Since I am new, I can't find where are error logs are kept. I have looked in /var/log /usr/local/mysql and have not found any error logs for MySQL. I sure need help!! Thanks. Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, May 08, 2004 6:44 PM To: Kirti S. Bajwa Subject: RE: MySQL does not automatically start at BOOT time?? Paul: Did what you said. Here is the response: % chkconfig --list mysql.server mysql.server 0:off 1:off 2:on 3:on 4:on 5:on 6:off That looks correct. If you did chkconfig mysql.server on, *and then restarted*, and the server still doesn't start automatically, check the MySQL error log to see if it has a clue. If it doesn't, I dunno. What next? Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, May 08, 2004 2:24 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: Re: MySQL does not automatically start at BOOT time?? At 14:08 -0400 5/8/04, Kirti S. Bajwa wrote: Hello List: I have been learning MySQL. I have installed tested MySQL server 3-4 times without problem. This time I used the an alpha-nightly snapshot and have run into problems. My current Installation: -- LINUX RH9 Source Installaion: mysql-5.0.1-alpha-nightly-20040504.tar.gz DUAL Pentium 1GHz CPU 1.5 GB Memory Installation Procedure: -- I follow the installation procedure is as described in MySQL documentation a doze of consulting MySQL by Paul DuBois book: % cd /usr/local % gunzip -dc mysql-5.0.1-alpha-nightly-20040504.tar.gz | tar xvf - % cd mysql-5.0.1-alpha-nightly-20040504 % ./configure -prefix=/usr/local/mysql % make % make install % scripts/mysql_install_db % chown -R mysqladm.mysqlgrp/usr/local/mysql/var % chown -R mysqladm.mysqlgrp/rad/var % chmod -R go-rwx /usr/local/mysql/var * It is a good idea to first see if the MySQL can be started: % /usr/local/mysql/bin/mysqld_safe -user=mysqladm % ps -aux | grep mysql There should be 4-5 lines showing how MySQL is running. Wonderful, MySQL is running. % reboot Setup to start MySQL automatically % cp /usr/local/mysql Version No/mysql.server /etc/init.d % cd /etc/init.d % chmod 500 mysql.server % chkconfig - -add mysql.server Try adding: chkconfig mysql.server on Then run this to see if it's been enabled for the appropriate runlevels: chkconfig --list mysql.server % reboot Check if MySQL is running: % ps -aux | grep mysql Problem: - Well, MySQL does not start automatically. -- - - -- As I said, I have used a similar installation script before without proble. This time, the only modifications made to the instalation script are: (1) Few hints from Paul DuBois book (2) Different version of MySQL. Can somebody point me to the problem? Is in the script I am using is missing something? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http
RE: MySQL does not automatically start at BOOT time??
Sam: I removed MySQL by removing the directory /etc/local/mysql-version /etc/local/mysql and then re-installing the mysql-4.0.18.tar.gz. I follwed the procedure (as you described) from mysql documentation again I can not get mysql auto start. Do you know which directory/file has mysql error so I can look into it. I am completely burned!! Will start again tomarrow morning if I get few responses. Kirti -Original Message- From: Sam [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 6:52 PM To: [EMAIL PROTECTED] Subject: RE: MySQL does not automatically start at BOOT time?? Kirti: I think you already did that as you said in you first msg about you installation steps. Setup to start MySQL automatically % cp /usr/local/mysql Version No/mysql.server /etc/init.d Did you get my prev msg where I suggested to check the previleges on your mysql. Usually I do it this way: 8) Change ownership of binaries to root and ownership of the data directory to the user that you will run mysqld as (in our case mysql): chown -R root . chown -R mysql var chgrp -R mysql . ( this is important too) 9) To start MySQL server automatically when you boot your machine, copy the mysql.server script to the `/etc/init.d' directory with the name mysql, and then make it executable cp support-files/mysql.server /etc/init.d/mysql chmod +x /etc/init.d/mysql 10) Activate to run the script at system startup by adding to the chkconfig list chkconfig --add mysql chkconfig --level 345 mysql on For more information read http://dev.mysql.com/doc/mysql/en/Automatic_start.html Good luck... Sam --- Kirti S. Bajwa [EMAIL PROTECTED] wrote: Brian: No. From where I copy this file from? Is it stright copy or something else? You might be my savior!! Thanks. Kirti -Original Message- From: Brian Duke [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 5:44 PM To: 'Kirti S. Bajwa'; [EMAIL PROTECTED] Subject: RE: MySQL does not automatically start at BOOT time?? I know that feeling. perhaps I can help. do you have an /etc/rc.d/init.d/mysqld file? -Original Message- From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 3:29 PM To: '[EMAIL PROTECTED]' Subject: RE: MySQL does not automatically start at BOOT time?? Hello List: I have spent the entire weekend solving this problem without success. PLEASE HELP. After the last response from Paul, and MySQL not starting at BOOT time, I thought that I may have done something wrong. So I went ahead and did a fresh install of RH9 MySQL Source Distro with one difference. This time I installed mysql-4.0.18. I followed the installation script as noted below, still MySQL does not automatically re-start at BOOT time. For those who did not follow this posting; previously I have installed MySQL and followed the same installation script. Each time MySQL started at BOOT time. The only major difference is that in previous cases, I installed from the binaries this time I installed from source. I can start the MySQL by mysqld_safe. Paul had suggested looking into the MySQL error logs. Since I am new, I can't find where are error logs are kept. I have looked in /var/log /usr/local/mysql and have not found any error logs for MySQL. I sure need help!! Thanks. Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, May 08, 2004 6:44 PM To: Kirti S. Bajwa Subject: RE: MySQL does not automatically start at BOOT time?? Paul: Did what you said. Here is the response: % chkconfig --list mysql.server mysql.server 0:off 1:off 2:on 3:on 4:on 5:on 6:off That looks correct. If you did chkconfig mysql.server on, *and then restarted*, and the server still doesn't start automatically, check the MySQL error log to see if it has a clue. If it doesn't, I dunno. What next? Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, May 08, 2004 2:24 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: Re: MySQL does not automatically start at BOOT time?? At 14:08 -0400 5/8/04, Kirti S. Bajwa wrote: Hello List: I have been learning MySQL. I have installed tested MySQL server 3-4 times without problem. This time I used the an alpha-nightly snapshot and have run into problems. My current Installation: -- LINUX RH9 Source Installaion: mysql-5.0.1-alpha-nightly-20040504.tar.gz DUAL Pentium 1GHz CPU 1.5 GB Memory Installation Procedure: -- I follow the installation procedure is as described in MySQL documentation a doze of consulting MySQL by Paul DuBois book: % cd /usr/local % gunzip -dc mysql-5.0.1-alpha-nightly-20040504.tar.gz
MySQL does not automatically start at BOOT time??
Hello List: I have been learning MySQL. I have installed tested MySQL server 3-4 times without problem. This time I used the an alpha-nightly snapshot and have run into problems. My current Installation: -- LINUX RH9 Source Installaion: mysql-5.0.1-alpha-nightly-20040504.tar.gz DUAL Pentium 1GHz CPU 1.5 GB Memory Installation Procedure: -- I follow the installation procedure is as described in MySQL documentation a doze of consulting MySQL by Paul DuBois book: % cd /usr/local % gunzip -dc mysql-5.0.1-alpha-nightly-20040504.tar.gz | tar xvf - % cd mysql-5.0.1-alpha-nightly-20040504 % ./configure -prefix=/usr/local/mysql % make % make install % scripts/mysql_install_db % chown -R mysqladm.mysqlgrp/usr/local/mysql/var % chown -R mysqladm.mysqlgrp/rad/var % chmod -R go-rwx /usr/local/mysql/var * It is a good idea to first see if the MySQL can be started: % /usr/local/mysql/bin/mysqld_safe -user=mysqladm % ps -aux | grep mysql There should be 4-5 lines showing how MySQL is running. Wonderful, MySQL is running. % reboot Setup to start MySQL automatically % cp /usr/local/mysql Version No/mysql.server /etc/init.d % cd /etc/init.d % chmod 500 mysql.server % chkconfig - -add mysql.server % reboot Check if MySQL is running: % ps -aux | grep mysql Problem: - Well, MySQL does not start automatically. -- As I said, I have used a similar installation script before without proble. This time, the only modifications made to the instalation script are: (1) Few hints from Paul DuBois book (2) Different version of MySQL. Can somebody point me to the problem? Is in the script I am using is missing something? Kirti TIB P. O. Box 49 Mountain City, TN 37683 Tel: (423) 727-30001 Fax: (423) 727-3002 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL does not automatically start at BOOT time??
Paul: Did what you said. Here is the output: % chkconfig --list mysql.server mysql.server 0:off 1:off 2:on 3:on 4:on 5:on 6:off What next? Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, May 08, 2004 2:24 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: Re: MySQL does not automatically start at BOOT time?? At 14:08 -0400 5/8/04, Kirti S. Bajwa wrote: Hello List: I have been learning MySQL. I have installed tested MySQL server 3-4 times without problem. This time I used the an alpha-nightly snapshot and have run into problems. My current Installation: -- LINUX RH9 Source Installaion: mysql-5.0.1-alpha-nightly-20040504.tar.gz DUAL Pentium 1GHz CPU 1.5 GB Memory Installation Procedure: -- I follow the installation procedure is as described in MySQL documentation a doze of consulting MySQL by Paul DuBois book: % cd /usr/local % gunzip -dc mysql-5.0.1-alpha-nightly-20040504.tar.gz | tar xvf - % cd mysql-5.0.1-alpha-nightly-20040504 % ./configure -prefix=/usr/local/mysql % make % make install % scripts/mysql_install_db % chown -R mysqladm.mysqlgrp/usr/local/mysql/var % chown -R mysqladm.mysqlgrp/rad/var % chmod -R go-rwx /usr/local/mysql/var * It is a good idea to first see if the MySQL can be started: % /usr/local/mysql/bin/mysqld_safe -user=mysqladm % ps -aux | grep mysql There should be 4-5 lines showing how MySQL is running. Wonderful, MySQL is running. % reboot Setup to start MySQL automatically % cp /usr/local/mysql Version No/mysql.server /etc/init.d % cd /etc/init.d % chmod 500 mysql.server % chkconfig - -add mysql.server Try adding: chkconfig mysql.server on Then run this to see if it's been enabled for the appropriate runlevels: chkconfig --list mysql.server % reboot Check if MySQL is running: % ps -aux | grep mysql Problem: - Well, MySQL does not start automatically. --- - -- As I said, I have used a similar installation script before without proble. This time, the only modifications made to the instalation script are: (1) Few hints from Paul DuBois book (2) Different version of MySQL. Can somebody point me to the problem? Is in the script I am using is missing something? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- 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 does not automatically start at BOOT time??
Paul: I did not realize that I sent the response directly to you instead of the list. In any case, it did not work now I re-start with a clean RH9 install. I thought why to wait until Monday. I need to get it done. Thanks again. You gave me lots of new instructions to read about. Kirt -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, May 08, 2004 6:44 PM To: Kirti S. Bajwa Subject: RE: MySQL does not automatically start at BOOT time?? Paul: Did what you said. Here is the response: % chkconfig --list mysql.server mysql.server 0:off 1:off 2:on 3:on 4:on 5:on 6:off That looks correct. If you did chkconfig mysql.server on, *and then restarted*, and the server still doesn't start automatically, check the MySQL error log to see if it has a clue. If it doesn't, I dunno. What next? Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, May 08, 2004 2:24 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: Re: MySQL does not automatically start at BOOT time?? At 14:08 -0400 5/8/04, Kirti S. Bajwa wrote: Hello List: I have been learning MySQL. I have installed tested MySQL server 3-4 times without problem. This time I used the an alpha-nightly snapshot and have run into problems. My current Installation: -- LINUX RH9 Source Installaion: mysql-5.0.1-alpha-nightly-20040504.tar.gz DUAL Pentium 1GHz CPU 1.5 GB Memory Installation Procedure: -- I follow the installation procedure is as described in MySQL documentation a doze of consulting MySQL by Paul DuBois book: % cd /usr/local % gunzip -dc mysql-5.0.1-alpha-nightly-20040504.tar.gz | tar xvf - % cd mysql-5.0.1-alpha-nightly-20040504 % ./configure -prefix=/usr/local/mysql % make % make install % scripts/mysql_install_db % chown -R mysqladm.mysqlgrp/usr/local/mysql/var % chown -R mysqladm.mysqlgrp/rad/var % chmod -R go-rwx /usr/local/mysql/var * It is a good idea to first see if the MySQL can be started: % /usr/local/mysql/bin/mysqld_safe -user=mysqladm % ps -aux | grep mysql There should be 4-5 lines showing how MySQL is running. Wonderful, MySQL is running. % reboot Setup to start MySQL automatically % cp /usr/local/mysql Version No/mysql.server /etc/init.d % cd /etc/init.d % chmod 500 mysql.server % chkconfig - -add mysql.server Try adding: chkconfig mysql.server on Then run this to see if it's been enabled for the appropriate runlevels: chkconfig --list mysql.server % reboot Check if MySQL is running: % ps -aux | grep mysql Problem: - Well, MySQL does not start automatically. -- - - -- As I said, I have used a similar installation script before without proble. This time, the only modifications made to the instalation script are: (1) Few hints from Paul DuBois book (2) Different version of MySQL. Can somebody point me to the problem? Is in the script I am using is missing something? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
No Posting
Test message. This is a test message. I have not received any post from MySQL for two days. I just want to make sure that this message gets back to me. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Perl Modelues
Michael: Thanks. It did the trick. Kirti -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Thursday, April 08, 2004 6:32 PM To: Kirti S. Bajwa Cc: [EMAIL PROTECTED] Subject: Re: Perl Modelues Kirti S. Bajwa wrote: Ken: Thank you for your response. I tried the 'mysql_config' command and got an error message. I will add 'mysql_config' to the path (if I figure out how!!!). You need to add the directory which contains mysql_config to your path. Adding to your PATH isn't difficult, but the method depends on your shell. You can find your shell with echo $SHELL I noticed that on my installation the 'mysql_config' is in '/usr/local/mysql/bin' directory whereas you have indicated that it should be in '/usr/local/bin' directory! Please clarify!! /usr/local/mysql/bin is fine. With tcsh, you can add this to your path with set path=($PATH /usr/local/mysql/bin) With sh or bash, you should be able to add this to your path with export PATH=$PATH:/usr/local/mysql/bin Either way, you should probably also add this to the appropriate shell startup file, so mysql is always in your path. You can check your path with echo $PATH Two more questions: (1) Since I have done partial installation, would it hurt if I re-do the entire Perl instalation or start from the command where the errors were encountered? You didn't break anything, you just didn't succeed in adding the module. Just go back into CPAN and try again. I'd suggest perl -MCPAN -e shell install Bundle::DBI install Bundle::DBD::mysql Installing the bundles will make sure you have everything you need. As you've already installed DBI, you'll already have most of what the bundles contain, and CPAN is smart enough not to reinstall what you already have. (2) I also have two Client MySQL servers (which connect to master MySQL server for data). Do I also need to install Perl on these Client MySQL Servers? I'm not sure what you mean by Client MySQL servers. Do you mean machines which need the mysql client to connect to the machine running the mysql server, or do you mean machines which will run the mysql server as slaves to the master server? In any case, you can run the mysql server and client without perl. On the other hand, a number of the helper apps in /usr/local/mysql/bin are perl scripts. Of course, you will need to install perl on any machine where you want to use perl to connect/manipulate your mysql data, and perl is handy to have around in general. Please remember, I am an IBM mainframe guy my knowledge of LINUX related soft is pretty low on scale. Thanks. Kirti Michael -- 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: Perl Modelues
First a big thanks to Mark, BAO, Beacker, Matthais, Rich Ken for their response. My problem was that I thought that I needed to download tar file to start the installation. Rich's response somewhat cleared that. I ran the following commands, and got the following errors: % perl -MCPAN -e shell cpan install Data::Dumper cpan install DBI (no problem upto this point) cpan install DBD::mysql Errors returned: Can't exec mysql_config: No such file or directory at Makefile.PL line 174 readline() on closed filehandle PIPE at Makefile.PL line 176 ... (there are 10 such errors) Then few other lines of output without error. Then I get the following (error) response: Checking if your kit is complete... looks good Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (number of such errors) Note (probabally harmless): No library found for -lmysqlclient Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (again quite a number of such errors) Note (probabally harmless): No library found for -lgz Writing Makefile for DBD::mysql Makefile:89: *** missing separator. Stop. /usr/bin/make --NOT OK Running make test Can't test without successful make Running make install make had returned bad status, install seems impossible cpan What are these errors? How should I fix them? Can I continue installing other software (Apache, qmail, etc.) Thanks. Kirti -Original Message- From: Rich Allen [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 6:02 PM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]' Subject: Re: Perl Modelues you can install Perl modules with $ perl -MCPAN -e shell cpan install [module::name] - hcir mysql - hcir On Apr 7, 2004, at 10:57 AM, Kirti S. Bajwa wrote: Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. -- 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: Perl Modelues
Ken: Thank you for your response. I tried the 'mysql_config' command and got an errot message. I will add 'mysql_config' to the path (if I figure out how!!!). I noticed that on my installation the 'mysql_config' is in '/usr/local/mysql/bin' directory whereas you have indicated that it should be in '/usr/local/bin' directory! Please clarify!! Two more questions: (1) Since I have doen partial installation, would it hurt if I re-do the entire Perl instalation or start from the command where the errors were encountered? (2) I also have two Client MySQL servers (which connect to master MySQL server for data). Do I also need to install Perl on these Client MySQL Servers? Please remember, I am an IBM mainframe guy my knowledge of LINUX related soft is pretty low on scale. Thanks. Kirti -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED] Sent: Thursday, April 08, 2004 3:29 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: Re: Perl Modelues Hi Kirti, mysql_config tell the perl build module how to link with the driver. The easiest way to fix this is make sure the bin driectory of MySQL is in your path. If you can type 'mysql_config' at the command line and get an answer like: Usage: /usr/local/bin/mysql_config [OPTIONS] Options: etc The perl DBD module should be able to find and use this program to configure itself. If you get a command not found error add the mysql bin driectory to the path. Ken - Original Message - From: Kirti S. Bajwa [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 08, 2004 1:53 PM Subject: RE: Perl Modelues First a big thanks to Mark, BAO, Beacker, Matthais, Rich Ken for their response. My problem was that I thought that I needed to download tar file to start the installation. Rich's response somewhat cleared that. I ran the following commands, and got the following errors: % perl -MCPAN -e shell cpan install Data::Dumper cpan install DBI (no problem upto this point) cpan install DBD::mysql Errors returned: Can't exec mysql_config: No such file or directory at Makefile.PL line 174 readline() on closed filehandle PIPE at Makefile.PL line 176 ... (there are 10 such errors) Then few other lines of output without error. Then I get the following (error) response: Checking if your kit is complete... looks good Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (number of such errors) Note (probabally harmless): No library found for -lmysqlclient Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (again quite a number of such errors) Note (probabally harmless): No library found for -lgz Writing Makefile for DBD::mysql Makefile:89: *** missing separator. Stop. /usr/bin/make --NOT OK Running make test Can't test without successful make Running make install make had returned bad status, install seems impossible cpan What are these errors? How should I fix them? Can I continue installing other software (Apache, qmail, etc.) Thanks. Kirti -Original Message- From: Rich Allen [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 6:02 PM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]' Subject: Re: Perl Modelues you can install Perl modules with $ perl -MCPAN -e shell cpan install [module::name] - hcir mysql - hcir On Apr 7, 2004, at 10:57 AM, Kirti S. Bajwa wrote: Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Perl Modelues
Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. Kirt TIB Mountain City, TN 37683 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Perl Modelues
Hello List: -- I left out the following information (sorry too much on mind): RH 9 MySQL 0.9.3 (Installing both Server Clients -- I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. Kirt TIB Mountain City, TN 37683 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB!!
Is InnoDB table type support included in the 5.?.? version? Kirt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Installation???
Hello List: I have installed and tested freeRADIUS 0.9.3 MySQL 5.?.? (latest dev version). Now I want to install test freeRADIUS MySQL with InnoDB tables. I have researched GOOGLE MySQL web site for information on installing MySQL with InnoDB tables without success. I would appreciate if somebody direct me to: What version of MySQL do I need to install (with freeRADIUS) so I can use InnoDB tables? I understand that installing MySQL with freeRADIUS requires a specific MySQL version? Is it correct? I would be more than happy to read the procedure if someone point me to the chapter in MySQL Doc! I have not been able to find out myself. Is it possible that there is no special separate procedure and that is why I am missing it? Thanks in advance. Kirt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Basic Setup Questions!!!!
Hello List:
After two weeks of struggling, I need help!!
My setup:
T1 to Internet Backbone
|
Cisco 26XX
12.21.237.1
|
---
| |
12.21.237.10 12.21.237.11
-- --
| Firewall | | Firewall |
| DNS1(NS1)| | DNS2(NS2)|
-- --
192.168.21.10 192.168.21.11
| |
---
DMZ |Hub|DMZ
-
| | | |
12.21.237.15 12.21.237.16 12.21.237.17 12.21.237.17
rdx mail Web data
| RADIUS | | Mail | | Web/HTTP | | DATA |
| Server | | Server | | Hosting | | MySQL |
192.168.6.15 192.168.6.16 192.168.6.17 192.168.6.18
rdxl maill webl datal
| | | |
---|Hub|-
In the above setup, I have setup a MySQL master server called data. This
master server (my plan) can only be accessed from MySQL client servers rdxl,
maill, webl datal (IP's 192.168.6.%).
I have read MySQL documentation MySQL by Paul DuBois (several times). I
can test and access data server as explained in the documentation DuBois
book.
My Problem:
---
(1) How do I setup so that servers on 192.168.6.? can (are allowed) access
the master MySQL server?
(2) I want to create an account jupiter password sunrise which can
access data custdata on master MySQL server?
Thanks.
Kirti
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Basic Setup Questions!!!!
Jeremy:
Yes I tried the GRANT ... and few others. Finally it HIT me (after two
weeks). I installed the MySQL master server on data server, which can't be
accessed from the Class C IP addresses (see my setup below). I used
mysqlcc GUI display and changed the server to datal and I started
accesses it from all servers on 192.168.6.%! What a trip.
Thank you for your response. You are always very helpful.
Kirti
-Original Message-
From: Jeremy March [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 14, 2004 6:23 PM
To: [EMAIL PROTECTED]
Subject: re: Basic Setup Questions
Have you tried:
GRANT privileges ON database.* TO 'jupiter'@'192.168.6.%' IDENTIFIED BY
'sunrise';
See:
http://www.mysql.com/doc/en/GRANT.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 14, 2004 4:37 PM
To: [EMAIL PROTECTED]
Subject: Basic Setup Questions
Hello List:
After two weeks of struggling, I need help!!
My setup:
T1 to Internet Backbone
|
Cisco 26XX
12.21.237.1
|
---
| |
12.21.237.10 12.21.237.11
-- --
| Firewall | | Firewall |
| DNS1(NS1)| | DNS2(NS2)|
-- --
192.168.21.10 192.168.21.11
| |
---
DMZ |Hub|DMZ
-
| | | |
12.21.237.15 12.21.237.16 12.21.237.17 12.21.237.17
rdx mail Web data
| RADIUS | | Mail | | Web/HTTP | | DATA |
| Server | | Server | | Hosting | | MySQL |
192.168.6.15 192.168.6.16 192.168.6.17 192.168.6.18
rdxl maill webl datal
| | | |
---|Hub|-
In the above setup, I have setup a MySQL master server called data. This
master server (my plan) can only be accessed from MySQL client servers rdxl,
maill, webl datal (IP's 192.168.6.%).
I have read MySQL documentation MySQL by Paul DuBois (several times). I
can test and access data server as explained in the documentation DuBois
book.
My Problem:
---
(1) How do I setup so that servers on 192.168.6.? can (are allowed) access
the master MySQL server?
(2) I want to create an account jupiter password sunrise which can
access data custdata on master MySQL server?
Thanks.
Kirti
--
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: my.cnf Setup!!
Hello List: I have setup MySQL and it is working fine. I tested connection to MySQL. Now I have gone one step futher and added a password for mysql, as follows: shell ./mysqladmin -u root password mysqlpw Now I want to setup myc.cnf. Our SQL server is a standalone server (RH9, Dual CPU, 1.5GB Memory, RAID1, etc.), so I copied the my-large.cnf to /etc/my.cnf. After looking into my.cnf, I decided to leave it as it is (no change). I do want to add the (1) name of the server and (2) password to the my.cnf. Here I am struck for last couple of days. Finally, here is my question; I want to execute the command: shell mysql -h data -u mysql password=mysqlpw Where (from above command), mysql server is data and password is mysqlpw. What lines do I need to enter in my.cnf for the above command to work? I have tried everything I know! HELP!! KIrti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: UID/PW Question???
During the last week I have asked couple of questions regarding setting up
MySQL have gotten good answers. Since my knowledge of MySQL is in the
beginer level, and I am very close to finishing up working with MySQL, I
have several questions still un answered. I will try asking one question at
a time so I do not confuse anything.
My setup:
T1 to Internet Backbone
|
---
| |
12.21.237.10 12.21.237.11
-- --
| Firewall | | Firewall |
| DNS (NS1)| | DNS (NS2)|
-- --
192.168.21.10 192.168.21.10
| |
---
DMZ |Hub|DMZ
-
| | |
192.168.5.15 192.168.5.16 192.168.5.17
rdx mail mails
| RADIUS | | Mail | | Web/HTTP | | DATA |
| Server | | Server | | Hosting | | MySQL |
192.168.6.15 192.168.6.16 192.168.6.17 192.168.6.18
rdxl maill mailsl datal
| | | |
---|Hub|-
The four servers sit behind a firewall communicate with each other on
private 192.168.6.XX network. Data Server (datal) is a MySQL Master Server
RH9,DUAL CPU, 1.5GB Mem RAID1) it is accessable only by servers in the
DMZ over 192.168.5.XX network. I have file /etc/my.cnf in the data1,
which I copied from my-large.cnf and have made no changed to it.
/etc/hosts table in each server resolves all other servers in the DMZ I
can PING any one of them from any one of them.
RADIUS Server (rdxl) is a client MySQL Server and reads authentication data
from DATA Server (datal). My INTENT is to setup Client MySQL Server (rdxl)
so
that(if possible)it is permanently connected to the MySQL Master Server
(datal)!
-
I use the following command in Client MySQL Server (rdxl) to connect to the
Master MySQL Server:
shell mysql -h datal -u root password=mysqlpw
Where root password (mysqlpw) is setup using mysqladmin command.
Question:
(1) What is the norm UID when connecting from a Client MySQL Server?
I am using root as UID, should I use mysql as UID why? If UID
mysql is used then how do I setup PW for it? Is it by mysqladmin
command or by changing the PW is the User Manager?
(2) I am told not to expose the password. In this situation, where
RADIUS server will be connecting to the Master MySQL server every
few seconds, how would I setup the connection to the datal server?
(2) In Clinet/Master MySQL setup, do I also need to create a /etc/my.cnf
file on the Client MySQL Server?
(3) What changes do I need in /etc/my.cnf file?
-
Thanks.
Kirti
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Client mySQL Server/I need help!!
Evelyn: I need help. I have followed your instructions. Here is my problem: . Installation ... ... Shell Make Install Shell scripts/mysql_install_db bash: scripts/mysql_install_db: No such file or directory -- Am I following the correct sequence? There is no directory scripts! In MySQL documentation, section 2.3.1 describes the Source Installation and that's what I am following. I am struck here since you have recently done it you may have a suggestion??? Thanks. Kirt -Original Message- From: Schwartz, Evelyn [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:51 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: RE: Client mySQL Server Just went through this. You need to install MySQL from source. The basic commands you must execute to install a MySQL source distribution are: shell groupadd mysql shell useradd -g mysql mysql shell gunzip mysql-VERSION.tar.gz | tar -xvf - shell cd mysql-VERSION shell ./configure --without-server shell make shell make install The ./configure --without-server only installs the client. You need to read the doco about the source install to look for other options you may want. Evelyn -Original Message- From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:31 PM To: '[EMAIL PROTECTED]' Subject: RE: Client mySQL Server First of all I admit that I am not an expert of MySQL. However, during the last three months I have TEST installed MySQL Server software and gone through the tutorial. My next step is to setup three computers as follows: |--| |--| |--| | 12.21.237.10 | | 12.21.237.11 | | 12.21.237.12 | | freeRADIUS | | qmail/HTTP | | DataServer | |--| |--| |--| | | | |---| My design is have run MySQL on data server and keep all data (sql) on this server. freeRADIUS server is for authentication and qmail/HTTP server is for mail and web pages. I am told that I need to install MySQL client program on freeRADIUS qmail/HTTP servers and master MySQL on DataServer. I have not been able to find either Client or Master MySQL but just MySQL! Is there a subset of MySQL which is known as Client and/or Master MySQL or is it just terminology? Any help is highly appreciated. Kirti -- 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: Client mySQL Server/I need help!!
Michael: You are right. I am installing MySQL Client ONLY do not find mysql_install_db is nowhere found. Now I realize that for a client installation, mysql_install_db is not installed. You have been very kind in responding and helping me with this problem. I need further assistance in setting up a MySQL Client machine. What other steps I need to finish the installation? Is there any documentation which describes MySQL client installation? Thanks. Kirti -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 4:31 PM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]' Subject: Re: Client mySQL Server/I need help!! If you are building from source and have already run `nake install`, then mysql_install_db should exist in the scripts directory inside your source directory and in the bin directory of the mysql install directory (/usr/local/mysql, perhaps). But, following this thread, there appears to be some confusion. mysql_install_db sets up the initial tables for the mysql server. It won't do anything useful if you are installing only the client (ran `configure --without-server`). In fact, if it isn't there at all, that may be the reason. Michael Kirti S. Bajwa wrote: Evelyn: I need help. I have followed your instructions. Here is my problem: . Installation ... ... Shell Make Install Shell scripts/mysql_install_db bash: scripts/mysql_install_db: No such file or directory -- Am I following the correct sequence? There is no directory scripts! In MySQL documentation, section 2.3.1 describes the Source Installation and that's what I am following. I am struck here since you have recently done it you may have a suggestion??? Thanks. Kirt -Original Message- From: Schwartz, Evelyn [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:51 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: RE: Client mySQL Server Just went through this. You need to install MySQL from source. The basic commands you must execute to install a MySQL source distribution are: shell groupadd mysql shell useradd -g mysql mysql shell gunzip mysql-VERSION.tar.gz | tar -xvf - shell cd mysql-VERSION shell ./configure --without-server shell make shell make install The ./configure --without-server only installs the client. You need to read the doco about the source install to look for other options you may want. Evelyn -Original Message- From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:31 PM To: '[EMAIL PROTECTED]' Subject: RE: Client mySQL Server First of all I admit that I am not an expert of MySQL. However, during the last three months I have TEST installed MySQL Server software and gone through the tutorial. My next step is to setup three computers as follows: |--| |--| |--| | 12.21.237.10 | | 12.21.237.11 | | 12.21.237.12 | | freeRADIUS | | qmail/HTTP | | DataServer | |--| |--| |--| | | | |---| My design is have run MySQL on data server and keep all data (sql) on this server. freeRADIUS server is for authentication and qmail/HTTP server is for mail and web pages. I am told that I need to install MySQL client program on freeRADIUS qmail/HTTP servers and master MySQL on DataServer. I have not been able to find either Client or Master MySQL but just MySQL! Is there a subset of MySQL which is known as Client and/or Master MySQL or is it just terminology? Any help is highly appreciated. Kirti -- 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: Client mySQL Server/I need help!!
Evelyn: I need help. I have followed your instructions. Here is my problem: . Installation ... ... Shell Make Install Shell scripts/mysql_install_db bash: scripts/mysql_install_db: No such file or directory -- Am I following the correct sequence? There is no directory scripts! In MySQL documentation, section 2.3.1 describes the Source Installation and that's what I am following. I am struck here since you have recently done it you may have a suggestion??? Thanks. Kirt -Original Message- From: Schwartz, Evelyn [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:51 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: RE: Client mySQL Server Just went through this. You need to install MySQL from source. The basic commands you must execute to install a MySQL source distribution are: shell groupadd mysql shell useradd -g mysql mysql shell gunzip mysql-VERSION.tar.gz | tar -xvf - shell cd mysql-VERSION shell ./configure --without-server shell make shell make install The ./configure --without-server only installs the client. You need to read the doco about the source install to look for other options you may want. Evelyn -Original Message- From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:31 PM To: '[EMAIL PROTECTED]' Subject: RE: Client mySQL Server First of all I admit that I am not an expert of MySQL. However, during the last three months I have TEST installed MySQL Server software and gone through the tutorial. My next step is to setup three computers as follows: |--| |--| |--| | 12.21.237.10 | | 12.21.237.11 | | 12.21.237.12 | | freeRADIUS | | qmail/HTTP | | DataServer | |--| |--| |--| | | | |---| My design is have run MySQL on data server and keep all data (sql) on this server. freeRADIUS server is for authentication and qmail/HTTP server is for mail and web pages. I am told that I need to install MySQL client program on freeRADIUS qmail/HTTP servers and master MySQL on DataServer. I have not been able to find either Client or Master MySQL but just MySQL! Is there a subset of MySQL which is known as Client and/or Master MySQL or is it just terminology? Any help is highly appreciated. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation problem!!!
No change. Any other suggestion? Thanks. Kirti -Original Message- From: Victor Medina [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 7:26 AM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]' Subject: Re: Installation problem!!! Hi! try using the one installed in /usr/local/mysql/bin/mysql_install_db Best Regards! On Wed, 2004-02-25 at 18:45, Kirti S. Bajwa wrote: Hello List: I have installed MySQL Master Server from Binaries 4-5 times without problem. Now I am installing MySQL CLIENT from source and have run into problem, as explained below: Download mysql-5.0.0-alpha.tar.gz in /usr/local % cd /usr/local % gunzip mysql-5.0.0-alpha.tar.gz | tar -xvf - % cd mysql-5.0.0-alpha % ./configure --without-server --prefix=/usr/local/mysql % make % make install % scripts/mysql_install_db When I run the last line scripts/mysql_install_db, I get an error message No such file or directory. I have looked into scripts folder and ther is mysql_install_db.sh. Has anybody else experienced the same problem? What is causing this error? Thanks in advance. Kirti -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation problem!!!
Hello List: I have installed MySQL Master Server from Binaries 4-5 times without problem. Now I am installing MySQL CLIENT from source and have run into problem, as explained below: Download mysql-5.0.0-alpha.tar.gz in /usr/local % cd /usr/local % gunzip mysql-5.0.0-alpha.tar.gz | tar -xvf - % cd mysql-5.0.0-alpha % ./configure --without-server --prefix=/usr/local/mysql % make % make install % scripts/mysql_install_db When I run the last line scripts/mysql_install_db, I get an error message No such file or directory. I have looked into scripts folder and ther is mysql_install_db.sh. Has anybody else experienced the same problem? What is causing this error? Thanks in advance. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to install data on a RAID HDD??
Hello List: First my apology: I have previously asked this question and saved the response. But we lost our Win NT server and all the saved data, so I ask the same question again. I have looked in archives for the last three months and have not been able to find my previous Q/A. I will be setting up MySQL server, as soon as I know how. I plan to install MySQL on a RH 9 Server named data. This server has one main disk (which is a boot disk with all the O/S ) and two RAID-1 HDD mirroring one another. My plan is to install MySQL on the main HDD but install/create all the SQL data, tables, Indexes, etc., on the RAID HDD. RAID HDD will have only SQL data. I have no problem installing MySQL on the main HDD but can not figure out what changes are needed so all the data goes to RAID disks. I am a newbie so please, give direction!! Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to install data on a RAID HDD??
Worked like a charm. Thanks. You are a life saver. Kirti -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 2:21 PM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: Re: How to install data on a RAID HDD?? I have no problem installing MySQL on the main HDD but can not figure out what changes are needed so all the data goes to RAID disks. I am a newbie so please, give direction!! The easiest way to do this would be to move the data directory and all its contents onto the RAID disks. Then symlink to that directory from the original location. Example only from basic source install: mv /usr/local/mysql/var /hdRAID/var ln -s /hdRAID/var /usr/local/mysql/var Please make sure that mysql is shutdown before doing this task. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which MySQL???
Hello List: This is the basic of the basic question. I have recently installed and tested MySQL and am happy with it. Now I want to setup a production server. I notice that there are two MySQL products listed on the MySQL org site (1) MySQL (2) MaxDB MySQL. My question is; which of these two products to use? I personally like to use MaxDB but I am not sure why is it better than regular MySQL? Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Client mySQL Server
First of all I admit that I am not an expert of MySQL. However, during the last three months I have TEST installed MySQL Server software and gone through the tutorial. My next step is to setup three computers as follows: |--| |--| |--| | 12.21.237.10 | | 12.21.237.11 | | 12.21.237.12 | | freeRADIUS | | qmail/HTTP | | DataServer | |--| |--| |--| | | | |---| My design is have run MySQL on data server and keep all data (sql) on this server. freeRADIUS server is for authentication and qmail/HTTP server is for mail and web pages. I am told that I need to install MySQL client program on freeRADIUS qmail/HTTP servers and master MySQL on DataServer. I have not been able to find either Client or Master MySQL but just MySQL! Is there a subset of MySQL which is known as Client and/or Master MySQL or is it just terminology? Any help is highly appreciated. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Control Center!!!
Hello: I have been reading MySQL Control Center. There are screen shots but I have not been able to find documentation. Is the documentation is hidden or not available? If there is documentation, kindly direct me to the URL. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Perl Modules!!!
Hello: I need some advise. I am trying to learn and install MySQL, RH9 distro. My question is about Pearl Modules: 1) Is it common to install Perl Modules? 2) If I do not install Perl Modules now, can I install later on with any big headache? Thanks, Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
my.cnf
Hello: I am installing MySQL 5.0.0 (on a fresh install RH9). I am following binary installation as outlined in official MySQL documentation with default location /usr/local. I sure appreciate if somebody on this list is kind enough to email or list contents of my.cnf file. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation Question
I am trying to install MySQL from source distribution by following the instructions under section: 2.3.1 Quick Source Installation Overview. I notice that the configure state is listed as follows: shell ./configure --prefix=/usr/local/mysql which means to install the software in /usr/local/mysql. After I run this configure statement, I do not see a folder /usr/local/mysql!! Is it correct? Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation Question
Dan: Thank you fast reply on New Year Day. The only reason I was trying to install the source distribution because it is supposed to be optimized!! Is binary distribution is also optimized or it makes no difference? I personally prefer binary myself. I will wait for a response before I start all over again. Thanks again. Kirti -Original Message- From: dan orlic [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 12:07 PM To: Kirti S. Bajwa Subject: Re: Installation Question i never had much luck with the source distribution, let alone using the prefix flag. Try untarring it in /usr/local/mysql dir yourself and then continue with the ./configure make and so forth... better yet, i would untar it in a /usr/local/mysql-whatever-version and then make a soft link of mysql point to that directory, allows you to have multiple installs of mysql where all you have to change is the link and restart mysql. my humble option, go with the binary installation it will take you less then a couple minutes to install. hope this helps. dan Kirti S. Bajwa wrote: I am trying to install MySQL from source distribution by following the instructions under section: 2.3.1 Quick Source Installation Overview. I notice that the configure state is listed as follows: shell ./configure --prefix=/usr/local/mysql which means to install the software in /usr/local/mysql. After I run this configure statement, I do not see a folder /usr/local/mysql!! Is it correct? Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL on RAID server????
Hello List: Here comes a newbie's newbie!! I want to install MySQL 5.0.0 on a machine with RAID. It has the following hardware/Software configuration: DISTRO: RH9 1-Disk which has all the software installed. 2-Disks, which are RAID1 format with one folder /data I plan to use the RAID for data only. I am trying to install Source 5.0.0-alpha version of MySQL. I am not sure how to go about installing. I have two chain of thought: (1) Install MySQL at /usr/local as suggested in the Source installation directive, but install the MySQL data on the RAID disk (/data folder) -or- (2) Install the entire MySQL package on the RAID disk. If my explanation needs better explanation, I will be more than happy to do it. I prefer the (1) method but I have no idea how I can install just data on the RAID disk? I think the ./configure statement needs additional directive, but what? I have reviewed the information on the MySQL web site under Source installation page. There are 4-5 notes from people. Please shoe me the way. Thanks in advance. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What am I doing wrong????a
Thanks. I think your help is what I needed is highly appreciated. Kirti -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 4:22 AM To: [EMAIL PROTECTED] Subject: Re: What am I doing wronga Kirti S. Bajwa [EMAIL PROTECTED] wrote: Hello List: Please point to what am I doing wrong: I am trying to install MySQL on top of RH9. I am following steps outlined MySQL official documentation from Section 2.3.1 titled Quick Source Installation Overview. These are the steps I have performed: # cd /usr/local Download: mysql-standard-4.0.17-pc-linux-i686.tar.gz Note: on RH9 group (mysql) user (mysql) are already there.. # gunzip mysql-standard-4.0.17-pc-linux-i686.tar.gz # tar -xvf mysql-standard-4.0.17-pc-linux-i686.tar # cd mysql-standard-4.0.17-pc-linux-i686 NOW THE PROBLEM = According to the instructions, my next step is: # ./configure --prefix=/usr/local/mysql But I get a message that ./configure is already done This is where I am struck-up for the whole day. Can someone help to direct me to the right direction. mysql-standard-4.0.17-pc-linux-i686.tar.gz is a binary distribution. You should download source or install MySQL from binary distribution. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL Installation!!
Hello List: This is my first post you can easily figure out that I am a complete newbie to mySQL. I have a fresh install of RH9 on a (test) server. It also has mySQL 3.23 installed (part of RH9). My question is: 1) Considering the above setup, do I upgrade (and How?) from 3.23 to 4.0.?? 2) or remove mySQL 3.23 from RH9 installation and re-install mySQL 4.0.?? (tar) I have spent better part of today reading the archives but I still have not gotten any satisfactory answer. Please Help!!! Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What am I doing wrong????
Hello List: Please point to what am I doing wrong: I am trying to install MySQL on top of RH9. I am following steps outlined MySQL official documentation from Section 2.3.1 titled Quick Source Installation Overview. These are the steps I have performed: # cd /usr/local Download: mysql-standard-4.0.17-pc-linux-i686.tar.gz Note: on RH9 group (mysql) user (mysql) are already there.. # gunzip mysql-standard-4.0.17-pc-linux-i686.tar.gz # tar -xvf mysql-standard-4.0.17-pc-linux-i686.tar # cd mysql-standard-4.0.17-pc-linux-i686 NOW THE PROBLEM = According to the instructions, my next step is: # ./configure --prefix=/usr/local/mysql But I get a message that ./configure is already done This is where I am struck-up for the whole day. Can someone help to direct me to the right direction. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
