VectorLinux

Please login or register.

Login with username, password and session length
Advanced search  

News:

Visit our home page for VL info. For support and documentation, visit the Vector Linux Knowledge Center or search the Knowledge Center and this Forum using the search box above.

Pages: 1 [2]

Author Topic: mysqld OPPS  (Read 492 times)

retired1af

  • Administrator
  • Vectorian
  • *****
  • Posts: 1446
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

Logged
ASUS K73 Intel i3 Dual Core 2.3GHz

StrayBit

  • Vectorite
  • ***
  • Posts: 487
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.
Logged
Dell GX280: 7.1-Gold 32 bit
HP 670 Win7 & VL7.0

retired1af

  • Administrator
  • Vectorian
  • *****
  • Posts: 1446
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.

Logged
ASUS K73 Intel i3 Dual Core 2.3GHz

StrayBit

  • Vectorite
  • ***
  • Posts: 487
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.
Logged
Dell GX280: 7.1-Gold 32 bit
HP 670 Win7 & VL7.0

retired1af

  • Administrator
  • Vectorian
  • *****
  • Posts: 1446
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
Logged
ASUS K73 Intel i3 Dual Core 2.3GHz

retired1af

  • Administrator
  • Vectorian
  • *****
  • Posts: 1446
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.
Logged
ASUS K73 Intel i3 Dual Core 2.3GHz

StrayBit

  • Vectorite
  • ***
  • Posts: 487
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 »
Logged
Dell GX280: 7.1-Gold 32 bit
HP 670 Win7 & VL7.0

nightflier

  • Administrator
  • Vectorian
  • *****
  • Posts: 4291
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?
Logged

StrayBit

  • Vectorite
  • ***
  • Posts: 487
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.
Logged
Dell GX280: 7.1-Gold 32 bit
HP 670 Win7 & VL7.0
Pages: 1 [2]