Re: [Catalyst] Newbie Question about Database

2009-01-21 Thread Wade Stuart
lol I know but I'm doing this inside a private lan where we are building this app with my coleagues :p of course later on we will have specific accounts with limited access Your colleagues can be your biggest security problem. It just takes an argument...a jealousy...someone who feels

Re: [Catalyst] Newbie Question about Database

2009-01-20 Thread Giancarlo Corcuera
Ashley wrote: On Jan 19, 2009, at 7:06 PM, Charlie Garrison wrote: Good afternoon, On 19/01/09 at 8:11 PM -0500, Robert L Cochran cochr...@speakeasy.net wrote: I also wonder if Catalyst can make use of a .my.cnf file if there is one. Why is this important? Because you can keep your

Re: [Catalyst] Newbie Question about Database

2009-01-20 Thread Chisel Wright
On Tue, Jan 20, 2009 at 09:08:31AM -0500, Giancarlo Corcuera wrote: Thank you all for your answers: Actually, what I did is to follow the basic instructions from mysql forum but what I was missing is to set the user with full access from any host, which I created later from phpmyadmin.

Re: [Catalyst] Newbie Question about Database

2009-01-20 Thread Giancarlo Corcuera
Chisel Wright wrote: On Tue, Jan 20, 2009 at 09:08:31AM -0500, Giancarlo Corcuera wrote: Thank you all for your answers: Actually, what I did is to follow the basic instructions from mysql forum but what I was missing is to set the user with full access from any host, which I created

Re: [Catalyst] Newbie Question about Database

2009-01-20 Thread Robert L Cochran
Giancarlo Corcuera wrote: Chisel Wright wrote: On Tue, Jan 20, 2009 at 09:08:31AM -0500, Giancarlo Corcuera wrote: Thank you all for your answers: Actually, what I did is to follow the basic instructions from mysql forum but what I was missing is to set the user with full access from

[Catalyst] Newbie Question about Database

2009-01-19 Thread Giancarlo Corcuera
Hi: I'm building an App but I want to have my database in another IP. Is there a way to enter the parameters to do this instead of the normal connection that appears in the manual? This is my model (a very standar one): package App::Model::ModelDB; use strict; use base

Re: [Catalyst] Newbie Question about Database

2009-01-19 Thread Gene Selkov
connect_info = [ 'dbi:mysql:model', This is a mysql question. DBI passes the connection line is mysql. See here for an example of what you can write in it, but I cannot confirm, not being a mysl user: http://www.apachefriends.org/f/viewtopic.php?f=16t=27481 Look for any examples

Re: [Catalyst] Newbie Question about Database

2009-01-19 Thread John Goulah
On Mon, Jan 19, 2009 at 3:10 PM, Giancarlo Corcuera gianca...@capybara-software.com wrote: Hi: I'm building an App but I want to have my database in another IP. Is there a way to enter the parameters to do this instead of the normal connection that appears in the manual? This is my model (a

Re: [Catalyst] Newbie Question about Database

2009-01-19 Thread Robert L Cochran
John Goulah wrote: On Mon, Jan 19, 2009 at 3:10 PM, Giancarlo Corcuera gianca...@capybara-software.com wrote: Hi: I'm building an App but I want to have my database in another IP. Is there a way to enter the parameters to do this instead of the normal connection that appears in the

Re: [Catalyst] Newbie Question about Database

2009-01-19 Thread Charlie Garrison
Good afternoon, On 19/01/09 at 8:11 PM -0500, Robert L Cochran cochr...@speakeasy.net wrote: I also wonder if Catalyst can make use of a .my.cnf file if there is one. Why is this important? Because you can keep your connection password private. You can pass a path to a user defaults file

Re: [Catalyst] Newbie Question about Database

2009-01-19 Thread Ashley
On Jan 19, 2009, at 7:06 PM, Charlie Garrison wrote: Good afternoon, On 19/01/09 at 8:11 PM -0500, Robert L Cochran cochr...@speakeasy.net wrote: I also wonder if Catalyst can make use of a .my.cnf file if there is one. Why is this important? Because you can keep your connection password