TAC: No license available, please input your valid license

[navds]

I installed TAC on my Ubuntu machine using the advanced mode of Talend-Tools-Installer-20181026_1147-V7.1.1-linux64-installer.run.

My computer is connected to the internet, my firewall is disabled temporarily. 

$ echo $JAVA_HOME
/usr/lib/jvm/java-8-openjdk-amd64

I am stuck at the following step. I can click "Set new license" then upload the license but it still shows "No license available, please input your valid license"

I can see the license at apache-tomcat/webapps/org.talend.administrator/WEB-INF/classes/install.txt though.

Nothing happens when I click the button "Validate your license manually". 

I tried to open the web app in a private window, nothing. Changed browser from Chrome to Firefox, nothing. Viewed the javascript console while I click validate license manually, nothing.

The license file is valid since it is used on our server.

Anyone could spot the source of the problem?

[Anonymous]

Hello,

What's your TAC database? Is it Oracle? In the table user role, is there any administrator user role?

Best regards

Sabrina

[navds]

Hello Sabrina,

I am using 

$ mysql --version
mysql  Ver 15.1 Distrib 10.1.40-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

driver: mysql-connector-java-8.0.16.jar

I think database connection should be fine since the tables are generated.

MariaDB [tac_administrator]> select * from userrole;
+----+----------+-----------+------------------------+----------------+-------+--------+---------+
| id | dtype    | e_version | name                   | localizedlabel | fixed | custom | enabled |
+----+----------+-----------+------------------------+----------------+-------+--------+---------+
|  1 | UserRole |         0 | Security Administrator | empty          |      |        |         |
|  2 | UserRole |         0 | Administrator          | empty          |      |        |         |
|  3 | UserRole |         0 | Viewer                 | empty          |       |        |         |
|  4 | UserRole |         0 | Operation manager      | empty          |       |        |         |
|  5 | UserRole |         0 | Auditor                | empty          |       |        |         |
|  6 | UserRole |         0 | Designer               | empty          |       |        |         |
|  7 | UserRole |         0 | Administrative Use     | empty          |       |        |         |
|  8 | UserRole |         0 | Custom Role 1          | empty          |       |       |         |
|  9 | UserRole |         0 | Custom Role 2          | empty          |       |       |         |
| 10 | UserRole |         0 | Custom Role 3          | empty          |       |       |         |
| 11 | UserRole |         0 | Custom Role 4          | empty          |       |       |         |
| 12 | UserRole |         0 | Custom Role 5          | empty          |       |       |         |
| 13 | UserRole |         0 | Custom Role 6          | empty          |       |       |         |
| 14 | UserRole |         0 | Custom Role 7          | empty          |       |       |         |
| 15 | UserRole |         0 | Custom Role 8          | empty          |       |       |         |
| 16 | UserRole |         0 | Custom Role 9          | empty          |       |       |         |
| 17 | UserRole |         0 | Custom Role 10         | empty          |       |       |         |
+----+----------+-----------+------------------------+----------------+-------+--------+---------+

Regards, 

[navds · Accepted solution]

I don't know why but I switched from mariadb to mysql and this problem has been solved.

Before:

$ mysql --version
mysql  Ver 15.1 Distrib 10.1.40-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Now:

# mysql --version
mysql  Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using  EditLine wrapper

Installed drivers:

$ ls apache-tomcat/endorsed       
mariadb-java-client-2.4.2.jar    talend-url-mvn-1.0.0.jar
mysql-connector-java-8.0.16.jar