> > You were doing this (looking at the mysql.db table) on your > "db.example.com" machine, correct?db.example.com is a load balanced VIP. The VIP is being handled by keepalived and HA/Proxy. There are two DB's setup in master/master replication. The two databases and two load balancers are on AWS. The web server and varnish servers are on digital ocean. I setup a grant on db1 to allow access to the database from the load balancers. And those permissions were automatically replicated over to the second database. Once I set that up I was able to mysql into the load balanced database and the media wiki started working. But the wordpress site and the test php script still couldn't access the load balanced database. Thanks On Sat, Aug 15, 2015 at 10:26 PM, Richard < lists-centos at listmail.innovate.net> wrote:> 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 ------------ > > > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos >-- GPG me!! gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
Hi Richard,
I actually made some progress on this. The problem was SSL. Once I I took
the SSL requirement out of the picture for the user everything worked. The
test php script and the wordpress site both. Originally when I setup my
wiki it NEEDED SSL. Because there was some sensitive data in it. My
website, however, is just a goofball toy project of mine. And doesn't
really need that. But since I have this done for my wiki I was like why
not? I stumbled getting the mediawiki to connect via SSL. Once I found the
setting $wgDBssl = true; for media wiki it just worked.
For my wordpress site, I found the setting define('DB_SSL', true);. I
set
that up in wp-config.php. However for some reason that wasn't the silver
bullet that the mediawiki SSL database setting was ( $wgDBssl = true; ). I
can understand why my little test script couldn't work with an SSL user.
But do you have any idea why that wordpress setting won't allow the site to
connect to the DB? While it may not be of super high importance to have my
site contact the DB via SSL, it would still be a nice thing to have.
Thanks,
Tim
On Sat, Aug 15, 2015 at 10:45 PM, Tim Dunphy <bluethundr at gmail.com>
wrote:
> You were doing this (looking at the mysql.db table) on your
>> "db.example.com" machine, correct?
>
>
> db.example.com is a load balanced VIP. The VIP is being handled by
> keepalived and HA/Proxy. There are two DB's setup in master/master
> replication. The two databases and two load balancers are on AWS. The web
> server and varnish servers are on digital ocean.
>
> I setup a grant on db1 to allow access to the database from the load
> balancers. And those permissions were automatically replicated over to the
> second database. Once I set that up I was able to mysql into the load
> balanced database and the media wiki started working. But the wordpress
> site and the test php script still couldn't access the load balanced
> database.
>
> Thanks
>
> On Sat, Aug 15, 2015 at 10:26 PM, Richard <
> lists-centos at listmail.innovate.net> wrote:
>
>> 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 ------------
>>
>>
>> _______________________________________________
>> CentOS mailing list
>> CentOS at centos.org
>> http://lists.centos.org/mailman/listinfo/centos
>>
>
>
>
> --
> GPG me!!
>
> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
>
>
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
Tony Mountifield
2015-Aug-17 13:53 UTC
[CentOS] wordpess can't connect to DB but mediawiki can
In article <CAOZy0ektHWPfH29gF65RyUX584NHp0km66XiVn9drnig--rF5g at mail.gmail.com>, Tim Dunphy <bluethundr at gmail.com> wrote:> Hi Richard, > > I actually made some progress on this. The problem was SSL. Once I I took > the SSL requirement out of the picture for the user everything worked. The > test php script and the wordpress site both. Originally when I setup my > wiki it NEEDED SSL. Because there was some sensitive data in it. My > website, however, is just a goofball toy project of mine. And doesn't > really need that. But since I have this done for my wiki I was like why > not? I stumbled getting the mediawiki to connect via SSL. Once I found the > setting $wgDBssl = true; for media wiki it just worked. > > For my wordpress site, I found the setting define('DB_SSL', true);. I set > that up in wp-config.php. However for some reason that wasn't the silver > bullet that the mediawiki SSL database setting was ( $wgDBssl = true; ). I > can understand why my little test script couldn't work with an SSL user. > But do you have any idea why that wordpress setting won't allow the site to > connect to the DB? While it may not be of super high importance to have my > site contact the DB via SSL, it would still be a nice thing to have.Did it use to work a few days ago? I have a box on which "yum update" installed a new version of openssl on 14 Aug, and that broke SSL connections for mysql. I haven't diagnosed it yet, neither by downgrading openssl again to see if it works, nor by recreating my CA and certs using the newer openssl. Cheers Tony -- Tony Mountifield Work: tony at softins.co.uk - http://www.softins.co.uk Play: tony at mountifield.org - http://tony.mountifield.org