+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.3 and Below (https://userspice.com/forums/forumdisplay.php?fid=26)
+--- Thread: Database connection unsuccessful (/showthread.php?tid=157)
Database connection unsuccessful - raven - 03-01-2017
sudo apt-get install git
then git clone https://github.com/mudmin/UserSpice4.git
then sudo mv UserSpice4 /var/www/html
then navigate to your domain name/ip and add /UserSpice4/install/index.php
this i can do i assume you have a ssh connection to your serverhost
you may need sudo yum or what ever depending on your linux version for the install of git if it isnt already installed
Database connection unsuccessful - raven - 03-01-2017
using the native php installer included with userspice should work
Database connection unsuccessful - mudmin - 03-02-2017
You can do a manual install by overwriting your users/init.php with this file...
https://hastebin.com/focijevuga.xml
Then Edit it with your own db credentials at line 26. Then if you want to use recaptcha and change your copyright, you can do that there as well.
After that, go to install/install/includes/sql.sql and import that sql dump into your database.
Delete the entire install folder and you should be good to go. If you find any reason why it wasn't connecting on your server, I'm REALLY interested in knowing because I haven't seen that in a long time, but I have 2 people with similar issues.
Database connection unsuccessful - cjm1000 - 03-03-2017
I did as you instructed.
The database is created, but I now get this...
Warning: require_once(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /usr/www/virtual/tpost/www.ueproductions.com/datasnap/users/init.php on line 64
Warning: require_once(/www/virtual/tpost/www.ueproductions.com/datasnap/users/classes/Upload.php): failed to open stream: No such file or directory in /usr/www/virtual/tpost/www.ueproductions.com/datasnap/users/init.php on line 64
Warning: require_once(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /usr/www/virtual/tpost/www.ueproductions.com/datasnap/users/init.php on line 64
Fatal error: require_once(): Failed opening required '/www/virtual/tpost/www.ueproductions.com/datasnap/users/classes/Upload.php' (include_path='.:/usr/local/lib/php') in /usr/www/virtual/tpost/www.ueproductions.com/datasnap/users/init.php on line 64
http://www.ueproductions.com/datasnap/
Database connection unsuccessful - mudmin - 03-03-2017
Ok. Something is weird. TimeZone is being set on line 85 of the init.phpm not 64. See if your init.php looks like this or if you're missing a big chunk of it. Compare yours with the one I posted in the hastebin file above. If everything's good there...
Your server must be configured differently than pretty much any one I've come across. Here are some steps for you...
Open your server's php.ini and make sure there's not a semicolon (
php ti in front of the date.timezone. Code:
;date.timezone=Europe/BerlinGo ahead and set your timezone in there while you're at it. Here are a list of the php timezones-click on your area to displa them.
http://php.net/manual/en/timezones.php
You can also try putting this (with your timezone) at the top of the init.php on line 3.
ini_alter('date.timezone','Asia/Calcutta');
Database connection unsuccessful - cjm1000 - 03-04-2017
Sorry about that. The time zone thing was a server wide issue probably caused by my host trying to get this script to work. That is fixed...However... i did still get this..
Fatal error: require_once(): Failed opening required '/www/virtual/tpost/www.ueproductions.com/datasnap/users/classes/Upload.php' (include_path='.:/usr/local/lib/php') in /usr/www/virtual/tpost/www.ueproductions.com/datasnap/users/init.php on line 64
Not sure if that file is important, or what it does, but I removed the line from init.php and now just get this...
SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
http://www.ueproductions.com/datasnap/
I tried running a few commands on mysql but nothing seem to remedy this situation. Any ideas?
Database connection unsuccessful - mudmin - 03-04-2017
What version of php are you running? If anything just put a php file in your root with the code
Code:
<?php phpinfo(); ?>We're using the current PDO in userspice so something doesn't seem right. OH and sorry about the upload class. That was for another one of my projects and shouldn't have been in the pastebin I sent you.
Database connection unsuccessful - cjm1000 - 03-04-2017
PHP Version 5.6.16
Database connection unsuccessful - raven - 03-05-2017
you have the proper addons for php and mysql installed this seems like a linux product
you should at minium have
sudo apt-get install php5-mcrypt php5-gd php5-mysql php5-common php5-cli php5-fpm
also do a sys update /upgrade
sudo apt-get update
sudo apt-get upgrade
then do an auto remove to remove unneeded kernels
audo apt-get autoremove
id also manually check that mysql is actually upto date
sudo apt-get install mysql-client mysql-server
note all the commands i list are for my versions of linux ubuntu server 14.04 and a debain 8 jessie w/ cinnamon installed to mirror commands from ubuntu
im starting to wonder if this is not a physical incompatibility with the system its self not interacting correctly
also what webserver is your host running apache2 or nginx in my exp nginx is the least forgiving. most all of your desktop server programs for windows emulates apache
failing all this we can always try connecting to a database that isnt provided by your host
and mudmin i think ive tracked down that issue to just being the difference in how the webprogram serves the data up the data because apache 2 native will run php once php is installed how ever it appears nginx has to be configured to run php naturally.
this is an older post but it should still be relivent http://askubuntu.com/questions/134666/what-is-the-easiest-way-to-enable-php-on-nginx
Database connection unsuccessful - mudmin - 03-05-2017
I think this is an issue that your hosting provider might need to work on. I've never seen this, but in the reading I've done, it looks like your password was set using an old method when it was created on your hosting providor's side and php/mysql doesn't like it. You basically need to reset your password.
Here is an article. It shows what to do if you do have access to your server and if you don't.
http://stackoverflow.com/questions/1575807/cannot-connect-to-mysql-4-1-using-old-authentication