It must be a bug in this version of mysql. It works with mysql 4.15, 4.17 and 3.x....
Patrick Proy wrote:
Hello,
I had problem creating a RA : The gui client told :
Error sent by SQL server: #2004\nSelect failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near \'x509 LONGBLOB NOT NULL)\' at line 1\n[SQL.cpp:60] <------------------------------------------------> Error sent by PKI server: #3026\nGiving up on previous error(s)\n[RaStore.cpp:97]<------------------------------------------------> Error sent by PKI server: #3026\nGiving up on previous error(s) [Entity.cpp:191] <------------------------------------------------> Error sent by PKI server: #3026\nGiving up on previous error(s) [Entity_RA.cpp:78] <------------------------------------------------> Error sent by PKI server: #3026\nGiving up on previous error(s) [Entity_SERVER.cpp:646] <------------------------------------------------>
I changed in RaStore.h the sql command (actually I am lazy so I changed it into the binary...) : before : , x509 LONGBLOB NOT NULL) after : , `x509` LONGBLOB NOT NULL)
And it worked.
Is this a bug of Mysql or Newpki ? Is it a known problem ?
System : Linux RH 9.0 (mostly..) Mysql : 4.0.13 (rpm) NewPKI : newpki-server-2.0.0-beta3.i386.rpm
Anyway, it works for me now, so this is just for information....
Patrick Proy -- Network & security consultant Cyber-Networks Tel: (33).6.87.59.83.01 Tel: (33).4.72.83.99.42, Fax: (33).4.78.52.06.18 [EMAIL PROTECTED]
_____________________________________________________________________ NewPKI http://www.newpki.org User Support Mailing List [EMAIL PROTECTED] Automated List Manager [EMAIL PROTECTED]
-- Fr�d�ric Giudicelli http://www.newpki.org _____________________________________________________________________ NewPKI http://www.newpki.org User Support Mailing List [EMAIL PROTECTED] Automated List Manager [EMAIL PROTECTED]
