Return of "Test failed (unable to verify MySQL)"

[Harold Wiebe]

I am currently trying to install ResourceSpace 6.0 on a Linux CentOS 6.5 system.  After a bit of juggling, I have the setup.php routine giving me OK on all the Installation Check items, but it then tells me "Test failed (unable to verify MySQL)".  I have tried various arrangements of databases on the MySQL server on this system, all to no avail.  I noticed that this question has been asked a couple of times previously, but the responses don't seem to work for my situation.

 

The following questions occur to me:

 

1.  I notice that in the "Database configuration" section the MySQL Username is set to root and the password is blank.  Does this mean that the setup script expects to find the MySQL server's root username with no password?

 

2.  The MySQL database is set to  resourcespace -- is this the correct name for the empty database the install instructions say to create?

 

3.  The MySQL binary path is set to  /usr/bin , which is where the mysql client is located  (in other words, /usr/bin/mysql -u root  will get the MySQL client started as the root user).  Is this what the script expects, or is something missing or incorrect?

 

Thanks in advance,

 

H. D. Wiebe

[Alan Pater]

Harold, I am trying to solve the same issue myself, in my case on Ubuntu 14.04 ..

To answer your questions:

1) It is waiting for us to enter the mysql root password, but the "Test failed (unable to verify MySQL)" popup prevents us from doing that. On other installations I have done, those fields turn green once you have entered the correct password.

2) Yes, resourcespace is the correct name for the default DB.

3) Yes, /usr/bin is correct.

That said, I don't have a solution (yet). On this system I already have other mysql DB's, might that be messing things up?

[T Williams]

I have had this happen before as well, I could log into and run queries in mySQL, add and drop tables and databases, everything acted normal, except Resourcespace seeing mySQL. While this may sound like the Dell Technical Support helpline, have you tried bouncing the box or restarting the VM ? I know it sounds crazy but it has worked for me. I'll take lucky over smart when it works. 

TW

[Alan Pater]

Thanks T, but restarting the VM did not work for me.

[Tom Gleason]

in your Developer Tools, (in Chrome it's the Network tab) see what the response is from dbtest.php

--
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/groups/opt_out.

--
Tom Gleason

Colorhythm LLC
http://www.colorhythm.com

Main Office:  +1 415-399-9921
Fax: +1 415-399-9928
Mobile:  +1 347-537-8465

tgle...@colorhythm.com

[Tom Gleason]

I'm guessing setup.php needs to be ported to use mysqli. The rest of the system has been already.

[Alan Pater]

Well that's embarrassing. In my case, it seems I forgot to install the php5-mysql package. Once that was installed, setup could complete.

On Wednesday, December 11, 2013 3:35:37 PM UTC-5, Harold Wiebe wrote:

[Jeff Nova]

That's a good lesson for us, too, so we can remember to ask to check that in the future when similar problems arise. Glad it worked out!

Jeff

--

Jeff Nova

Chief Executive Officer

Colorhythm LLC

http://www.colorhythm.com

Main Office:  +1 415-399-9921

Fax: +1 415-399-9928

Mobile:  +1 510-710-9590

jn...@colorhythm.com

--

[bigmo]

Good afternoon Tom --

So in this case, is there a workaround for this beside waiting on setup.php to be ported to use mysqli. Is there anything else i can do to finish the installation process? Even changing the parameters manually using nano and entering everything manually in config.php I still can't get through. It just throw an error saying the "Connection refused" even though I can easily connect to the MySQL db using a terminal command...

Many Thanks for your assistance!

Cheers,

Mo.

To unsubscribe from this group and stop receiving emails from it, send an email to resour...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
Tom Gleason

Colorhythm LLC
http://www.colorhythm.com

Main Office:  +1 415-399-9921
Fax: +1 415-399-9928
Mobile:  +1 347-537-8465

tgle...@colorhythm.com

[Dan Huby]

Hi Mo,

That post was 6 years old and setup.php has been using mysqli for some time. Your connection issue probably isn't related to this unless you're running a very old version of the software.

If you're running Ubuntu 19.10 see the important step here: https://www.resourcespace.com/knowledge-base/systemadmin/install_ubuntu

Dan

[bigmo]

Good morning Dan --

I'm actually running this on a macOS 10.11.X box and yes, even after I followed the Ubuntu important step, I'm still stuck at the same stage. It just doesn't like the info for "MySQL server" field no mater what I put in. i.e. localhost or localhost:3086 or 127.0.0.1 or 127.0.0.1:3086... still no go I can sign int the MySQL server as root and create the resourcespace user account and set the password without any issues... Is there something else I'm missing?

Many Thanks,

Mo.

[benjinet]

Same issue on a clean install of RS onto a clean OSX Catalina install.

Blank startup screen after all the install fields are go. Mysql workbench is all good in testing.

sad clown.

[benjinet]

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /Library/WebServer/Documents/resourcespace/pages/setup.php on line 576

Warning: mysqli_errno() expects parameter 1 to be mysqli, bool given in /Library/WebServer/Documents/resourcespace/pages/setup.php on line 579

Warning: mysqli_get_server_info() expects parameter 1 to be mysqli, bool given in /Library/WebServer/Documents/resourcespace/pages/setup.php on line 591

Fatal error: Uncaught Error: Call to undefined function check_password() in /Library/WebServer/Documents/resourcespace/pages/setup.php:708 Stack trace: #0 {main} thrown in /Library/WebServer/Documents/resourcespace/pages/setup.php on line 708

[Dan Huby]

Are you installing the realease, or trunk? 

--

ResourceSpace: Open Source Digital Asset Management

http://www.resourcespace.com
---
You received this message because you are subscribed to a topic in the Google Groups "ResourceSpace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/resourcespace/ZlTbmwRKduI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to resourcespac...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/resourcespace/9f813a3a-846f-415d-8dec-f593ae4a89ef%40googlegroups.com.