Sorry for the previous message, something went wrong. Ok, i've finally solved the problem and i must tell you guys for further reference.
I've made a php script for connection testing and it worked fine, so i've never tried to access mysql the directly on shell. But that did help, i must explain: $ mysql --user=behem0t_tracks --password=!2********* -- database=behem0t_tracks --host=localhost Note that the password starts with a !2 . That in shell didn't work. The bash was interpreting that as command and changing it to perl, so the error line was something like $ mysql --user=behem0t_tracks --password=perl ********* -- database=behem0t_tracks --host=localhost I don't know how activerecord authenticates, but i've changed to a no special chars - plain password and all worked fine. Weird. Thanks. Miguel ----- Ok Luke, c On Jul 26, 2007, at 4:15 PM, Luke Melia wrote: > Hi Miguel, > > The error message certainly seems to indicate that the app can't > connect to the database. > > If you type: > > mysql --user=behem0t_tracks --password=mypassword -- > database=behem0t_tracks --host=localhost > > are you able to connect successfully? > > Cheers from NYC, > Luke > > Miguel Carvalho wrote: >> Hi, >> i've been trying for days to put tracks working on site5, and have >> no success.. >> I'm getting an error, >> "Application error (Apache) >> Change this error message for exceptions thrown outside of an >> action (like in Dispatcher setups or broken Ruby code) in public/ >> 500.html " >> Email by email with support i've tried everything, chmoding >> files, rebuilding links, etc, etc, until they tell me "sorry but >> whe don't support third party applications!" :-( >> My development.log shows the following error: >> SwitchEnvironmentController: missing default helper path >> switch_environment_helper >> UnobtrusiveJavascriptController: missing default helper path >> unobtrusive_javascript_helper >> Access denied for user 'behem0t_tracks'@'localhost' (using >> password: YES) >> ../config/../vendor/rails/activerecord/lib/active_record/ >> connection_adapters/mysql_adapter.rb:389:in `real_connect' >> ../config/../vendor/rails/activerecord/lib/active_record/ >> connection_adapters/mysql_adapter.rb:389:in `connect' >> ../config/../vendor/rails/activerecord/lib/active_record/ >> connection_adapters/mysql_adapter.rb:152:in `initialize' >> ../config/../vendor/rails/activerecord/lib/active_record/ >> connection_adapters/mysql_adapter.rb:82:in `mysql_connection' >> I'm sure that the PASSWORD IT'S CORRECT in database.yml: >> development: >> adapter: mysql >> database: behem0t_tracks >> username: behem0t_tracks >> password: mypassword >> production: >> adapter: mysql >> database: behem0t_tracks >> username: behem0t_tracks >> password: mypassword >> test: >> adapter: mysql >> database: tracks104 >> username: root >> password: >> I just can't think in anything else. >> Please help. >> Thanks. >> m k >> ps. Probably for this problem it's not relevante but my ruby >> version is ruby 1.8.4 (2005-12-24) [i386-linux] >> _______________________________________________ >> Tracks-discuss mailing list >> [email protected] >> http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss > _______________________________________________ Tracks-discuss mailing list [email protected] http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
