Error connecting DB
Mark
via web
Can't figure out how to fix this, new install. I know the db works with the host/uid/pwd as I can access it remotely through Navicat for MySQL. Quadruple checked the define.php file and made sure it's uploaded in the proper location. Ioncube is correctly installed and tested.
This is installed on Windows Server 2003 with PHP 5.
Comments are currently closed for this discussion. You can start a new one.
Support Staff 2 Posted by Rob Chuah (InstantSifu) on 20 Jul, 2010 01:29 PM
Is your db username/password configured correctly ? That is the only reason you'll be getting this message.
3 Posted by Mark on 23 Jul, 2010 07:32 AM
No go. Won't work either on IIS6 nor on Apache Linux servers. Created new db's with simple uid and pwd (isu and 1234 respectively). Checked define.php and uploaded repeatedly. Checked permissions. Tried either localhost or IP address of server for db_host. Rebooted servers. I have another linux expert looking into this.
Support Staff 4 Posted by Rob Chuah (InstantSifu) on 23 Jul, 2010 09:21 AM
Could you grant me access to the mysql and FTP so that we can take a look ?
thanks
Rob
5 Posted by Mark Leder on 01 Aug, 2010 02:44 AM
Rob,
Sorry for the delay. We'll work on the instance set up on IIS6.
Here's the info:
MySQL - tested again and it does connect remotely using Navicat for MySQL:
IP/Host: 74.219.154.203 (on define.php, it's localhost)
Port: 3306
UID = isu
PWD = LjbGOm2
FTP:
IP: 74.219.154.203
UID: _isutemp
PWD: 1234
Let me know what else you need.
Mark
-----Original Message-----
From: Rob Chuah (InstantSifu) [mailto:***@tenderapp.com]
Sent: Friday, July 23, 2010 5:23 AM
To: ***@markleder.com
Subject: Re: Error connecting DB [InstantSlideUp]
Support Staff 6 Posted by Rob Chuah (InstantSifu) on 03 Aug, 2010 12:51 PM
Hi Mark,
How do I access the ISU folder ?
http://74.219.154.203/isu/ ?
thanks
Rob
7 Posted by Mark Leder on 03 Aug, 2010 01:03 PM
URL: http://admin.evokenet.com/instantslideup
Should be through FTP:
IP: 74.219.154.203
UID: _isutemp
PWD: 1234
Just checked again to make sure it works.
Mark
-----Original Message-----
From: Rob Chuah [mailto:tender+df81f6d4ba1f566bc3b8ef08f0dcc463710a298b0=***@sendgrid.me] On Behalf Of Rob Chuah (InstantSifu)
Sent: Tuesday, August 03, 2010 8:53 AM
To: ***@markleder.com
Subject: Re: Error connecting DB [InstantSlideUp]
Support Staff 8 Posted by Rob Chuah (InstantSifu) on 03 Aug, 2010 11:56 PM
Hi mark,
For some reason there were 2 error in your define.php file
define('DB_HOST', 'localhost');
It should be localhost instead of an IP address which you have put there
define('DB_USER', 'isu');
In the define.ph, the user was defined as isu, and then with a lot of white space.
It is working now
http://admin.evokenet.com/instantslideup/
please install it by running the installation first at http://admin.evokenet.com/instantslideup/index.php?page=install
thanks
Rob
Rob Chuah (InstantSifu) closed this discussion on 03 Aug, 2010 11:56 PM.
Mark Leder re-opened this discussion on 04 Aug, 2010 12:19 AM
9 Posted by Mark Leder on 04 Aug, 2010 12:19 AM
Take a look at this screenshot error. Looks like in MySQL. Let me know what table and I'll fix.
Mark
-----Original Message-----
From: Rob Chuah [mailto:tender+df81f6d4ba1f566bc3b8ef08f0dcc463710a298b0=***@sendgrid.me] On Behalf Of Rob Chuah (InstantSifu)
Sent: Tuesday, August 03, 2010 7:59 PM
To: ***@markleder.com
Subject: Re: Error connecting DB [InstantSlideUp]
10 Posted by Mark Leder on 04 Aug, 2010 12:19 AM
Hmm,
wonder how that white space got there. I usually cut and paste from a flat file.
Yeah, with the db_host, I was playing with both the IP and localhost.
But, thanks again for your help. I'll let you know how it goes.
Thanks!
Mark
-----Original Message-----
From: Rob Chuah [mailto:tender+df81f6d4ba1f566bc3b8ef08f0dcc463710a298b0=***@sendgrid.me] On Behalf Of Rob Chuah (InstantSifu)
Sent: Tuesday, August 03, 2010 7:59 PM
To: ***@markleder.com
Subject: Re: Error connecting DB [InstantSlideUp]
Support Staff 11 Posted by Rob Chuah (InstantSifu) on 04 Aug, 2010 05:35 AM
Hi Mark,
I cant see any screenshot attached. Do you still have any problem ? Let me know
thanks
Rob
12 Posted by Mark Leder on 04 Aug, 2010 12:02 PM
Error message on the installation scree:
BLOB/TEXT column 'option_value' can't have a default value
Mark
-----Original Message-----
From: Rob Chuah [mailto:tender+df81f6d4ba1f566bc3b8ef08f0dcc463710a298b0=***@sendgrid.me] On Behalf Of Rob Chuah (InstantSifu)
Sent: Wednesday, August 04, 2010 1:37 AM
To: ***@markleder.com
Subject: Re: Error connecting DB [InstantSlideUp]
Support Staff 13 Posted by Rob Chuah (InstantSifu) on 04 Aug, 2010 03:18 PM
HI Mark,
This is due to windows MySQL bug. I've changed the db file abit. Can you try clean up the DB and try again ?
I've attached the db.php file where you'll need to upload it to the app/trusted folder. I've helped you to uploaded it though
thanks
Rob
Rob Chuah (InstantSifu) closed this discussion on 04 Aug, 2010 03:18 PM.
Mark Leder re-opened this discussion on 04 Aug, 2010 04:49 PM
14 Posted by Mark Leder on 04 Aug, 2010 04:49 PM
That worked, I'm in.
Thanks for your help.
Mark
-----Original Message-----
From: Rob Chuah [mailto:tender+df81f6d4ba1f566bc3b8ef08f0dcc463710a298b0=***@sendgrid.me] On Behalf Of Rob Chuah (InstantSifu)
Sent: Wednesday, August 04, 2010 11:21 AM
To: ***@markleder.com
Subject: Re: Error connecting DB [InstantSlideUp]
Rob Chuah (InstantSifu) closed this discussion on 04 Aug, 2010 10:34 PM.