problem with ssl connection

2009-04-14 Thread Stefano Elmopi


Hi,

Is there someone who is able to connect to an MySQL instance  
connection via ssl,
from a client located on a different server than where is the MySQL  
instance,

using the only option --ssl-ca ?
I'm not able, I can only connect if I use the options  --ssl-ca, --ssl- 
cert and --ssl-key

even if the user that I use was created without any REQUIRE !

thanks.


Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

cell. 3466147165
tel.  0657060500
email:stefano.elm...@sociale.it



Re: SSL Connections

2009-03-31 Thread Stefano Elmopi


Hi Andy,

I used the same user.
I list the steps that I made:

on the server MySQL (10.43.249.17) I created the user:

GRANT ALL PRIVILEGES ON *.* TO 'pippo'@'%' IDENTIFIED BY '*';

then, on the same server:

mysql --ssl-ca=/root/openssl/cacert.pem -u pippo  -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1872
Server version: 5.0.45 Source distribution

on the another server :

mysql --ssl-ca=/root/openssl/cacert.pem -u pippo -h 10.43.249.17  -p
Enter password:
ERROR 2026 (HY000): SSL connection error

mysql --ssl-ca=/root/openssl/cacert.pem --ssl-cert=/root/openssl/ 
client-cert.pem --ssl-key=/root/openssl/client-key.pem -u pippo -h  
10.43.249.17  -p

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1884
Server version: 5.0.45 Source distribution

I believe that to be asked the certification to client
but I wish it was not the case.

Thanks.




Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

cell. 3466147165
tel.  0657060500
email:stefano.elm...@sociale.it

Il giorno 30/mar/09, alle ore 22:39, Andy Shellam ha scritto:


Hi Stefano,

I'm guessing your remote (non-local) server is using a different  
user account than your local server.


r...@localhost
r...@%
r...@somehost.com

are all different users.  If your remote host, or wildhost user  
account has the REQUIRE X509 flag (user must be certified) but your  
local one doesn't, that would explain it.


What are your MySQL versions on both your server and remote client?   
What errors do you get on your client?


Regards,
Andy

Stefano Elmopi wrote:



Hi,

I'm trying to make connections ssl.
I followed the MySQL guide and I've configured the server
then I created a normal user, without the REQUIRE SSL.
On the same server can connect with the only option:

mysql --ssl-ca=cacert.pem -u Pluto -p

but if I try to connect from another host, I must, forcibly, also  
specify the options:


--ssl-cert=client-cert.pem
--ssl-key=client-key.pem

Why ??
The guide says that even from another host, on a normal user,
you can use the only option:

--ssl-ca

but it is not, I am forced to certify the client.
Something wrong?

Thanks



Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

cell. 3466147165
tel.  0657060500
email:stefano.elm...@sociale.it







--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



SSL Connections

2009-03-30 Thread Stefano Elmopi



Hi,

I'm trying to make connections ssl.
I followed the MySQL guide and I've configured the server
then I created a normal user, without the REQUIRE SSL.
On the same server can connect with the only option:

mysql --ssl-ca=cacert.pem -u Pluto -p

but if I try to connect from another host, I must, forcibly, also  
specify the options:


--ssl-cert=client-cert.pem
--ssl-key=client-key.pem

Why ??
The guide says that even from another host, on a normal user,
you can use the only option:

--ssl-ca

but it is not, I am forced to certify the client.
Something wrong?

Thanks



Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

cell. 3466147165
tel.  0657060500
email:stefano.elm...@sociale.it


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi


Hi Krishna,

thanks for the your answer !!!

I have three different my.cnf for my three instances but one general  
my.cnf to manage all instances,

my general my.cnf is:

[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
password = mysys2008srv
log = /MYSQL/MYSQL_LOG/Mysqld_Multi_Log/mysqld_multi.log


## ISTANZE DELLA PARTE PRODUZIONE
##---

## ISTANZA SIA DI PRODUZIONE
##--
[mysqld01]
defaults-file = /etc/mysql.config/my50_SIA.cnf
socket = /tmp/mysql50_SIA.sock
port   = 3307
pid-file   = /DB_MYSQL_PRODUZIONE/MYSQL50/SIA/mysql50_SIA.pid
datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/SIA

## ISTANZA IPPOFONO DI PRODUZIONE
##---
[mysqld02]
defaults-file = /etc/mysql.config/my50_IPPOFONO.cnf
socket = /tmp/mysql50_IPPOFONO.sock
port   = 3306
pid-file   = /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO/mysql50_IPPOFONO.pid
datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO
###

## ISTANZE DELLA PARTE SVILUPPO
##-

## ISTANZA SIA DI SVILUPPO
##
[mysqld11]
defaults-file = /etc/mysql.config/my50_SIA_SVILUPPO.cnf
socket = /tmp/mysql50_SIA_SVILUPPO.sock
port   = 3317
pid-file   = /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO/ 
mysql50_SIA_SVILUPPO.pid

datadir= /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO

but if I put the variable prompt in the specific my.cnf (for example / 
etc/mysql.config/my50_SIA_SVILUPPO.cnf),

the prompt doesn't change 


By


Il giorno 22/dic/08, alle ore 11:59, Krishna Chandra Prajapati ha  
scritto:



Hi Stefano,

You are running three mysql instance on single server. You can have  
three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and  
socket and other information in them. In this way you can set the  
prompt for different instance.


On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi stefano.elm...@sociale.it 
 wrote:



I need advice.
I have three instances of MySQL on a single server.
How can I change the MySQL prompt depending of the instance on which  
connecting ?
If I put the variable prompt in the general my.cnf, the prompt is  
changed but for all instances.
If I put in the variable prompt in the my.cnf associated with the  
instance

in the [mysql] section, the prompt does not change.

Thanks




Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

cell. 3466147165
tel.  0657060500
email:stefano.elm...@sociale.it


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com




--
Krishna Chandra Prajapati
Mob: 9912924044
Email-id: prajapat...@gmail.com


Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

cell. 3466147165
tel.  0657060500
email:stefano.elm...@sociale.it



Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi


Hi Krishna,

the problem is that you use --default-file on the command line and in  
this mode it's working fine,

I also tried,
but I have the configuration of the variable default-file in the  
general my.cnf and I enter in MySQL

in this way:

mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1408
Server version: 5.0.51b-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql

in my case the prompt doesn't change


Il giorno 23/dic/08, alle ore 11:01, Krishna Chandra Prajapati ha  
scritto:



Hi Stefano,

I have tested. It's working fine without any issue.

Open mysql configuration(.cnf) file referencing to 1st mysql  
instance. Add the below entires and restart the mysql server.


[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
prompt  = 'mysql5.1.30 '


[r...@linux18 ~]# mysql --defaults-file=/etc/my1.cnf
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.30 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql5.1.30

Thanks,
-Krishna Chandra Prajapati


On Tue, Dec 23, 2008 at 2:00 PM, Stefano Elmopi stefano.elm...@sociale.it 
 wrote:


Hi Krishna,

thanks for the your answer !!!

I have three different my.cnf for my three instances but one general  
my.cnf to manage all instances,


my general my.cnf is:

[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
password = mysys2008srv
log = /MYSQL/MYSQL_LOG/Mysqld_Multi_Log/mysqld_multi.log


## ISTANZE DELLA PARTE PRODUZIONE
##---

## ISTANZA SIA DI PRODUZIONE
##--
[mysqld01]
defaults-file = /etc/mysql.config/my50_SIA.cnf
socket = /tmp/mysql50_SIA.sock
port   = 3307
pid-file   = /DB_MYSQL_PRODUZIONE/MYSQL50/SIA/mysql50_SIA.pid
datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/SIA

## ISTANZA IPPOFONO DI PRODUZIONE
##---
[mysqld02]
defaults-file = /etc/mysql.config/my50_IPPOFONO.cnf
socket = /tmp/mysql50_IPPOFONO.sock
port   = 3306
pid-file   = /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO/ 
mysql50_IPPOFONO.pid

datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO
###

## ISTANZE DELLA PARTE SVILUPPO
##-

## ISTANZA SIA DI SVILUPPO
##
[mysqld11]
defaults-file = /etc/mysql.config/my50_SIA_SVILUPPO.cnf
socket = /tmp/mysql50_SIA_SVILUPPO.sock
port   = 3317
pid-file   = /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO/ 
mysql50_SIA_SVILUPPO.pid

datadir= /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO

but if I put the variable prompt in the specific my.cnf (for  
example /etc/mysql.config/my50_SIA_SVILUPPO.cnf),

the prompt doesn't change 


By


Il giorno 22/dic/08, alle ore 11:59, Krishna Chandra Prajapati ha  
scritto:



Hi Stefano,

You are running three mysql instance on single server. You can have  
three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and  
socket and other information in them. In this way you can set the  
prompt for different instance.


On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi stefano.elm...@sociale.it 
 wrote:



I need advice.
I have three instances of MySQL on a single server.
How can I change the MySQL prompt depending of the instance on  
which connecting ?
If I put the variable prompt in the general my.cnf, the prompt is  
changed but for all instances.
If I put in the variable prompt in the my.cnf associated with the  
instance

in the [mysql] section, the prompt does not change.

Thanks




Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

cell. 3466147165
tel.  0657060500
email:stefano.elm...@sociale.it


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com




--
Krishna Chandra Prajapati
Mob: 9912924044
Email-id: prajapat...@gmail.com



Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

cell. 3466147165
tel.  0657060500
email:stefano.elm...@sociale.it




--
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15, Sindhi Colony
P.G.Road, Secunderabad.
Pin Code: 53
Office Number: 040-66489771
Mob: 9912924044
URL: ed-ventures-online.com
Email-id: prajapat...@gmail.com


Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

cell. 3466147165
tel.  0657060500
email:stefano.elm...@sociale.it



Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi



Hi Krishna,

I use the script mysql_multi to stop and the start several, or all,  
instances.


At the end, to work with more ease,
I will create scripts to connect to each instance
and in the script force the variable prompt at the connection  
seems easy 


Thanks for all !!!



Il giorno 23/dic/08, alle ore 13:51, Krishna Chandra Prajapati ha  
scritto:



Hi Stefano,

I believe that, different mysql configuration file for different  
mysql instance is a better idea. In your case, if any thing goes  
wrong with my.cnf Then, it is going to effect all mysql instance  
(either restart mysql server or any other way). It has a lots of  
disadvantages.


You might be using mysql_multi to manage mysql instance (restart,  
start, stop)


As, you told me. You have 1 general my.cnf and three different  
my.cnf for mysql instance. In one of my.cnf  add and try


[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
prompt  = 'mysql5.1.30 '

But again, if you are connecting with socket then it will not show  
the changed prompt. Try, to connect using defaults-file.


I feel that connecting to mysql server using socket is not reading  
the configuration file. i mean to say the it's using default  
available to it.


Thanks,
Krishna Chandra Prajapati



On Tue, Dec 23, 2008 at 5:14 PM, Stefano Elmopi stefano.elm...@sociale.it 
 wrote:


Hi Krishna,

the problem is that you use --default-file on the command line and  
in this mode it's working fine,

I also tried,
but I have the configuration of the variable default-file in the  
general my.cnf and I enter in MySQL

in this way:

mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1408
Server version: 5.0.51b-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql

in my case the prompt doesn't change


Il giorno 23/dic/08, alle ore 11:01, Krishna Chandra Prajapati ha  
scritto:



Hi Stefano,

I have tested. It's working fine without any issue.

Open mysql configuration(.cnf) file referencing to 1st mysql  
instance. Add the below entires and restart the mysql server.


[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
prompt  = 'mysql5.1.30 '


[r...@linux18 ~]# mysql --defaults-file=/etc/my1.cnf
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.30 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql5.1.30

Thanks,
-Krishna Chandra Prajapati


On Tue, Dec 23, 2008 at 2:00 PM, Stefano Elmopi stefano.elm...@sociale.it 
 wrote:


Hi Krishna,

thanks for the your answer !!!

I have three different my.cnf for my three instances but one  
general my.cnf to manage all instances,


my general my.cnf is:

[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
password = mysys2008srv
log = /MYSQL/MYSQL_LOG/Mysqld_Multi_Log/mysqld_multi.log


## ISTANZE DELLA PARTE PRODUZIONE
##---

## ISTANZA SIA DI PRODUZIONE
##--
[mysqld01]
defaults-file = /etc/mysql.config/my50_SIA.cnf
socket = /tmp/mysql50_SIA.sock
port   = 3307
pid-file   = /DB_MYSQL_PRODUZIONE/MYSQL50/SIA/mysql50_SIA.pid
datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/SIA

## ISTANZA IPPOFONO DI PRODUZIONE
##---
[mysqld02]
defaults-file = /etc/mysql.config/my50_IPPOFONO.cnf
socket = /tmp/mysql50_IPPOFONO.sock
port   = 3306
pid-file   = /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO/ 
mysql50_IPPOFONO.pid

datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO
###

## ISTANZE DELLA PARTE SVILUPPO
##-

## ISTANZA SIA DI SVILUPPO
##
[mysqld11]
defaults-file = /etc/mysql.config/my50_SIA_SVILUPPO.cnf
socket = /tmp/mysql50_SIA_SVILUPPO.sock
port   = 3317
pid-file   = /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO/ 
mysql50_SIA_SVILUPPO.pid

datadir= /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO

but if I put the variable prompt in the specific my.cnf (for  
example /etc/mysql.config/my50_SIA_SVILUPPO.cnf),

the prompt doesn't change 


By


Il giorno 22/dic/08, alle ore 11:59, Krishna Chandra Prajapati ha  
scritto:



Hi Stefano,

You are running three mysql instance on single server. You can  
have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port  
and socket and other information in them. In this way you can set  
the prompt for different instance.


On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi stefano.elm...@sociale.it 
 wrote:



I need advice.
I have three instances of MySQL on a single server.
How can I change the MySQL prompt depending of the instance on  
which connecting ?
If I put

Problem with MySQL prompt

2008-12-22 Thread Stefano Elmopi



I need advice.
I have three instances of MySQL on a single server.
How can I change the MySQL prompt depending of the instance on which  
connecting ?
If I put the variable prompt in the general my.cnf, the prompt is  
changed but for all instances.
If I put in the variable prompt in the my.cnf associated with the  
instance

in the [mysql] section, the prompt does not change.

Thanks




Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

cell. 3466147165
tel.  0657060500
email:stefano.elm...@sociale.it


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: Problem with MySQL prompt

2008-12-22 Thread Stefano Elmopi


Thanks for the all answers !!!

It's ok,
even if I have three different my.cnf for my three instances,
my general my.cnf is:

[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
password = mysys2008srv
log = /MYSQL/MYSQL_LOG/Mysqld_Multi_Log/mysqld_multi.log


## ISTANZE DELLA PARTE PRODUZIONE
##---

## ISTANZA SIA DI PRODUZIONE
##--
[mysqld01]
defaults-file = /etc/mysql.config/my50_SIA.cnf
socket = /tmp/mysql50_SIA.sock
port   = 3307
pid-file   = /DB_MYSQL_PRODUZIONE/MYSQL50/SIA/mysql50_SIA.pid
datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/SIA

## ISTANZA IPPOFONO DI PRODUZIONE
##---
[mysqld02]
defaults-file = /etc/mysql.config/my50_IPPOFONO.cnf
socket = /tmp/mysql50_IPPOFONO.sock
port   = 3306
pid-file   = /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO/mysql50_IPPOFONO.pid
datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO
###

## ISTANZE DELLA PARTE SVILUPPO
##-

## ISTANZA SIA DI SVILUPPO
##
[mysqld11]
defaults-file = /etc/mysql.config/my50_SIA_SVILUPPO.cnf
socket = /tmp/mysql50_SIA_SVILUPPO.sock
port   = 3317
pid-file   = /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO/ 
mysql50_SIA_SVILUPPO.pid

datadir= /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO

to have three different prompts,
I have to create three scripts connection where I configure the prompt  
variable.

I say right?


By



Il giorno 22/dic/08, alle ore 12:07, Warren Young ha scritto:


Stefano Elmopi wrote:
If I put the variable prompt in the general my.cnf, the prompt is  
changed but for all instances.
If I put in the variable prompt in the my.cnf associated with the  
instance

in the [mysql] section, the prompt does not change.


This is because the client reads from my.cnf before it starts  
talking to the server, and it can read any my.cnf file it likes.   
There's no way you can mandate that a single my.cnf file gets used  
for both the server and any client session connecting to it.


Instead of running mysql(1) directly, I'd run it via one of three  
scripts, each of which sets up its environment so as to force  
mysql(1) to read a different my.cnf file in each case.  This will  
also let you hard-code other information about each particular  
server that isn't important to keep secret, like the login name and  
the DB name.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=stefano.elm...@sociale.it




Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

cell. 3466147165
tel.  0657060500
email:stefano.elm...@sociale.it


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Problem with BLOB data.

2008-06-12 Thread Stefano Elmopi



Hi,

I have a problem with the migration of a table that has a column with BLOB data.
The source server is MySQL version: 4.0.16 and the destination server is MySQL 
version: 5.0.45
I tried with mysqldump and SELECT INTO but when import the data on the destination server, the 
BLOB data are corrupt.



Someone can help me?



Thanks



--
Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

tel:0657060500
email:[EMAIL PROTECTED]

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



Problem with install DBD

2008-05-15 Thread Stefano Elmopi


Hi,

I have installed MySQL on an Opteron 64bit with operating system Scientific Linux CERN SLC release 
4.6 (Beryllium)

by an archive TAR, under the directory /opt/local/mysql50.
The problem is that I want to install drivers DBD to use MySQLBenchmark but i 
run

perl Makefile.PL --mysql_config=/opt/local/mysql50/bin/mysql_config

then

make

and then

make test

But there are many errors of this type:

t/warningsinstall_driver(mysql) failed: Can't load 
'/opt/BUILD/DBD/DBD-mysql-4.006/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: 
libmysqlclient.so.15: cannot open shared object file: No such file or directory at 
/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/DynaLoader.pm line 230


but the library there is in:

/opt/local/mysql50/lib/mysql/libmysqlclient.so.15

and is located in the directory that is returned by the script

/opt/local/mysql50/bin/mysql_config --libs
-L/opt/local/mysql50/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm

Someone help me?

Thanks





--
Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

tel:0657060500
email:[EMAIL PROTECTED]

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



Multi Instances

2008-04-08 Thread Stefano Elmopi


Hi,

I have two instances of Mysql 5.0 on a server Scientific Linux CERN SLC release 
4.6 (Beryllium)
and the instances work well, I turn on and turn off the instances by 
mysqld_multi.
I would like to start automatically instances at the start of the server Linux.
I took the script mysqld_multi.server and I added lines:

# Comments to support chkconfig on RedHat Linux
# chkconfig: 2345 64 36
# description: A very fast and reliable SQL database engine.

and i copied it in the directory:

/etc/init.d

with the name mysqld
then I typed the commands:

chmod -x /etc/init.d/mysqld  and
chkconfig --add mysqld

but if I start the service (service mysqld start), I have:

WARNING: my_print_defaults command not found.
Please make sure you have this command available and
in your path. The command is available from the latest
MySQL distribution.
ABORT: Can't find command 'my_print_defaults'.
This command is available from the latest MySQL
distribution. Please make sure you have the command
in your PATH.



Ciao

--
Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma

tel:0657060500
email:[EMAIL PROTECTED]

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