-->
Welcome, Guest
Username: Password: Remember me

TOPIC: Installation SQL user creation error

Installation SQL user creation error 2 months 6 days ago #34562

  • Rhino
  • Rhino's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 3
  • Karma: 0
Hi, completely new.

I've just been trying to install Dolibarr on a debian LAMP VM.
Installation seems to fail when it tries to create the Dolibarr MySQL User.

It shows "creation user error:0"

then database creation failed.

I've checked the root password for mysql is correct and logged into mysql as root using that password.
I have apache2 and php7 installed.

I've googled and read the installation docs but I'm not sure which way to look. Can someone please point me in the right direction?
The administrator has disabled public write access.

Installation SQL user creation error 2 months 6 days ago #34563

  • yves57
  • yves57's Avatar
  • OFFLINE
  • Expert
  • Posts: 101
  • Thank you received: 25
  • Karma: 4
Hi Rhino,
Which way do you use for the installation?
Is php7 enabled in apache2?
The administrator has disabled public write access.

Installation SQL user creation error 2 months 6 days ago #34567

  • Rhino
  • Rhino's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 3
  • Karma: 0
Thankyou for replying

I ran a2enmod php7.0 to check and it said module already enabled.

To install I have downloaded dolibarr_8.0.1-4_all.deb from the website and installed it through dpkg.

I go to doliibar/install - the prerequisites check shows all green ticks and I clicked start for fresh install.
On the next page i leave everything as default, but clear the box for the port, enter a password for the database user and enter the root password.

When I click next, it says it has saved the values, reload config information with green tick. Then error for "creation user"
The administrator has disabled public write access.

Installation SQL user creation error 2 months 5 days ago #34571

  • aljawaid
  • aljawaid's Avatar
  • OFFLINE
  • Moderator
  • Trying to make the source open.
  • Posts: 649
  • Thank you received: 92
  • Karma: 12
Can you post a screenshot please?
The administrator has disabled public write access.

Installation SQL user creation error 2 months 5 days ago #34572

  • yves57
  • yves57's Avatar
  • OFFLINE
  • Expert
  • Posts: 101
  • Thank you received: 25
  • Karma: 4
Hello,
Do you have phpmyadmin ? Can you access to Mysql with the root/password you tried?
It seems to me that there is a problem with database access.
The administrator has disabled public write access.
The following user(s) said Thank You: aljawaid

Installation SQL user creation error 2 months 5 days ago #34573

  • Rhino
  • Rhino's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 3
  • Karma: 0
Screenshot attached

I'm having trouble with phpmyadmin, I cant log in as root. I've not used it before
I just read somewhere that mysql 5.7 introduced new security and needs a sudo command to log in as root
which might explain why i can log in to mysql from root terminal but dolibarr and now phpmyadmin cannot.

I think for phpmyadmin I can log in as another user with authority, but the user on the dolibarr install screen is greyed out and set as root.
Attachments:
The administrator has disabled public write access.

Installation SQL user creation error 2 months 5 days ago #34574

  • aljawaid
  • aljawaid's Avatar
  • OFFLINE
  • Moderator
  • Trying to make the source open.
  • Posts: 649
  • Thank you received: 92
  • Karma: 12
Hi Rhino

I think the problem is on your server side. You should be able to login using phpMyAdmin or similar to access the database. Check with your hosting company.

Also, another option, if/once you get access to MySQL (through phpMyAdmin or similar) would be to create the (database)+(database user) yourself and then go through setup again without checking the 'create database' option. Dolibarr should only then create the tables within the database once it has had the access.

Ultimately, you need to check with your server hosting company on why MySQL cannot be accessed.

Do let us know if you find a solution.
The administrator has disabled public write access.
Time to create page: 0.062 seconds