DB Error on web interface about dmarc-srg HOT 15 CLOSED

Hello! As far as I can see in the error message, you used root as your user name. You should use a different username for that (not root) because in new versions of mysql / mariadb, using root without sudo is prohibited for security reasons.

from dmarc-srg.

nope, I created the user d'marc_user' and have tested the login with mysql utility.

maybe its a php.ini setting?

from dmarc-srg.

oops username is 'dmarc_user'

from dmarc-srg.

In your error message, I see the root user, which shouldn't be there. Are you sure that your conf.php looks like this?

$database = [
    'host'     => 'localhost',
    'type'     => 'mysql',
    'name'     => 'dmarc',
    'user'     => 'dmarc_user',
    'password' => 'yourpassword'
];

from dmarc-srg.

below is my conf.php file, its like the variables are not being passed to the functions.

from dmarc-srg.

Okay. What is your php version? Do you have any warnings in the log?

from dmarc-srg.

Where is the log located?

php is version 7.4.21. Thanks for your help!

from dmarc-srg.

liuch, it looks like the php session never started and other php files do not have access to the data... but I may be wrong.

from dmarc-srg.

Usually php writes its errors and warnings to the log of the web server you are using. For me, the log is located in /var/log/nginx directory (I'm using nginx web server on debian).

from dmarc-srg.

This is Centos 8 with Apache. Rather than waste time trying to make that work, I'll configure the same platform you are using.

what version of debian?
what version of php?

Thanks!

from dmarc-srg.

I use Debian Testing (bullseye), standard packages from the repositories. Just for case:

$ cat /etc/issue
Debian GNU/Linux 11 \n \l

$ /usr/sbin/nginx -v
nginx version: nginx/1.18.0

$ php -v
PHP 7.4.15 (cli) (built: Feb 20 2021 09:45:56) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.15, Copyright (c), by Zend Technologies

$ mariadb --version
mariadb  Ver 15.1 Distrib 10.5.10-MariaDB, for debian-linux-gnu (x86_64) using  EditLine wrapper

from dmarc-srg.

Is there any result on this issue?

from dmarc-srg.

from dmarc-srg.

I made many tries to get an error as yours but failed and I have no idea why it happends. It would be useful to see your log file. If you do not have the access to the log, you can turn on the debug mode in the config file to see error messages in the server responces by using the console of your browser.

from dmarc-srg.

Try replacing localhost with 127.0.0.1 in the config. If it doesn't work, could you turn the debug mode on then run the command php utils/database_admin.php status with the latest updates and show me the error messages?

from dmarc-srg.