Hello, I have been a happy tracks user now for several months (quite addicted really) and following an upgrade from Ubuntu 7.04 to 7.10, my tracks installation is now broken :(

Here are the details:
1. The version of Tracks you’re using : 1.043
2. The platform you have Tracks installed on (Windows, Mac or Linux): Linux Ubuntu 7.10
3. The browser you are using: Firefox 2.0.0.8
4. Any other relevant information (e.g. version of Ruby used, whether you are using Locomotive or InstantRails, etc.): Ruby 1.8 and Rubygems 0.9.4 (?) and I used this guide as my primary basis for the install: http://www.cooldown.com.ar/2006/12/16/install-tracks-on-ubuntu-or-debian/

So the upgrade went well, really well, except Tracks.  Everything else seems to have survived…

Now, when I go to my http://0.0.0.0:3000/ homepage, I get a bunch of text starting with:
wrong number of arguments (1 for 0)
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:551:in `initialize’

and it continues on down with a page and a half of lines along the lines of the second line.  I have attached a screen shot if it may help.

I have burned a bunch of hours trying to find the problem including checking all the configs, and installations and all, but nothing.  Really would appreciate if anyone can help me.

did you try to run ‘rake db:migrate’. Did it work?

btw, your screenshot is to small to be read. Perhaps copy-and-past of the error message?

maddentim, it sounds like something might be broken with your MySQL installation. Did you upgrade that too? Can you connect to your MySQL db directly from the command line?

To Reinier.  I had a bigger screen shot, but the forum only allows 75K attachments. here is the webpage text:

wrong number of arguments (1 for 0)
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:551:in `initialize’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:551:in `new’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:551:in `scramble41’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:141:in `real_connect’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:331:in `connect’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:88:in `initialize’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:37:in `new’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:37:in `mysql_connection’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in `send’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in `connection_without_query_cache=‘
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/query_cache.rb:54:in `connection=‘
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in `retrieve_connection’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/base.rb:696:in `columns’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/base.rb:704:in `columns_hash’
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/session/active_record_store.rb:103:in `setup_sessid_compatibility!‘
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/session/active_record_store.rb:77:in `find_by_session_id’
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/session/active_record_store.rb:281:in `initialize’
/var/www/tracks/script/../config/../vendor/rails/activerecord/lib/active_record/base.rb:794:in `silence’
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/session/active_record_store.rb:281:in `initialize’
/usr/lib/ruby/1.8/cgi/session.rb:273:in `new’
/usr/lib/ruby/1.8/cgi/session.rb:273:in `initialize’
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/cgi_process.rb:111:in `new’
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/cgi_process.rb:111:in `session’
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/cgi_process.rb:141:in `stale_session_check!‘
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/cgi_process.rb:107:in `session’
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/base.rb:885:in `assign_shortcuts_without_flash’
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/flash.rb:141:in `assign_shortcuts’
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/base.rb:373:in `process_without_filters’
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/filters.rb:364:in `process_without_session_management_support’
/var/www/tracks/script/../config/../vendor/rails/actionpack/lib/action_controller/session_management.rb:117:in `process’
/var/www/tracks/script/../config/../vendor/rails/railties/lib/dispatcher.rb:38:in `dispatch’
/var/www/tracks/script/../config/../vendor/rails/railties/lib/webrick_server.rb:115:in `handle_dispatch’
/var/www/tracks/script/../config/../vendor/rails/railties/lib/webrick_server.rb:81:in `service’
/usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service’
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run’
/usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread’
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start’
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread’
/usr/lib/ruby/1.8/webrick/server.rb:95:in `start’
/usr/lib/ruby/1.8/webrick/server.rb:92:in `each’
/usr/lib/ruby/1.8/webrick/server.rb:92:in `start’
/usr/lib/ruby/1.8/webrick/server.rb:23:in `start’
/usr/lib/ruby/1.8/webrick/server.rb:82:in `start’
/var/www/tracks/script/../config/../vendor/rails/railties/lib/webrick_server.rb:67:in `dispatch’
/var/www/tracks/script/../config/../vendor/rails/railties/lib/commands/servers/webrick.rb:59
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require’
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in `require’
/var/www/tracks/script/../config/../vendor/rails/activesupport/lib/active_support/dependencies.rb:136:in `require’
/var/www/tracks/script/../config/../vendor/rails/railties/lib/commands/server.rb:30
/var/www/tracks/script/server:3:in `require’
/var/www/tracks/script/server:3

to bsag:

I am not sure if my MySql got upgraded in the distribution upgrade or not.  MySQL is now at 5.0.45.  MySQL seems to be working fine.  I am able to see the tracks database (I backed it up and have checked the permissions, passwords, users, etc.  I have a MySQL query tool and can execute queries against the database so I think the MySQL is ok…

The webserver launches ok too (I think):

tim@tim-laptop:~$ sudo ruby /var/www/tracks/script/server -e production
[sudo] password for tim:
=> Booting WEBrick…
=> Rails application started on http://0.0.0.0:3000
=> Ctrl-C to shutdown server; call with—help for options
[2007-10-25 07:00:26] INFO WEBrick 1.3.1
[2007-10-25 07:00:26] INFO ruby 1.8.6 (2007-06-07) [i486-linux]
[2007-10-25 07:00:26] INFO WEBrick::HTTPServer#start: pid=24867 port=3000
127.0.0.1 - - [25/Oct/2007:07:00:34 CDT] “GET / HTTP/1.1” 500 5371
- -> /

I still have not resolved this after spending to much time on it.  I now suspect that the problem lies in the rubygem connection to MySQL.

When I try to do:

I get this error:

tim@tim-laptop:~/rubygems-0.9.4$ sudo gem install mysql
Select which gem to install for your platform (i486-linux)
1. mysql 2.7.3 (mswin32)
2. mysql 2.7.1 (mswin32)
3. mysql 2.7 (ruby)
4. mysql 2.6 (ruby)
5. Skip this gem
6. Cancel installation
> 3
Building native extensions.  This could take a while…
ERROR:  While executing gem ... (Gem::Installer::ExtensionBuildError)
  ERROR: Failed to build gem native extension.

ruby extconf.rb install mysql
extconf.rb:1:in `require’: no such file to load—mkmf (LoadError)
      from extconf.rb:1

Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/mysql-2.7 for inspection.
Results logged to /usr/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out
tim@tim-laptop:~/rubygems-0.9.4$

Just not sure what to do with it…

Well, I am proud of myself (sort of) as I seem to have fixed it.  I plugged one the errors into google which lead me here:

http://mentalized.net/journal/2006/01/24/no_such_file_to_load_mkmf/

who had me:

(edit) That enabled me to

gem install mysql

and tracks fired up once that worked.

So, I am very pleased to have tracks back working.  The only trouble is that when it came back up, my password for my tracks user didn’t work. 

Is there a way to reset the password from mysql??

(edit again, sorry about the multiple edits) I figured out how I hosed the password.  I had changed the salt thing in environment.rb which (i believe) scambles the password between the site and mysql.  So I changed it back to what it had been and boom, I’m in!

maddentim - 26 October 2007 04:24 AM

Is there a way to reset the password from mysql??

You can do it from script/console. It’s described on this thread.

Cheers from NYC,
Luke