Tango 9 installation error on ubuntu

# 8 years ago
Reynald	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 Rosenberg's Law: Software is easy to make, except when you want it to do something new. Corollary: The only software that's worth making is software that does something new.

# 8 years ago

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

Rosenberg's Law: Software is easy to make, except when you want it to do something new.
Corollary: The only software that's worth making is software that does something new.

# 8 years ago
TCS_GMRT	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 - 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 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 Regards, TCS_GMRT Edited 8 years ago Attachments:* 2Kb

# 8 years ago

TCS_GMRT

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 -

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

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

Regards,
TCS_GMRT

Edited 8 years ago

# 8 years ago
wnasimzada	is there any update about this problem? we're facing the same issues with the database thanks Best regards Wahid

# 8 years ago
wnasimzada	updatet mysql5.5 to 5.6 and now it works Best regards Wahid

# 8 years ago
Astroblogweb	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 Attachments:

# 8 years ago

Astroblogweb

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

# 7 years ago
Andy	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: http://sourceforge.net/projects/tango-cs/files/tango-9.2.5a.tar.gz/download Andy

# 7 years ago
Reynald	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` Rosenberg's Law: Software is easy to make, except when you want it to do something new. Corollary: The only software that's worth making is software that does something new.

# 7 years ago
Astroblogweb	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 :) Edited 7 years ago

# 7 years ago

Astroblogweb

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 :)

Edited 7 years ago

# 7 years ago
Ingvord	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, Edited 7 years ago