Print

Print


Jacek,

> How about simply keeping the credentials in ~/.my.cnf
> file (I think it'd be useful to can come up with
> lsst-specific name for the file to avoid collisions.)
> I just realized mysql api allows to directly use such
> config file:
> 
> db=_mysql.connect(host="outhouse",db="thangs",read_default_file="~/.my.cnf")
> 
> (this is from http://mysql-python.sourceforge.net/MySQLdb.html)
> 
> It is handy and mysql-compatible.

	I think this is good for MySQL.  ~/.my.cnf should already be
read by default, I believe.  My only concern is that we don't have a
problem if we have to change RDBMS implementations.  The original
~/.lsst/db-auth.paf was developed to be database-agnostic, but it's
probably not too bad to force people to use database-specific
credential storage, as implementations won't change that frequently.

-- 
Kian-Tat Lim, LSST Data Management, [log in to unmask]

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