cms-sw/cmsdist — pull request #1031 by jmonkevicius (2014-09-18 23:08:27+00:00)
Title: Adding new MariaDB version

* Updated database from MySQL to MariaDB 10.0.12 version.
* Updated py2-mysqldb to newer 1.2.4b4 version.
* Updated py2-mysqldb-setup.patch for correct py2-mysqldb working with new mysqldb version.
* Removed mysql.spec file
* Removed "required mysql " from crabserver.spec

It was tested only in SLC6 and pushed to comp_gcc481 branch.
It was tested also with SQLAlchemy 0.9.6 version [ https://github.com/cms-sw/cmsdist/pull/1029 ]. Not with 0.5.2 version.
It was tested also with cx_Oracle 5.1.3 version [ https://github.com/cms-sw/cmsdist/pull/1030 ]. Not with 5.1 version.

In WMAgent deployment case, before starting MariaDB services, need to change deployment file [ https://github.com/jmonkevicius/deployment/commit/fb33c9e12365d760b0ca27075d0fd5285df77503 ].
Reason: new version of database don't understand simbols "set-variable" . Seting my.cnf parameters at mariadb.spec file is not working because deployment script [ https://github.com/dmwm/deployment ] is overwriting this config file.

======================================================
* [Not resolved yet] Standart testing and validation of WMAgent from Justas was successful, but this MariaDB version gives warning after command

" ./manage execute-agent wmagent-resource-control --add-all-sites --plugin=CondorPlugin --pending-slots=50 --running-slots=50 " -->

"
Adding T3_GR_IASA to the resource control db...
/data/srv/wmagent/0.9.95b-comp2/sw.pre.jmonkevi/slc6_amd64_gcc481/external/py2-sqlalchemy/0.9.6/lib/python2.6/site-packages/sqlalchemy/engine/default.py:435: Warning: Duplicate entry 'T3_GR_IASA' for key 'site_name'
cursor.execute(statement, parameters)
"
.
=====================================================

@amaltaro @juztas @hufnagel @geneguvo