whoops! silly me! I forgot to install the php-mysql extension! I did that and now it's working. So thanks for your help!
tim On Sun, Nov 6, 2011 at 12:04 AM, Andras Kende <and...@kende.com> wrote: > 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 > -- 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
