setup.php - Test Failed (unable to verify MySQL)

[Ryan Gates]

I am trying to install ResourceSpace from scratch on a Windows VM. I am currently following the documentation from the website: http://wiki.resourcespace.org/index.php/Installing_on_Windows_Server_2008_R2_64-bit

The issue I am having is that when I go to configure the initial settings for ResourceSpace it is setting me Test Failed (Unable to verify MySQL). I did a search in the group to see if any other answers exist but can't find a solution to the problem. Can someone help me on this issue?

[Noel Slevin]

The Windows install instructions aren't great to be honest. However, in relation to your MySQL issue, is MySQL installed on the same server, and if so, is the service started?

[Dan Huby]

Agreed on the Windows installation instructions and if someone wants to help update them I will gladly set up a wiki account for them.

It sounds like you might be missing the MySQL PHP extension. Is it enabled in your php.ini file?

[Ryan Gates]

Hey Guys,

I found the problem after many attempts that the problem was the version of windows I was using. Windows Server 2012 R2 no matter what I tried didn't work. But the second I followed all the steps the same on Just 2012 R1 then it worked perfectly. Looks like their is a problem with running it on 2012 R2.

[Allison M Stec]

Have you verified that the mysqi extension shows as loaded on a phpinfo page or via cli "phpinfo -i"?

The php error suggests that RS is trying to use mysql rather than mysqli still. The default config sets whether to use mysql or mysqli based on the existence of mysqli_connect.

Another possibility is that there is more than one version of mysql installed on the system and the wrong version's configuration settings are being edited or the wrong version's path is set in the RS config. phpinfo will help flush that out.

On 03/01/2016 04:19 PM, ResourcesForAll wrote:

I have the exact same problem. brand new install, following instructions and making changes because they wiki is horribly out of date.

phpmyadmin can see the mysql install fine. Thats how i made the database. But no matter what, the resourcespace setup program just keeps throwing errors. Its very annoying as well because i cant even type in a username or password because every character throws up a "cannot connect to mysql" entry. The log file, i get this:

[01-Mar-2016 21:07:07 GMT] PHP Fatal error:  Uncaught Error: Call to undefined function mysql_connect() in E:\ResourceSpace\pages\setup.php:512
Stack trace:
#0 {main}
  thrown in E:\ResourceSpace\pages\setup.php on line 512

I have enabled mysqli.dll in the php.ini and like i said, phpmyadmin has no problem loading the database and logging on, so i doubt its a php / mysql problem.

is there a list of extensions that need to be enabled in the php.ini file? The wiki has no such list but i have had to enable mbstring, mysqli, GD2 and ldap just to get to this point. Are there some other extensions that i should be enabling? other than that i am lost. Is there some other way to run the inital config besides the web wizard which seems to be failing?

Only difference i can see is that i am using maria db as opposed to mysql however its a drop in replacement so shouldnt cause an issue, or so i was told.

--
ResourceSpace: Open Source Digital Asset Management
http://www.resourcespace.org
---
You received this message because you are subscribed to the Google Groups "ResourceSpace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to resourcespac...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
--
ResourceSpace Developer
Reseller of Colorhythm's Prismpoint Portal DAM