[Catalyst] MySQL on another host, YAML

Davood Firoozian davood at sibiran.com
Wed Jan 18 04:47:16 CET 2006


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




More information about the Catalyst mailing list