"User not created in ART" error

[Predrag Zečević]

I have created new instance, with own MySQL database.
Connection to DB from command line from node works (checked).

:; MYSQL_PWD=*** mysql -h arttestdb2 -u art arttest2 -NBe "Select Now()"
2023-04-26 16:22:39

DB string is defined properly in webapps/art/WEB-INF/work/art-database.json file:

{
  "datasourceId" : 0,
  "name" : null,
  "driver" : "com.mysql.jdbc.Driver",
  "url" : "jdbc:mysql://arttestdb2/arttest2?useSSL=false",
  "username" : "art",
  "testSql" : "select 1",
  "connectionPoolTimeoutMins" : 5,
  "jndi" : false,
  "passwordAlgorithm" : null,
  "datasourceType" : null,
  "maxPoolConnections" : 20,
  "connectionPoolLibrary" : "ArtDBCP"
}

Tomcat 9.0.73 is configured and running (deployed art-7.3/art.war)
DB Schema imported:

:; mysql -uroot arttest2 < art-7.3-art-tables.sql
:; mysql -uroot arttest2 < art-7.3-qrtz_tables_mysql.sql

Yet, accessing http://node:8080/art shows no Configure option (see attached image).

How can I create admin user (error from title is shown when I have tried to use admin/admin user)?

Regards.

[Timothy Anyona]

The admin/admin user exists in the demo hsqldb database and is not contained in the art-tables.sql script.

What you can do is login using the database credentials e.g. root user and password. After that you should be able to create an admin user or role.

[Predrag Zečević]

Thanks! That has worked.

BUT: I was able to see main menu only first time when I was logged as mysql user.
After clicking on save (after adding admin user), mainj menu got lost.

Using Firefox 112, cleared complete Cache, not using proxy.

What would it be?

If I use http://node:8080/art/settings directly, I see form.. Same for /users, etc entries (I have to guess what to add).

Regards.

P.S. I use old art 3, and that is how I can guess all configuration options. See attached image for old art menu

[Timothy Anyona]

Could you post a screenshot of the menu you have when logged in as the admin user?

[Predrag Zečević]

Hi, sure (just w/o real host name).

So, log-in screen (http://node:8080/art/login) let me log-in as admin user, and then redirects to http://node:8080/art/reports (see attached image).

Regards.

[Timothy Anyona]

OK. Was interested in the main menu, the one with reports, language etc, but it's ok.

Login as the root user, and then edit this admin user and confirm which Roles he has.

[Predrag Zečević]

That is problem ("OK. Was interested in the main menu, the one with reports, language etc, but it's ok."): there is NO MAIN menu

Regarding roles, it shows (see image art-admin-user-screen, http://node:8080/art/editUser?id=0)

[Timothy Anyona]

Please deactivate the Public User option. That is likely why there is no main menu.

I also see the user id is 0, which is odd. Not sure if the record was created or amended in the database.

[Predrag Zečević]

Thanks,! So:

• Public User option did it! I see Menu now...
• User ID 0 is my mistake (before I have open this thread, I have added admin user manually -- anyway, I am planning to throw away this container and create new one!)

We can consider this solved (maybe to add into documentation "Public User" option note, just for other users)
Thanks again.