[Catalyst] MySQL on another host, YAML

[Ian Docherty]

Davood

Your dsn should be something like

dsn: 'dbi:mysql:svnserver'

it seems to me. I don't know what the 'svpn' bit is but CDBI is taking 
everything after the 'mysql:' part as the server name.

Regards
Ian



Davood Firoozian wrote:

> hi,
> Using this YAML config
>
> Model::CDBI:
>    dsn: 'dbi:mysql:svpn:svnserver'
>    user: 'dummy'
>    password: 'monaliza'
>    options: {}
>    relationships: 1
>
> got an error:
>
> You have an error in your SQL syntax; check the manual that 
> corresponds to your MySQL server version for the right syntax to use 
> near ':svnserver LIKE 'svpn_account_role'' at line 1 [for Statement 
> "SHOW TABLE STATUS FROM svpn:svnserver LIKE 'svpn_account_role'"] at 
> /usr/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line 52.
>
> and here is the Query log:
>
> 060118  2:41:06      16 Connect     dummy at 21.21.21.26 on svpn
>                     16 Query       SHOW TABLES
>                     16 Quit
>                     17 Connect     dummy at 21.21.21.26 on svpn
>                     17 Query       DESCRIBE svpn_account_role
>                     17 Query       DESCRIBE svpn_accounts
>                     17 Query       DESCRIBE svpn_configs
>                     17 Query       DESCRIBE svpn_log
>                     17 Query       DESCRIBE svpn_reseller
>                     17 Query       DESCRIBE svpn_role
>                     17 Query       DESCRIBE svpn_try_accounts
>                     17 Query       SHOW TABLE STATUS FROM 
> svpn:svnserver LIKE 'svpn_account_role'
>                     17 Quit
>
> help me find the error plz
>
>
> _______________________________________________
> Catalyst mailing list
> Catalyst at lists.rawmode.org
> http://lists.rawmode.org/mailman/listinfo/catalyst
>
>
>