[OSM-dev] set up test server

[Jonas Svensson]

On 26 Aug 2006 at 15:53, Immanuel Scholz wrote:

> Hi,
> 
> > 1. I can't create new account: "Internal Server Error". This is
> > some problem with the mysql settings which I have not really
> > understood so far. Minor problem I think.
> 
> "Internal Server Error" is spit out on almost any error. :-(
> 
> Look at the following places for help:
> 
> /var/log/apache2/access.log
> /var/log/apache2/error.log
> /var/log/apache2/osm.access.log
> /var/log/apache2/osm.error.log
> /tmp/localhost.log
> 
> Best, do one tail over all these files and put it to your desktop
> background or on the second monitor.

osm.error.log says:
[Sat Aug 26 15:07:49 2006] [error] mod_ruby: error in ruby
[Sat Aug 26 15:07:49 2006] [error] mod_ruby: 
/home/jonas/svn.openstreetmap.org/www.openstreetmap.org/ruby/api/osm
/dao.rb:239:in `close': MySQL server has gone away (Mysql::Error)
[Sat Aug 26 15:07:49 2006] [error] mod_ruby:   from 
/home/jonas/svn.openstreetmap.org/www.openstreetmap.org/ruby/api/osm
/dao.rb:239:in `call_sql'
[Sat Aug 26 15:07:49 2006] [error] mod_ruby:   from 
/home/jonas/svn.openstreetmap.org/www.openstreetmap.org/ruby/api/osm
/dao.rb:327:in `does_user_exist?'
[Sat Aug 26 15:07:49 2006] [error] mod_ruby:   from 
/home/jonas/svn.openstreetmap.org/www.openstreetmap.org/ruby/api/osm
/dao.rb:284:in `create_account'
[Sat Aug 26 15:07:49 2006] [error] mod_ruby:   from 
/home/jonas/svn.openstreetmap.org/www.openstreetmap.org/eruby/create
-account.rhtml:61
[Sat Aug 26 15:07:49 2006] [error] mod_ruby:   from (eval):117
[Sat Aug 26 15:07:49 2006] [error] mod_ruby:   from 
/usr/lib/ruby/1.8/apache/eruby-run.rb:116:in `run'
[Sat Aug 26 15:07:49 2006] [error] mod_ruby:   from 
/usr/lib/ruby/1.8/apache/eruby-run.rb:72:in `handler'

Seem like there is some problem with the connection to mysql. The 
users table in the database is empty. My servinfo.rb looks like 
this:
$DBSERVER = 'localhost'
$DATABASE= 'osm'
$USERNAME = 'root'
$PASSWORD = 'password'
$SERVER_NAME = '192.168.0.199'

and there is a database osm in mysql.  And no, I did not use 
password for password.  :-)

Btw, I have begun importing the planet-dump. Had to change a few ' 
to " in the perl script. If the import works I will try to check in 
that change. Seems like it will be a few hours...

/Jonas