Hi,
It looks like you are encountering the problem explained by Andy in the following thread of the forum:
http://www.tango-controls.org/community/forums/c/general/installation/ubuntu-1604-problem-installing-from-source-code-libmysqlclient-replaces-libmysqlclient_r/?page=1#post-1470
Hoping this helps,
Reynald
Hi Reynald,
Thanks for your prompt response and it worked well. But again database is created but table are not created.
This time only two tables(access_address and access_device) are created. And subsequently, databased and jive can not be started. It throws an error -
[quote]main(): arrived
Received a CORBA::Exception
Tango exception
Severity = ERROR
Error reason = DB_SQLError
Desc : Failed to query TANGO database (error=Table ‘tango.property_device_hist’ doesn’t exist)
The query was: SELECT count(*) FROM property_device_hist
Origin : DataBase::check_history_tables()
Exiting[/quote]
I have attached dump file of tango database which was created while installation for your reference.
+++ I have also tried to update db manually as suggested in previous post of the same thread. But it didn’t work.
Thanks & Regards,
TCS-GMRT
is there any update about this problem? we’re facing the same issues with the database
thanks
updatet mysql5.5 to 5.6 and now it works
Hi,
I am using a new, clean install of Ubuntu 16.04.
installed mysql-server and mysql-client using apt-get. next, installed python-dev for omniORB and oracle-java-8.
then, i downloaded zmq,omniorb and tango 9.2.2 source files as mentioned in (http://www.tango-controls.org/community/forum/topic/259/post/add/?quote_id=1519). Got stuck at configuration for tango-9.2.2.
I get MYSQL CLIENT LIB : [empty]
I understood that I should setup the mysql-client lib to ‘lmysqlclient_r’. But, how shoudl I do that?
Thanks and Regards,
AstroBlogWeb
Hi AstroBlogWeb,
I just noticed your request for help. Did you solve your problem? In case you didn’t I suggest you try with the latest official release of Tango 9.2.5 first:
[url=http://sourceforge.net/projects/tango-cs/files/tango-9.2.5a.tar.gz/download]http://sourceforge.net/projects/tango-cs/files/tango-9.2.5a.tar.gz/download[/url]
Andy
Hi,
Sorry for the late reply. The solution to the problem reported by Astroblogweb is to install libmysqlclient-dev package:
sudo apt install libmysqlclient-dev
Hi,
Thanks to Andy, Nicolas and Reynald. Finally, I was able to configure tango 9.2.5 on ubuntu 16.04 (clean install). For freshers, I have made a script (not fully automated :P).
It is available at Tango installation script.
The script is a slight modification of the one Nicolas had posted here on the Forum.
bare Ubuntu 16.04 => running Jive, POGO, astor : works 
Hope this script helps others.
AstroBlogWeb
Hi Astroblogweb,
Thank you for sharing the script! It looks very useful.
Just a hint (maybe you already know this): you can easily automitize your script using debconf-set-selections. For instance mysql root password:
debconf-set-selections <<< 'mysql-server mysql-server/root_password password root'
Cheers,