Print

---

Hello,

scisql require a running MySQL instance in order to be installed. 
Indeed, it will insert stored procedures, contained in sql scripts, in 
MySQL.
Nevertheless, eups procedure only build and install MySQL, but doesn't 
configure it.
Indeed, MySQL configuration should be done during Qserv configuration 
procedure, and so once eups procedure is finished.

That's why it's currently not possible to launch scisql install 
procedure in eups.

Here's three proposals which could solve this issue :

- divide scisql install procedure in two phase : a build/install step 
managed by eups (for UDF) and a configuration step managed by Qserv 
configuration procedure (for SQL scripts and tests).
- install zookeeper before scisql, and fill zookeeper with bootstrap 
informations (like MySQL credentials, and datadir) during its own 
installation,
   then during scisql installation :
     - check if mysql is configured, if no configure it.
     - check if mysql is started, if no start it.
     - build scisql UDF,
     - run scisql sql scripts.
   This solution looks complicated. Furthermore, it could be difficult 
to reconfigure Qserv with different Mysql parameters.
- install scisql during Qserv configuration phase, and so extract scisql 
install procedure from eups.

Could we talk briefly about this in our next Qserv meeting ?

Thanks,

Have a nice day,

Fabrice

P.S. : please note that LSST stack already install scisql, but with 
"./configure --client-only", which only performs a partial install and 
is not enough for Qserv.

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