Author Topic: mysqld OPPS  (Read 7996 times)

retired1af

  • Administrator
  • Vectorian
  • *****
  • Posts: 1475
Re: mysqld OPPS
« Reply #15 on: April 03, 2017, 04:37:24 am »
Any idea where it is to be located?  I put this on in public_html.

You put php.ini in a public facing folder?!!! No no no no no no no no. Does not belong there. No wonder it's not being read correctly.

php -i | grep "php.ini"  should tell you where it is. Generally, it's buried somewhere under /etc

ASUS K73 Intel i3 Dual Core 2.3GHz

StrayBit

  • Vectorian
  • ****
  • Posts: 543
    • Middleton Post 39
Re: mysqld OPPS
« Reply #16 on: April 03, 2017, 08:28:06 am »
Using the command you provided, I determined that php.ini should have been in /etc/httpd.  Moved it there.  Now getting
Quote
vector://home/bruce
root:# php -i | grep "php.ini"
PHP Warning:  PHP Startup: mysql: Unable to initialize module
Module compiled with module API=20131226
PHP    compiled with module API=20160303
These options need to match
 in Unknown on line 0
Configuration File (php.ini) Path => /etc/httpd
Loaded Configuration File => /etc/httpd/php.ini
Of course I'm still getting
Quote
Your PHP installation appears to be missing the MySQL extension which is required by WordPress.
7.2 STD B2 built on Feb-01-2017
HP 670 Win7 & VL7.0

retired1af

  • Administrator
  • Vectorian
  • *****
  • Posts: 1475
Re: mysqld OPPS
« Reply #17 on: April 03, 2017, 04:56:58 pm »
Ensure PHP is the most current "stable". Then redo your MYSQL installation. Something in your install has a mismatch, and if I recall, the only way to fix that error is to reinstall the offending "module", which is MYSQL in this case.

ASUS K73 Intel i3 Dual Core 2.3GHz

StrayBit

  • Vectorian
  • ****
  • Posts: 543
    • Middleton Post 39
Re: mysqld OPPS
« Reply #18 on: April 04, 2017, 10:29:40 am »
Gslapt informs me that I have php7 installed.  I removed mysql then installed it.  I find that I have to
Quote
vector://home/bruce
root:# mkdir /run/mysqld
vector://home/bruce
root:# chown mysql /run/mysqld
vector://home/bruce
root:# mysql_safe
vector://home/bruce
root:# 2017-04-04T17:16:54.741021Z mysqld_safe Logging to '/srv/mysql/vector.linux.vnet.err'.
2017-04-04T17:16:54.746815Z mysqld_safe Logging to '/srv/mysql/vector.linux.vnet.err'.
2017-04-04T17:16:54.824741Z mysqld_safe Starting mysqld daemon with databases from /srv/mysql
^C
vector://home/bruce
If I don't mkdir /run/mysqld, mysqld complains that it can't open a socket in that directory.
No change to http://idlegion39///wp-admin/install.php.
7.2 STD B2 built on Feb-01-2017
HP 670 Win7 & VL7.0

retired1af

  • Administrator
  • Vectorian
  • *****
  • Posts: 1475
Re: mysqld OPPS
« Reply #19 on: April 07, 2017, 04:47:13 am »
I just took a look at my installation and php.ini is in /usr/local/lib
ASUS K73 Intel i3 Dual Core 2.3GHz

retired1af

  • Administrator
  • Vectorian
  • *****
  • Posts: 1475
Re: mysqld OPPS
« Reply #20 on: April 07, 2017, 05:06:52 am »
You can also use this to obtain detailed information about your php installation.

https://codex.wordpress.org/Finding_Server_Info

This will tell you if it's finding the php.ini file along with a metric crap ton of other information.
ASUS K73 Intel i3 Dual Core 2.3GHz

StrayBit

  • Vectorian
  • ****
  • Posts: 543
    • Middleton Post 39
Re: mysqld OPPS
« Reply #21 on: April 08, 2017, 12:06:01 pm »
Selected info
Quote
Configuration File (php.ini) Path    /etc/httpd
Loaded Configuration File    /etc/httpd/php.ini
Scan this dir for additional .ini files    /etc/php
Quote
Server Root    /usr
Loaded Modules    core mod_so http_core mod_authn_file mod_authn_core mod_authz_host mod_authz_groupfile mod_authz_user mod_authz_core mod_access_compat mod_auth_basic mod_reqtimeout mod_filter mod_mime mod_log_config mod_env mod_headers mod_setenvif mod_version event mod_unixd mod_status mod_autoindex mod_dir mod_userdir mod_alias mod_php7
Quote
SERVER_SOFTWARE    Apache/2.4.25 (Unix) PHP/7.1.1
SERVER_NAME    idlegion39
SERVER_ADDR    127.0.0.1
SERVER_PORT    80
REMOTE_ADDR    127.0.0.1
DOCUMENT_ROOT    /home/public_html
Quote
MysqlI Support   enabled
Client API library version    mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $
Active Persistent Links    0
Inactive Persistent Links    0
Active Links    0
Directive   Local Value   Master Value
mysqli.allow_local_infile   On   On
mysqli.allow_persistent   On   On
mysqli.default_host   no value   no value
mysqli.default_port   3306   3306
mysqli.default_pw   no value   no value
mysqli.default_socket   /var/run/mysql/mysql.sock   /var/run/mysql/mysql.sock
mysqli.default_user   no value   no value
mysqli.max_links   Unlimited   Unlimited
mysqli.max_persistent   Unlimited   Unlimited
mysqli.reconnect   Off   Off
mysqli.rollback_on_cached_plink   Off   Off
mysqlnd
mysqlnd   enabled
Version    mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $
...
Loaded plugins    mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_password
API Extensions    mysqli,pdo_mysql
Quote
PDO support   enabled
PDO drivers    mysql, sqlite
pdo_mysql
PDO Driver for MySQL   enabled
Client API version    mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $
Directive   Local Value   Master Value
pdo_mysql.default_socket   /var/run/mysql/mysql.sock   /var/run/mysql/mysql.sock
You're right - there is a ton of information!
As I read this, mysql is enabled.  But why doesn't it work?
Am updating my apps seeing PHP7 is among them.  Will restart and try again.

What a startling developing revoltment!  There was no change to starting a php file.  AND I can't connect to the internet!  I can ping the router and I can access VL files from my laptop.
« Last Edit: April 08, 2017, 12:31:20 pm by StrayBit »
7.2 STD B2 built on Feb-01-2017
HP 670 Win7 & VL7.0

nightflier

  • Administrator
  • Vectorian
  • *****
  • Posts: 4461
Re: mysqld OPPS
« Reply #22 on: April 09, 2017, 04:18:00 am »
What a startling developing revoltment!  There was no change to starting a php file.  AND I can't connect to the internet!  I can ping the router and I can access VL files from my laptop.

Since this should not be php related, I have some suggestions. Sounds like a DNS problem. Can you ping a public ip, like 8.8.8.8?

StrayBit

  • Vectorian
  • ****
  • Posts: 543
    • Middleton Post 39
Re: mysqld OPPS
« Reply #23 on: April 09, 2017, 11:47:02 am »
Ping -c 3 8.8.8.8 works fine.  So it must be DNS.
I'm going to down load the latest ISO and start over.
7.2 STD B2 built on Feb-01-2017
HP 670 Win7 & VL7.0