In-Portal installation troubleshooting - In-Portal Web 2.0 Content Management System (CMS)

robpandy
Member

Joined: 23-May-2010
Location: United States
Posts: 30

Posted: 05/28/2010 11:18:38 AM

I read somewhere in the In-portal documentation, that I should
"ENSURE THAT php HAS BEEN COMPILED WITH SUPPORT FOR MySQL {Windows Set-up}"

How do I determine whether or not this has been done, & if it has not been done,
then HOW DO I GO ABOUT GETTING IT DONE . This sounds like a reasonable solution
to my INSTALLATION problem & I'd like to give it a try --- just don't know how.
Please help.
Regards & Thanks {robpandy}

Dmitry
Member

Joined: 29-Jan-2002
Location: United States
Posts: 1675

Posted: 05/28/2010 11:27:24 AM

Reply Quoted

Hi Robert,

I have reviewed your PHPINFO that you sent earlier and seems like you just need to Enable the MySQL extension.

Open php.ini and uncomment (remove leading ;) from php_mysql.dll line. That php.ini file can be found inside your PHp installation - just look around there. Here as some additional info how to find it:

http://www.php.net/manual/en/faq.installation.php#faq.installation.phpini

Let us know how it goes.

Cheers!

robpandy
Member

Joined: 23-May-2010
Location: United States
Posts: 30

Posted: 05/28/2010 3:58:17 PM

Reply Quoted

That fix {UNCOMENTING--php_mysql.dll} in php.ini was made even before my current prob;

What i'm now getting is the following error --->

{error 2003}--"Cant connect to Mysql server on localhost (113)

robPandy

alex
Member

Joined: 24-Jun-2009
Location: Latvia
Posts: 231

Posted: 05/29/2010 6:54:53 AM

Reply Quoted

MySQL support is build-in since PHP 4.4. No need to add more extensions to do that.

Maybe you don't have MySQL server running/installed at all. In that case please install/run it first.

Maybe you specify incorrect credentials in "db configuration" step.

robpandy
Member

Joined: 23-May-2010
Location: United States
Posts: 30

Posted: 05/30/2010 9:39:05 PM

Reply Quoted

I'm trying to install in-portal to work with my Apache server, you know ---
using that [ APACHE_MySQL_PHP ] package for WINDOWS from "WAMP" & continue to get

---> { CONNECTION ERROR : (2003) Can't connect to MySQL server on "localhost" }

After trying every suggested solution under the sun {all 2000+ of them] without
any success, i decided to GOOGLE the damn ERROR MSG #2003 just for the hell of it.
RESULT--->
Everyone in the MILKY WAY GALAXY & a few from the ANDROMEDA GALAXY are
experiencing the same prob.
Is there some kinda BUG/VIRUS involved, or is this some kinda sick 'CYBER_JOKE'
being played on all of us???
Needless to say, I'm stressed out, pissed-off & fed-up with all this. {Talk about
'USER UNFRIENDLY'}
Any NEW SUGGESTIONS out there ---- Please heeeelp!!!!!

Dmitry
Member

Joined: 29-Jan-2002
Location: United States
Posts: 1675

Posted: 06/01/2010 12:26:57 PM

Reply Quoted

robpandy wrote:

05/30/2010 9:39:05 PM

I'm trying to install in-portal to work with my Apache server, you know ---
using that [ APACHE_MySQL_PHP ] package for WINDOWS from "WAMP" & continue to get

---> { CONNECTION ERROR : (2003) Can't connect to MySQL server on "localhost" }

After trying every suggested solution under the sun {all 2000+ of them] without
any success, i decided to GOOGLE the damn ERROR MSG #2003 just for the hell of it.
RESULT--->
Everyone in the MILKY WAY GALAXY & a few from the ANDROMEDA GALAXY are
experiencing the same prob.
Is there some kinda BUG/VIRUS involved, or is this some kinda sick 'CYBER_JOKE'
being played on all of us???
Needless to say, I'm stressed out, pissed-off & fed-up with all this. {Talk about
'USER UNFRIENDLY'}
Any NEW SUGGESTIONS out there ---- Please heeeelp!!!!!

Hi Robert,

This seems to be the issue with your MySQL/Apache/PHP setup. Let's try getting it working first since In-Portal requires the environment to be functioning before you can install it.

Please create a simple PHP script in the root of your website with the following code:



<?php



$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');

if (!$link) {

    die('Not connected : ' . mysql_error());

}



// make foo the current db

$db_selected = mysql_select_db('foo', $link);

if (!$db_selected) {

    die ('Can\'t use foo : ' . mysql_error());

}

?>

Make sure to replace 'mysql_user', 'mysql_password' and 'foo' with MySQL username, password and database name.

Try running it in your browser.

If you are getting "Not connected : ...". Please post the error here.

Thanks.

robpandy
Member

Joined: 23-May-2010
Location: United States
Posts: 30

Posted: 06/02/2010 8:14:52 PM

Reply Quoted

DMITRY,
I have 2 questions re your proposed solution:

(1) What exactly do you mean by "root of your website"
the APACHE'S 'DOCUMENT ROOT' containing webpages?
or the actual folder containing APACHE software?
or none of the above?

(2)Does the 2nd reference to POO {line #9} also gets changed to my DB name?

Dmitry
Member

Joined: 29-Jan-2002
Location: United States
Posts: 1675

Posted: 06/04/2010 11:50:21 AM

Reply Quoted

robpandy wrote:	06/02/2010 8:14:52 PM
DMITRY, I have 2 questions re your proposed solution: (1) What exactly do you mean by "root of your website" the APACHE'S 'DOCUMENT ROOT' containing webpages? or the actual folder containing APACHE software? or none of the above? (2)Does the 2nd reference to POO {line #9} also gets changed to my DB name?

Hi Robert,

1. Yes, that's correct

2. Yes, that's correct (it's not POO, it's 'foo' what you change to your DB name).

Thanks.

robpandy
Member

Joined: 23-May-2010
Location: United States
Posts: 30

Posted: 06/08/2010 7:32:07 PM

Reply Quoted

Dmitii,
I ran the suggested php file in IE browser & received this error --->>

PARSE ERROR :
syntax error unexpected T_CONSTANT_ESCAPED
in C:\easyphp\www\iptest.php on line 5

NOTE ---> ** easyphp\www is my DOCROOT

** iptest.php is the php file with the info you recomended

robpandy
Member

Joined: 23-May-2010
Location: United States
Posts: 30

Posted: 06/08/2010 9:03:47 PM

Reply Quoted

Dmitri,
I did a little tweaking & got a little further with the IN-PORTAL Config.

I used 'root' as userame & left the password blank --- all this
as opposed to my actual username or password.

With this i was able to reach as far as STEP #8 in the IN-PORTAL Config
but here I get the foll error msg:

"WEBPAGE CANNOT BE DISPLAYED HTTP 500

In-Portal Forum

In-Portal installation troubleshooting (13)