Schema not properly created on first start

[jbrtrnd]

System overview :

• Ubuntu Server 13.04
• Tomcat 7
• MySQL 5.5

I've started from a clean and fresh installation of my server. With only OpenSSH, Apache2 and Tomcat installed by the ubuntu server setup.

1. JDBC Driver class :

Error log :

WARNING: Failed to register in JMX: javax.naming.NamingException: com.mysql.jdbc.Driver

Solved by copying "path/to/tomcat_webapps_folder/ROOT/WEB-INF/lib/gems-gems-jdbc-mysql-5.1.24-lib-mysql-connector-java-5.1.24.jar" to "/usr/share/java/gems-gems-jdbc-mysql-5.1.24-lib-mysql-connector-java-5.1.24.jar"

2. DB Schema
I didn't fix it, so I can't setup jobsworth.

Error log :

ActiveRecord::JDBCError: Table 'jobsworth.tasks' doesn't exist: ALTER TABLE `tasks` ADD `milestone_id` int(11)

In my DB, the only tables created are "milestones" and "schema_migration".
Maybe a review of table creation order is necessary ?

[ari]

Thanks for your feedback on (1). I'll add some notes to the documentation about installing db drivers. As for (2)... looks like the automatic script which should install the schema isn't working right. I've asked my colleague to look at it.

[nelinnemann]

I have the exact same problems using a CentOS 6.4 x86_64 install.

Only the bare minimal.

tomcat6 and mysql

edited the context.xml to reflect my DB setup

did the same step 1 as jbrtrnd

Upload ROOT.war to /usr/share/tomcat6/webapps

go to 10.0.80.60:8080/ROOT

get this error

org.jruby.rack.RackInitializationException: An error has occurred, all later migrations canceled:

ActiveRecord::JDBCError: Table 'jwdb.tasks' doesn't exist: ALTER TABLE `tasks` ADD `milestone_id` int(11)

After restarting tomcat and reloading the page a new error occurs.

org.jruby.rack.RackInitializationException: An error has occurred, all later migrations canceled:

ActiveRecord::JDBCError: Table 'milestones' already exists: CREATE TABLE `milestones` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `company_id` int(11), `project_id` int(11), `user_id` int(11), `name` varchar(255), `description` text, `due_at` datetime, `position` int(11)) ENGINE=InnoDB DEFAULT CHARSET=utf8

[nelinnemann]

Hi
Well I would not let this stop me so I downloaded the tar.gz file of jobsworth v4.b1 and went through the install of ruby.

Adjusted the entries in config/database.yml and ran the bin/jobsworth setup.

After the creation of the database I can now sucessfully use jobsworth.

Its not an ideal approach but it works :-)

[ari]

Nicely done! Vikrant and I have just been talking about how to automate this, but that's one way to sort it out....

[nelinnemann]

Hi I can use a mysqldump of the jwdb on a new host but the encrypted password does not work on the new host.

I get to the login screen with no errors but I just cant login.

Is there any way to reset the password when email is not running?

For reference here is the mysqldump sql

https://docs.google.com/file/d/0BxalvZxv-zSEOWJ0WnoxN25Iek0/edit?usp=sharing

[ari]

Unfortunately email is the only way since the passwords are salted and hashed. This is actually a feature...

[blakkheimgw]

Hello,

I encounter the same issue when installing the app from the .war package. The error message is :

ActiveRecord::JDBCError: Table 'jobsworth.tasks' doesn't exist: ALTER TABLE tasks ADD milestone_id int(11)

Is there any fix for this one ?

Regards.

[nasa42]

We have acknowledged this issue and a fix is coming in beta2.

Cheers.

• Vikrant

On 28 August 2013 19:59, blakkheimgw notifications@github.com wrote:

Hello,

I encounter the same issue when installing the app from the .war package.
The error message is :

ActiveRecord::JDBCError: Table 'jobsworth.tasks' doesn't exist: ALTER
TABLE tasks ADD milestone_id int(11)

Is there any fix for this one ?

Regards.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/442#issuecomment-23418772
.

[blakkheimgw]

Ok, thanks ;)

Is there a way to test the app anyway ? And what is the approximative release date of the beta 2 ?

Regards.

[ari]

If you know Rails you can use rake to run the schema load task.

[sasselin]

.... how to install this with ruby? Not ROOT.war... have the same error

[eresonance]

Thanks for fixing this, I just ran into this issue today!

Is there a way we could get a new .war file or is the beta2 still a ways-away yet?

[Slind14]

@nelinnemann How did you fix this, I don´t get it working ?

@ari Is it possible to update the beta (alpha ?), that it is useable ?

[balojs]

nelinnemann
How did you fix this, I don´t get it working ?