1.18 Manual Install

GCTECH

We have enough customizations that we always do a manual installation and import previous data. When we install 1.18, no default users are created (idoit_data.isys_cats_person_list is empty). When I try using the install script on a Redhat installation (no customization), the script fails on MariaDB setup:

Do you want to configure MariaDB? [Y]es [n]o:
Configure MariaDB DBMS
Please enter the MariaDB hostname [leave empty for 'localhost']:
Please enter a new password for MariaDB's super user 'root' [leave empty for 'idoit']:
Set root password and plugin 'mysql_native_password'
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Like I said we run this on a server with pretty stringent security settings and lots of customizations so it may have more to do with our setup than anything else. Can anyone give some advice on how to create default users in db with proper encryption?

Selcuk Kekec

Hi,

actually it is not clear to me on which way you try to install i-doit. If you are using the default "install" command provided by "console.php" the issue that no persons are created is unknown to me.

But there is known problem regarding the "install"-script placed in "setup/install.sh" which is not able to create such users because of a bug. We are currently working on this topic.

Until a solution you can use "console.php install" instead.

Unfortunately i think you have a typo in your mysql password for the "root" user. Please try to login via the mysql client directly and ensure that the password is correct:

mysql -u root -p[YOUR_PASSWORD_WITHOUT_A_SPACE_AFTER_P_OPTION]

Best regards

Selcuk