CRIN Trac: Ticket #112: phpMyAdmin HTTP Authentication

hours, status changed; resolution, totalhours set

chris — Tue, 25 Apr 2017 11:25:07 GMT

hours changed from 0 to 0.5
status changed from new to closed
resolution set to fixed
totalhours set to 0.5

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 — Fri, 28 Apr 2017 10:27:16 GMT

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

hours, totalhours changed

chris — Fri, 28 Apr 2017 11:05:45 GMT

hours changed from 0 to 0.5
totalhours changed from 0.5 to 1.0

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 — Fri, 28 Apr 2017 15:04:24 GMT

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 — Fri, 28 Apr 2017 15:05:22 GMT

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