Database passwords with DoliDeb Installation are?

Installing my Dolibarr
1

Hello,

I tried to install the last DoliDeb Version with Dolibarr 3.5.8 on my new ubuntu System.
As you can see at the screenshots below everything goes fine, till the question of Superuser and Password.

The Login name for database owner is given from the system named “dolibarr”

My questions are:
- What is the password for the database owner dolibarr?
- What is the right entry for the superuser name and password?

The DoliDeb installation package must set these entrys, but I couldn`t find it…
Or is there a way to reset it? Thank you!

1.png
1.png1083×325 44.5 KB

2.png
2.png1366×768 216 KB

3.png
3.png1366×768 201 KB

4.png
4.png1366×768 150 KB

5.png
5.png1366×768 151 KB

6.png
6.png1366×768 137 KB

2

No idea?

3

Hi,
When you are on page related to screenshot you sent, you must fill the last field (root password) with the root password of mysql.
This password was set when mysql was installed the first time.

If you don’t remind it, you can reset it following tutorial
https://wiki.dolibarr.org/index.php/FAQ_I_Lost_my_database_password#Reset_the_root_password_of_Mysql_2

1 Like
4

Maybe this leads to a solution (in German):

https://blog.v-gar.de/2016/07/solved-error-1698-28000-in-mysqlmariadb/

Best regards

1 Like
5

That is the point. I’ve never set a password :unhappy:
I have choosen the Dolideb Installation and that is including mysql Server, php and apache.
The ubuntu client is new installed and Dolideb Installation was the first I’ve done.

That is why I find it strange… but it seems to me to go this way, or the one casati wrote down below.
I thought it must be a bug inside Dolideb that the password is preset and someone shoud know that.

6

That way won’t work for me…
File or folder not found.

Bildschirmfotovom2016-07-2708-56-04.png

7

sudo cat /etc/mysql/debian.cnf

1 Like
8

In my instalation of Mysql the preset password for the root user was “admin” … try

9

You must be root

Captura.png

10

Sadly no :unhappy:

Yes, normally I do this with sudo su. Thanks :happy:

I get the default passwort from the user debian-sys-maint, with these results:

root@aspire-6930G:/home/holger# cat /etc/mysql/debian.cnf

Automatically generated for Debian scripts. DO NOT TOUCH!

[client]
host = localhost
user = debian-sys-maint
password = 7hh9xxxxxxxxxxxx
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = 7hh9xxxxxxxxxxxx
socket = /var/run/mysqld/mysqld.sock

When I put this user and password in the installation fields (Database server - Superuser access) I can go on! :laugh:
But isn’t that user only for maintance?

Can I go on with that user, or better still find out the pw for root?
However it stucks on the last page, as I show you on the screenshots… :blink:

1_2016-07-28.png
1_2016-07-28.png1261×519 111 KB

(Pic 2 appears after the input of debian-sys-maint and the pw)

2_2016-07-28.png
2_2016-07-28.png1268×383 70.3 KB

3_2016-07-28.png
3_2016-07-28.png1263×449 121 KB

Maybe I should install everything new and try your suggestions from the beginning… I’m not sure if I “break” something inside the software…

11

Good Afternoon!
I have the same issue - new install of Debian. New to Debian and Linux and Dolibarr!
I have been trying to install Dolideb and get to the same point as several others in this thread.
Databas Server - Superuser access
Login:
Password:

Access denied for user “xxxx@localhost” using password: YES
etc. etc.

Someone suggested i needed the password from MySql installation. To my knowledge, I have not installed MySql - as far as I understand, this is part of this package installation.

Any help for this?

Thanks!
MAG

12

Hey MAG,
my problem was solved when Ubuntu 14.04 was installed!
It didn´t work with the 16.04 version…

Last week I´ve installed it with the Ubuntu Server Version of 16.04 and that worked perfect.
Sorry, no better news.

13

Hi - I did get Dolibarr running on Debian but then other problems convinced me to try Lubunto (16.10) . I got past the first hurdle onlt to run aground on the same problem as Ndrosis with the MySql syntax error.

Anyone with a clue about this?
Thanks
MAG