Jump to content

Your database connection settings are not valid ?

Are
 Share

Recommended Posts

Are Newbie

Are

Posted
Posted

Hello, i have used oscommerce for many online shops but prestashop got my intention and for many reasons i decided to give it a try.

 

Everything went smooth until stuck at Database configuration where i tried every combination i could think off.

 

im running several other mysql databases and all is well.

I have set up a prestashop and i can use it from mysql promt as well as phpmyadmin.

 

I cant se any errors in logfiles and need help to get past this.

Your database connection settings are not valid. Please check your server, name, login and prefix.

 

Please help me debug this.

 

Tia

/are

Link to comment
Share on other sites
maconl Newbie

maconl

Posted
Posted

hi, Are

here the same , after years being using and building OSC shops

decided to try prestashop ,

 

i'm still busy with building , but sofar it suits me great

 

but ok back to your problem

 

perhaps a little typo ?

 

just doubble check database name database user , database password

 

Database servername = yourdatabase_name

Database Name = yourdatabase_name

database engine = innoDB

login = root

 

before you go on and to check ,

you can press the button " Verify Now "

you see straight away if prestashop connects the database

Link to comment
Share on other sites
maconl Newbie

maconl

Posted
Posted

Hi Carl ,

he is using prestashop 1.4.6.2

 

about the database this is really the quiestion ,

i created an database named presta 3 and this db had exact the same settings as what i used before with my old db

but still no succes

 

will sent are an email so he can reply here and perhaps he can give you acces to have a look in his Db

tried so many things ,,i couldn't figure it out anymore what the problem could be

hopefully you got more succes , i'm really curious about this problem

Link to comment
Share on other sites
  • 1 month later...
  • 5 months later...
coverup Newbie

coverup

Posted
Posted (edited)

I found a solution!, i'm not sure if my solution will work for you.

But, to get an idea i will share my story (also posted on bug tracker)

 

--------------------------------------------------------------

 

 

..I have the same problem with 1.4.8.3

This error is very strange

I can install using IIS and MySQL without problems, then when i move to a unix sistem using Apache & MySQL this error show up.

All the server is updated using the lastest version of everything, fresh install from zero.

Everything well configured.

I also install phpyAdmin for MySQL administration without problems (this is the first proof of a well configured server)

Then i tried to install prestashop, just like before..

ALL the step 2 is on Green status

but then, on step 3 the following message appear:

"Your database connection settings are not valid. Please check your server, name, login and prefix."

Of course, all the parameter are ok. including proper CHMOD (I also test 777 on all the site and subdirectories) and user proviledges on system and DB.

 

I also make a little PHP script, to test my DB data.

 

<?php

$enlace = mysql_connect('localhost', 'myadminuser', 'myadminpass');

if (!$enlace) { die('No pudo conectarse: ' . mysql_error()); /* Can't connect */ }

echo 'Conectado satisfactoriamente'; /* connected satisfactory */

mysql_close($enlace);

?>

 

And work!!!

 

But the prestashop install, don't. :(

 

I also edit the classes/mysql.php archive to bypass the form variables and hard code the db info

doing this i solve momentarily the error message but of course the table creation don't work, so i still stuck on step 3.

 

----------------------------------------------------

 

By the way, if you search on google you will find a lot of people with this issue, and no solution.

install log and php logs don't show nothing bad.

 

Prestashop

Version 1.4.8.3

installed on var/www/ default root directory

 

MySQL

Server: Localhost via UNIX socket

Server version: 5.5.24

Protocol Version: 10

Usuario: myadminuser@localhost

character type MySQL: UTF-8 Unicode (utf8)

 

Web server

Apache/2.2.22

Client version: 5.5.24

PHP extension: mysqli

 

PHP

Version 5.3.14

 

Server installation info (YUM)

php-mysql php php-xml php-mcrypt php-mbstring php-cli mysql httpd

--------------------------------------------------------------------

 

Well, this is one of these situations in which you solve the problem, without knowing what was wrong exactly.

I don't like to unknow the real problem, but the important thing is that i solve it.

now the important thing.. how?

 

[yum upgrade]

 

So pick one of these options below, as a possible solution to this problem.

 

Installed:

jpackage-utils.x86_64 0:1.7.5-15.16.amzn1 perl-IO-Compress.noarch 0:2.037-2.3.amzn1

 

Dependency Installed:

dhcp-common.x86_64 12:4.1.1-31.P1.17.amzn1 libgcrypt.i686 0:1.4.5-9.10.amzn1 li

libnfnetlink.i686 0:1.0.0-1.2.amzn1 nss-tools.x86_64 0:3.13.5-1.26.amzn1 pe

perl-Encode-Locale.noarch 0:1.02-3.1.amzn1 perl-File-Listing.noarch 0:6.02-3.2.amzn1 pe

perl-HTTP-Daemon.noarch 0:6.00-3.2.amzn1 perl-HTTP-Date.noarch 0:6.00-2.1.amzn1 pe

perl-HTTP-Negotiate.noarch 0:6.00-3.3.amzn1 perl-LWP-MediaTypes.noarch 0:6.01-3.3.amzn1 pe

perl-Mozilla-CA.noarch 0:20110914-2.2.amzn1 perl-Net-HTTP.noarch 0:6.02-1.2.amzn1 pe

perl-WWW-RobotRules.noarch 0:6.01-3.2.amzn1 setools-libs-tcl.x86_64 0:3.3.7-19.14.amzn1

Updated:

acl.x86_64 0:2.2.49-6.9.amzn1 alsa-lib.x86_64 0:1.0.22-3.9.amzn1

audit.x86_64 0:2.1.3-3.16.amzn1 audit-libs.i686 0:2.1.3-3.16.amzn1

aws-amitools-ec2.noarch 0:1.4.0.7-1.4.amzn1 aws-apitools-as.noarch 0:1.0.61.0-1.5.amzn1

aws-apitools-ec2.noarch 0:1.6.1.0-1.0.amzn1 aws-apitools-elb.noarch 0:1.0.17.0-1.4.amzn1

aws-apitools-mon.noarch 0:1.0.12.1-1.7.amzn1 aws-apitools-rds.noarch 0:1.8.002-1.2.amzn1

bash.x86_64 0:4.1.2-9.15.amzn1 bind-libs.x86_64 32:9.8.2-0.10.rc1.23.amzn1

binutils.x86_64 0:2.20.51.0.7-8.29.amzn1 checkpolicy.x86_64 0:2.1.6-2.7.amzn1

coreutils.x86_64 0:8.4-16.14.amzn1 coreutils-libs.x86_64 0:8.4-16.14.amzn1

cryptsetup-luks.x86_64 0:1.2.0-6.10.amzn1 cryptsetup-luks-libs.x86_64 0:1.2.0-6.10.amzn1

cyrus-sasl.x86_64 0:2.1.23-13.9.amzn1 cyrus-sasl-lib.x86_64 0:2.1.23-13.9.amzn1

cyrus-sasl-plain.x86_64 0:2.1.23-13.9.amzn1 dhclient.x86_64 12:4.1.1-31.P1.17.amzn1

dmraid.x86_64 0:1.0.0.rc16-10.7.amzn1 dmraid-events.x86_64 0:1.0.0.rc16-10.7.amzn1

dump.x86_64 1:0.4-0.6.b42.7.amzn1 e2fsprogs.x86_64 0:1.42-2.15.amzn1

ethtool.x86_64 2:3.1-1.10.amzn1 expat.x86_64 0:2.0.1-11.9.amzn1

file-libs.x86_64 0:5.07-6.11.amzn1 filesystem.x86_64 0:2.4.30-3.8.amzn1

fipscheck-lib.x86_64 0:1.2.0-7.10.amzn1 get_reference_source.noarch 0:1.2-0.4.amzn1

glibc.x86_64 0:2.12-1.80.40.amzn1 glibc-common.x86_64 0:2.12-1.80.40.amzn1

gpgme.x86_64 0:1.3.1-1.12.amzn1 gpm-libs.x86_64 0:1.20.6-12.8.amzn1

initscripts.x86_64 0:9.03.27-1.18.amzn1 iproute.x86_64 0:3.2.0-3.7.amzn1

iptables.i686 0:1.4.12-2.15.amzn1 iptables.x86_64 0:1.4.12-2.15.amzn1

keyutils-libs.i686 0:1.4-3.9.amzn1 keyutils-libs.x86_64 0:1.4-3.9.amzn1

krb5-libs.i686 0:1.9-33.22.amzn1 krb5-libs.x86_64 0:1.9-33.22.amzn1

ksh.x86_64 0:20100621-12.9.amzn1 less.x86_64 0:436-10.8.amzn1

libassuan.x86_64 0:2.0.3-1.0.amzn1 libattr.x86_64 0:2.4.44-7.9.amzn1

libcgroup.x86_64 0:0.37-3.3.amzn1 libcom_err.i686 0:1.42-2.15.amzn1

libcurl.x86_64 0:7.24.0-1.24.amzn1 libgcc.i686 0:4.4.6-3.45.amzn1

libgcrypt.x86_64 0:1.4.5-9.10.amzn1 libgpg-error.x86_64 0:1.10-1.9.amzn1

libnih.x86_64 0:1.0.1-7.5.amzn1 libselinux.i686 0:2.1.6-6.12.amzn1

libselinux-utils.x86_64 0:2.1.6-6.12.amzn1 libsemanage.x86_64 0:2.1.2-1.9.amzn1

libsepol.x86_64 0:2.1.3-2.11.amzn1 libss.x86_64 0:1.42-2.15.amzn1

libyaml.x86_64 0:0.1.4-1.3.amzn1 lsof.x86_64 0:4.82-2.9.amzn1

lvm2-libs.x86_64 0:2.02.86-6.17.amzn1 mailcap.noarch 0:2.1.31-2.7.amzn1

mingetty.x86_64 0:1.08-5.9.amzn1 net-tools.x86_64 0:1.60-109.8.amzn1

newt-python.x86_64 0:0.52.11-3.7.amzn1 nspr.x86_64 0:4.9.1-2.14.amzn1

nss-softokn.x86_64 0:3.12.9-11.13.amzn1 nss-softokn-freebl.i686 0:3.12.9-11.13.amzn1

nss-sysinit.x86_64 0:3.13.5-1.26.amzn1 nss-util.x86_64 0:3.13.5-1.13.amzn1

ntpdate.x86_64 0:4.2.4p8-2.16.amzn1 openldap.x86_64 0:2.4.23-26.15.amzn1

openssh-clients.x86_64 0:5.3p1-81.17.amzn1 openssh-server.x86_64 0:5.3p1-81.17.amzn1

pam.x86_64 0:1.1.1-10.15.amzn1 pam_ccreds.i686 0:10-3.8.amzn1

pam_krb5.i686 0:2.3.11-9.12.amzn1 pam_krb5.x86_64 0:2.3.11-9.12.amzn1

perl.x86_64 4:5.10.1-119.12.amzn1 perl-Compress-Raw-Zlib.x86_64 0:2.037-4.2.amzn1

perl-IO-Socket-SSL.noarch 0:1.49-1.6.amzn1 perl-Module-Pluggable.x86_64 1:3.90-119.12.amzn1

perl-Pod-Simple.x86_64 1:3.13-119.12.amzn1 perl-libs.x86_64

perl-version.x86_64 3:0.77-119.12.amzn1 php.x86_64 0:5.3.

php-common.x86_64 0:5.3.15-1.22.amzn1 php-gd.x86_64 0:5

php-mcrypt.x86_64 0:5.3.15-1.22.amzn1 php-mysql.x86_64

php-soap.x86_64 0:5.3.15-1.22.amzn1 php-xml.x86_64 0:

policycoreutils.x86_64 0:2.1.4-13.13.amzn1 procps.x86_64 0:3

python26-libs.x86_64 0:2.6.8-2.28.amzn1 rhino.noarch 0:1.

rsyslog.x86_64 0:5.8.10-2.17.amzn1 sed.x86_64 0:4.2.

selinux-policy-targeted.noarch 0:3.10.0-75.18.amzn1 setools.x86_64 0:

setools-libs.x86_64 0:3.3.7-19.14.amzn1 setup.noarch 0:2.

sudo.x86_64 0:1.7.4p5-12.14.amzn1 system-release.no

tcp_wrappers-libs.x86_64 0:7.6-57.8.amzn1 tcsh.x86_64 0:6.1

tzdata.noarch 0:2011l-4.13.amzn1 tzdata-java.noarc

wget.x86_64 0:1.12-4.7.amzn1 which.x86_64 0:2.

yum-plugin-fastestmirror.noarch 0:1.1.30-10.12.amzn1 yum-plugin-priori

yum-updatesd.noarch 1:0.9-10.10.amzn1 yum-utils.noarch

zlib.x86_64 0:1.2.3-27.9.amzn1

 

Replaced:

jpackage-utils.noarch 0:1.7.5-3.12.13.amzn1 perl-Compress-Zlib

perl-IO-Compress-Zlib.x86_64 0:2.020-119.11.amzn1 python-sqlite.x86_

 

Complete!

 

 

That is my "big story" have fun, and i hope that this solve the problem to you as well

 

Best regards

 

Fernando

 

PD: English is not my native language but i do my best,thx for understand.

Edited by coverup (see edit history)
Link to comment
Share on other sites
benjamin utterback Newbie

benjamin utterback

Posted
Posted

Thank you coverup for your story. I have found that the best hosting provider for PrestaShop is BlueHost, 99% of shops do not need a dedicated server. You can sign up for bluehost and have close to zero server issues ever. You can install PrestaShop with simple script in 30 seconds. It's really cool. Check it out at www.bluehost.com/prestashop

Link to comment
Share on other sites
  • 4 years later...
crestron_modules Newbie

crestron_modules

Posted
Posted

Well, I had the same issue that during Prestashop installation the database connection won't establish.

 

Believe it or not, I was using a complex password and as soon as I changed it to a normal password (caps and special char.) it works perfectly!!!

 

try to put a simple password for testing the then change it.

Link to comment
Share on other sites
  • 1 year later...
rakan34 Newbie

rakan34

Posted
Posted (edited)

If the same settings work on another jdbc based connection, then it's your firewalls or network settings. If your other system is not using identical methods to connect (by which I mean Bitbucket has a connection string, username, password etc, and your other system is using a different format like host, port, username, password, or something else), then can you show us the comparison you've made? What do they both look like?  DigitalOcean SiteGround iPage

Edited by rakan34 (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...