PostgreSQL or mySQL

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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 ??

[Kirti S. Bajwa]

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
% gunzip  <  mysql-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]

RE: Restrict connection to MySQL Server

[Kirti S. Bajwa]

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]

Restrict connection to MySQL Server

[Kirti S. Bajwa]

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: MySQL does not automatically start at BOOT time??

[Kirti S. Bajwa]

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]

Simple questions!!

[Kirti S. Bajwa]

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??

[Kirti S. Bajwa]

Sam:

I removed MySQL by removing the directory /etc/local/ &
/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/ 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?
> > >
> > 

RE: MySQL does not automatically start at BOOT time??

[Kirti S. Bajwa]

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.server
> >>/etc/init.d
> >>% cd /etc/in

RE: MySQL does not automatically start at BOOT time??

[Kirti S. Bajwa]

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.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??

[Kirti S. Bajwa]

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.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??

[Kirti S. Bajwa]

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.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]

MySQL does not automatically start at BOOT time??

[Kirti S. Bajwa]

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.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]

No Posting

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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]

RE: Perl Modelues

[Kirti S. Bajwa]

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]

Perl Modelues

[Kirti S. Bajwa]

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
, 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

[Kirti S. Bajwa]

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
, 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!!

[Kirti S. Bajwa]

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???

[Kirti S. Bajwa]

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]

RE: Basic Setup Questions!!!!

[Kirti S. Bajwa]

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]

Basic Setup Questions!!!!

[Kirti S. Bajwa]

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: UID/PW Question???

[Kirti S. Bajwa]

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: my.cnf Setup!!

[Kirti S. Bajwa]

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: Client mySQL Server/I need help!!

[Kirti S. Bajwa]

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!!

[Kirti S. Bajwa]

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!!!

[Kirti S. Bajwa]

No change. Any other suggestion?

Thanks.

Kirti

-Original Message-
From: Victor Medina [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 7:26 AM
To: Kirti S. Bajwa
Cc: '[EMAIL PROTECTED]'
Subject: Re: Installation problem!!!


Hi!

try using the one installed in /usr/local/mysql/bin/mysql_install_db

Best Regards!

On Wed, 2004-02-25 at 18:45, Kirti S. Bajwa wrote:

> Hello List:
> 
> I have installed MySQL Master Server from Binaries 4-5 times without
> problem. Now I am installing MySQL CLIENT from source and have run into
> problem, as explained below:
>   Download "mysql-5.0.0-alpha.tar.gz" in  /usr/local 
>   % cd  /usr/local
>   % gunzip < mysql-5.0.0-alpha.tar.gz  | tar -xvf -   
>   % cd mysql-5.0.0-alpha
>   % ./configure   --without-server   --prefix=/usr/local/mysql
>   % make
>   % make install
>   % scripts/mysql_install_db
> 
> When I run the last line "scripts/mysql_install_db", I get an error
message
> "No such file or directory".  I have looked into "scripts" folder and ther
> is "mysql_install_db.sh".
> 
> Has anybody else experienced the same problem? What is causing this error?
> 
> Thanks in advance.
> 
> Kirti

-- 

 |...|
 |  _    _|Victor Medina M   |
 |\ \ \| |  _ \ / \   |Linux - Java - MySQL  |
 | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
 | / / / |___|  __/ ___ \ |[EMAIL PROTECTED]  |
 |/_/_/|_|_| /_/   \_\|ext. 325 - Tél: +58-241-8507325   |
 ||geek by nature - linux by choice  |
 |...|





















--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Client mySQL Server/I need help!!

[Kirti S. Bajwa]

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]

Installation problem!!!

[Kirti S. Bajwa]

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]

RE: How to install data on a RAID HDD??

[Kirti S. Bajwa]

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]

How to install data on a RAID HDD??

[Kirti S. Bajwa]

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]

Which MySQL???

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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]

Perl Modules!!!

[Kirti S. Bajwa]

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]

MySQL Control Center!!!

[Kirti S. Bajwa]

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]

my.cnf

[Kirti S. Bajwa]

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]

RE: Installation Question

[Kirti S. Bajwa]

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]

Installation Question

[Kirti S. Bajwa]

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????

[Kirti S. Bajwa]

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

[Kirti S. Bajwa]

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
> 
> 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]

What am I doing wrong????

[Kirti S. Bajwa]

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

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]

mySQL Installation!!

[Kirti S. Bajwa]

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]