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]
