 |
 |
Hello, Osma Aidel, database expert at CC-IN2P3, find out some problems when installing SciSQL in MariaDB. Here are some of them : 1. default plugin dir has been modified, so next option has to be added to configure : --mysql-plugins=/usr/local/mysql/lib/plugin 2. MariaDB version isn't recognize at configure time : -- Checking for mysql plugins directory : /usr/local/mysql/lib/plugin Checking for mysql.h : yes Checking MySQL version : Invalid MYSQL_SERVER_VERSION 5.5.34-MariaDB -- 3. after having hacked 2, a problem occurs during install : [qserv@clrlsstwn04 scisql-0.3.2]$ make install Waf: Entering directory `/home/qserv/src/scisql-0.3.2/build' ... Running testS2PtInBox.py : OK Running testS2PtInCircle.py : OK Running testS2PtInEllipse.py : OK Running docs.py : FAIL [see /home/qserv/src/scisql-0.3.2/build/tools/docs.log] 9 tests passed, 1 failed, and 0 failed to run docs.log contains next message : ERROR 1148 (42000) at line 5: The used command is not allowed with this MariaDB version Failed to run documentation example: TRUNCATE TABLE Science_Ccd_Exposure_HtmId10; LOAD DATA LOCAL INFILE '/tmp/scisql_demo_htmid10.tsv' INTO TABLE Science_Ccd_Exposure_HtmId10; The problem is that "local-infile" isn't allowed by default, so mysql client has to be launched with next option : mysql --local-infile=1 -u root -p MariaDB [scisql_demo]> TRUNCATE TABLE Science_Ccd_Exposure_HtmId10; Query OK, 0 rows affected (0.00 sec) MariaDB [scisql_demo]> LOAD DATA LOCAL INFILE '/tmp/scisql_demo_htmid10.tsv' INTO TABLE Science_Ccd_Exposure_HtmId10; Query OK, 123 rows affected (0.00 sec) Records: 123 Deleted: 0 Skipped: 0 Warnings: 0 I think we should make a fix in order to support MariaDB ? Cheers, Fabrice ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the QSERV-L list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1