Zikula: A Flexible Open Source Content Management System
home | forum | contact us

Dizkus

Goto page: 1 - 2 [+1]

Bottom
Problem with mysql_pconnect function
  • Posted: 25.01.2006, 15:36
     
    pkvaranasi
    rank:
    Freshman Freshman
    registered:
     April 2005
    Status:
    offline
    last visit:
    16.08.06
    Posts:
    33
    Hai,
    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.
  • Posted: 25.01.2006, 17:23
     
    ainigma32
    rank:
    Professional Professional
    registered:
     January 2004
    Status:
    offline
    last visit:
    22.03.06
    Posts:
    958
    What does the error message say exactly?
  • Posted: 25.01.2006, 23:46
     
    Simon
    rank:
    Steering Committee Steering Committee
    registered:
     December 2002
    Status:
    offline
    last visit:
    09.11.08
    Posts:
    13413
    Based on the title of this topic, I'd have said you've compiled PHP without MySQL support, but it's hard to say...

    --
    Regards,
    Simon

    itbegins.co.uk - Zikula Consulting

    Please read the Support Guide
  • Posted: 30.01.2006, 10:24
     
    pkvaranasi
    rank:
    Freshman Freshman
    registered:
     April 2005
    Status:
    offline
    last visit:
    16.08.06
    Posts:
    33
    There is no error message. But when I traced through the files, I found that there is a problem with mysql_pconnect function.
    So kindly suggest me in solving this issue.

    Thanks.
  • Posted: 30.01.2006, 13:22
     
    Simon
    rank:
    Steering Committee Steering Committee
    registered:
     December 2002
    Status:
    offline
    last visit:
    09.11.08
    Posts:
    13413
    Recompile your PHP installation with MySQL support as outlined in the PHP Manual.

    --
    Regards,
    Simon

    itbegins.co.uk - Zikula Consulting

    Please read the Support Guide
  • Posted: 31.01.2006, 08:28
     
    cdnsupra
    rank:
    Freshman Freshman
    registered:
     January 2006
    Status:
    offline
    last visit:
    16.02.06
    Posts:
    8

    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.
  • Posted: 31.01.2006, 08:33
     
    AmmoDump
    rank:
    Professional Professional
    registered:
     December 2003
    Status:
    offline
    last visit:
    21.11.08
    Posts:
    2975
    Are you using CPanel?

    username is something like:

    siteUserName_mySQLuserName

    and DBname is something like:

    siteUserName_mySQLdataBaseName

    --
    David Pahl
    Zikula Support Team
  • Posted: 31.01.2006, 08:39
     
    cdnsupra
    rank:
    Freshman Freshman
    registered:
     January 2006
    Status:
    offline
    last visit:
    16.02.06
    Posts:
    8
    No, I do not know what Cpanel is?
    Should I install that on my pc to get the info out of mysql?
  • Posted: 31.01.2006, 08:42
     
    AmmoDump
    rank:
    Professional Professional
    registered:
     December 2003
    Status:
    offline
    last visit:
    21.11.08
    Posts:
    2975
    No. Do not install cpanel. But do tell us about your server...

    --
    David Pahl
    Zikula Support Team
  • Posted: 31.01.2006, 08:53
     
    cdnsupra
    rank:
    Freshman Freshman
    registered:
     January 2006
    Status:
    offline
    last visit:
    16.02.06
    Posts:
    8
    it is an insomnia 365 server located at the planet in texas. it is basically a gaming server. it has a gaming software setup called "cortex" which runs the games, and it uses mysql. apache was installed, but configured or started. i had to d/l PHP myself, configure it and get it going.

    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?
  • Posted: 31.01.2006, 09:13
     
    AmmoDump
    rank:
    Professional Professional
    registered:
     December 2003
    Status:
    offline
    last visit:
    21.11.08
    Posts:
    2975
    mysql need to be at least 4.1.1 (I think, it may be higher)

    --
    David Pahl
    Zikula Support Team
  • Posted: 31.01.2006, 09:21
     
    cdnsupra
    rank:
    Freshman Freshman
    registered:
     January 2006
    Status:
    offline
    last visit:
    16.02.06
    Posts:
    8

    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?
  • Posted: 31.01.2006, 09:25
     
    AmmoDump
    rank:
    Professional Professional
    registered:
     December 2003
    Status:
    offline
    last visit:
    21.11.08
    Posts:
    2975
    Sorry, the beers are kicking in... I was thinking PHP, but sayin mysql... what is your PHP version...

    --
    David Pahl
    Zikula Support Team
  • Posted: 31.01.2006, 09:31
     
    cdnsupra
    rank:
    Freshman Freshman
    registered:
     January 2006
    Status:
    offline
    last visit:
    16.02.06
    Posts:
    8

    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
  • Posted: 31.01.2006, 09:55
     
    AmmoDump
    rank:
    Professional Professional
    registered:
     December 2003
    Status:
    offline
    last visit:
    21.11.08
    Posts:
    2975
    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?

    --
    David Pahl
    Zikula Support Team

Goto page: 1 - 2 [+1]

Main Menu

Extensions Database

Documentation

Development

Login

Donate to Zikula