problem with ssl connection

2009-04-14 Thread Stefano Elmopi
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
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

SSL Connections

2009-03-30 Thread Stefano Elmopi
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

Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi
/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

Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi
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

Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi
!!! 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

Problem with MySQL prompt

2008-12-22 Thread Stefano Elmopi
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

Re: Problem with MySQL prompt

2008-12-22 Thread Stefano Elmopi
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

Problem with BLOB data.

2008-06-12 Thread Stefano Elmopi
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

Problem with install DBD

2008-05-15 Thread Stefano Elmopi
/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

Multi Instances

2008-04-08 Thread Stefano Elmopi
'. 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

Re: Stored procedures using a variable tablename

2005-11-07 Thread Stefano Obliquid
to do this? Thankyou Stefano Locati - Obliquid http://software.obliquid.com Stefano Obliquid wrote: Hello, I am moving my first steps with stored procedures in Mysql and I was trying to write a stored procedure using a tablename given as a variable. In this example the local variable m_sequence

Stored procedures using a variable tablename

2005-11-06 Thread Stefano Obliquid
and how? Thank you very much Stefano Locati - Obliquid http://software.obliquid.it/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Innodb optimzation

2005-05-30 Thread stefano
by the old table be entirely returned to the free pool, i.e. added to innodb free? This is important because though the new table would be optimized, I'd have a huge space waste if the answer to this questio is no. Thanks for any input Stefano -- MySQL General Mailing List For list archives

INSERT ... SELECT statement

2005-01-21 Thread Stefano Giorgetti
I need to execute an INSERT...SELECT query. INSERT HIGH_PRIORITY INTO stations_data (station_id, Tmin, Tmax, Tmed, RHmin, RHmax, RHmed, rain, Wmax, slpres, insertion_date) ( SELECT stations.station_id AS stId, min(stations_rt_data.T) AS tmax,

Error 11 and Linux 2.4 (LONG with details included)

2003-10-12 Thread Stefano - 3000 Staff
? Thanks Bye, Stefano -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

HAVING column not in select_statement

2003-09-03 Thread Stefano Fraccaro
I have a query with a column in HAVING clause that not refer any column listed in SELECT statement because I don't need to group by this column and ... this query don't work. It's possible or this feature is planned for the future? Any solution? Thanks

Re: images with mysql

2003-03-20 Thread stefano . cardo
that LONGBLOB could be useful for large objct like images, but I can't understand how to set it in my database... Thank you in advance stefano -- S t e f a n o C a r d o Debian GNU-Linux user - Before posting, please check: http

Re: Inserting strings containing only spaces fails?

2003-02-08 Thread Stefano Bruno Grenci
Hi All, I had the same problem on MySql server 3.23.43 on Solaris platform but, so far, I don't know how to solve it. Can you help me? Thanks in advance. Regards. Stefano Bruno Grenci -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stefano Bruno Grenci ([EMAIL PROTECTED]) Ion Trading System

Re: altering data structure

2003-01-02 Thread Stefano
is my project XML Metabase schema: http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/obliquid/obliquid/common/configs/ Here is the same schema after an XSLT transform http://demo.obliquid.com/index.php?page=core_dbdoc This is the project home page by the way http://dev.obliquid.com/ bye, Stefano

Re: mailing list mysql@lists.mysql.com~{5DWT6/;XPE~}

2002-11-25 Thread Stefano Locati
means i've received the email that you sent me. so it's obviously an automated answer by someone on mysql list. Stefano - http://dev.obliquid.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: unwanted timestamp update

2002-11-22 Thread Stefano Locati
Hello everyone, try using: update szurtcounter set hely='kulfold', datum=datum; instead of: update szurtcounter set hely='kulfold'; this works, maybe there are better ways. Regards, Stefano Locati - http://dev.obliquid.com/ now i run an SQL query like this one: update szurtcounter set

RE: MYSQL freezing

2002-07-18 Thread Stefano Incontri
You could use something like : mysqldump -Q --opt -F --all-databases -h serverName -u root --password=yourpasswd /some/where/backup.sql It generates a SQL commands file able to completely rebuild the DB, e.g. after a mysql_install_db command. Ciao, Stefano -Original Message- From

RE: shell script to backup

2002-07-18 Thread Stefano Incontri
You could use something like : mysqldump -Q --opt -F --all-databases -h serverName -u root --password=yourpasswd /some/where/backup.sql It generates a SQL commands file able to completely rebuild the DB, e.g. useful after a mysql_install_db command. Ciao, Stefano -Original Message

RE: backup

2002-07-18 Thread Stefano Incontri
Try useing something like : mysqldump -Q --opt -F --all-databases -h serverName -u root --password=yourpasswd /some/where/backup.sql It generates a SQL commands file able to completely rebuild the DB, e.g. useful after a mysql_install_db command. Ciao, Stefano -Original Message

RE: MySQL dump/recovery - no bug at all

2002-06-21 Thread Stefano Incontri
very much again, the problem is solved. Regards, Stefano -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: 21 June 2002 16:31 To: [EMAIL PROTECTED] Subject: Re: MySQL dump/recovery probable bug Stefano, Friday, June 21, 2002, 4:43:29 PM, you wrote

a little help for a beginner

2002-04-10 Thread Luigi Stefano Sona
Hello, where can I find a simple php to generate a default html table from a MySql table ? thanks Luigi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

VB6 ADO and UPDATE method

2001-12-09 Thread Stefano Vaccari
and updating is supported, or if there is something wrong in my code. Thank you Stefano - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive