[Catalyst] MySQL on another host, YAML

[Will Hawes]

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
> 

mysql might be choking on the ":" character. You could see if using 
Class::DBI::Plugin::Backtickify to quote table names makes any difference.

Or maybe you have an old mysql version on the remote machine?