ERROR 1050 (42S01) at line 29 in file: 'mysql_gen/AUDIT_TRAIL.sql': Table 'AUDIT_TRAIL' already exists

[salonimi...@gmail.com]

Hi Ronald,

We are installing schedulix 2.7 in our new environment where we are creating schedulix database and after running below command -

mysql --user=schedulix --password='Schedulix@123' --database=schedulixdb --execute="source mysql/install.sql"

we are getting the below error-

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1050 (42S01) at line 29 in file: 'mysql_gen/AUDIT_TRAIL.sql': Table 'AUDIT_TRAIL' already exists

Could you please help.

Thank you,

Saloni

[Ronald Jeninga]

Hi Saloni,

as it seems, the schema is already present in your database.

If it's empty, you can use it, if not, you'll have to drop and recreate it.

If we've made a mistake in our installation scripts that causes the CREATE AUDIT_TRAIL statement to be executed twice, well, that's fine as well.

We need that table, but we don't need two of them ;-) In that case, just ignore the error.

HTH

Best regards,

Ronald

[salonimi...@gmail.com]

Hi Ronald,

Before the above error we have got the below error-

[root@ora-sitbtch sql]# mysql --user=schedulix --password=Schedulix@123 --database=schedulixdb --execute="source mysql/install.sql"

mysql: [Warning] Using a password on the command line interface can be insecure.

ERROR 1064 (42000) at line 29 in file: 'mysql_gen/GROUPS.sql': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUPS (
    `ID`                           decimal(20) NOT NULL
    , `NAME`   ' at line 1

Could you please help on this?

Thank you,

Saloni