phpMyAdmin HTTP Authentication

[chris]

There is a problem with the HTTP Authentication at ​https://phpmyadmin.crin.org/

[chris]

Looking at the ticket that was used for the install, ticket:8, and after deleting the crin line from the /etc/phpmyadmin/.htpasswd file the following was run:

cd /etc/phpmyadmin
htdigest .htpasswd phpmyadmin crin
chown root:www-data .htpasswd
chmod 640 .htpasswd

The HTTP Authentication password on file now works so closing this ticket.

[russell]

I'm getting through httpauth to phpmyadmin now, but I can't log in wtih the dev DB creds.

[chris]

The problem was that the user was only allowed to access the database from the dev server and phpMyAdmin is running on the database server, these were the original commands to create the database and add the user:

CREATE DATABASE dev;
GRANT ALL ON dev.* to 'dev'@'crin2' identified by 'XXX' REQUIRE SSL;
FLUSH PRIVILEGES;

So in order to grant access from localhost:

GRANT ALL ON dev.* to 'dev'@'localhost' identified by 'XXX';
FLUSH PRIVILEGES;

I have done the same for the stage and newprod databases and tested access for all three.

Looking at /var/www/stage/docroot/sites/default/settings.php and /var/www/dev/docroot/sites/default/settings.php Crin4 they both appear to be using the newprod live database? Or an I missing something?

At some point in the new week I'm going to need to update the certs that MySQL is using for SSL -- they are due to expire in early May.

[russell]

I believe that /var/www/stage/docroot/sites/default/settings.php is overridden by /var/www/stage/docroot/sites/dev.crin.org/settings.php in the case of dev. - so dev. is using the dev DB

[russell]

I'm in to the dev DB on phpmyadmin now, thank you. I'll go ahead now and truncate the big tables in there.