problem with ssl connection

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

SSL Connections

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

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

Re: Problem with MySQL prompt

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

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 s

Re: Problem with MySQL prompt

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

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

Problem with BLOB data.

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

Multi Instances

2008-04-08 Thread Stefano Elmopi
27;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 Gene

Re: Stored procedures using a variable tablename

2005-11-07 Thread Stefano Obliquid
ted behaviour? anyone has some explanation or a better way 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 g

Stored procedures using a variable tablename

2005-11-06 Thread Stefano Obliquid
nstead. Anyone knows if it's possible 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
he above is true, will the space formerly occupied 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

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
i cannot get more than 245 threads? 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
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:

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 S

Re: altering data structure

2003-01-02 Thread Stefano
e insight you're welcome. Here 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://de

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

2002-11-25 Thread Stefano Locati
tten in simplified chinese and it simply 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, pl

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

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 M

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 M

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 M

RE: MySQL dump/recovery - no bug at all

2002-06-21 Thread Stefano Incontri
efault? Anyway thank you 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 > > >

MySQL dump/recovery probable bug

2002-06-21 Thread Stefano Incontri
KEY Load (IL,Item_ID)-> UNIQUE KEY (IL,Item_ID) I think this could be a bug, because as a matter of fact I wouldn't be able to rebuild our DB in case of crash without editing the SQL Backup file generated by mysqldump, which is really dangerous. Is really urgent for us to solve

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/ (the

VB6 ADO and UPDATE method

2001-12-09 Thread Stefano Vaccari
uld like to know if the simple moving through records 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:/