Page 1 of 1

missing extension for mysql

Posted: Wed Oct 26, 2005 4:47 am
by joel
I have read the topics on this forum regarding this message and i have set the OLD_PASSWORD variable for the user as suggested but I still get the 'missing extension for mysql' followed by connection failed message.
the os is CentOS 4.1,  MySQL is 4.1.10a, PHP is 4.3.9.  I installed from this file;  cmsmadesimple-0.10.3.tar.gz
I am using phpmyadmin to confirm that the OLD_PASSWORD variable is on.
Any help appreciated.

Re: missing extension for mysql

Posted: Wed Oct 26, 2005 12:29 pm
by Ted
If you're using the OLD_PASSWORD thing, then you want to select mysql 3/4 from the dropdown instead of mysql 4.1.  If it's still not working, make sure that lib/adodb/drivers/adodb-mysql.inc.php was uploaded to your host properly.

Re: missing extension for mysql

Posted: Wed Oct 26, 2005 4:30 pm
by joel
First of all, Thanks for responding!

In order to re-run index.php I have been going into config.php and deleting the three lines that an unsuccessful install places there. If i don't do that then index.php returns a message that the site is down for maintenance?? Is there a 'proper' way to do a re-install if the first attempt didn't work?

I tried to re-install leaving database type at MySQL 3.0 and 4.0 I get the following message returned(which is different than if I select 4.1):
Warning: mysql_connect(): Access denied for user 'cms'@'localhost' (using password: YES) in /var/www/html/cms/lib/adodb/drivers/adodb-mysql.inc.php on line 340
localhost: Access denied for user 'cms'@'localhost' (using password: YES)
Connection failed

Here is a directory listing of the drivers directory. Unfortunalely I don't know if its 'proper' just that it is indeed there:
drwxrwxr-x  2 root dip  4096 Oct  3 20:56 .
drwxrwxr-x  4 root dip  4096 Oct  3 20:56 ..
-rw-r--r--  1 root dip 20373 Oct  3 20:55 adodb-mysqli.inc.php
-rw-r--r--  1 root dip 18450 Oct  3 20:55 adodb-mysql.inc.php
-rw-r--r--  1 root dip 30596 Oct  3 20:55 adodb-postgres64.inc.php
-rw-r--r--  1 root dip  5898 Oct  3 20:55 adodb-postgres7.inc.php

If there is a way to attach a file I don't see it. I tried to copy the contents of adodb-mysql.inc.php but it makes the messages too big. So I am going to try to just show the beginning and the area around line 340 (this may be totally screwed up however) :
0) return "CONCAT($s)";
                else return '';
        }

        function OffsetDate($dayFraction,$date=false)
        {
                if (!$date) $date = $this->sysDate;
                return "from_unixtime(unix_timestamp($date)+($dayFraction)*24*3600)";
        }

        // returns true or false
        function _connect($argHostname, $argUsername, $argPassword, $argDatabasename)
        {
                if (ADODB_PHPVER >= 0x4300)
                        $this->_connectionID = mysql_connect($argHostname,$argUsername,$argPassword,
                                                                                                $this->forceNewConnect,$this->clientFlags);
                else if (ADODB_PHPVER >= 0x4200)
                        $this->_connectionID = mysql_connect($argHostname,$argUsername,$argPassword,
                                                                                                $this->forceNewConnect);
                else
                        $this->_connectionID = mysql_connect($argHostname,$argUsername,$argPassword);

                if ($this->_connectionID === false) return false;
                if ($argDatabasename) return $this->SelectDB($argDatabasename);
                return true;
        }

         
                     


                 
   

Re: missing extension for mysql - SOLVED...but do not know why.

Posted: Thu Oct 27, 2005 1:08 am
by joel
I changed localhost to the IP address, left the database version at 3.0/4.0 (even though I have 4.1), put the OLD_PASSWORD setting on and it worked....I've no idea why.

Re: missing extension for mysql

Posted: Thu Oct 27, 2005 9:23 am
by Ted
Very strange stuff.  Well, I'm glad it's working.  :)