Update Mac, login modified, access denied

Hi,

This morning I was with Apple assistance as my Macbook after the Catalina update 10.15.1
Then I realise I lost all my passwords, and I couldn’t access Dolibar anymore.
I first tried to recover my password, giving my login: But Dolibar says there was no email adress linked to this name…
I went on phpadmin and modified the Root password, when I came back to my login this message appeared:

[b]DolibarrHasDetectedError.
InformationToHelpDiagnose:
Date: 20191111104921
Dolibarr: 7.0.1
PHP: 7.2.7
Server: Apache/2.2.34 (Unix) mod_wsgi/3.5 Python/2.7.13 PHP/7.2.7 mod_ssl/2.2.34 OpenSSL/1.0.2o DAV/2 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_perl/2.0.9 Perl/v5.24.0
OS: Darwin STEPHANIEs-Air 19.0.0 Darwin Kernel Version 19.0.0: Thu Oct 17 16:17:15 PDT 2019; root:xnu-6153.41.3~29/RELEASE_X86_64 x86_64
UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_1) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Safari/605.1.15

RequestedUrl: /dolibarr-7.0.1/htdocs/index.php
Referer: http://localhost:8888/dolibarr-7.0.1/htdocs/user/passwordforgotten.php
MenuManager:

DatabaseTypeManager: mysqli
RequestLastAccessInError: ErrorNoRequestInError
ReturnCodeLastAccessInError: ErrorNoRequestInError
InformationLastAccessInError: ErrorNoRequestInError

Message: host=localhost, port=8889, user=root, databasename=dolibarr, Access denied for user ‘root’@‘localhost’ (using password: YES)[/b]

And so no connexion anymore on my php my admin too…

Sorry, I am quite lost with Mac

You can try to see your credentials in

/dolibarr-7.0.1/htdocs/conf/conf.php
if they are not encrypted. You can also try to reinstall Dolibarr by using command

[code]
/dolibarr-7.0.1/htdocs/install[/code

1 Like

Thank you very much,

With this fonction:
http://localhost:8888/dolibarr-7.0.1/htdocs/conf/conf.php

Reply is

Forbidden

You don’t have permission to access /dolibarr-7.0.1/htdocs/conf/conf.php on this server.

And for this fonction:
http://localhost:8888/dolibarr-7.0.1/htdocs/install/check.php?testget=ok

The answer is
Échec de connexion à la base ‘dolibarr’.

Should I proceed a new installation ? I will lost my data …

Apparently I have no more this fonction

http://localhost:8888/dolibarr-7.0.1/htdocs/

DolibarrHasDetectedError.
InformationToHelpDiagnose:
Date: 20191111211446
Dolibarr: 7.0.1
PHP: 7.2.7
Server: Apache/2.2.34 (Unix) mod_wsgi/3.5 Python/2.7.13 PHP/7.2.7 mod_ssl/2.2.34 OpenSSL/1.0.2o DAV/2 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_perl/2.0.9 Perl/v5.24.0
OS: Darwin STEPHANIEs-Air 19.0.0 Darwin Kernel Version 19.0.0: Thu Oct 17 16:17:15 PDT 2019; root:xnu-6153.41.3~29/RELEASE_X86_64 x86_64
UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_1) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Safari/605.1.15

RequestedUrl: /dolibarr-7.0.1/htdocs/
Referer: http://localhost:8888/dolibarr-7.0.1/
MenuManager:

DatabaseTypeManager: mysqli
RequestLastAccessInError: ErrorNoRequestInError
ReturnCodeLastAccessInError: ErrorNoRequestInError
InformationLastAccessInError: ErrorNoRequestInError

Message: host=localhost, port=8889, user=root, databasename=dolibarr, Access denied for user ‘root’@‘localhost’ (using password: YES)

The first link is the file directory on your Mac and you need to access it via Finder.
The second link needs to be passed in the web browser. In your case, it is

http://localhost:8888/dolibarr-7.0.1/htdocs/install
your “answer” was Échec de connexion à la base 'dolibarr'. which basically means Failed to connect to database 'dolibarr'.
Are you using DoliMamp?
Is your database called dolibarr?
Are all the services running?
BTW. Did you try http://localhost:8889/dolibarr-7.0.1/htdocs/install instead of http://localhost:8888/dolibarr-7.0.1/htdocs/install as you get a message

[code]
Message: host=localhost, port=8889, user=root, databasename=dolibarr, Access denied for user ‘root’@‘localhost’ (using password: YES)[/code

Hi,

So here is the file at /dolibarr-7.0.1/htdocs/conf/conf.php

<?php // // File generated by Dolibarr installer 7.0.1 on 31 Juil. 2018 // // Take a look at conf.php.example file for an example of conf.php file // and explanations for all possibles parameters. // $dolibarr_main_url_root='http://localhost:8888/dolibarr-7.0.1/htdocs '; $dolibarr_main_document_root='/Applications/MAMP/htdocs/dolibarr-7.0.1/htdocs'; $dolibarr_main_url_root_alt='/custom'; $dolibarr_main_document_root_alt='/Applications/MAMP/htdocs/dolibarr-7.0.1/htdocs/custom'; $dolibarr_main_data_root='/Applications/MAMP/htdocs/dolibarr-7.0.1/documents'; $dolibarr_main_db_host='localhost'; $dolibarr_main_db_port='8889'; $dolibarr_main_db_name='dolibarr'; $dolibarr_main_db_prefix='llx_'; $dolibarr_main_db_user='root'; $dolibarr_main_db_pass='root'; $dolibarr_main_db_type='mysqli'; $dolibarr_main_db_character_set='utf8'; $dolibarr_main_db_collation='utf8_unicode_ci'; // Authentication settings $dolibarr_main_authentication='dolibarr'; //$dolibarr_main_demo='autologin,autopass'; // Security settings $dolibarr_main_prod='0'; $dolibarr_main_force_https='0'; $dolibarr_main_restrict_os_commands='mysqldump, mysql, pg_dump, pgrestore'; $dolibarr_nocsrfcheck='0'; $dolibarr_main_cookie_cryptkey='9eef134a4eb913b58b54bea26d84e15d'; $dolibarr_mailing_limit_sendbyweb='0'; //$dolibarr_lib_FPDF_PATH=''; //$dolibarr_lib_TCPDF_PATH=''; //$dolibarr_lib_FPDI_PATH=''; //$dolibarr_lib_TCPDI_PATH=''; //$dolibarr_lib_ADODB_PATH=''; //$dolibarr_lib_GEOIP_PATH=''; //$dolibarr_lib_NUSOAP_PATH=''; //$dolibarr_lib_PHPEXCEL_PATH=''; //$dolibarr_lib_ODTPHP_PATH=''; //$dolibarr_lib_ODTPHP_PATHTOPCLZIP=''; //$dolibarr_js_CKEDITOR=''; //$dolibarr_js_JQUERY=''; //$dolibarr_js_JQUERY_UI=''; //$dolibarr_js_JQUERY_FLOT=''; //$dolibarr_font_DOL_DEFAULT_TTF=''; //$dolibarr_font_DOL_DEFAULT_TTF_BOLD=''; Yes port seems to be 8889... is there a difference between MAMP and MAMP pro ? apparently this is MAM Pro that answer to this request, but in my memory I am using MAMP. Is there somthing I should change here ?

and I do http://localhost:8889/dolibarr-7.0.1/htdocs/install in my browser I get this answer by safari (see file attached) please.

Update !!

Big thanks, I succeed to reinstall Dolibarr !!! :woohoo:
I finally understood what was needed to do, but now I am back to the start…Can’t log, I have tried the password I created but it doesn’t work. and now it says that there is no email address linked to my login… :pinch:

A little help of my friend…

here is the file:
I have tried login root
password Tk4rebvste

but it doesn’t work…

Please can someone give me an answer.
I have created a new user but then I loose all my previous data…or maybe they are already lost and I should reconfig everything…

<?php // // File generated by Dolibarr installer 7.0.1 on 12 Nov. 2019 // // Take a look at conf.php.example file for an example of conf.php file // and explanations for all possibles parameters. // $dolibarr_main_url_root='http://localhost:8888/dolibarr-7.0.1/htdocs '; $dolibarr_main_document_root='/Applications/MAMP/htdocs/dolibarr-7.0.1/htdocs'; $dolibarr_main_url_root_alt='/custom'; $dolibarr_main_document_root_alt='/Applications/MAMP/htdocs/dolibarr-7.0.1/htdocs/custom'; $dolibarr_main_data_root='/Applications/MAMP/htdocs/dolibarr-7.0.1/documents'; $dolibarr_main_db_host='localhost'; $dolibarr_main_db_port='8888'; $dolibarr_main_db_name='dolibarr'; $dolibarr_main_db_prefix='llx_'; $dolibarr_main_db_user='root'; $dolibarr_main_db_pass='Tk4rebvste'; $dolibarr_main_db_type='mysqli'; $dolibarr_main_db_character_set='utf8'; $dolibarr_main_db_collation='utf8_unicode_ci'; // Authentication settings $dolibarr_main_authentication='dolibarr'; //$dolibarr_main_demo='autologin,autopass'; // Security settings $dolibarr_main_prod='0'; $dolibarr_main_force_https='0'; $dolibarr_main_restrict_os_commands='mysqldump, mysql, pg_dump, pgrestore'; $dolibarr_nocsrfcheck='0'; $dolibarr_main_cookie_cryptkey='ac6b9b95967f753f11d65a40bf3f4471'; $dolibarr_mailing_limit_sendbyweb='0'; //$dolibarr_lib_FPDF_PATH=''; //$dolibarr_lib_TCPDF_PATH=''; //$dolibarr_lib_FPDI_PATH=''; //$dolibarr_lib_TCPDI_PATH=''; //$dolibarr_lib_ADODB_PATH=''; //$dolibarr_lib_GEOIP_PATH=''; //$dolibarr_lib_NUSOAP_PATH=''; //$dolibarr_lib_PHPEXCEL_PATH=''; //$dolibarr_lib_ODTPHP_PATH=''; //$dolibarr_lib_ODTPHP_PATHTOPCLZIP=''; //$dolibarr_js_CKEDITOR=''; //$dolibarr_js_JQUERY=''; //$dolibarr_js_JQUERY_UI=''; //$dolibarr_js_JQUERY_FLOT=''; //$dolibarr_font_DOL_DEFAULT_TTF=''; //$dolibarr_font_DOL_DEFAULT_TTF_BOLD='';

“root” is your database login, not Dolibarr login. To find your Dolibarr login, please log in to your database and search for the table llx_user which contains a list of all the user names (you can also check the assigned email address for each user)

Hi FutureHost,

Yesterday evening i succeed to go back on Dolibar but I didn’t have access to all the function as if I was not a super admin anymore.
So I decided to save my file Dolibarr, uninstall MAMP and reinstall MAMP, reinstall Dolibarr with my save folder.
I did all the steps and when I created a new database I realise that again the new installation was on port 8889 instead of 8888…
If I try a connexion via local host 8889 it says that

Cancelled load from ‘http://localhost:8889/dolibarr/’ because it’s using HTTP:/0.9.

And on the old data base called Dolibarr-7-0-1 that runs on 8888 I still have

Message: host=localhost, port=8888, user=root, databasename=dolibarr, Access denied for user ‘root’@‘localhost’ (using password: YES)

I suppose this mean that somewhere MAMP is still loged on 8888 but I can’t find how to deconnect it.
I have checked and I couldn’t find any trace of MAMP anywhere before reinstalling it…

Sorry to be a mess