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
--
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
