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
