Freshman
Posts: 33
Posted:
25.Jan 2006 - 15:36
I have upgraded my PHP from 4.3.10 to 4.3.11 and my mysql database from 3.2 to 4.1 and i am using PostNuke version 0.761. Now, I am having a problem with the installation of PostNuke
I have entered the details of the database and clicked on the New Installation button and then checked the "Create database" checkbox and clicked on Start button. Now, there is no indication about the database creation.
So I have checked the install.php. It is entering into the 'start' case
case "Start":
if(!isset($dbmake)) {
$dbmake = false;
}
make_db($dbhost, $dbuname, $dbpass, $dbname, $prefix, $dbtype, $dbmake, $dbtabletype);
print_start();
break;
And make_db function is called from newinstall.php page.
But in that function mysql_pconnect function is not working. I am not able to resolve this issue. So, please help me out in solving this
Thanks in advance.
Professional
Posts: 958
Posted:
25.Jan 2006 - 17:23
online
Steering Committee
Posts: 13427
Posted:
25.Jan 2006 - 23:46
--
Regards,
Simon
itbegins.co.uk - Zikula Consulting
Please read the Support Guide
Freshman
Posts: 33
Posted:
30.Jan 2006 - 10:24
So kindly suggest me in solving this issue.
Thanks.
online
Steering Committee
Posts: 13427
Posted:
30.Jan 2006 - 13:22
--
Regards,
Simon
itbegins.co.uk - Zikula Consulting
Please read the Support Guide
Freshman
Posts: 8
Posted:
31.Jan 2006 - 08:28
HammerHead
Recompile your PHP installation with MySQL support as outlined in the PHP Manual.
i received this error as well, so i d/led the apache 2.0.44 and PHP 4.4.2. configured and compiled both without errors, having the --with-mysql statements as well.
I even created the info.php page and viewed it fine.
I figured everything was golden after that.
When i went back to install.php of Post nuke, it still crapped out on same error.
What information do i really need on the input screen?
The documentation seems kinda indifferent. It lists things like this: "If you know the database username, put it in, otherwise leave it blank" I read up and understand persistant connections, and how this may actually work, but is that true for the host name and database name as well? if not, is there a way to tell what these variables are without calling my host company?
When I get to the page for user input[database host, database username,database password,database name,table prefix,database type, and database table type] I have tried these with the defaults. i have tried the host as 127.0.0.1 and my ip. I have tried putting in root and mysql for the username. I even put in my root p/w and root username. All of these came back to undefined function error.
Team Member
Posts: 3024
Posted:
31.Jan 2006 - 08:33
username is something like:
siteUserName_mySQLuserName
and DBname is something like:
siteUserName_mySQLdataBaseName
--
David Pahl
Zikula Support Team
Freshman
Posts: 8
Posted:
31.Jan 2006 - 08:39
Should I install that on my pc to get the info out of mysql?
Team Member
Posts: 3024
Posted:
31.Jan 2006 - 08:42
--
David Pahl
Zikula Support Team
Freshman
Posts: 8
Posted:
31.Jan 2006 - 08:53
the mysql server seemed to be an older version(3), but even that version has pnconnect() listed an a command.
ip is 70.86.222.106
domain is www.brotersofsmash.com
both of those with install.php will take you to PostNuke install script.
what other info are you refering to?
Team Member
Posts: 3024
Posted:
31.Jan 2006 - 09:13
--
David Pahl
Zikula Support Team
Freshman
Posts: 8
Posted:
31.Jan 2006 - 09:21
AmmoDump
mysql need to be at least 4.1.1 (I think, it may be higher)
Why do you say that?
I too thought it was an older version.
If i am too ask the hosting company to upgrade it, i would like to include the reasoning as well.
when i went to the mysql site, there was about 50 flavours of the current version to choose from based on what system you have, processors, and other variables, some of which i have no clue.
If it has been installed by the hosting company, am i best just to ask them to upgrade it?
could i setup a seperate mysql database server that does not interfere with theirs?
Team Member
Posts: 3024
Posted:
31.Jan 2006 - 09:25
--
David Pahl
Zikula Support Team
Freshman
Posts: 8
Posted:
31.Jan 2006 - 09:31
AmmoDump
Sorry, the beers are kicking in... I was thinking PHP, but sayin mysql... what is your PHP version...
lol, i installed PHP 4.4.2, and apache 2.0.44. I found explicit instructions to download, configure, and start these two versions specifically. i also tried the latest and greatest of both apache and PHP, but they gave me variosus erors, whic i figured was because of other no-yet-updated software, like the mysql itself. the 4.4.2 and 2.0.44 were the only ones i had no errors wth.
the mysql version is 3.58
Team Member
Posts: 3024
Posted:
31.Jan 2006 - 09:55
Have you tried manually dumping the mysql using myphpadmin or something else?
Have you tried manully editing you config.php?
--
David Pahl
Zikula Support Team
Freshman
Posts: 8
Posted:
31.Jan 2006 - 10:17
AmmoDump
You have created the DB and User for the DB, Correct?
Have you tried manually dumping the mysql using myphpadmin or something else?
Have you tried manully editing you config.php?
no, i have not created any databases. in PostNuke installation, it said it would create the database. i have had no other reason to use mysql.
i know the database user is mysql, but i don't know the pw. i have the ability to change/reset as a rot user, bu if that p/w is hard coded in a config page somewhere, hat might cause other problems, right?
i have not installed phpMyAdmin either.
which config.phph are you refering to? theone which comes with PostNuke?
Professional
Posts: 1680
Posted:
31.Jan 2006 - 10:53
AmmoDump
mysql need to be at least 4.1.1 (I think, it may be higher)
pn0761a working beautifuly on MySQL 3.23.58 (and man have I got a letter getting ready to send to them about that... I guess it's stable enough, but currently writen scripts require better).
--
Under Construction!
Freshman
Posts: 8
Posted:
1.Feb 2006 - 07:50
Topiatic
AmmoDump
mysql need to be at least 4.1.1 (I think, it may be higher)
pn0761a working beautifuly on MySQL 3.23.58 (and man have I got a letter getting ready to send to them about that... I guess it's stable enough, but currently writen scripts require better).
and what versions of apache and PHP are you running?
What am i missing then?
To figure out where mysql was installed, i searched for mysqld_safe or mysqlcheck[i forge which]. there is 46 files in that bin folder[/usr/local/i365/mysql/bin] including the 2 i mentioned plus mysqldump, mysqldumpslow, mysql_install, and mysql_install_db.
I also have several of the same mysql-type files in /usr/bin, but not all of them. Is this the mysql instal path?
I then did the configure step for apache, which included "--with-mysql", then make and make install. I then did configure for PHP, which included "--with-mysql=/usr/local/i365/mysql".
Do i need to include the path on both configure steps?
Do i have the mysql path correct?
Professional
Posts: 1680
Posted:
1.Feb 2006 - 09:53
--
Under Construction!