WEAK FAQ

Prerequisites Update the admin password When install in light_mode=false: MySQL Error: The server time zone value 'CEST' is unrecongnized When install in light_mode=false: MySQL Error: Error on start - Access denied for user 'root'@'localhost' Find PID from unix
Prerequisites
  • Linux / OSX / Windows
  • Hard disk : 2,5 Go
  • RAM: 4 Go
  • Proc: 2,5 Ghz
  • With light_mode=false ::: 1 database (charset latin1) from MySQL 5.7/5.8
  • With light_mode=trye ::: Nothing (H2 Dabase was already embedded)

When install in light_mode=false: MySQL Error: The server time zone value 'CEST' is unrecongnized
- Go to your conf/server.conf

- Go to the section SQL or MySQL

- set options=allowMultiQueries=true&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
- or add '?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC' after your database name
for example:
db=mentdb?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

- Delete the directory data
- Restart the server...
        

Update the admin password
- Go to the conf/server.conf
- Go to the first section [ADMIN]
- Update the field 'PWD'
- Update the admin secret key: 'SERVER_ENCRYPT_KEY'
- Don't forget to change your client connections ...
        

Find PID from unix
ps -e | grep java
4422 ?        00:02:45 java
7623 ?        08:14:08 java

netstat -tnlp | grep java
tcp6       0      0 :::9996                 :::*                    LISTEN      4422/java       
tcp6       0      0 :::9997                 :::*                    LISTEN      4422/java       
tcp6       0      0 :::9998                 :::*                    LISTEN      7623/java       
tcp6       0      0 :::9999                 :::*                    LISTEN      7623/java       
tcp6       0      0 :::8080                 :::*                    LISTEN      7623/java       
tcp6       0      0 :::8081                 :::*                    LISTEN      4422/java       
tcp6       0      0 :::8083                 :::*                    LISTEN      7623/java       
tcp6       0      0 :::8084                 :::*                    LISTEN      4422/java
        

Error on start - Access denied for user 'root'@'localhost'
Problem :  Open MySQL connection> java.sql.SQLException: Access denied for user 'root' @ 'localhost'

Cause :  The password of the 'root' user of your MySQL server is not correct.

Solution :  Open the 'conf/server.conf' file, go to MySQL section, and set the correct user password 'root' 
(here you have to change 'pwd' after the '=')

#The MySQL password [string]
pwd=pwd

To check your MySQL connection :

    mysql --host=127.0.0.1 --port=3306 -u root -ppwd --database=mentdb

    mysql --host=localhost --port=3306 -u root -ppwd --database=mentdb

Noted :  That use the root user is deprecated on servers.
        

 


MentDB © 2020 - Legal Notice