Joomla 4 - setup doesn't have MySQLi as database type option

Be informed that this forum is not an official support forum for Joomla! 4.0. Any issues regarding Joomla! 4.0 must be reported at https://issues.joomla.org/.

Joomla 4.0 is still in Beta stage. This forum should be used for sharing information about Joomla! 4.0.

Moderator: ooffick

Forum rules
Locked
User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 9634
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Joomla 4 - setup doesn't have MySQLi as database type option

Post by AMurray » Sat Mar 03, 2018 1:30 am

I don't know where else to post this (perhaps Github) but I am testing J40 Nightly build, downloaded 3/03/2018 and my host is running PHP 7.0.16 which should be sufficient at this stage. I am on shared hosting, with no option to update PHP any higher.

While this is obviously development stage of Joomla 4.0 I am keen to know the source of this error and why it's occuring.

I tried installing in normal fashion, the download package but it wouldn't go further than installing the database tables (white screens), and then tried an Akeeba Kickstart restore of a working copy of J40 (from my PC - localhost). The restore seems to work until the "view site" or "view administrator" stage and then goes to white screen (PHP errors).

Turning error reporting on reveals:

Warning: Uncaught RuntimeException: The MySQLi extension is not available in /home/murrayad/public_html/test/j40kickstart/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:162 Stack trace: #0 /home/murrayad/public_html/test/j40kickstart/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php(222): Joomla\Database\Mysqli\MysqliDriver->connect() #1 [internal function]: Joomla\Session\Handler\DatabaseHandler->open('', 'ce710b09ae1f27d...') #2 /home/murrayad/public_html/test/j40kickstart/libraries/vendor/joomla/session/src/Storage/NativeStorage.php(454): session_start() #3 /home/murrayad/public_html/test/j40kickstart/libraries/src/Session/Storage/JoomlaStorage.php(293): Joomla\Session\Storage\NativeStorage->start() #4 /home/murrayad/public_html/test/j40kickstart/libraries/vendor/joomla/session/src/Session.php(458): Joomla\CMS\Session\Storage\JoomlaStorage->start() #5 /home/murrayad/public_html/test/j40kickstart/libraries/vendor/joomla/session/src/Session.php(346): Joomla\Session\Session->start() #6 /hom in /home/murrayad/public_html/test/j40kickstart/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php on line 162

Below is the FPA. The above error seems to contradict the FPA as it shows the MySQLi driver "enabled". Maybe it's just J4.0 is not working correctly at this point.
Forum Post Assistant (v1.3.9) : 2nd March 2018 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 4.0.0-dev-Development (Amani) 19-November-2017
Joomla! Configured :: Yes | Writable (644) | Owner: --protected-- . (uid: 1/gid: 1) | Group: --protected-- (gid: 1) | Valid For: 4.0
Configuration Options :: Offline: '0' | SEF: '1' | SEF Suffix: '0' | SEF ReWrite: '0' | .htaccess/web.config: Yes | GZip: '0' | Cache: '0' | CacheTime: '15' | CacheHandler: file | CachePlatformPrefix: '0' | FTP Layer: '0' | Proxy: '0' | LiveSite: | Session lifetime: '15' | Session handler: database | Shared sessions: '0' | SSL: '0' | FrontEdit: '1' | Error Reporting: maximum | Site Debug: '0' | Language Debug: '0' | Default Access: '1' | Unicode Slugs: '0' | dbConnection Type: mysqli | Database Credentials Present: Yes

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

PHP Configuration :: Version: 7.0.16 | PHP API: cgi-fcgi | Session Path Writable: No | Display Errors: | Error Reporting: 24567 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 1024M | Max. POST Size: 1024M | Max. Input Time: 300 | Max. Execution Time: 300 | Memory Limit: 256M

MySQL Configuration :: Version: 5.5.51-38.2 (Client:5.5.54-MariaDB) | Host: --protected-- (--protected--) | Collation: utf8_general_ci (Character Set: utf8) | Database Size: 7.92 MiB | #of Tables: 148
Detailed Environment :: wrote:PHP Extensions :: Core (7.0.16) | date (7.0.16) | libxml (7.0.16) | openssl (7.0.16) | pcre (7.0.16) | sqlite3 (0.7-dev) | zlib (7.0.16) | bcmath (7.0.16) | bz2 (7.0.16) | calendar (7.0.16) | ctype (7.0.16) | curl (7.0.16) | dom (20031129) | hash (1.0) | fileinfo (1.0.5) | filter (7.0.16) | ftp (7.0.16) | gd (7.0.16) | gettext (7.0.16) | SPL (7.0.16) | iconv (7.0.16) | session (7.0.16) | intl (1.1.0) | json (1.4.0) | mbstring (7.0.16) | mcrypt (7.0.16) | standard (7.0.16) | mysqli (7.0.16) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $) | PDO (7.0.16) | Phar (2.0.2) | posix (7.0.16) | pspell (7.0.16) | Reflection (7.0.16) | imap (7.0.16) | SimpleXML (7.0.16) | snmp (0.1) | soap (7.0.16) | sockets (7.0.16) | exif (1.4 $Id: 8bdc0c8f27c2c9dd1f7551f1f9fe3ab57a06a4b1 $) | tidy (7.0.16) | tokenizer (7.0.16) | wddx (7.0.16) | xml (7.0.16) | xmlreader (7.0.16) | xmlrpc (7.0.16) | xmlwriter (7.0.16) | xsl (7.0.16) | zip (1.13.5) | cgi-fcgi () | pdo_sqlite (7.0.16) | pdo_pgsql (7.0.16) | pdo_mysql (7.0.16) | pgsql (7.0.16) | imagick (3.4.3) | timezonedb (2014.9) | yaml (2.0.0RC5) | Zend Engine (3.0.0) |
Potential Missing Extensions :: mysql | suhosin |

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (---) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) |

Elevated Permissions (First 10) ::
Database Information :: wrote:Database statistics :: Uptime: 3105804 | Threads: 7 | Questions: 903426460 | Slow queries: 326 | Opens: 53528831 | Flush tables: 37 | Open tables: 400 | Queries per second avg: 290.883 |
Extensions Discovered :: wrote:Components :: SITE :: com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
Components :: ADMIN :: com_redirect (3.0.0) 1 | com_languages (3.0.0) 1 | com_tags (3.1.0) 1 | com_menus (3.0.0) 1 | com_cache (3.0.0) 1 | com_templates (3.0.0) 1 | com_media (3.0.0) 1 | com_checkin (3.0.0) 1 | com_messages (3.0.0) 1 | com_modules (3.0.0) 1 | com_categories (3.0.0) 1 | com_login (3.0.0) 1 | com_fields (3.7.0) 1 | com_plugins (3.0.0) 1 | com_contenthistory (3.2.0) 1 | com_newsfeeds (3.0.0) 1 | com_associations (3.7.0) 1 | com_finder (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_joomlaupdate (3.6.2) 1 | com_installer (3.0.0) 1 | com_content (3.0.0) 1 | com_users (3.0.0) 1 | com_ajax (3.2.0) 1 | com_cpanel (3.0.0) 1 | Akeeba (6.0.1) 1 | com_search (3.0.0) 1 | com_config (3.0.0) 1 | com_banners (3.0.0) 1 | com_admin (3.0.0) 1 |

Modules :: SITE :: mod_articles_category (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_login (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_languages (3.5.0) 1 | mod_finder (3.0.0) 1 | mod_search (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_users_latest (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_random_image (3.0.0) 1 |
Modules :: ADMIN :: mod_menu (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_login (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_title (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_status (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_version (3.0.0) 1 |

Plugins :: SITE :: plg_editors_codemirror (5.35.0) 1 | plg_editors_tinymce (4.7.7) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_akeebabackup (1.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | plg_installer_webinstaller (1.1.1) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_behaviour_taggable (4.0.0.) 1 | plg_behaviour_versionable (4.0.0.) 1 | plg_system_stats (3.5.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_httpheader (4.0.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_fields (3.7.0) 1 | PLG_SYSTEM_AKEEBAUPDATECHECK_T (1.1) 1 | plg_system_logout (3.0.0) 1 | PLG_SYSTEM_BACKUPONUPDATE_TITL (3.7) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_sef (3.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_updatenotification (3.5.0) 1 | plg_system_log (3.0.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_fields_imagelist (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_extension_namespacemap (4.0.0) 1 | plg_user_joomla (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_profile (3.0.0) 0 | plg_search_tags (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_categories (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_authentication_cookie (3.0.0) 1 | plg_filesystem_local (4.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_vote (3.0.0) 0 | plg_finder_tags (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_media-action_rotate (4.0.0) 1 |
Templates Discovered :: wrote:Templates :: SITE :: cassiopeia (1.0) 1 |
Templates :: ADMIN :: atum (1.0) 1 |
I have a working Joomla 3.8.5 site on my host running on db type MySQLi so I don't know if there's some difference in how 3.8.x and 4.0.x work in respect to MySQL

Thanks.
Last edited by imanickam on Thu Mar 22, 2018 3:27 am, edited 2 times in total.
Reason: Moved the topic from the forum General Questions/New to Joomla! 3.x to the forum Joomla! 4 Related
Regards - A Murray
General Support Moderator

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 9634
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by AMurray » Sat Mar 03, 2018 1:38 am

Kind of resolved (for the moment): I changed

Code: Select all

public $dbtype = 'mysqli';
to

Code: Select all

public $dbtype = 'mysql';
and it now works. That's fine for testing but will look to be using MySQLi when 4.0 is stable.
Regards - A Murray
General Support Moderator

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 28193
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by imanickam » Sat Mar 03, 2018 7:35 am

Interesting... I noticed that your environment is Linux.


I just downloaded the nightly build (from https://developer.joomla.org/nightly-builds.html - file https://developer.joomla.org/nightlies/ ... ackage.zip) and installed Joomla! 4 using the MySQLi option. It installed correctly and also the site is working.

I am using WAMP Server on my laptop and the environment is:

O/s: Windows 10 64 bit machine
PHP: v7.0.23
MySQL: v5.7.19
Apache: v2.4.27

Let me test in a Linux environment and post my result.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
Former Joomla! Translations Coordination Team Lead
Eegan - Support the poor and underprivileged

frostmakk
Joomla! Explorer
Joomla! Explorer
Posts: 262
Joined: Sun Dec 28, 2014 9:30 am
Location: Stavanger, Norway

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by frostmakk » Sat Mar 03, 2018 8:49 am

I wonder how current these nightly builds are. Two weeks since last build???
nb.PNG
You do not have the required permissions to view the files attached to this post.

frostmakk
Joomla! Explorer
Joomla! Explorer
Posts: 262
Joined: Sun Dec 28, 2014 9:30 am
Location: Stavanger, Norway

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by frostmakk » Sat Mar 03, 2018 1:53 pm

When reading through https://github.com/joomla/joomla-cms/issues/19779 it becomes clear that 4.0 database installation is a bit off at the moment. Had to do a couple of tests anyway, just for fun.
Wampserver on win10.
With existing database. Mysqli and pdomysql install flawless.
Without existing database. Mysqli creates db and install flawless. pdomysql crashes.
None of the two postgreSQL methods works. PostgreSQL crashes, and pdo just redirects back to start.
There is no problem installing 3.8.6-dev to the postgreSQL server.

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 28193
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by imanickam » Sun Mar 04, 2018 4:58 am

Found out that the latest code could be downloaded from https://github.com/joomla/joomla-cms/ar ... .0-dev.zip.

I have downloaded the file (joomla-cms-4.0-dev.zip) and installed it successfully in a Linux environment that uses PHP v7.0.27 and MySQL 5.6.38.

The only odd thing I noticed is that "mysql (PDO)" is shown as the default which I understand is broken at this time. I chose MySQLi from the dropdown and went ahead with the install.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
Former Joomla! Translations Coordination Team Lead
Eegan - Support the poor and underprivileged

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 9634
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by AMurray » Sun Mar 04, 2018 10:30 pm

I can't see any MySQLi option at all, and the MySQL (PDO) doesn't connect to DB at all.

The available PHP versions:

PHP 5.5.38
PHP 5.6.33 - System Default
PHP 7.0.27
PHP 7.1.14
PHP 7.2.2

Tried 7.0.27 and 7.1.4
no_MySQLi_PHP_7.0.27.png
Selecting MySQL (PDO) results in :

"Fatal error: session_start(): Failed to initialize storage module: user (path: /tmp) in /home/murraywe/public_html/test/j40/libraries/vendor/joomla/session/src/Storage/NativeStorage.php on line 454"

And

Error: Could not connect to PDO: SQLSTATE[28000] [1045] Access denied for user 'XXXX'@'localhost' (using password: YES) (etc....).

Database was simply created in cPanel through normal means. I even tried changing db password and starting the process over - no luck. I know MySQL has problems with non-alpha characters in passwords so was made up of alpha-numeric only.
You do not have the required permissions to view the files attached to this post.
Regards - A Murray
General Support Moderator

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 9634
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by AMurray » Sun Mar 04, 2018 10:47 pm

I tried again with PostGre database, but it failed as well.
Regards - A Murray
General Support Moderator

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 28193
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by imanickam » Mon Mar 05, 2018 3:09 am

Interesting... I know that it would be frustrating...

Have you tried with the file referenced below?
imanickam wrote:Found out that the latest code could be downloaded from https://github.com/joomla/joomla-cms/ar ... .0-dev.zip.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
Former Joomla! Translations Coordination Team Lead
Eegan - Support the poor and underprivileged

User avatar
brian
Joomla! Master
Joomla! Master
Posts: 12781
Joined: Fri Aug 12, 2005 7:19 am
Location: Leeds, UK
Contact:

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by brian » Mon Mar 05, 2018 5:02 pm

AMurray

1. Joomla 4 requires a minimum of php7

2. In php 7 and above there is no such thing as mysqli and mysql. there is only mysqli so it is identified as simply mysql

3. Mysql PDO currently will NOT create a database but will happily install if a database already exists
"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 9634
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by AMurray » Mon Mar 05, 2018 9:52 pm

To confirm, yes I am using PHP 7 (tried the various releases - 7.0.27, 7.1.14, 7.2 (as they are the available versions on my host). I created the DB before installation and have tried both MySQL and PostgreSQL without any luck.

I will try it again this week using the 4.0Alpha release @imanikam has mentioned, and include the FPA again for reference when I have a spare moment.
Regards - A Murray
General Support Moderator

User avatar
brian
Joomla! Master
Joomla! Master
Posts: 12781
Joined: Fri Aug 12, 2005 7:19 am
Location: Leeds, UK
Contact:

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by brian » Mon Mar 05, 2018 9:58 pm

Do NOT use the alpha release - that is now very old

Download the nightly build https://developer.joomla.org/nightly-builds.html
"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/

deleted user

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by deleted user » Mon Mar 05, 2018 11:00 pm

I don't suppose anyone has searched or found their way to https://issues.joomla.org/tracker/joomla-cms/18660 by chance.

TL;DR there's a known platform configuration where MySQLi won't work on and won't be fixed apparently until I find some time in my copious amounts of free time to fix it since the issue has been known for ~4 months now and nobody's taken a stab at the fix I suggest is needed.

sozzled
I've been banned!
Posts: 13639
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by sozzled » Tue Mar 06, 2018 12:04 am

Dear all,

I base my comments only on what I've read here and on GitHub; I have no first-hand experience with the issues raised here. There are two problems as I see them.

We are all aware of the seismic difference (in pre-J! 4.0 terms) between using the database connection methods MySQL and MySQLi. Without going into hair-splitting technicalities, from a Joomla novice's perspective, we know that there isn't a native "MySQL" handler for PHP 7; in other words, when people install Joomla they expect to find and use MySQLi if they're installing Joomla on a PHP 7 codebase.

I think that's what Andy was referring to in, at least in part, in his contribution to the topic or, to put it more bluntly, "Where the heck is the MySQLi option?". Brian's answer seems to suggest that the "option" has been renamed.
brian wrote:... In php 7 and above there is no such thing as mysqli and mysql. there is only mysqli so it is identified as simply mysql.
Ouch! This could become a little confusing, going forward, if people don't understand that MySQLi (in PHP7) is a kind of archaic way of saying MySQL. As we head into the unchartered territory of J! 4.x support, if people aren't aware that MySQL actually means MySQLi then we're "cruising for a bruising".

While it may not appease the purists among us to continue to refer to MySQL and MySQLi—whether in the short- or long-term—it may be less abrupt if the nomenclature (as outdated as it may seem) remains in force.

These matters notwithstanding, in Andy's case, using MySQL (meaning "MySQLi", of course) caused the installation to blow up in his face, anyway. So there's still a technical issue to pursue.

Thanks, guys. :)

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 9634
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by AMurray » Tue Mar 06, 2018 9:30 am

OK last attempt....
developer.joomla.org wrote:These packages were last built: Tuesday, 06 March 2018 03:05:03 UTC
Have downloaded the nightly build per the above. (if this 'build' is 6 March, why does the FPA note the date as 17 November 2017 - are the two dates referring to different things?)

Uploaded the ZIP file, extracted the files to the server

Created MySQL database, assigned database user with all privileges.

Ran the installer.

Selected Language US or GB English.

Entered Site Name.

**had trouble proceeding to next screen (mouse click doesn't respond on button "set up login info")

Eventually worked after clearing browser cache.

In Database Type select box
MySQL PDO
PostgreSQL PDO
PostgreSQL

**no choice for "normal" MySQL (formerly MySQLi).

Chose MySQL PDO.

(Databse previously created before installation)

Entered credentials for the database.

Proceed from there initially gave some "database error" (not specific)
db_error.PNG
.

Finally proceeded but got PHP error:
PHP error wrote:Fatal error: session_start(): Failed to initialize storage module: user (path: /tmp) in /home/murraywe/public_html/test/libraries/vendor/joomla/session/src/Storage/NativeStorage.php on line 454
Tried PHP 7.2.2, tried PHP 7.1.14, tried PHP 7.0.27 as available on the host and changeable through cPanel.

Can't get past the error above.

FPA results for your info (may not help).
Forum Post Assistant (v1.3.9) : 6th March 2018 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 4.0.0-dev-Development (Amani) 19-November-2017
Joomla! Configured :: Yes | Writable (644) | Owner: --protected-- . (uid: 1/gid: 1) | Group: --protected-- (gid: 1) | Valid For: 4.0
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: Yes | GZip: false | Cache: 0 | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: 0 | Proxy: N/A | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: N/A | FrontEdit: N/A | Error Reporting: maximum | Site Debug: true | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysql | Database Credentials Present: Yes

Host Configuration :: OS: Linux | OS Version: 3.12.18-clouder0 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 469.01 GiB |

PHP Configuration :: Version: 7.0.27 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: 1 | Error Reporting: 30709 | Log Errors To: php_errorlog | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 128M | Max. POST Size: 128M | Max. Input Time: 120 | Max. Execution Time: 120 | Memory Limit: 768M

MySQL Configuration :: Connection Error: : Database Credentials Present? in Configuration...
Detailed Environment :: wrote:PHP Extensions :: Core (7.0.27) | date (7.0.27) | libxml (7.0.27) | openssl (7.0.27) | pcre (7.0.27) | sqlite3 (7.0.27) | zlib (7.0.27) | bcmath (7.0.27) | bz2 (7.0.27) | calendar (7.0.27) | ctype (7.0.27) | curl (7.0.27) | dba (7.0.27) | dom (20031129) | enchant (7.0.27) | hash (1.0) | fileinfo (1.0.5) | filter (7.0.27) | ftp (7.0.27) | gd (7.0.27) | gettext (7.0.27) | SPL (7.0.27) | iconv (7.0.27) | session (7.0.27) | intl (1.1.0) | json (1.4.0) | ldap (7.0.27) | mbstring (7.0.27) | mcrypt (7.0.27) | standard (7.0.27) | mysqli (7.0.27) | pcntl (7.0.27) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $) | PDO (7.0.27) | pdo_mysql (7.0.27) | pdo_pgsql (7.0.27) | pdo_sqlite (7.0.27) | pgsql (7.0.27) | Phar (2.0.2) | posix (7.0.27) | pspell (7.0.27) | readline (7.0.27) | Reflection (7.0.27) | imap (7.0.27) | shmop (7.0.27) | SimpleXML (7.0.27) | soap (7.0.27) | sockets (7.0.27) | exif (7.0.27) | sysvmsg (7.0.27) | sysvsem (7.0.27) | tidy (7.0.27) | tokenizer (7.0.27) | wddx (7.0.27) | xml (7.0.27) | xmlreader (7.0.27) | xmlrpc (7.0.27) | xmlwriter (7.0.27) | xsl (7.0.27) | zip (1.13.5) | cgi-fcgi () | memcached (2.2.0) | ionCube Loader () | Zend OPcache (7.0.27) | Zend Engine (3.0.0) |
Potential Missing Extensions :: mysql | suhosin |

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (---) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) |

Elevated Permissions (First 10) ::
Extensions Discovered :: wrote:Components :: SITE :: com_wrapper (3.0.0) | com_mailto (3.0.0) |
Components :: ADMIN :: com_login (3.0.0) | com_messages (3.0.0) | com_cpanel (3.0.0) | com_cache (3.0.0) | com_tags (3.1.0) | com_templates (3.0.0) | com_banners (3.0.0) | com_joomlaupdate (3.6.2) | com_menus (3.0.0) | com_content (3.0.0) | com_redirect (3.0.0) | com_installer (3.0.0) | com_admin (3.0.0) | com_users (3.0.0) | com_categories (3.0.0) | com_checkin (3.0.0) | com_associations (3.7.0) | com_media (3.0.0) | com_languages (3.0.0) | com_ajax (3.2.0) | com_plugins (3.0.0) | com_modules (3.0.0) | com_search (3.0.0) | com_finder (3.0.0) | com_fields (3.7.0) | com_contenthistory (3.2.0) | com_config (3.0.0) | com_newsfeeds (3.0.0) | com_postinstall (3.2.0) |

Modules :: SITE :: mod_custom (3.0.0) | mod_whosonline (3.0.0) | mod_articles_news (3.0.0) | mod_breadcrumbs (3.0.0) | mod_articles_category (3.0.0) | mod_articles_archive (3.0.0) | mod_stats (3.0.0) | mod_articles_latest (3.0.0) | mod_tags_popular (3.1.0) | mod_menu (3.0.0) | mod_syndicate (3.0.0) | mod_wrapper (3.0.0) | mod_banners (3.0.0) | mod_login (3.0.0) | mod_tags_similar (3.1.0) | mod_finder (3.0.0) | mod_footer (3.0.0) | mod_articles_popular (3.0.0) | mod_random_image (3.0.0) | mod_users_latest (3.0.0) | mod_related_items (3.0.0) | mod_languages (3.5.0) | mod_feed (3.0.0) | mod_articles_categories (3.0.0) | mod_search (3.0.0) |
Modules :: ADMIN :: mod_custom (3.0.0) | mod_version (3.0.0) | mod_popular (3.0.0) | mod_logged (3.0.0) | mod_menu (3.0.0) | mod_title (3.0.0) | mod_login (3.0.0) | mod_toolbar (3.0.0) | mod_sampledata (3.8.0) | mod_status (3.0.0) | mod_stats_admin (3.0.0) | mod_feed (3.0.0) | mod_latest (3.0.0) | mod_quickicon (3.0.0) | mod_multilangstatus (3.0.0) |

Plugins :: SITE :: plg_search_categories (3.0.0) | plg_search_tags (3.0.0) | plg_search_newsfeeds (3.0.0) | plg_search_content (3.0.0) | plg_search_contacts (3.0.0) | plg_fields_integer (3.7.0) | plg_fields_textarea (3.7.0) | plg_fields_imagelist (3.7.0) | plg_fields_text (3.7.0) | plg_fields_usergrouplist (3.7.0) | plg_fields_editor (3.7.0) | plg_fields_url (3.7.0) | plg_fields_media (3.7.0) | plg_fields_calendar (3.7.0) | plg_fields_sql (3.7.0) | plg_fields_user (3.7.0) | plg_fields_list (3.7.0) | plg_fields_color (3.7.0) | plg_fields_radio (3.7.0) | plg_fields_checkboxes (3.7.0) | plg_system_cache (3.0.0) | plg_system_sef (3.0.0) | plg_system_fields (3.7.0) | plg_system_stats (3.5.0) | plg_system_debug (3.0.0) | plg_system_logout (3.0.0) | plg_system_languagecode (3.0.0) | plg_system_highlight (3.0.0) | plg_system_log (3.0.0) | plg_system_languagefilter (3.0.0) | plg_system_remember (3.0.0) | plg_system_redirect (3.0.0) | plg_system_httpheader (4.0.0) | plg_system_updatenotification (3.5.0) | plg_authentication_gmail (3.0.0) | plg_authentication_cookie (3.0.0) | plg_authentication_ldap (3.0.0) | plg_authentication_joomla (3.0.0) | plg_editors_codemirror (5.35.0) | plg_editors_tinymce (4.7.7) | plg_extension_joomla (3.0.0) | plg_extension_namespacemap (4.0.0) | plg_captcha_recaptcha (3.4.0) | plg_media-action_resize (4.0.0) | plg_media-action_rotate (4.0.0) | plg_media-action_crop (4.0.0) | plg_editors-xtd_fields (3.7.0) | plg_editors-xtd_image (3.0.0) | plg_editors-xtd_menu (3.7.0) | plg_editors-xtd_module (3.5.0) | plg_editors-xtd_readmore (3.0.0) | plg_editors-xtd_pagebreak (3.0.0) | plg_editors-xtd_article (3.0.0) | plg_installer_packageinstaller (3.6.0) | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) | PLG_INSTALLER_URLINSTALLER (3.6.0) | plg_installer_webinstaller (1.1.1) | plg_user_contactcreator (3.0.0) | plg_user_joomla (3.0.0) | plg_user_profile (3.0.0) | plg_finder_categories (3.0.0) | plg_finder_tags (3.0.0) | plg_finder_newsfeeds (3.0.0) | plg_finder_content (3.0.0) | plg_finder_contacts (3.0.0) | plg_quickicon_phpversioncheck (3.7.0) | plg_quickicon_extensionupdate (3.0.0) | plg_quickicon_joomlaupdate (3.0.0) | plg_twofactorauth_totp (3.2.0) | plg_twofactorauth_yubikey (3.2.0) | plg_filesystem_local (4.0.0) | plg_behaviour_taggable (4.0.0.) | plg_behaviour_versionable (4.0.0.) | plg_content_vote (3.0.0) | plg_content_fields (3.7.0) | plg_content_pagenavigation (3.0.0) | plg_content_joomla (3.0.0) | plg_content_loadmodule (3.0.0) | plg_content_finder (3.0.0) | plg_content_pagebreak (3.0.0) | plg_content_emailcloak (3.0.0) |
Templates Discovered :: wrote:Templates :: SITE :: cassiopeia (1.0) |
Templates :: ADMIN :: atum (1.0) |
Appears the installation gets half way then bombs out. The FPA seems to report the required PHP extensions for MySqL PDO and MySqLi are both present.

There's no installation log file I can find at this point. I did find a phplog file but only repeats 4 x the error stated above.
You do not have the required permissions to view the files attached to this post.
Regards - A Murray
General Support Moderator

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 9634
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by AMurray » Tue Mar 06, 2018 9:54 am

Finally tried PostgreSQL but same trouble

- would not proceed to end of installation stuck at the rotating joomla logo
- ended up with the database error:
pg_DB_error.PNG
You do not have the required permissions to view the files attached to this post.
Regards - A Murray
General Support Moderator

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 9634
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by AMurray » Tue Mar 06, 2018 10:20 am

Thanks all for the advice, I will leave it for the time being. I can get J4.0 working on my PC under WAMPServer PHP 7.2.2 MySQL 5.7.19 Apache 2.4.27, so something is obviously wrong at my host (SiteGround). Maybe they not are set up for J4.0 (regardless of dev or stable).

But it is strange it will work in one and not the other.
Regards - A Murray
General Support Moderator

deleted user

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by deleted user » Tue Mar 06, 2018 1:32 pm

*sigh* Since I've very clearly been ignored, and since there is very clearly misinformation going around...

- The lack of a MySQLi option on some platforms is a known issue as seen in https://issues.joomla.org/tracker/joomla-cms/18660, which will eventually be fixed (most likely whenever my schedule can accommodate the time required for it since the issue and a potential fix have been posted for 4 months and the only responses since then are "it's still broken")

- "MySQLi" is not renamed. It never will be. MySQLi is the name of the underlying PHP extension used by that option, `ext/mysqli`.

- There is no "plain" MySQL option anymore. The driver that corresponded to in Joomla 3 and PHP 5 combinations is not supported on PHP 7.

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20652
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by leolam » Tue Mar 06, 2018 2:50 pm

With all respect for all contributions but we do not have a Joomla 4.x forum yet so this issue does not belong here and is confusing for a lot of users probably. I do suggest with respect that this topic is closed and that further discussions on this issue are being directed to the Issue at https://issues.joomla.org/tracker/joomla-cms/18660 as correctly referred to by Michael. It simply does not belong here

@Mods: Kindly suggest to lock this thread

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -

sozzled
I've been banned!
Posts: 13639
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by sozzled » Tue Mar 06, 2018 3:08 pm

leolam wrote:... we do not have a Joomla 4.x forum yet ...
and, like @mbabker who's been ignored, see viewtopic.php?f=7&t=952483 which I posted here about 9 months ago. :(

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20652
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by leolam » Tue Mar 06, 2018 3:13 pm

sozzled wrote:
leolam wrote:... we do not have a Joomla 4.x forum yet ...
and, like @mbabker who's been ignored, see viewtopic.php?f=7&t=952483 which I posted here about 9 months ago. :(
I do disagree with opening a Joomla 4 forum since Joomla 4.0 is in a development stage and any discussions or issues belong on the Tracker and not on a forum. (a reply though "we do not open a forum yet" could have been appropriate by the global mods I do agree)

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -

sozzled
I've been banned!
Posts: 13639
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Joomla 4 - setup doesn't have MySQLi as database type option

Post by sozzled » Tue Mar 06, 2018 3:30 pm

@Leo: There have been other "in development" forum categories here. What's so special about J! 4? I agree with you that having "under development" discussions sitting alongside "stable release" topics makes things confusing; it will become more confusing when (in 6-9 months' time) J! 4 is released as stable.

But, returning to the discussion topic, I was confused and worried when I read Brian's "explanation". From the looks of things, Michael has put this matter to rest for present and I'm not so confused. Lastly, Andy may just have to hold fire, unable to test J! 4 on his setup, until things settle down a bit.


Locked

Return to “Joomla! 4 Related”