Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[StrayBit]

Please be advised that php7 does not include /usr/lib/php/extensions/mysql.so.
Php5 does but it is not compatible with php7.

Edit: or should I have put this in New Package Requests?

Edit:  According to http://php.net/manual/en/intro.mysql.php

This extension is deprecated as of PHP 5.5.0, and has been removed as of PHP 7.0.0. Instead, either the mysqli or PDO_MySQL extension should be used.

As it is, php5 (or php7) still complains that httpd doesn't have mysql running.  I have insured both are running from cli and have enabled all mod_*db[d|m] in httpd.conf
I just want to get a web site running locally!

[StrayBit]

Might there be someone in SW Idaho that would be willing to visit me to get this resolved?
I've been fighting this since 7.1 and always run into a stone wall!

[M0E-lnx]

Can you provide us some details on your setup?  What kind of services does your website require?  how are you starting those services?  Post complete error messages or other output from the commands you are running to get this started as well any available logs to try to help you debug

[rbistolfi]

How are you installing PHP7? Indeed mysql.so has been deprecated, but it was replaced by other extensions, so you still need MySQL support compiled into PHP.

[StrayBit]

This is a Compaq Presario with 7.2 STD FINAL built on Aug-03-2017.  I am currently using PHP5 installed with gslapt.  Unfortunately they don't start at log-on

vector://home/bruce
root:# mkdir /run/mysqld
vector://home/bruce
root:# chown mysql:mysql /run/mysqld
vector://home/bruce
root:# mysqld_safe
2017-09-12T15:10:43.401073Z mysqld_safe Logging to '/srv/mysql/vector.linux.vnet.err'.
2017-09-12T15:10:43.656067Z mysqld_safe Starting mysqld daemon with databases from /srv/mysql

^Z
[2]+  Stopped                 mysqld_safe
vector://home/bruce
root:# apachectl start
vector://home/bruce
root:# 1505229701507   addons.update-checker   WARN   Update manifest for modern@themes.mozilla.org did not contain an updates property
1505229701648   addons.update-checker   WARN   Update manifest for {972ce4c6-7e08-4474-a285-3208198ce6fd} did not contain an updates property

vector.linux.vnet.err

2017-09-12T14:46:54.414137Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-12T14:46:54.414729Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-09-12T14:46:54.414945Z 0 [Note] /usr/bin/mysqld (mysqld 5.7.18) starting as process 13359 ...
2017-09-12T14:46:54.485005Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-09-12T14:46:54.485218Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-12T14:46:54.485367Z 0 [Note] InnoDB: Uses event mutexes
2017-09-12T14:46:54.485480Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-12T14:46:54.485559Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-09-12T14:46:54.503090Z 0 [Note] InnoDB: Number of pools: 1
2017-09-12T14:46:54.535873Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-09-12T14:46:54.541040Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-09-12T14:46:54.614783Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-09-12T14:46:54.624461Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-09-12T14:46:54.773003Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-12T14:46:55.229163Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-09-12T14:46:55.229614Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-09-12T14:46:56.925935Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-09-12T14:46:56.931179Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-09-12T14:46:56.931438Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-09-12T14:46:56.934065Z 0 [Note] InnoDB: Waiting for purge to start
2017-09-12T14:46:56.985266Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 2536173
2017-09-12T14:46:56.987918Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mysql/ib_buffer_pool
2017-09-12T14:46:57.977298Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2017-09-12T14:46:57.977513Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2017-09-12T14:46:58.133590Z 0 [Warning] CA certificate ca.pem is self signed.
2017-09-12T14:46:58.133905Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2017-09-12T14:46:58.147706Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170912  8:46:58
2017-09-12T14:46:59.173889Z 0 [Note] Event Scheduler: Loaded 0 events
2017-09-12T14:46:59.174893Z 0 [Note] /usr/bin/mysqld: ready for connections.
Version: '5.7.18'  socket: '/run/mysqld/mysqld.sock'  port: 0  Source distribution
2017-09-12T14:46:59.175001Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-09-12T14:46:59.175051Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-09-12T14:46:59.590238Z 0 [Note] End of list of non-natively partitioned tables

Status information:

Current dir: /srv/mysql/
Running threads: 0  Stack size: 196608
Current locks:
lock: 0xa03b8b8:

lock: 0x9fdc668:

lock: 0x9f900b0:

lock: 0x9fcb478:

lock: 0x9fafde0:

lock: 0x9faaaa0:

lock: 0x9fa4e60:

lock: 0x979a660:

lock: 0x979a5e0:

lock: 0x979a560:

lock: 0x979a4e0:

lock: 0x979a460:

lock: 0x979a3e0:

lock: 0x979a360:

lock: 0x979a2e0:

lock: 0x979a260:

lock: 0x979a9e0:

lock: 0x97988e0:

lock: 0x979aee0:

lock: 0x979ae60:

lock: 0x979ade0:

lock: 0x979ad60:

lock: 0x979ace0:

lock: 0x979ac60:

lock: 0x979abe0:

lock: 0x979ab60:

lock: 0x97996e0:

lock: 0x979a6e0:

lock: 0x9799960:

lock: 0x97998e0:

lock: 0x9799860:

lock: 0x97997e0:

lock: 0x9799760:

lock: 0x979aae0:

lock: 0x979aa60:

lock: 0x9799be0:

lock: 0x9799b60:

lock: 0x9799ae0:

lock: 0x9799ce0:

lock: 0x97983e0:

lock: 0x979a960:

lock: 0x9798ce0:

lock: 0x9798b60:

lock: 0x9798c60:

lock: 0x9798ae0:

lock: 0x9798be0:

lock: 0x9799060:

lock: 0x97990e0:

lock: 0x9799160:

lock: 0x9798860:

lock: 0x97987e0:

lock: 0x9798a60:

lock: 0x9798760:

lock: 0x97989e0:

lock: 0x97986e0:

lock: 0x9798960:

lock: 0x9798ee0:

lock: 0x9798f60:

lock: 0x9798fe0:

lock: 0x9798660:

lock: 0x97984e0:

lock: 0x97985e0:

lock: 0x9798460:

lock: 0x9798560:

lock: 0x9798d60:

lock: 0x9798de0:

lock: 0x9798e60:

lock: 0x979a760:

lock: 0x979a8e0:

lock: 0x979a860:

lock: 0x979a7e0:

lock: 0x979a060:

lock: 0x9799fe0:

lock: 0x9799f60:

lock: 0x9799ee0:

lock: 0x9799e60:

lock: 0x979a160:

lock: 0x9799de0:

lock: 0x9799d60:

lock: 0x979a1e0:

lock: 0x9799c60:

lock: 0x97999e0:

lock: 0x9799a60:

lock: 0x9799660:

lock: 0x97995e0:

lock: 0x97993e0:

lock: 0x9799560:

lock: 0x97994e0:

lock: 0x9799360:

lock: 0x9799460:

lock: 0x97991e0:

lock: 0x9799260:

lock: 0x97992e0:

lock: 0x979a0e0:


Key caches:
default
Buffer_size:      16777216
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:             3
not flushed:             0
w_requests:              0
writes:                  0
r_requests:              6
reads:                   3


handler status:
read_key:           11
read_next:           1
read_rnd             0
read_first:         13
write:             280
delete               0
update:              0

Table status:
Opened tables:        108
Open tables:          101
Open files:            14
Open streams:           0

Memory status:
<malloc version="1">
<heap nr="0">
<sizes>
                             <size from="17" to="17" total="17" count="1"/>
                             <size from="25" to="25" total="100" count="4"/>
                             <size from="33" to="33" total="627" count="19"/>
                             <size from="41" to="41" total="1066" count="26"/>
                             <size from="49" to="49" total="3626" count="74"/>
                             <size from="57" to="57" total="57" count="1"/>
                             <size from="81" to="81" total="81" count="1"/>
                             <size from="89" to="89" total="89" count="1"/>
                             <size from="225" to="225" total="225" count="1"/>
                             <size from="313" to="313" total="313" count="1"/>
                             <size from="393" to="393" total="393" count="1"/>
                             <size from="417" to="417" total="417" count="1"/>
                             <size from="953" to="953" total="953" count="1"/>
                             <size from="2673" to="2673" total="2673" count="1"/>
                             <size from="8201" to="8201" total="8201" count="1"/>
                             <size from="16369" to="16369" total="32738" count="2"/>
                             <size from="17417" to="17417" total="17417" count="1"/>
                             <size from="24529" to="24529" total="49058" count="2"/>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="139" size="118051"/>
<system type="current" size="10280960"/>
<system type="max" size="10280960"/>
<aspace type="total" size="10280960"/>
<aspace type="mprotect" size="10280960"/>
</heap>
<heap nr="1">
<sizes>
                             <size from="41" to="48" total="48" count="1"/>
                             <size from="49" to="56" total="224" count="4"/>
                             <size from="17" to="17" total="187" count="11"/>
                             <size from="25" to="25" total="500" count="20"/>
                             <size from="33" to="33" total="726" count="22"/>
                             <size from="41" to="41" total="164" count="4"/>
                             <size from="49" to="49" total="147" count="3"/>
                             <size from="409" to="409" total="409" count="1"/>
                             <size from="6065" to="6065" total="6065" count="1"/>
                             <size from="8201" to="8201" total="24603" count="3"/>
                             <size from="11993" to="11993" total="11993" count="1"/>
                             <size from="15289" to="16369" total="80765" count="5"/>
                             <size from="21481" to="24529" total="143806" count="6"/>
                             <size from="32697" to="32697" total="130788" count="4"/>
                             <size from="40857" to="40857" total="40857" count="1"/>
                             <size from="46657" to="46657" total="46657" count="1"/>
                             <size from="234057" to="234057" total="234057" count="1"/>
</sizes>
<total type="fast" count="5" size="272"/>
<total type="rest" count="84" size="721724"/>
<system type="current" size="1421312"/>
<system type="max" size="1421312"/>
<aspace type="total" size="372736"/>
<aspace type="mprotect" size="372736"/>
</heap>
<heap nr="2">
<sizes>
                             <size from="17" to="24" total="24" count="1"/>
                             <size from="25" to="32" total="32" count="1"/>
                             <size from="17" to="17" total="17" count="1"/>
</sizes>
<total type="fast" count="2" size="56"/>
<total type="rest" count="1" size="17"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<total type="fast" count="7" size="328"/>
<total type="rest" count="224" size="839792"/>
<total type="mmap" count="61" size="186781696"/>
<system type="current" size="11837440"/>
<system type="max" size="11837440"/>
<aspace type="total" size="10788864"/>
<aspace type="mprotect" size="10788864"/>
</malloc>



Events status:
LLA = Last Locked At  LUA = Last Unlocked At
WOC = Waiting On Condition  DL = Data Locked

Event scheduler status:
State      : INITIALIZED
Thread id  : 0
LLA        : n/a:0
LUA        : n/a:0
WOC        : NO
Workers    : 0
Executed   : 0
Data locked: NO

Event queue status:
Element count   : 0
Data locked     : NO
Attempting lock : NO
LLA             : init_queue:95
LUA             : init_queue:103
WOC             : NO
Next activation : never
2017-09-12T14:58:49.878652Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-09-12T14:58:49.878762Z 0 [Note] Shutting down slave threads
2017-09-12T14:58:49.878818Z 0 [Note] Forcefully disconnecting 0 remaining clients
2017-09-12T14:58:49.878881Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2017-09-12T14:58:49.879160Z 0 [Note] Binlog end
2017-09-12T14:58:49.879487Z 0 [Note] Shutting down plugin 'ngram'
2017-09-12T14:58:49.879589Z 0 [Note] Shutting down plugin 'partition'
2017-09-12T14:58:49.879650Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-09-12T14:58:49.879767Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-09-12T14:58:49.879838Z 0 [Note] Shutting down plugin 'MyISAM'
2017-09-12T14:58:49.879914Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-09-12T14:58:49.879973Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-09-12T14:58:49.880022Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-09-12T14:58:49.880071Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-09-12T14:58:49.880118Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-09-12T14:58:49.880165Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-09-12T14:58:49.880213Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-09-12T14:58:49.880259Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-09-12T14:58:49.880402Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-09-12T14:58:49.880486Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-09-12T14:58:49.880538Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-09-12T14:58:49.880588Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-09-12T14:58:49.880635Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-09-12T14:58:49.880684Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-09-12T14:58:49.880732Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-09-12T14:58:49.880779Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-09-12T14:58:49.880826Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-09-12T14:58:49.880874Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-09-12T14:58:49.880923Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-09-12T14:58:49.880973Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-09-12T14:58:49.881119Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-09-12T14:58:49.881188Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-09-12T14:58:49.881239Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-09-12T14:58:49.881287Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-09-12T14:58:49.881784Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-09-12T14:58:49.881859Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-09-12T14:58:49.881915Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-09-12T14:58:49.881967Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-09-12T14:58:49.882015Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-09-12T14:58:49.882063Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-09-12T14:58:49.882111Z 0 [Note] Shutting down plugin 'InnoDB'
2017-09-12T14:58:49.886563Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-09-12T14:58:49.887238Z 0 [Note] InnoDB: Starting shutdown...
2017-09-12T14:58:49.988384Z 0 [Note] InnoDB: Dumping buffer pool(s) to /srv/mysql/ib_buffer_pool
2017-09-12T14:58:49.989225Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170912  8:58:49
2017-09-12T14:58:50.714829Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2536201
2017-09-12T14:58:50.723646Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-09-12T14:58:50.723782Z 0 [Note] Shutting down plugin 'MEMORY'
2017-09-12T14:58:50.723853Z 0 [Note] Shutting down plugin 'CSV'
2017-09-12T14:58:50.723909Z 0 [Note] Shutting down plugin 'sha256_password'
2017-09-12T14:58:50.723957Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-09-12T14:58:50.724585Z 0 [Note] Shutting down plugin 'binlog'
2017-09-12T14:58:50.729402Z 0 [Note] /usr/bin/mysqld: Shutdown complete

2017-09-12T15:10:44.962899Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-12T15:10:44.972029Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-09-12T15:10:44.973710Z 0 [Note] /usr/bin/mysqld (mysqld 5.7.18) starting as process 4699 ...
2017-09-12T15:10:45.374253Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-09-12T15:10:45.374543Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-12T15:10:45.374637Z 0 [Note] InnoDB: Uses event mutexes
2017-09-12T15:10:45.374722Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-12T15:10:45.374806Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-09-12T15:10:45.408817Z 0 [Note] InnoDB: Number of pools: 1
2017-09-12T15:10:45.442105Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-09-12T15:10:45.447193Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-09-12T15:10:45.500069Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-09-12T15:10:45.507823Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-09-12T15:10:45.668632Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-12T15:10:46.145524Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-09-12T15:10:46.145911Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-09-12T15:10:47.899428Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-09-12T15:10:47.904827Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-09-12T15:10:47.904978Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-09-12T15:10:47.906552Z 0 [Note] InnoDB: Waiting for purge to start
2017-09-12T15:10:47.958463Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 2536201
2017-09-12T15:10:47.960290Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mysql/ib_buffer_pool
2017-09-12T15:10:49.122253Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2017-09-12T15:10:49.122546Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2017-09-12T15:10:49.286717Z 0 [Warning] CA certificate ca.pem is self signed.
2017-09-12T15:10:49.287009Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2017-09-12T15:10:49.632066Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170912  9:10:49
2017-09-12T15:10:50.100540Z 0 [Note] Event Scheduler: Loaded 0 events
2017-09-12T15:10:50.101584Z 0 [Note] /usr/bin/mysqld: ready for connections.
Version: '5.7.18'  socket: '/run/mysqld/mysqld.sock'  port: 0  Source distribution
2017-09-12T15:10:50.101693Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-09-12T15:10:50.101744Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-09-12T15:10:50.434253Z 0 [Note] End of list of non-natively partitioned tables

Can't locate any other logs.
There are symlinks in /srv to /home/www and /home/www/htdocs.  Sending Seamonkey to http://127.0.0.1/

It works! In /home/www/htdocs

https://127.0.0.1/wordpress/wp-admin/install.php

Failed to Connect

The connection was refused when attempting to contact 127.0.0.1.

Though the site seems valid, the browser was unable to establish a connection.

    Could the site be temporarily unavailable? Try again later.
    Are you unable to browse other sites? Check the computer’s network connection.
    Is your computer or network protected by a firewall or proxy? Incorrect settings can interfere with Web browsing.

[M0E-lnx]

The mysql server needs to be started using its init script located in /etc/rc.d Same goes for php