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 <[email protected]> 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 as part of the DBI connect string. I don't recall the syntax though.

This is how I usually do it. The __path_to()__ in configs gets expanded properly.

Model::DBIC:
  schema_class: MyApp::Schema
  connect_info:
- dbi:mysql:myappdb;mysql_read_default_file=__path_to(etc/.mysql.cnf)__
    - ~
    - ~
    - RaiseError: 1
      PrintError: 0
      AutoCommit: 1
      ChopBlanks: 1

-Ashley


_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/


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.

Regards,

Giancarlo

_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/

Reply via email to