Re: [CentOS] Centos 6.5 install, missing libraries: where did I go wrong?
On Saturday 15 August 2015 06:59:36 Gilbert Sebenste wrote: > Hello everyone, > > I had a CentOS 6.5 CD for a clean install, and I did a desktop > install. Then I did a yum update to bring it up to 6.7. So far, so > good. > > I run a bunch of scientific programs that use C++ compilers and > libraries. But, the programs were failing becaause in /usr/lib, > the libraries simply weren't there. The directory was fairly > sparsely populated with about 10 directories of libraries for > specific programs. But otherwise, things that are in /usr/lib on a > Centos 5 server, such as: > > libkate.so.1.2.1 > libkdb5.a > libkdb5.so > libkdb5.so.4 > > are indeed there. These are just 4 library examples. I assume I did > something wrong in the installation to keep the lib*.so.* files > from installing into /usr/lib. What do I need to do next time to > keep that from happening? Anyone have any ideas? > > Gilbert > Assuming this was a 64bit install the libraries are in /usr/lib64 not /usr/lib. Tony -- Linux nogs.tonyshome.ie 2.6.32-573.3.1.el6.x86_64 #1 SMP Thu Aug 13 22:55:16 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Centos 6.5 install, missing libraries: where did I go wrong?
> Date: Saturday, August 15, 2015 09:57:46 +0100 > From: Tony Molloy > > On Saturday 15 August 2015 06:59:36 Gilbert Sebenste wrote: >> Hello everyone, >> >> I had a CentOS 6.5 CD for a clean install, and I did a desktop >> install. Then I did a yum update to bring it up to 6.7. So far, >> so good. >> >> I run a bunch of scientific programs that use C++ compilers and >> libraries. But, the programs were failing becaause in /usr/lib, >> the libraries simply weren't there. The directory was fairly >> sparsely populated with about 10 directories of libraries for >> specific programs. But otherwise, things that are in /usr/lib on >> a Centos 5 server, such as: >> >> libkate.so.1.2.1 >> libkdb5.a >> libkdb5.so >> libkdb5.so.4 >> >> are indeed there. These are just 4 library examples. I assume I >> did something wrong in the installation to keep the lib*.so.* >> files from installing into /usr/lib. What do I need to do next >> time to keep that from happening? Anyone have any ideas? >> >> Gilbert >> > > Assuming this was a 64bit install the libraries are in /usr/lib64 > not /usr/lib. > > Tony The default install doesn't necessarily include all the libraries that you might need, but you have the option to add (and subtract) packages during that process. Now that you're past that point, you can use "yum whatprovides" to find the .rpms that include the needed libraries. You'll want to make certain that you install the 32 vs 64 bit versions as needed. ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Centos 6.5 install, missing libraries: where did I go wrong?
On 08/15/2015 08:11 AM, Richard wrote: > > >> Date: Saturday, August 15, 2015 09:57:46 +0100 >> From: Tony Molloy >> >> On Saturday 15 August 2015 06:59:36 Gilbert Sebenste wrote: >>> Hello everyone, >>> >>> I had a CentOS 6.5 CD for a clean install, and I did a desktop >>> install. Then I did a yum update to bring it up to 6.7. So far, >>> so good. >>> >>> I run a bunch of scientific programs that use C++ compilers and >>> libraries. But, the programs were failing becaause in /usr/lib, >>> the libraries simply weren't there. The directory was fairly >>> sparsely populated with about 10 directories of libraries for >>> specific programs. But otherwise, things that are in /usr/lib on >>> a Centos 5 server, such as: >>> >>> libkate.so.1.2.1 >>> libkdb5.a >>> libkdb5.so >>> libkdb5.so.4 >>> >>> are indeed there. These are just 4 library examples. I assume I >>> did something wrong in the installation to keep the lib*.so.* >>> files from installing into /usr/lib. What do I need to do next >>> time to keep that from happening? Anyone have any ideas? >>> >>> Gilbert >>> >> >> Assuming this was a 64bit install the libraries are in /usr/lib64 >> not /usr/lib. >> >> Tony > > The default install doesn't necessarily include all the libraries > that you might need, but you have the option to add (and subtract) > packages during that process. > > Now that you're past that point, you can use "yum whatprovides" to > find the .rpms that include the needed libraries. You'll want to > make certain that you install the 32 vs 64 bit versions as needed. Also, since you are talking about compilers ... -devel files are used for compiling against. These devel files provide headers (.h files) and the main .so file for linking. Devel files are not normally installed on systems as they are not needed for normal operation, but are used for building. signature.asc Description: OpenPGP digital signature ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
[CentOS] wordpess can't connect to DB but mediawiki can
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.
Here's the media wiki config first since that one's working:
## Database settings
$wgLBFactoryConf['class'] = 'LBFactorySimple';
$wgDBtype = "mysql";
$wgDBservers = '';
$wgDBserver = "db.example.com";
$wgDBssl= true;
$wgDBname = "jfwiki";
$wgDBuser = "admin_ssl";
$wgDBpassword = "secret";
And here's what the wordpress database connection settings look like since
they are not:
/** MySQL database username */
define('DB_NAME', 'jokefire');
define('DB_USER', 'admin_ssl');
/** MySQL database password */
define('DB_PASSWORD', 'secret');
/** MySQL hostname */
define('DB_HOST', 'db.example.com');
/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');
/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');
/** Contact the database over a secure connection */
define('DB_SSL', true);
I realize that they're not exactly the same. But I think you can make an
easy correlation between the mediawiki settings and the settings for
wordpress. And they look similar enough to think that wordpress should be
working. Right?
The only real other difference is the name of the database each site is
using, which I guess makes sense.
But the fact that medawiki works fine tells me that the user and password
set for both sites has access to the database.
Just for laughs I use the account settings from the wordpress config to
demonstrate that I can connect to the DB on the command line. Again, it's
the same account info that I have in the wik site:
#mysql -uadmin_ssl -p -h db.example.com -D jokefire -e "show tables" | head -5
Enter password:
Tables_in_jokefire
wp_bp_activity
wp_bp_activity_meta
wp_bp_chat_channel_users
wp_bp_chat_channels
Also, I created a basic php script to see if it could connect to the
database
And to my surprise it can't connect!
php testconnect.php
Could not connect: Access denied for user
'admin_ssl'@'ec2-54-86-143-49.compute-1.amazonaws.com' (using
password: YES)
Why am I surprised that it can't? Because again 1) the wiki can connect to
the database no problem. And 2) I can connect to the db on the command line
using the same credentials.
My API Client version is:
Client API version mysqlnd 5.0.10 - 20111026 - $Id:
c85105d7c6f7d70d609bb4c000257868a40840ab $
There are two MySQL databases configured in a master/master setup. The
database address is a VIP that is load balanced on the same two HA/Proxy
nodes. The two database servers are using MariaDB version 10.0.20-1.
There's 3 web servers sitting behind a VIP as well. But to troubleshoot
this I just the IP address of the 1st web server into my hosts file and I'm
using that as the site name.
I'm not really sure how important it is to know all of that about the load
balanced aspects of the site. But I wanted to get those details out into
the open just in case they were important.
Thanks in advance!
Tim
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] New desktop oriented Linux distribution based on CentOS 6
Thanks! На 15.08.2015 в 06:43, Always Learning написа: On Sat, 2015-08-15 at 02:14 +0200, Ivaylo Kuzev wrote: for those interested we are working on a CentOS 6 based Linux distribution for Bulgarian users called StotinkaOS. Lots of good luck. Anything to reduce the Windoze usage is splendid. ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] persistent change of max_stack_depth
On 08/14/2015 07:19 AM, Michael H wrote: I have currently set it by running 'ulimit -s 10240' but this does not survive a reboot. It's already been pointed out that you'll need to modify the init script, but just to make clear why that is the case, I thought it should be pointed out that "ulimit" is a bash built-in command. When you run "ulimit -s 10240" you're not modifying the system, as a whole. You're only modifying that shell's environment and any child process that you start from that shell. Not only does the command not survive a reboot, it doesn't persist between logins. And that's one of the better features of systemd. Because services are always started by systemd, they don't inherit environment, or process limits, or SELinux context from a login shell. If they start correctly interactively, via systemctl, they'll start correctly the next time the system boots. Under the old init system, that wasn't true. ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] persistent change of max_stack_depth
On 8/15/2015 1:17 PM, Gordon Messmer wrote: On 08/14/2015 07:19 AM, Michael H wrote: I have currently set it by running 'ulimit -s 10240' but this does not survive a reboot. It's already been pointed out that you'll need to modify the init script, but just to make clear why that is the case, I thought it should be pointed out that "ulimit" is a bash built-in command. When you run "ulimit -s 10240" you're not modifying the system, as a whole. You're only modifying that shell's environment and any child process that you start from that shell. Not only does the command not survive a reboot, it doesn't persist between logins. And that's one of the better features of systemd. Because services are always started by systemd, they don't inherit environment, or process limits, or SELinux context from a login shell. If they start correctly interactively, via systemctl, they'll start correctly the next time the system boots. Under the old init system, that wasn't true. The problem with it though is it ignores system wide and user specific baseline settings. If systemd still obeyed ulimits.conf I would agree that it was an improvement. ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] wordpess can't connect to DB but mediawiki can
> Date: Saturday, August 15, 2015 13:53:28 -0400 > From: Tim Dunphy > > 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. ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] persistent change of max_stack_depth
On Fri, 14 Aug 2015, Thomas Eriksson wrote: >If it's centos 6 stick 'ulimit -s' in the init script I suggest putting it in the sysconfig file instead, if such exists. /mark ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] persistent change of max_stack_depth
On Aug 15, 2015 13:23, Mark Milhollan wrote: > > On Fri, 14 Aug 2015, Thomas Eriksson wrote: > > >If it's centos 6 stick 'ulimit -s' in the init script > > I suggest putting it in the sysconfig file instead, if such exists. > > Sure, but how many init scripts provide for adding an extra command via sysconfig files? Most of them only allows for adding some predefined options to main service start command. Thomas ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] wordpess can't connect to DB but mediawiki can
> > [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 > > > > 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. > > ___ > CentOS mailing list > CentOS@centos.org > http://lists.centos.org/mailman/listinfo/centos > -- GPG me!! gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] wordpess can't connect to DB but mediawiki can
> Date: Saturday, August 15, 2015 17:57:03 -0400 > From: Tim Dunphy >> >> [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 >> > >> > 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@centos.org http://lists.centos.org/mailman/listinfo/centos
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 wrote: > > > Date: Saturday, August 15, 2015 17:57:03 -0400 > > From: Tim Dunphy > > >> > >> [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 > >> > > >> > 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@centos.org > http://lists.centos.org/mailman/listinfo/centos > -- GPG me!! gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] wordpess can't connect to DB but mediawiki can
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 > To: CentOS mailing list > 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 > > wrote: > >> >> > Date: Saturday, August 15, 2015 17:57:03 -0400 >> > From: Tim Dunphy >> >> >> >> >> [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 >> >> > >> >> > 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@centos.org >> http://lists.centos.org/mailman/listinfo/centos End Original Message ___ CentOS mailing list CentOS@cento
Re: [CentOS] wordpess can't connect to DB but mediawiki can
> > 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-cen...@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 > > To: CentOS mailing list > > 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 > > >> wrote: > > > >> > >> > Date: Saturday, August 15, 2015 17:57:03 -0400 > >> > From: Tim Dunphy > >> > >> >> > >> >> [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 > >> >> > > >> >> > 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
Re: [CentOS] wordpess can't connect to DB but mediawiki can
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 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-cen...@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
>> > To: CentOS mailing list
>> > 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
>> > > >> wrote:
>> >
>> >>
>> >> > Date: Saturday, August 15, 2015 17:57:03 -0400
>> >> > From: Tim Dunphy
>> >>
>> >> >>
>> >> >> [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
