I have installed web-erp successfully. After login it shows following error message.
ERROR Report : Security settings have not been defined for your user account. Please advise your system administrator. It could also be that there is a session problem with your PHP web server.
This looks like the installation has not fully completed populating the database. This can happen as a result of the timeout on some servers kicking in before completion.
The fool proof way would be to populate the database by running the sql under
webERP/sql/mysql/country_sql/default.sql
for a new system or
webERP/sql/mysql/country_sql/demo.sql
directly against your mysql server - perhaps using phpMyAdmin ? or the command line.
instructions on how to do this are in:
Hello Phil,
I am having the same problem. After doing the installation, the login would not work. After three attempts the message as above appeared. Research suggested a number of solutions, including checking whether the user is blocked (it is not), changing the password using PHP,. That did not work. Reinstalling webERP from scratch, Installing using the default.sql script as suggested above. The server is running PHP 7.4 and MariaDB 10.4 running on Ubuntu 18.4. I am comfortable with SQL and PHP, and program in both, so that should not be the problem. When reinstalling I have deleted the folder and installed anew. Similarly with the database, I have dropped the schema, and started with a new database. Perhaps I've missed something, but at this stage, I can't see what. Please help. Thanks.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello Roy, when the password is inserted in the database it is
encrypted using the PHP function - password_hash() (see https://www.php.net/manual/en/function.password-hash.php), assuming
you are using a version of PHP greater than 5.5. If you are familiar
with PHP and sql you are probably able to create a small script that
manually updates the database table www_users. If not, or if this
doesn't work, then let me know.
Thanks
Tim
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I tried that before trying to contact you. It did not work either. The
problem is now sorted out. Please see my previous response.
Thenks for coming back on this.
Roy
On 10/19/21 8:32 AM, Tim Schofield wrote:
Hello Roy, when the password is inserted in the database it is
encrypted using the PHP function - password_hash() (see https://www.php.net/manual/en/function.password-hash.php https://www.php.net/manual/en/function.password-hash.php), assuming
you are using a version of PHP greater than 5.5. If you are familiar
with PHP and sql you are probably able to create a small script that
manually updates the database table www_users. If not, or if this
doesn't work, then let me know.
To be sure of certain matters:
1. Which version of webERP?
2. Do you mean the same security settings error message as shown in the first post?
3. After install, how may tables are present?
There are 161 tables after the most recent install attempt.
Thanks
Roy
On 10/19/21 3:22 AM, Paul wrote:
Hello, Roy.
To be sure of certain matters:
1. Which version of webERP?
2. Do you mean the same security settings error message as shown in
the first post?
3. After install, how may tables are present?
The solution was simple. The SysAdminEmail was missing from the
config.php file. After updating that, and granting permissions on the
server to write files and folders in the weberp folder, webERP started
working.
Sorry for the inconvenience, and thanks for the help.
Roy
On 10/19/21 7:03 AM, Roy Dalle Vedove wrote:
Hello Paul,
Thanks for the prompt response.
In response to your questions:
Version 4.15.1
Yes, it's the same error message.
There are 161 tables after the most recent install attempt.
Thanks
Roy
On 10/19/21 3:22 AM, Paul wrote:
Hello, Roy.
To be sure of certain matters:
1. Which version of webERP?
2. Do you mean the same security settings error message as shown in
the first post?
3. After install, how may tables are present?
I have installed web-erp successfully. After login it shows following error message.
ERROR Report : Security settings have not been defined for your user account. Please advise your system administrator. It could also be that there is a session problem with your PHP web server.
Please advice.
Last edit: devina 2019-04-01
This looks like the installation has not fully completed populating the database. This can happen as a result of the timeout on some servers kicking in before completion.
The fool proof way would be to populate the database by running the sql under
webERP/sql/mysql/country_sql/default.sql
for a new system or
webERP/sql/mysql/country_sql/demo.sql
directly against your mysql server - perhaps using phpMyAdmin ? or the command line.
instructions on how to do this are in:
webERP/doc/INSTALL.txt
https://github.com/PhilDaintree/webERP/blob/master/doc/INSTALL.txt
Hello Phil,
I am having the same problem. After doing the installation, the login would not work. After three attempts the message as above appeared. Research suggested a number of solutions, including checking whether the user is blocked (it is not), changing the password using PHP,. That did not work. Reinstalling webERP from scratch, Installing using the default.sql script as suggested above. The server is running PHP 7.4 and MariaDB 10.4 running on Ubuntu 18.4. I am comfortable with SQL and PHP, and program in both, so that should not be the problem. When reinstalling I have deleted the folder and installed anew. Similarly with the database, I have dropped the schema, and started with a new database. Perhaps I've missed something, but at this stage, I can't see what. Please help. Thanks.
Hello Roy, when the password is inserted in the database it is
encrypted using the PHP function - password_hash() (see
https://www.php.net/manual/en/function.password-hash.php), assuming
you are using a version of PHP greater than 5.5. If you are familiar
with PHP and sql you are probably able to create a small script that
manually updates the database table www_users. If not, or if this
doesn't work, then let me know.
Thanks
Tim
Hello Tim,
I tried that before trying to contact you. It did not work either. The
problem is now sorted out. Please see my previous response.
Thenks for coming back on this.
Roy
On 10/19/21 8:32 AM, Tim Schofield wrote:
Hello, Roy.
To be sure of certain matters:
1. Which version of webERP?
2. Do you mean the same security settings error message as shown in the first post?
3. After install, how may tables are present?
In the chance of a password matter, see if this post in our forum might help reset?
Last edit: Paul 2021-10-19
Hello Paul,
Thanks for the prompt response.
In response to your questions:
Thanks
Roy
On 10/19/21 3:22 AM, Paul wrote:
Hello Paul,
The problem is resolved.
The solution was simple. The SysAdminEmail was missing from the
config.php file. After updating that, and granting permissions on the
server to write files and folders in the weberp folder, webERP started
working.
Sorry for the inconvenience, and thanks for the help.
Roy
On 10/19/21 7:03 AM, Roy Dalle Vedove wrote: