I think you need mysql.so extension for the cake 1.3 and pdo_mysql.so for cake 2.0
Just paste the errors into google, the answer should be there somewhere... http://www.somacon.com/p109.php Andras Kende http://www.kende.com On Nov 5, 2011, at 10:52 PM, Tim Dunphy wrote: > ok, update. so I decided to ls the php modules directory > > [root@cloud cake]# ls -l /usr/lib64/php/modules/ > total 2392 > -rwxr-xr-x 1 root root 63008 Sep 30 14:14 curl.so > -rwxr-xr-x 1 root root 1838496 Sep 30 14:14 fileinfo.so > -rwxr-xr-x 1 root root 32984 Sep 30 14:14 json.so > -rwxr-xr-x 1 root root 98312 Sep 30 14:14 pdo.so > -rwxr-xr-x 1 root root 24264 Sep 30 14:14 pdo_sqlite.so > -rwxr-xr-x 1 root root 257440 Sep 30 14:14 phar.so > -rwxr-xr-x 1 root root 15416 Mar 30 2011 phpcups.so > -rwxr-xr-x 1 root root 82112 Sep 30 14:14 zip.so > > and saw that pdo.so was there. > > so I got rid of pdo_mysql.so from the extension=php.ini file and left > extension=pdo.so in there. then I restarted apache. and now this is > what happens when I run the mysql connect script you've provided: > > [root@cloud cake]# php mysql.php > PHP Warning: Module 'PDO' already loaded in Unknown on line 0 > PHP Fatal error: Call to undefined function mysql_connect() in > /var/www/cakephp-cakephp-73205dc/mysql.php on line 2 > > any thoughts? thanks! > > > > On Sat, Nov 5, 2011 at 11:48 PM, Tim Dunphy <bluethu...@gmail.com> wrote: >> Thanks for that! It seems that php can't find it's pdo librarries >> >> >> [root@cloud cake]# php mysql.php >> PHP Warning: PHP Startup: Unable to load dynamic library >> '/usr/lib64/php/modules/pdo_mysql.so' - >> /usr/lib64/php/modules/pdo_mysql.so: cannot open shared object file: >> No such file or directory in Unknown on line 0 >> PHP Warning: Module 'PDO' already loaded in Unknown on line 0 >> PHP Fatal error: Call to undefined function mysql_connect() in >> /var/www/cakephp-cakephp-73205dc/mysql.php on line 2 >> >> I can't ls the module file >> >> [root@cloud cake]# ls -l /usr/lib64/php/modules/pdo_mysql.so >> ls: /usr/lib64/php/modules/pdo_mysql.so: No such file or directory >> >> >> But the rpm database tells me that php-pdo is already installed. >> >> [root@cloud cake]# rpmquery php-pdo >> php-pdo-5.3.8-5.el5.remi.1 >> >> so what gives? :) >> >> >> >> >> On Sat, Nov 5, 2011 at 11:38 PM, Andras Kende <and...@kende.com> wrote: >>> Maybe php5-mysql support not enabled ? You could try a plain php file to >>> test without cakephp >>> >>> <?php >>> mysql_connect("localhost", "admin", "secret") or die(mysql_error()); >>> echo "Connected to MySQL<br />"; >>> mysql_select_db("cake") or die(mysql_error()); >>> echo "Connected to Database"; >>> ?> >>> >>> 'Andras Kende >>> http://www.kende.com >>> >>> On Nov 5, 2011, at 10:25 PM, Tim Dunphy wrote: >>> >>>> Hello and thanks for your reply.. >>>> >>>> I tried removing the port setting as you've suggested and moved from >>>> cake 1.3 to cake 2.0 but the result was the same! >>>> >>>> class DATABASE_CONFIG { >>>> >>>> public $default = array( >>>> 'datasource' => 'Database/Mysql', >>>> 'persistent' => false, >>>> 'host' => 'localhost', >>>> 'login' => 'admin', >>>> 'password' => 'secret', >>>> 'database' => 'cake', >>>> 'prefix' => '', >>>> //'encoding' => 'utf8', >>>> ); >>>> >>>> public $test = array( >>>> 'datasource' => 'Database/Mysql', >>>> 'persistent' => false, >>>> 'host' => 'admin', >>>> 'login' => 'root', >>>> 'password' => 'secret', >>>> 'database' => 'cakeblog', >>>> 'prefix' => '', >>>> //'encoding' => 'utf8', >>>> ); >>>> } >>>> >>>> On Sat, Nov 5, 2011 at 10:03 PM, Ma'moon <phpir...@gmail.com> wrote: >>>>> Most likely you need to leave the port section empty in your db >>>>> configuration >>>>> >>>>> On Sat, Nov 5, 2011 at 9:55 PM, bluethundr <bluethu...@gmail.com> wrote: >>>>>> >>>>>> ## cake cannot connect to the databse >>>>>> >>>>>> Your tmp directory is writable. >>>>>> >>>>>> The FileEngine is being used for caching. To change the config edit >>>>>> APP/config/core.php >>>>>> >>>>>> Your database configuration file is present. >>>>>> >>>>>> Cake is NOT able to connect to the database. >>>>>> >>>>>> ## database config file >>>>>> >>>>>> >>>>>> class DATABASE_CONFIG { >>>>>> >>>>>> var $default = array( >>>>>> 'driver' => 'mysql', >>>>>> 'persistent' => false, >>>>>> 'host' => 'localhost', >>>>>> 'login' => 'admin', >>>>>> 'password' => 'secret', >>>>>> 'database' => 'cake', >>>>>> 'prefix' => '', >>>>>> 'port' => '/var/lib/mysql/mysql.sock', >>>>>> //'encoding' => 'utf8', >>>>>> ); >>>>>> >>>>>> var $test = array( >>>>>> 'driver' => 'mysql', >>>>>> 'persistent' => false, >>>>>> 'host' => 'localhost', >>>>>> 'login' => 'admin', >>>>>> 'password' => 'secret', >>>>>> 'database' => 'cakeblog', >>>>>> 'prefix' => '', >>>>>> 'port' => '/var/lib/mysql/mysql.sock', >>>>>> //'encoding' => 'utf8', >>>>>> ); >>>>>> } >>>>>> >>>>>> >>>>>> >>>>>> ## user can connect to (and use) database on the command line >>>>>> >>>>>> >>>>>> [root@cloud cake]# mysql -uadmin -psecret >>>>>> Welcome to the MySQL monitor. Commands end with ; or \g. >>>>>> Your MySQL connection id is 2 >>>>>> Server version: 5.5.17-log MySQL Community Server (GPL) by Remi >>>>>> >>>>>> Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights >>>>>> reserved. >>>>>> >>>>>> Oracle is a registered trademark of Oracle Corporation and/or its >>>>>> affiliates. Other names may be trademarks of their respective >>>>>> owners. >>>>>> >>>>>> Type 'help;' or '\h' for help. Type '\c' to clear the current input >>>>>> statement. >>>>>> >>>>>> mysql> use cake >>>>>> Database changed >>>>>> >>>>>> thank you! >>>>>> >>>>>> -- >>>>>> Our newest site for the community: CakePHP Video Tutorials >>>>>> http://tv.cakephp.org >>>>>> Check out the new CakePHP Questions site http://ask.cakephp.org and help >>>>>> others with their CakePHP related questions. >>>>>> >>>>>> >>>>>> To unsubscribe from this group, send email to >>>>>> cake-php+unsubscr...@googlegroups.com For more options, visit this group >>>>>> at http://groups.google.com/group/cake-php >>>>> >>>>> -- >>>>> Our newest site for the community: CakePHP Video Tutorials >>>>> http://tv.cakephp.org >>>>> Check out the new CakePHP Questions site http://ask.cakephp.org and help >>>>> others with their CakePHP related questions. >>>>> >>>>> >>>>> To unsubscribe from this group, send email to >>>>> cake-php+unsubscr...@googlegroups.com For more options, visit this group >>>>> at >>>>> http://groups.google.com/group/cake-php >>>>> >>>> >>>> >>>> >>>> -- >>>> GPG me!! >>>> >>>> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B >>>> >>>> -- >>>> Our newest site for the community: CakePHP Video Tutorials >>>> http://tv.cakephp.org >>>> Check out the new CakePHP Questions site http://ask.cakephp.org and help >>>> others with their CakePHP related questions. >>>> >>>> >>>> To unsubscribe from this group, send email to >>>> cake-php+unsubscr...@googlegroups.com For more options, visit this group >>>> at http://groups.google.com/group/cake-php >>> >>> -- >>> Our newest site for the community: CakePHP Video Tutorials >>> http://tv.cakephp.org >>> Check out the new CakePHP Questions site http://ask.cakephp.org and help >>> others with their CakePHP related questions. >>> >>> >>> To unsubscribe from this group, send email to >>> cake-php+unsubscr...@googlegroups.com For more options, visit this group at >>> http://groups.google.com/group/cake-php >>> >> >> >> >> -- >> GPG me!! >> >> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B >> > > > > -- > GPG me!! > > gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group at > http://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
