How to manually create tango database ?

Dear tangoer

I try to install Tango 9.2.1 on Ubuntu 14.04, after configure,make is ok except it could not create tango database in MySQL, the error message is : create_db_tables.sql': Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

so i must firstly to solve create_db_tables.sql file or MySQL configure problem( now i didn't get what cause this problem?, before install tango 8.1.2 all is ok),then i will create tango database manually (because i don't want to rebuild tango library), but i want to know how to create tango database by using file in tango-9.2.1\cppserver\database directory?

mysql version: mysql Ver 14.14 Distrib 5.5.47, for debian-linux-gnu (x86_64) using readline 6.3

Thanks
Edited 4 years ago
Hi Jimmy,

I am using mysql 5.6.28 and I have just try once again. I don't have problem with the create_db_tables.sql script.
If you had Tango 8.1.2 running, this means that you have already a database created and configured.
In such a case, you should not use the create_db.sh (calling create_db_tables.sql) but rather one of the update database
script which will simply update your database to be compatible with Tango 9.
look in the README file the chapter "Updating from previous Tango releases"

Hoping this help

Emmanuel
Hi Manu

Thanks for your reply

The problem arise form
accessed timestamp NOT NULL default CURRENT_TIMESTAMP
in tango-9.2.1/cppserver/database/create_db_tables.sql.in file

It's my mysql 5.5.x restriction
Edited 4 years ago
 
Register or login to create to post a reply.