[CentOS] wordpess can't connect to DB but mediawiki can

Sun Aug 16 02:26:14 UTC 2015
Richard <lists-centos at listmail.innovate.net>

You were doing this (looking at the mysql.db table) on your
"db.example.com" machine, correct?


------------ Original Message ------------
> Date: Saturday, August 15, 2015 19:32:25 -0400
> From: Tim Dunphy <bluethundr at gmail.com>
> To: CentOS mailing list <centos at centos.org>
> Subject: Re: [CentOS] wordpess can't connect to DB but mediawiki
can
>
>> 
>> "Use" that db and then issue:
>>  select * from db where Db='jfwiki' or Db='jokefire' order by
>>  Host;
> 
> 
> Well yeah. I used the mysql database before I issued that command.
> 
> 
>  MariaDB [(none)]> use mysql
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> 
> Database changed
> 
> Then if I run that command for some reason there's no jfwiki or
> jokefire entry in the db table:
> 
> MariaDB [mysql]>  select * from db where Db='jfwiki' or
> Db='jokefire' order by Host;
> Empty set (0.00 sec)
> 
> 
> For some reason another database I imported to do bacula backups
> has an entry in the db table:
> 
> MariaDB [mysql]> select Host,Db from db;
> +-----------+--------+
>| Host      | Db     |
> +-----------+--------+
>| %         | bacula |
>| localhost | bacula |
> +-----------+--------+
> 2 rows in set (0.00 sec)
> 
> However I'm thinking more along the lines of my php mysql client
> having an issue. Although I'm still a little stuck on why the wiki
> works without any problem and why neither my php script nor
> wordpress are able to connect to the db. It's really strange how
> that's happening!
> 
> 
> On Sat, Aug 15, 2015 at 6:12 PM, Richard
> <lists-centos at listmail.innovate.net
>> wrote:
> 
>> 
>> > Date: Saturday, August 15, 2015 17:57:03 -0400
>> > From: Tim Dunphy <bluethundr at gmail.com>
>> 
>> >> 
>> >> [this isn't really a centos issue, even if you're using centos,
>> >> which isn't obvious. that said ...]
>> > 
>> > 
>> > Yeah that's true. But this list tends to be rather helpful for
>> > general problems that are less specific to centos. Sometimes. :)
>> > Really seems to depend...
>> > 
>> > Incidentally I am using centos on all hosts:
>> > 
>> ># cat /etc/redhat-release
>> > CentOS Linux release 7.0.1406 (Core)
>> > 
>> > OK now that that's out of the way, for some reason I don't seem
>> > to have an entry in my db database for either jokefire or
>> > jfwiki:
>> > 
>> > MariaDB [mysql]> select * from db  where Db like 'jfwiki' or Db
>> > like 'jokefire';
>> > Empty set (0.00 sec)
>> > 
>> > Not sure why that would be the case. They're definitely there on
>> > this database server:
>> > 
>> > MariaDB [mysql]> show databases;
>> > +--------------------+
>> >| Database           |
>> > +--------------------+
>> >| bacula             |
>> >| information_schema |
>> >| jfwiki             |
>> >| jokefire           |
>> >| mysql              |
>> >| performance_schema |
>> > +--------------------+
>> > 6 rows in set (0.00 sec)
>> > 
>> > Any other ideas?
>> > 
>> > Thanks,
>> > Tim
>> > 
>> > On Sat, Aug 15, 2015 at 3:07 PM, Richard wrote:
>> > 
>> >> 
>> >> 
>> >> > Date: Saturday, August 15, 2015 13:53:28 -0400
>> >> > From: Tim Dunphy <bluethundr at gmail.com>
>> >> > 
>> >> > Hey guys,
>> >> > 
>> >> > I'm running both a wordpress site as well as a mediawiki off
>> >> > of the same web servers. The mediawiki site works great! The
>> >> > wordpress site, meh. Not so much. I keep getting the common
>> >> > database connection error:
>> >> > 
>> >> > Error establishing a database connection
>> >> > 
>> >> > And as far as I can tell the settings between the mediawiki
>> >> > site and the wordpress site are nearly identical.
>> >> 
>> >>   < ... snip ... >
>> >> 
>> >> [this isn't really a centos issue, even if you're using centos,
>> >> which isn't obvious. that said ...]
>> >> 
>> >> I would start by looking at the access control entries for the
>> >> wp and mw dbs, (in the mysql.db table). Based on what you are
>> >> trying here, there should be matching entries in that table
>> >> for the "Db"s "jokefire" and "jfwiki" (e.g., for the Host as
>> >> well as the various _priv fields).
>> >> 
>> >>  select * from db where Db='jokefire' or Db='jfwiki' order by
>> >>  Host\g
>> >> 
>> >> There may be something else going on, but without knowing that
>> >> the access control is as it should be there's not much value in
>> >> speculating.
>> >> 
>> 
>> The mysql access control bits are in tables in the mysql db that's
>> in your list above.
>> 
>>   +---------------------------+
>>   | Tables_in_mysql           |
>>   +---------------------------+
>>   | columns_priv              |
>>   | db                        |
>>   | event                     |
>>   | func                      |
>>       ...
>> 
>> "Use" that db and then issue:
>> 
>>  select * from db where Db='jfwiki' or Db='jokefire' order by
>>  Host;
>> 
>> 
>> _______________________________________________
>> CentOS mailing list
>> CentOS at centos.org
>> http://lists.centos.org/mailman/listinfo/centos

------------ End Original Message ------------