Sessions filling up HDD can't release space

[stuffdone]

I have a site that is filling up disk space with additions to DB / Session handler. sessions_id

It has grown the SQL to almost 2GB. I manually cleared all the old sessions from that key but the server refuses to release the disk space leaving this site at 90% capacity now.

Two questions:

1. Why is Joomla not removing old expired sessions and how do I fix that? A setting?
( I did switch saving from DB to PHP but not sure that will solve the issue)

2. How can I release all that disk space?

Thanks for any help

[sozzled]

Go to Global Configuration » System » Session Settings and change Session Handler = PHP

[AMurray]

Go to Global Configuration » System » Session Settings and change Session Handler = PHP

Isn't that what the OP says he did (his question (item 1. above):

1. Why is Joomla not removing old expired sessions and how do I fix that? A setting?
( I did switch saving from DB to PHP but not sure that will solve the issue)

Maybe what he did is not what you're suggesting, but all I can do is interpret what he said he had done, as the same thing you're suggesting.

[SharkyKZ]

Enable System - Session Data Purge plugin or setup a Cronjob for cli/sessionGc.php script.

[stuffdone]

Enable System - Session Data Purge plugin or setup a Cronjob for cli/sessionGc.php script.

I checked that plugin is enabled. I don't see any settings or options to "run" (cronjob) said script to release that space?

It would appear that said script is not functional??

Any added info most appreciated.

[gws]

You create your own cron job in your cpanel.

[stuffdone]

You create your own cron job in your cpanel.

I just posted that I did that but for some reason that post did not appear. Thanks.

I set up at 5min interval to check function:

/usr/local/bin/php/home/USER/public_html/cli/sessionGc.php

Will go back and reset time to once per week.

[stuffdone]

running getting this error:

/usr/local/cpanel/bin/jailshell: /usr/local/bin/php/home/[USER]/public_html/cli/sessionGc.php: Not a directory

Wondering if having changed from DB to PHP the chron job is trying to release the wrong space or only the recent PHP space but not the prior DB space? Should I switch back to DB sessions until the space can be cleared?

//

[stuffdone]

I cannot seem to find out what permissions to set on that file. Some places I find general linux info on cron jobs that require access to add a user to a file I don't have access to.

Is there a specific permission to set? I don't want to enable too lenient of a permission.

[sozzled]

@stuffdone: I haven't the slightest idea how to assist you; most of us are just guessing anyway. Have you considered using the Forum Post Assistant? I've searched through a few of your topics on the forum and I can't say that I've seen you use the FPA report.

[stuffdone]

@stuffdone: I haven't the slightest idea how to assist you; most of us are just guessing anyway. Have you considered using the Forum Post Assistant? I've searched through a few of your topics on the forum and I can't say that I've seen you use the FPA report.

I'm really not sure what I could put there that would be any different! There are no error message other than "permission denied"

What is baffling is I have not seen this issue on any other site and I have been using Joomla for over ten years?

[stuffdone]

@stuffdone: I haven't the slightest idea how to assist you; most of us are just guessing anyway. Have you considered using the Forum Post Assistant? I've searched through a few of your topics on the forum and I can't say that I've seen you use the FPA report.

I'm really not sure what I could put there that would be any different! There are no error message other than "permission denied"

What is baffling is I have not seen this issue on any other site and I have been using Joomla for over ten years?

The other thing is that in reality this is outside of the Joomla system as it is a linux cron running a php script and cron is ignorant of Joomla as is MySQL.


The Joomla part of this is figuring out why the plugin is not cleaning up after an accumulation of sessions withing Joomla but that's a separate matter from the immediate concern of releasing disk space.

It is just trying to execute a script on the server.

[stuffdone]

Hope I am doing this right. :)

[01-Feb-2019 18:41:34 UTC] PHP Warning: Illegal string offset 'style' in /home/lourdesthevoice/public_html/libraries/src/Helper/ModuleHelper.php on line 252

Joomla! Instance :: Joomla! 3.9.2-Stable (Amani) 15-January-2019
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) | Owner: --protected-- . (uid: 1/gid: 1) | Group: --protected-- (gid: 1) | Valid For: 3.9
Configuration Options :: Offline: false | SEF: true | SEF Suffix: true | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: true | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 12 | Session handler: none | Shared sessions: false | SSL: 0 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: true | dbConnection Type: mysqli | PHP Supports J! 3.9.2: Yes | Database Supports J! 3.9.2: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 2.6.32-754.6.3.el6.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 56.59 GiB |

PHP Configuration :: Version: 7.2.14 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 32759 | Log Errors To: error_log | Last Known Error: 01st February 2019 18:41:34. | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 20M | Max. POST Size: 8M | Max. Input Time: 60 | Max. Execution Time: 60 | Memory Limit: 256M

Database Configuration :: Version: 5.5.61-cll (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $) | Host: --protected-- (--protected--) | default Collation: latin1_swedish_ci (default Character Set: latin1) | Database Size: 4.69 MiB | #of Tables: 98

PHP Extensions :: Core (7.2.14) | date (7.2.14) | libxml (7.2.14) | openssl (7.2.14) | pcre (7.2.14) | zlib (7.2.14) | filter (7.2.14) | hash (1.0) | pcntl (7.2.14) | readline (7.2.14) | Reflection (7.2.14) | SPL (7.2.14) | session (7.2.14) | standard (7.2.14) | cgi-fcgi () | bcmath (7.2.14) | calendar (7.2.14) | ctype (7.2.14) | curl (7.2.14) | dom (20031129) | ftp (7.2.14) | gd (7.2.14) | iconv (7.2.14) | imap (7.2.14) | json (1.6.0) | mbstring (7.2.14) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $) | PDO (7.2.14) | Phar (2.0.2) | posix (7.2.14) | SimpleXML (7.2.14) | soap (7.2.14) | sockets (7.2.14) | sqlite3 (7.2.14) | tokenizer (7.2.14) | xml (7.2.14) | xmlwriter (7.2.14) | xsl (7.2.14) | zip (1.15.4) | mysqli (7.2.14) | pdo_mysql (7.2.14) | pdo_sqlite (7.2.14) | wddx (7.2.14) | xmlreader (7.2.14) | Zend Engine (3.2.0) |
Potential Missing Extensions ::

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No

Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (---) |

Elevated Permissions (First 10) ::

Database statistics :: Uptime: 1459234 | Threads: 1 | Questions: 9279995 | Slow queries: 91 | Opens: 454116 | Flush tables: 69 | Open tables: 400 | Queries per second avg: 6.359 |

Components :: SITE ::
Core :: com_wrapper (3.0.0) 1 | com_mailto (3.0.0) 1 |
3rd Party:: WF_XHTMLXTRAS_TITLE (2.5.14) ? | WF_LAYER_TITLE (2.5.14) ? | WF_FULLSCREEN_TITLE (2.5.14) ? | WF_AUTOSAVE_TITLE (2.5.14) ? | WF_PREVIEW_TITLE (2.5.14) ? | WF_FORMATSELECT_TITLE (2.5.14) ? | WF_LINK_TITLE (2.5.14) ? | WF_VISUALCHARS_TITLE (2.5.14) ? | WF_TEXTCASE_TITLE (2.5.14) ? | WF_SPELLCHECKER_TITLE (2.5.14) ? | WF_TABLE_TITLE (2.5.14) ? | WF_ARTICLE_TITLE (2.5.14) ? | WF_BROWSER_TITLE (2.5.14) ? | WF_CONTEXTMENU_TITLE (2.5.14) ? | WF_VISUALBLOCKS_TITLE (2.5.14) ? | WF_PRINT_TITLE (2.5.14) ? | WF_FONTCOLOR_TITLE (2.5.14) ? | WF_KITCHENSINK_TITLE (2.5.14) ? | WF_ANCHOR_TITLE (2.5.14) ? | WF_FONTSELECT_TITLE (2.5.14) ? | WF_SEARCHREPLACE_TITLE (2.5.14) ? | WF_HR_TITLE (2.5.14) ? | WF_LISTS_TITLE (2.5.14) ? | WF_DIRECTIONALITY_TITLE (2.5.14) ? | WF_STYLESELECT_TITLE (2.5.14) ? | WF_MEDIA_TITLE (2.5.14) ? | WF_CLIPBOARD_TITLE (2.5.14) ? | WF_STYLE_TITLE (2.5.14) ? | WF_FONTSIZESELECT_TITLE (2.5.14) ? | WF_CHARMAP_TITLE (2.5.14) ? | WF_CLEANUP_TITLE (2.5.14) ? | WF_IMGMANAGER_TITLE (2.5.14) ? | WF_NONBREAKING_TITLE (2.5.14) ? | WF_INLINEPOPUPS_TITLE (2.5.14) ? | WF_SOURCE_TITLE (2.5.14) ? | WF_LINKS_JOOMLALINKS_TITLE (2.5.14) ? | WF_LINK_SEARCH_TITLE (2.5.14) ? | WF_MEDIAPLAYER_JCEPLAYER_TITLE (2.5.14) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.5.14) ? | WF_POPUPS_WINDOW_TITLE (2.5.14) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.5.14) ? | WF_AGGREGATOR_VIMEO_TITLE (2.5.14) ? | WF_AGGREGATOR_[youtube]_TITLE (2.5.14) ? | WF_AGGREGATOR_VINE_TITLE (2.5.14) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.5.14) ? |

Components :: ADMIN ::
Core :: com_ajax (3.2.0) 1 | com_menus (3.0.0) 1 | com_admin (3.0.0) 1 | com_tags (3.1.0) 1 | com_joomlaupdate (3.6.2) 1 | com_newsfeeds (3.0.0) 1 | com_privacy (3.9.0) 1 | com_postinstall (3.2.0) 1 | com_messages (3.0.0) 1 | com_associations (3.7.0) 1 | com_contenthistory (3.2.0) 1 | com_login (3.0.0) 1 | com_redirect (3.0.0) 1 | com_cpanel (3.0.0) 1 | com_languages (3.0.0) 1 | com_modules (3.0.0) 1 | com_cache (3.0.0) 1 | com_config (3.0.0) 1 | com_categories (3.0.0) 1 | com_users (3.0.0) 1 | com_finder (3.0.0) 1 | com_checkin (3.0.0) 1 | com_media (3.0.0) 1 | com_fields (3.7.0) 1 | com_search (3.0.0) 1 | com_installer (3.0.0) 1 | com_content (3.0.0) 1 | com_plugins (3.0.0) 1 | com_templates (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_banners (3.0.0) 1 |
3rd Party:: System - Jumi Router (2.0.6) 1 | Jumi (3.0.1) 1 | System - Jumi (3.0.4) 1 | com_jumi (3.0.3) 1 | COM_JEVENTS (3.4.48) 1 | Akeeba (6.3.3) 1 | com_xmap (2.3.4) 1 | JCE (2.5.14) 1 |

Modules :: SITE ::
Core :: mod_login (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_search (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_feed (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_banners (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_syndicate (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_popular (3.0.0) 1 |
3rd Party:: MOD_JEV_LATEST_EVENTS_TITLE (3.4.48) 1 | MOD_JEV_FILTER_MODULE_TITLE (3.4.48) 1 | Jumi (3.0.1) 1 | MOD_JEV_CUSTOM_MODULE_TITLE (3.4.48) 1 | MOD_JEV_LEGEND_TITLE (3.4.48) 1 | Nice Social Bookmark (3.0.2) 1 | MOD_JEV_SWITCH_VIEW_TITLE (3.4.48) 1 | MOD_JEV_CALENDAR_TITLE (3.4.48) 1 |

Modules :: ADMIN ::
Core :: mod_title (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_login (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_custom (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_status (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_version (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_menu (3.0.0) 1 |
3rd Party::

Libraries :: SITE ::
Core ::
3rd Party::

Plugins :: SITE ::
Core :: plg_fields_color (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_search_contacts (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_twofactorauth_totp (3.2.0) 0 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_privacyconsent (3.9.0) 0 | plg_system_fields (3.7.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_p3p (3.0.0) 0 | plg_system_stats (3.5.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_debug (3.0.0) 1 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 0 | plg_system_logout (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_log (3.0.0) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_sef (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_finder (3.0.0) 0 | plg_content_emailcloak (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_gmail (3.0.0) 0 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_user_joomla (3.0.0) 1 | plg_user_terms (3.9.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_user_profile (3.0.0) 0 | plg_extension_joomla (3.0.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_message (3.9.0) 1 |
3rd Party:: plg_editors_codemirror (5.40.0) 1 | plg_editors_jce (2.5.14) 1 | plg_editors_tinymce (4.5.9) 1 | plg_quickicon_akeebabackup (1.0) 1 | plg_quickicon_jcefilebrowser (2.5.14) 1 | PLG_JEV_SEARCH_TITLE (3.4.48) 1 | Helix3 - Ajax (2.5.6) 1 | plg_installer_jeventsinstaller (3.4.48) 0 | PLG_FINDER_JEVENTS (3.4.48) 0 | PLG_SYSTEM_GWEJSON (3.4.44) 1 | PLG_SYSTEM_AKEEBAACTIONLOG (1.0) 0 | PLG_SYSTEM_AKEEBAUPDATECHECK (1.1) 0 | plg_system_jce (2.5.14) 1 | PLG_SYSTEM_BACKUPONUPDATE (3.7) 0 | System - Jumi (3.0.4) 1 | System - Helix3 Framework (2.5.6) 1 | System - Jumi Router (2.0.6) 1 | AllVideos (by JoomlaWorks) (4.8.0) 1 | AllVideos (by JoomlaWorks) (4.8.0) 1 | PLG_JEV_CORE_CONTENT_PLUGIN_TITLE (3.4.48) 1 | Xmap - Virtuemart Plugin (2.0.3) 0 | Xmap - Mosets Tree Plugin (2.0.2) 0 | Xmap - SobiPro Plugin (2.0.2) 0 | Xmap - Kunena Plugin (3.0.0) 0 | Xmap - Content Plugin (2.0.4) 0 | Xmap - WebLinks Plugin (2.0.1) 0 | XMAP_PLUGIN_K2 (1.3) 0 |

Templates :: SITE :: lourdes-beez (3.1.0) 1 | protostar (1.0) ? | siteground-j16-11 (1.0.0) 1 | beez3 (3.1.0) ? |
Templates :: ADMIN :: hathor (3.0.0) 1 | isis (1.0) 1 |

[sozzled]

I can't read that, sorry. Please see the instructions on how to use the FPA at viewtopic.php?f=7&t=966324#p3550995

Your question about "sessions filling up HDD can't release space" is a bit like asking the captain of a sinking ship, "Can we bail the water out faster" without knowing where the water is coming from. In other words, are you trying to "bail" or do you know the reason(s) for the volume of session data?

I don't know. I don't know how you're managing your J! sessions. I don't know, for example, the details of session length or the session handler mechanism you're using. And if there's an inherent design flaw in J! that allows the build-up of session data (to the extent that it might compromise the availability of disk space) why would this not affect more people than just you?

While it might be good to know how to purge "disk space" as the result of an accumulation of session data, maybe you're asking the wrong question?

[stuffdone]

I followed instructions and posted from the FPA as it stated? Is there a step I am missing?

-- I guess my mistake was placing inside a CODE container. LOL that is a little item that should be added to the instructions...."Do not place in CODE container" LOL

---------- From yellow box of FPA - Ctrl c --> Ctrl v ------------

Unable to execute script to purge sessions

None

[01-Feb-2019 18:58:49 UTC] PHP Warning: Illegal string offset 'style' in /home/lourdesthevoice/public_html/libraries/src/Helper/ModuleHelper.php on line 252

Set cron job but get errors. permission denied than different error:
/home/lourdesthevoice/public_html/cli/sessionGc.php: line 1: ?php: No such file or directory
/home/lourdesthevoice/public_html/cli/sessionGc.php: line 2: /**: No such file or directory
/home/lourdesthevoice/public_html/cli/sessionGc.php: line 3: access-logs: command not found
/home/lourdesthevoice/public_html/cli/sessionGc.php: line 4: access-logs: command not found
/home/lourdesthevoice/public_html/cli/sessionGc.php: line 5: syntax error near unexpected token `('
/home/lourdesthevoice/public_html/cli/sessionGc.php: line 5: ` * @copyright Copyright (C) 2005 - 2019 Open Source Matters, Inc. All rights reserved.'

Joomla! Instance :: Joomla! 3.9.2-Stable (Amani) 15-January-2019
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) | Owner: --protected-- . (uid: 1/gid: 1) | Group: --protected-- (gid: 1) | Valid For: 3.9
Configuration Options :: Offline: false | SEF: true | SEF Suffix: true | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: true | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 12 | Session handler: none | Shared sessions: false | SSL: 0 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: true | dbConnection Type: mysqli | PHP Supports J! 3.9.2: Yes | Database Supports J! 3.9.2: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 2.6.32-754.6.3.el6.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 56.59 GiB |

PHP Configuration :: Version: 7.2.14 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 32759 | Log Errors To: error_log | Last Known Error: 01st February 2019 19:01:06. | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 20M | Max. POST Size: 8M | Max. Input Time: 60 | Max. Execution Time: 60 | Memory Limit: 256M

Database Configuration :: Version: 5.5.61-cll (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $) | Host: --protected-- (--protected--) | default Collation: latin1_swedish_ci (default Character Set: latin1) | Database Size: 4.69 MiB | #of Tables: 98

PHP Extensions :: Core (7.2.14) | date (7.2.14) | libxml (7.2.14) | openssl (7.2.14) | pcre (7.2.14) | zlib (7.2.14) | filter (7.2.14) | hash (1.0) | pcntl (7.2.14) | readline (7.2.14) | Reflection (7.2.14) | SPL (7.2.14) | session (7.2.14) | standard (7.2.14) | cgi-fcgi () | bcmath (7.2.14) | calendar (7.2.14) | ctype (7.2.14) | curl (7.2.14) | dom (20031129) | ftp (7.2.14) | gd (7.2.14) | iconv (7.2.14) | imap (7.2.14) | json (1.6.0) | mbstring (7.2.14) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $) | PDO (7.2.14) | Phar (2.0.2) | posix (7.2.14) | SimpleXML (7.2.14) | soap (7.2.14) | sockets (7.2.14) | sqlite3 (7.2.14) | tokenizer (7.2.14) | xml (7.2.14) | xmlwriter (7.2.14) | xsl (7.2.14) | zip (1.15.4) | mysqli (7.2.14) | pdo_mysql (7.2.14) | pdo_sqlite (7.2.14) | wddx (7.2.14) | xmlreader (7.2.14) | Zend Engine (3.2.0) |
Potential Missing Extensions ::

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No

Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (---) |

Elevated Permissions (First 10) ::

Database statistics :: Uptime: 1460345 | Threads: 1 | Questions: 9288606 | Slow queries: 91 | Opens: 454155 | Flush tables: 69 | Open tables: 400 | Queries per second avg: 6.360 |

Components :: SITE ::
Core :: com_wrapper (3.0.0) 1 | com_mailto (3.0.0) 1 |
3rd Party:: WF_XHTMLXTRAS_TITLE (2.5.14) ? | WF_LAYER_TITLE (2.5.14) ? | WF_FULLSCREEN_TITLE (2.5.14) ? | WF_AUTOSAVE_TITLE (2.5.14) ? | WF_PREVIEW_TITLE (2.5.14) ? | WF_FORMATSELECT_TITLE (2.5.14) ? | WF_LINK_TITLE (2.5.14) ? | WF_VISUALCHARS_TITLE (2.5.14) ? | WF_TEXTCASE_TITLE (2.5.14) ? | WF_SPELLCHECKER_TITLE (2.5.14) ? | WF_TABLE_TITLE (2.5.14) ? | WF_ARTICLE_TITLE (2.5.14) ? | WF_BROWSER_TITLE (2.5.14) ? | WF_CONTEXTMENU_TITLE (2.5.14) ? | WF_VISUALBLOCKS_TITLE (2.5.14) ? | WF_PRINT_TITLE (2.5.14) ? | WF_FONTCOLOR_TITLE (2.5.14) ? | WF_KITCHENSINK_TITLE (2.5.14) ? | WF_ANCHOR_TITLE (2.5.14) ? | WF_FONTSELECT_TITLE (2.5.14) ? | WF_SEARCHREPLACE_TITLE (2.5.14) ? | WF_HR_TITLE (2.5.14) ? | WF_LISTS_TITLE (2.5.14) ? | WF_DIRECTIONALITY_TITLE (2.5.14) ? | WF_STYLESELECT_TITLE (2.5.14) ? | WF_MEDIA_TITLE (2.5.14) ? | WF_CLIPBOARD_TITLE (2.5.14) ? | WF_STYLE_TITLE (2.5.14) ? | WF_FONTSIZESELECT_TITLE (2.5.14) ? | WF_CHARMAP_TITLE (2.5.14) ? | WF_CLEANUP_TITLE (2.5.14) ? | WF_IMGMANAGER_TITLE (2.5.14) ? | WF_NONBREAKING_TITLE (2.5.14) ? | WF_INLINEPOPUPS_TITLE (2.5.14) ? | WF_SOURCE_TITLE (2.5.14) ? | WF_LINKS_JOOMLALINKS_TITLE (2.5.14) ? | WF_LINK_SEARCH_TITLE (2.5.14) ? | WF_MEDIAPLAYER_JCEPLAYER_TITLE (2.5.14) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.5.14) ? | WF_POPUPS_WINDOW_TITLE (2.5.14) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.5.14) ? | WF_AGGREGATOR_VIMEO_TITLE (2.5.14) ? | WF_AGGREGATOR_[youtube]_TITLE (2.5.14) ? | WF_AGGREGATOR_VINE_TITLE (2.5.14) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.5.14) ? |

Components :: ADMIN ::
Core :: com_ajax (3.2.0) 1 | com_menus (3.0.0) 1 | com_admin (3.0.0) 1 | com_tags (3.1.0) 1 | com_joomlaupdate (3.6.2) 1 | com_newsfeeds (3.0.0) 1 | com_privacy (3.9.0) 1 | com_postinstall (3.2.0) 1 | com_messages (3.0.0) 1 | com_associations (3.7.0) 1 | com_contenthistory (3.2.0) 1 | com_login (3.0.0) 1 | com_redirect (3.0.0) 1 | com_cpanel (3.0.0) 1 | com_languages (3.0.0) 1 | com_modules (3.0.0) 1 | com_cache (3.0.0) 1 | com_config (3.0.0) 1 | com_categories (3.0.0) 1 | com_users (3.0.0) 1 | com_finder (3.0.0) 1 | com_checkin (3.0.0) 1 | com_media (3.0.0) 1 | com_fields (3.7.0) 1 | com_search (3.0.0) 1 | com_installer (3.0.0) 1 | com_content (3.0.0) 1 | com_plugins (3.0.0) 1 | com_templates (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_banners (3.0.0) 1 |
3rd Party:: System - Jumi Router (2.0.6) 1 | Jumi (3.0.1) 1 | System - Jumi (3.0.4) 1 | com_jumi (3.0.3) 1 | COM_JEVENTS (3.4.48) 1 | Akeeba (6.3.3) 1 | com_xmap (2.3.4) 1 | JCE (2.5.14) 1 |

Modules :: SITE ::
Core :: mod_login (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_search (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_feed (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_banners (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_syndicate (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_popular (3.0.0) 1 |
3rd Party:: MOD_JEV_LATEST_EVENTS_TITLE (3.4.48) 1 | MOD_JEV_FILTER_MODULE_TITLE (3.4.48) 1 | Jumi (3.0.1) 1 | MOD_JEV_CUSTOM_MODULE_TITLE (3.4.48) 1 | MOD_JEV_LEGEND_TITLE (3.4.48) 1 | Nice Social Bookmark (3.0.2) 1 | MOD_JEV_SWITCH_VIEW_TITLE (3.4.48) 1 | MOD_JEV_CALENDAR_TITLE (3.4.48) 1 |

Modules :: ADMIN ::
Core :: mod_title (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_login (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_custom (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_status (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_version (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_menu (3.0.0) 1 |
3rd Party::

Libraries :: SITE ::
Core ::
3rd Party::

Plugins :: SITE ::
Core :: plg_fields_color (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3. 0 | plg_search_contacts (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_twofactorauth_totp (3.2.0) 0 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_privacyconsent (3.9.0) 0 | plg_system_fields (3.7.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_p3p (3.0.0) 0 | plg_system_stats (3.5.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_debug (3.0.0) 1 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 0 | plg_system_logout (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_log (3.0.0) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_sef (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_finder (3.0.0) 0 | plg_content_emailcloak (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_gmail (3.0.0) 0 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_user_joomla (3.0.0) 1 | plg_user_terms (3.9.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_user_profile (3.0.0) 0 | plg_extension_joomla (3.0.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_message (3.9.0) 1 |
3rd Party:: plg_editors_codemirror (5.40.0) 1 | plg_editors_jce (2.5.14) 1 | plg_editors_tinymce (4.5.9) 1 | plg_quickicon_akeebabackup (1.0) 1 | plg_quickicon_jcefilebrowser (2.5.14) 1 | PLG_JEV_SEARCH_TITLE (3.4.48) 1 | Helix3 - Ajax (2.5.6) 1 | plg_installer_jeventsinstaller (3.4.48) 0 | PLG_FINDER_JEVENTS (3.4.48) 0 | PLG_SYSTEM_GWEJSON (3.4.44) 1 | PLG_SYSTEM_AKEEBAACTIONLOG (1.0) 0 | PLG_SYSTEM_AKEEBAUPDATECHECK (1.1) 0 | plg_system_jce (2.5.14) 1 | PLG_SYSTEM_BACKUPONUPDATE (3.7) 0 | System - Jumi (3.0.4) 1 | System - Helix3 Framework (2.5.6) 1 | System - Jumi Router (2.0.6) 1 | AllVideos (by JoomlaWorks) (4.8.0) 1 | AllVideos (by JoomlaWorks) (4.8.0) 1 | PLG_JEV_CORE_CONTENT_PLUGIN_TITLE (3.4.48) 1 | Xmap - Virtuemart Plugin (2.0.3) 0 | Xmap - Mosets Tree Plugin (2.0.2) 0 | Xmap - SobiPro Plugin (2.0.2) 0 | Xmap - Kunena Plugin (3.0.0) 0 | Xmap - Content Plugin (2.0.4) 0 | Xmap - WebLinks Plugin (2.0.1) 0 | XMAP_PLUGIN_K2 (1.3) 0 |

Templates :: SITE :: lourdes-beez (3.1.0) 1 | protostar (1.0) ? | siteground-j16-11 (1.0.0) 1 | beez3 (3.1.0) ? |
Templates :: ADMIN :: hathor (3.0.0) 1 | isis (1.0) 1 |

[Per Yngve Berg]

Max. Upload Size: 20M | Max. POST Size: 8M

Max Post size should be the largest value.

[sozzled]

Thanks. That's a good start.

We can confirm that Session Handler = PHP. We can also confirm that you're using the latest version of J! and you're using a version of PHP that's up-to-date. The PHP settings Max Upload Size and Max. POST Size are probably inadequate (there are many topics on the forum that discuss more appropriate values for these settings and I'll let you search for them).

The database collation / character encoding is wrong for versions of J! after J! 3.5. Suggest you change to UTF8 Multibyte. Again, many topics on the forum that discuss how you can do this, too. It's quite simple, really.

Lots of outdated extensions used on this website. Xmap was retired a long time ago; get rid of that junk! Don't ask me what the Jumi stuff does; never heard of it and, from the look of it, it hasn't been touched in over three years. Basically, if you don't know what these things do or you don't use 'em, uninstall 'em!

Don't fiddle with folder/file permissions. No good will come of that!

First of all, update your existing extensions (there are a lot of 'em), like Akeeba Backup. Recommend that you install Akeeba Admin Tools and use the single-click "fixer-upper" features of that extension.

I'm sure that other members of the community (like @Per) will have useful tips for you.

[stuffdone]

For some reason some of my replies are vanishing.

I just deleted Xmap.

Jumi is a small plugin that will insert content of a text file into a document. I use it a lot for insertion of things that Joomla might just remove like PayPal codes etc. Also great for things you want to place in multiple locations where you can change them all by editing a single text file.

While none of this appears related to purging MySQL it is appreciated and I will follow through with neglected cleanup.

Thanks

[stuffdone]

The database collation / character encoding is wrong for versions of J! after J! 3.5. Suggest you change to UTF8 Multibyte. Again, many topics on the forum that discuss how you can do this, too. It's quite simple, really.

I looked at the downloaded SQL and this line indicates it is already UTF8?

ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

[sozzled]

Did you update Akeeba Backup and install Akeeba Admin Tools as I suggested?

[stuffdone]

Did you update Akeeba Backup and install Akeeba Admin Tools as I suggested?

Not yet. I don't want to muddy waters on releasing disk space with component updates because the more things I introduce the more places for a problem.

I don't see there should be any connection between a component update and a cron job not running to purge SQL. I will try to fix one thing at a time.

What I find in the FPA read out is a strange conflict.

The discovery section says the DB is latin-1 Char Set but looking at every table below it confirms they are UTF8mba4 encoded. I don't quite understand this conflicting information.

[SharkyKZ]

running getting this error:

/usr/local/cpanel/bin/jailshell: /usr/local/bin/php/home/[USER]/public_html/cli/sessionGc.php: Not a directory

Wondering if having changed from DB to PHP the chron job is trying to release the wrong space or only the recent PHP space but not the prior DB space? Should I switch back to DB sessions until the space can be cleared?

//

There should be a space between PHP location and script location:

Code: Select all

/usr/local/bin/php /home/[USER]/public_html/cli/sessionGc.php

[stuffdone]

Don't know about that all I did was copy/paste the error displayed.