CakePHP

New to Cake

Classic

List

Threaded

18 messages Options

Bob-140

New to Cake

I am attempting to start Cake for the first time. I get the following
errors when trying to open:

Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/b/r/
o/brob3435594/html/cake/cake/libs/model/dbo/dbo_mysql.php on line 100

Warning: mysql_select_db(): supplied argument is not a valid MySQL-
Link resource in /home/content/b/r/o/brob3435594/html/cake/cake/libs/
model/dbo/dbo_mysql.php on line 105

I am very new and any help would be appreciated.

Thanks

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

John David Anderson (_psychic_)

Re: New to Cake

On Jul 19, 2007, at 10:28 AM, Bob wrote:

>
> I am attempting to start Cake for the first time. I get the following
> errors when trying to open:
>
> Warning: mysql_connect(): Can't connect to local MySQL server through
> socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/
> b/r/
> o/brob3435594/html/cake/cake/libs/model/dbo/dbo_mysql.php on line 100
>
> Warning: mysql_select_db(): supplied argument is not a valid MySQL-
> Link resource in /home/content/b/r/o/brob3435594/html/cake/cake/libs/
> model/dbo/dbo_mysql.php on line 105
>
> I am very new and any help would be appreciated.

Make sure your database server is up and running, and give Cake a try
once you're sure it's up.

The error messages you've supplied here mean that PHP can't connect
to the server.

-- John

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Bob-140

Re: New to Cake

Thanks for the reply.

I set up the database this morning and it is up and running, but still
unable to connect.

Any other suggestions?

On Jul 19, 11:37 am, "John David Anderson (_psychic_)"
<[hidden email]> wrote:

> On Jul 19, 2007, at 10:28 AM, Bob wrote:
>
>
>
> > I am attempting to start Cake for the first time. I get the following
> > errors when trying to open:
>
> > Warning: mysql_connect(): Can't connect to local MySQL server through
> > socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/
> > b/r/
> > o/brob3435594/html/cake/cake/libs/model/dbo/dbo_mysql.php on line 100
>
> > Warning: mysql_select_db(): supplied argument is not a valid MySQL-
> > Link resource in /home/content/b/r/o/brob3435594/html/cake/cake/libs/
> > model/dbo/dbo_mysql.php on line 105
>
> > I am very new and any help would be appreciated.
>
> Make sure your database server is up and running, and give Cake a try
> once you're sure it's up.
>
> The error messages you've supplied here mean that PHP can't connect
> to the server.
>
> -- John

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

rtconner

Re: New to Cake

Did you config the configure/database.php file?

On Jul 19, 10:43 am, Bob <[hidden email]> wrote:

> Thanks for the reply.
>
> I set up the database this morning and it is up and running, but still
> unable to connect.
>
> Any other suggestions?
>
> On Jul 19, 11:37 am, "John David Anderson (_psychic_)"
>
> <[hidden email]> wrote:
> > On Jul 19, 2007, at 10:28 AM, Bob wrote:
>
> > > I am attempting to start Cake for the first time. I get the following
> > > errors when trying to open:
>
> > > Warning: mysql_connect(): Can't connect to local MySQL server through
> > > socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/
> > > b/r/
> > > o/brob3435594/html/cake/cake/libs/model/dbo/dbo_mysql.php on line 100
>
> > > Warning: mysql_select_db(): supplied argument is not a valid MySQL-
> > > Link resource in /home/content/b/r/o/brob3435594/html/cake/cake/libs/
> > > model/dbo/dbo_mysql.php on line 105
>
> > > I am very new and any help would be appreciated.
>
> > Make sure your database server is up and running, and give Cake a try
> > once you're sure it's up.
>
> > The error messages you've supplied here mean that PHP can't connect
> > to the server.
>
> > -- John

Bob-140

Re: New to Cake

yes, here it is.

class DATABASE_CONFIG
{
var $default = array('driver' => 'mysql',
'connect' => 'mysql_connect',
'host' => 'localhost',
'login' => 'br_cake',
'password' => 'Cle01cat',
'database' => 'cakeDB',
'prefix' => '');

var $test = array('driver' => 'mysql',
'connect' => 'mysql_connect',
'host' => 'localhost',
'login' => 'br_cake',
'password' => 'Cle01cat',
'database' => 'cakeDB',
'prefix' => '');
}
?>

On Jul 19, 12:06 pm, rtconner <[hidden email]> wrote:

> Did you config the configure/database.php file?
>
> On Jul 19, 10:43 am, Bob <[hidden email]> wrote:
>
>
>
> > Thanks for the reply.
>
> > I set up the database this morning and it is up and running, but still
> > unable to connect.
>
> > Any other suggestions?
>
> > On Jul 19, 11:37 am, "John David Anderson (_psychic_)"
>
> > <[hidden email]> wrote:
> > > On Jul 19, 2007, at 10:28 AM, Bob wrote:
>
> > > > I am attempting to start Cake for the first time. I get the following
> > > > errors when trying to open:
>
> > > > Warning: mysql_connect(): Can't connect to local MySQL server through
> > > > socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/
> > > > b/r/
> > > > o/brob3435594/html/cake/cake/libs/model/dbo/dbo_mysql.php on line 100
>
> > > > Warning: mysql_select_db(): supplied argument is not a valid MySQL-
> > > > Link resource in /home/content/b/r/o/brob3435594/html/cake/cake/libs/
> > > > model/dbo/dbo_mysql.php on line 105
>
> > > > I am very new and any help would be appreciated.
>
> > > Make sure your database server is up and running, and give Cake a try
> > > once you're sure it's up.
>
> > > The error messages you've supplied here mean that PHP can't connect
> > > to the server.
>
> > > -- John- Hide quoted text -
>
> - Show quoted text -

Christopher E. Franklin, Sr.

Re: New to Cake

You should not include your password :)

On Jul 19, 10:28 am, Bob <[hidden email]> wrote:

> yes, here it is.
>
> class DATABASE_CONFIG
> {
> var $default = array('driver' => 'mysql',
> 'connect' => 'mysql_connect',
> 'host' => 'localhost',
> 'login' => 'br_cake',
> 'password' => 'xxxxxx',
> 'database' => 'cakeDB',
> 'prefix' => '');
>
> var $test = array('driver' => 'mysql',
> 'connect' => 'mysql_connect',
> 'host' => 'localhost',
> 'login' => 'br_cake',
> 'password' => 'xxxxxx',
> 'database' => 'cakeDB',
> 'prefix' => '');}
>
> ?>
>
> On Jul 19, 12:06 pm, rtconner <[hidden email]> wrote:
>
> > Did you config the configure/database.php file?
>
> > On Jul 19, 10:43 am, Bob <[hidden email]> wrote:
>
> > > Thanks for the reply.
>
> > > I set up the database this morning and it is up and running, but still
> > > unable to connect.
>
> > > Any other suggestions?
>
> > > On Jul 19, 11:37 am, "John David Anderson (_psychic_)"
>
> > > <[hidden email]> wrote:
> > > > On Jul 19, 2007, at 10:28 AM, Bob wrote:
>
> > > > > I am attempting to start Cake for the first time. I get the following
> > > > > errors when trying to open:
>
> > > > > Warning: mysql_connect(): Can't connect to local MySQL server through
> > > > > socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/
> > > > > b/r/
> > > > > o/brob3435594/html/cake/cake/libs/model/dbo/dbo_mysql.php on line 100
>
> > > > > Warning: mysql_select_db(): supplied argument is not a valid MySQL-
> > > > > Link resource in /home/content/b/r/o/brob3435594/html/cake/cake/libs/
> > > > > model/dbo/dbo_mysql.php on line 105
>
> > > > > I am very new and any help would be appreciated.
>
> > > > Make sure your database server is up and running, and give Cake a try
> > > > once you're sure it's up.
>
> > > > The error messages you've supplied here mean that PHP can't connect
> > > > to the server.
>
> > > > -- John- Hide quoted text -
>
> > - Show quoted text -

John David Anderson (_psychic_)

Re: New to Cake

In reply to this post by Bob-140

On Jul 19, 2007, at 11:28 AM, Bob wrote:

>
> yes, here it is.
>
> class DATABASE_CONFIG
> {
> var $default = array('driver' => 'mysql',
> 'connect' => 'mysql_connect',
> 'host' => 'localhost',

Try 127.0.0.1, just for fun.

Oh, and change your password now that you've shared it with us. ;)

-- John

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Bob-140

Re: New to Cake

In reply to this post by Christopher E. Franklin, Sr.

you are correct!

On Jul 19, 12:30 pm, "Christopher E. Franklin, Sr."
<[hidden email]> wrote:

> You should not include your password :)
>
> On Jul 19, 10:28 am, Bob <[hidden email]> wrote:
>
>
>
> > yes, here it is.
>
> > class DATABASE_CONFIG
> > {
> > var $default = array('driver' => 'mysql',
> > 'connect' => 'mysql_connect',
> > 'host' => 'localhost',
> > 'login' => 'br_cake',
> > 'password' => 'xxxxxx',
> > 'database' => 'cakeDB',
> > 'prefix' => '');
>
> > var $test = array('driver' => 'mysql',
> > 'connect' => 'mysql_connect',
> > 'host' => 'localhost',
> > 'login' => 'br_cake',
> > 'password' => 'xxxxxx',
> > 'database' => 'cakeDB',
> > 'prefix' => '');}
>
> > ?>
>
> > On Jul 19, 12:06 pm, rtconner <[hidden email]> wrote:
>
> > > Did you config the configure/database.php file?
>
> > > On Jul 19, 10:43 am, Bob <[hidden email]> wrote:
>
> > > > Thanks for the reply.
>
> > > > I set up the database this morning and it is up and running, but still
> > > > unable to connect.
>
> > > > Any other suggestions?
>
> > > > On Jul 19, 11:37 am, "John David Anderson (_psychic_)"
>
> > > > <[hidden email]> wrote:
> > > > > On Jul 19, 2007, at 10:28 AM, Bob wrote:
>
> > > > > > I am attempting to start Cake for the first time. I get the following
> > > > > > errors when trying to open:
>
> > > > > > Warning: mysql_connect(): Can't connect to local MySQL server through
> > > > > > socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/
> > > > > > b/r/
> > > > > > o/brob3435594/html/cake/cake/libs/model/dbo/dbo_mysql.php on line 100
>
> > > > > > Warning: mysql_select_db(): supplied argument is not a valid MySQL-
> > > > > > Link resource in /home/content/b/r/o/brob3435594/html/cake/cake/libs/
> > > > > > model/dbo/dbo_mysql.php on line 105
>
> > > > > > I am very new and any help would be appreciated.
>
> > > > > Make sure your database server is up and running, and give Cake a try
> > > > > once you're sure it's up.
>
> > > > > The error messages you've supplied here mean that PHP can't connect
> > > > > to the server.
>
> > > > > -- John- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

Bob-140

Re: New to Cake

In reply to this post by John David Anderson (_psychic_)

127.0.0.1? please explain.
thanks

On Jul 19, 12:31 pm, "John David Anderson (_psychic_)"
<[hidden email]> wrote:

> On Jul 19, 2007, at 11:28 AM, Bob wrote:
>
>
>
> > yes, here it is.
>
> > class DATABASE_CONFIG
> > {
> > var $default = array('driver' => 'mysql',
> > 'connect' => 'mysql_connect',
> > 'host' => 'localhost',
>
> Try 127.0.0.1, just for fun.
>
> Oh, and change your password now that you've shared it with us. ;)
>
> -- John

John David Anderson (_psychic_)

Re: New to Cake

On Jul 19, 2007, at 11:42 AM, Bob wrote:

>
> 127.0.0.1? please explain.

Instead of

'host' => 'localhost'

do

'host' => '127.0.0.1'

-- John

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Chris Hartjes

Re: New to Cake

In reply to this post by Bob-140

On 7/19/07, Bob <[hidden email]> wrote:
>
> 127.0.0.1? please explain.
> thanks

127.0.0.1 is an IP address that usually represents your local machine.

--
Chris Hartjes
Senior Developer
Cake Development Corporation

My motto for 2007: "Just build it, damnit!"

@TheBallpark - http://www.littlehart.net/attheballpark
@TheKeyboard - http://www.littlehart.net/atthekeyboard

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Bob-140

Re: New to Cake

Thank you.

Tried that. Same result, same errors.

Bob

On Jul 19, 12:47 pm, "Chris Hartjes" <[hidden email]> wrote:

> On 7/19/07, Bob <[hidden email]> wrote:
>
>
>
> > 127.0.0.1? please explain.
> > thanks
>
> 127.0.0.1 is an IP address that usually represents your local machine.
>
> --
> Chris Hartjes
> Senior Developer
> Cake Development Corporation
>
> My motto for 2007: "Just build it, damnit!"
>
> @TheBallpark -http://www.littlehart.net/attheballpark
> @TheKeyboard -http://www.littlehart.net/atthekeyboard

Chris Hartjes

Re: New to Cake

On 7/19/07, Bob <[hidden email]> wrote:
>
> Thank you.
>
> Tried that. Same result, same errors.
>
> Bob

Well, I'm pretty sure that when PHP is saying that it can't connect to
the database server, it's being honest. I would triple check that the
username and password you are using are correct. That's the only
possible explanation given the error message.

--
Chris Hartjes
Senior Developer
Cake Development Corporation

My motto for 2007: "Just build it, damnit!"

@TheBallpark - http://www.littlehart.net/attheballpark
@TheKeyboard - http://www.littlehart.net/atthekeyboard

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Erich C. Beyrent

Re: New to Cake

Can you connect to the database via the console using that username and
password? Did you add permissions to the database for that user?

-Erich-

Chris Hartjes wrote:

> On 7/19/07, Bob <[hidden email]> wrote:
>> Thank you.
>>
>> Tried that. Same result, same errors.
>>
>> Bob
>
> Well, I'm pretty sure that when PHP is saying that it can't connect to
> the database server, it's being honest. I would triple check that the
> username and password you are using are correct. That's the only
> possible explanation given the error message.
>

bikoz

Re: New to Cake

In reply to this post by Chris Hartjes

Hi,

- Is MySQL accepting (socket) connections on localhost?

- Does the /usr/local/mysql-5.0/data/mysql.sock file exist?

See:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html

-- Vincent

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Bob-140

Re: New to Cake

In reply to this post by Chris Hartjes

I logged in to the DB using the user and pass, so I know it is
correct. It matches what is in the database.PHP file. I took the IP
address of the DB server and plugged it into database.PHP. I did not
get the errors this time, but still can't connect to DB?

Thanks

On Jul 19, 12:57 pm, "Chris Hartjes" <[hidden email]> wrote:

> On 7/19/07, Bob <[hidden email]> wrote:
>
>
>
> > Thank you.
>
> > Tried that. Same result, same errors.
>
> > Bob
>
> Well, I'm pretty sure that when PHP is saying that it can't connect to
> the database server, it's being honest. I would triple check that the
> username and password you are using are correct. That's the only
> possible explanation given the error message.
>
> --
> Chris Hartjes
> Senior Developer
> Cake Development Corporation
>
> My motto for 2007: "Just build it, damnit!"
>
> @TheBallpark -http://www.littlehart.net/attheballpark
> @TheKeyboard -http://www.littlehart.net/atthekeyboard

Pablo Viojo

Re: New to Cake

Try installing someother app that uses db (could be wordpress) and check if it works correctly. If it doesn't then theres a problem with the comuunication between php and mysql.

Pablo

On 7/19/07, Bob <[hidden email]> wrote:

I logged in to the DB using the  user and pass, so I know it is
correct. It matches what is in the database.PHP file. I took the IP
address of the DB server and plugged it into database.PHP. I did not
get the errors this time, but still can't connect to DB?

Thanks

On Jul 19, 12:57 pm, "Chris Hartjes" <[hidden email]> wrote:

> On 7/19/07, Bob <[hidden email]> wrote:
>
>
>
> > Thank you.
>
> > Tried that. Same result, same errors.
>
> > Bob
>
> Well, I'm pretty sure that when PHP is saying that it can't connect to
> the database server, it's being honest.  I would triple check that the
> username and password you are using are correct.  That's the only
> possible explanation given the error message.
>
> --
> Chris Hartjes
> Senior Developer
> Cake Development Corporation
>
> My motto for 2007:  "Just build it, damnit!"
>
> @TheBallpark - http://www.littlehart.net/attheballpark
> @TheKeyboard -http://www.littlehart.net/atthekeyboard

http://pviojo.net
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Samuel DeVore

Re: New to Cake

In reply to this post by Erich C. Beyrent

also some php5 installs do not have the mysql connectors installed by
default, have you verified that you can connect to the mysql db using
just plain php?
http://us.php.net/mysql
Sam D

On 7/19/07, Erich C. Beyrent <[hidden email]> wrote:

>
> Can you connect to the database via the console using that username and
> password? Did you add permissions to the database for that user?
>
> -Erich-
>
> Chris Hartjes wrote:
> > On 7/19/07, Bob <[hidden email]> wrote:
> >> Thank you.
> >>
> >> Tried that. Same result, same errors.
> >>
> >> Bob
> >
> > Well, I'm pretty sure that when PHP is saying that it can't connect to
> > the database server, it's being honest. I would triple check that the
> > username and password you are using are correct. That's the only
> > possible explanation given the error message.
> >
>
> >
>

--
(the old fart) the advice is free, the lack of crankiness will cost you

- its a fine line between a real question and an idiot

http://blog.samdevore.com/archives/2007/03/05/when-open-source-bugs-me/

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---