Quantcast

Unable to setup sonar using mySQL

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Unable to setup sonar using mySQL

mclark_114
trying to use mySQL


We're sorry, but something went wrong.

We've been notified about this issue and we'll take a look at it shortly.

<%= link_to "go back projects homepage", :controller=>"project" %>

following it he sonar log


2008.02.28 15:34:30 WARN  c.h.s.c.batch.Batch - Database must be updated. Please browse to your sonar server. Database required model version (9) does not match current version (0)
2008.02.28 15:35:40 ERROR rails.sonar -
 
ActiveRecord::StatementInvalid (NativeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Too big column length for column 'group_id' (max = 255). Use BLOB instead: CREATE TABLE projects (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `group_id` varchar(256) NOT NULL, `artifact_id` varchar(256) NOT NULL, `branch` varchar(64) NOT NULL, `name` varchar(256) DEFAULT NULL, `description` varchar(2000) DEFAULT NULL, `parent_project_id` integer(10) DEFAULT NULL, `enabled` tinyint(1) DEFAULT 1 NOT NULL) ENGINE=InnoDB):
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/ActiveRecord-JDBC-0.5/lib/active_record/connection_adapters/jdbc_adapter.rb:550:in `log_no_bench'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/ActiveRecord-JDBC-0.5/lib/active_record/connection_adapters/jdbc_adapter.rb:471:in `execute'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/schema_statements.rb:104:in `create_table'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/ActiveRecord-JDBC-0.5/lib/jdbc_adapter/jdbc_mysql.rb:123:in `create_table'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:275:in `send'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:275:in `method_missing'
    /app/controllers/../../db/migrate//001_initial_schema.rb:21:in `say_with_time'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:273:in `measure'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:259:in `say_with_time'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:273:in `method_missing'
    /app/controllers/../../db/migrate//001_initial_schema.rb:21:in `up'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:212:in `send'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:212:in `migrate'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:335:in `measure'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:212:in `migrate'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:335:in `migrate'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:297:in `each'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:330:in `migrate'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:297:in `up'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:288:in `migrate'
    /app/controllers/setup_controller.rb:42:in `setup_database'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/base.rb:1095:in `send'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/base.rb:1095:in `perform_action'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/filters.rb:632:in `call_filter'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/filters.rb:638:in `call_filter'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/filters.rb:619:in `call'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/filters.rb:637:in `call_filter'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/filters.rb:619:in `perform_action_with_filters'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:66:in `perform_action_with_benchmark'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/rescue.rb:83:in `measure'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:66:in `perform_action_with_benchmark'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/rescue.rb:83:in `perform_action_with_rescue'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/base.rb:430:in `send'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/base.rb:430:in `process'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/filters.rb:624:in `process_with_filters'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/session_management.rb:114:in `process_with_session_management_support'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/base.rb:330:in `process'
    /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/rails-1.2.3/lib/dispatcher.rb:41:in `dispatch'
    :1
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Unable to setup sonar using mySQL

Cédric Munger-2
Hi,

what version of sonar and mysql are you using ?

On Thu, Feb 28, 2008 at 9:37 PM, mclark_114 <[hidden email]> wrote:

trying to use mySQL


We're sorry, but something went wrong.

We've been notified about this issue and we'll take a look at it shortly.

<%= link_to "go back projects homepage", :controller=>"project" %>

following it he sonar log


2008.02.28 15:34:30 WARN  c.h.s.c.batch.Batch - Database must be updated.
Please browse to your sonar server. Database required model version (9) does
not match current version (0)
2008.02.28 15:35:40 ERROR rails.sonar -

ActiveRecord::StatementInvalid (NativeException:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Too big column length
for column 'group_id' (max = 255). Use BLOB instead: CREATE TABLE projects
(`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `group_id`
varchar(256) NOT NULL, `artifact_id` varchar(256) NOT NULL, `branch`
varchar(64) NOT NULL, `name` varchar(256) DEFAULT NULL, `description`
varchar(2000) DEFAULT NULL, `parent_project_id` integer(10) DEFAULT NULL,
`enabled` tinyint(1) DEFAULT 1 NOT NULL) ENGINE=InnoDB):

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/ActiveRecord-JDBC-0.5/lib/active_record/connection_adapters/jdbc_adapter.rb:550:in
`log_no_bench'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/ActiveRecord-JDBC-0.5/lib/active_record/connection_adapters/jdbc_adapter.rb:471:in
`execute'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/schema_statements.rb:104:in
`create_table'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/ActiveRecord-JDBC-0.5/lib/jdbc_adapter/jdbc_mysql.rb:123:in
`create_table'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:275:in
`send'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:275:in
`method_missing'
   /app/controllers/../../db/migrate//001_initial_schema.rb:21:in
`say_with_time'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:273:in
`measure'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:259:in
`say_with_time'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:273:in
`method_missing'
   /app/controllers/../../db/migrate//001_initial_schema.rb:21:in `up'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:212:in
`send'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:212:in
`migrate'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:335:in
`measure'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:212:in
`migrate'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:335:in
`migrate'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:297:in
`each'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:330:in
`migrate'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:297:in
`up'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.3/lib/active_record/migration.rb:288:in
`migrate'
   /app/controllers/setup_controller.rb:42:in `setup_database'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/base.rb:1095:in
`send'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/base.rb:1095:in
`perform_action'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/filters.rb:632:in
`call_filter'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/filters.rb:638:in
`call_filter'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/filters.rb:619:in
`call'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/filters.rb:637:in
`call_filter'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/filters.rb:619:in
`perform_action_with_filters'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:66:in
`perform_action_with_benchmark'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/rescue.rb:83:in
`measure'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:66:in
`perform_action_with_benchmark'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/rescue.rb:83:in
`perform_action_with_rescue'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/base.rb:430:in
`send'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/base.rb:430:in
`process'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/filters.rb:624:in
`process_with_filters'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/session_management.rb:114:in
`process_with_session_management_support'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-1.13.3/lib/action_controller/base.rb:330:in
`process'

/projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/rails-1.2.3/lib/dispatcher.rb:41:in
`dispatch'
   :1
--
View this message in context: http://www.nabble.com/Unable-to-setup-sonar-using-mySQL-tp15745457p15745457.html
Sent from the Sonar mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email



Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: Unable to setup sonar using mySQL

mclark_114
RE: [sonar-user] Unable to setup sonar using mySQL

Sorry I should have included that info
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
sonar 1.0


-----Original Message-----
From: [hidden email] on behalf of Cédric Munger
Sent: Thu 2/28/2008 4:01 PM
To: [hidden email]
Subject: Re: [sonar-user] Unable to setup sonar using mySQL

Hi,

what version of sonar and mysql are you using ?

On Thu, Feb 28, 2008 at 9:37 PM, mclark_114 <[hidden email]> wrote:

>
> trying to use mySQL
>
>
> We're sorry, but something went wrong.
>
> We've been notified about this issue and we'll take a look at it shortly.
>
> <%= link_to "go back projects homepage", :controller=>"project" %>
>
> following it he sonar log
>
>
> 2008.02.28 15:34:30 WARN  c.h.s.c.batch.Batch - Database must be updated.
> Please browse to your sonar server. Database required model version (9)
> does
> not match current version (0)
> 2008.02.28 15:35:40 ERROR rails.sonar -
>
> ActiveRecord::StatementInvalid (NativeException:
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Too big column length
> for column 'group_id' (max = 255). Use BLOB instead: CREATE TABLE projects
> (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `group_id`
> varchar(256) NOT NULL, `artifact_id` varchar(256) NOT NULL, `branch`
> varchar(64) NOT NULL, `name` varchar(256) DEFAULT NULL, `description`
> varchar(2000) DEFAULT NULL, `parent_project_id` integer(10) DEFAULT NULL,
> `enabled` tinyint(1) DEFAULT 1 NOT NULL) ENGINE=InnoDB):
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/ActiveRecord-
> JDBC-0.5/lib/active_record/connection_adapters/jdbc_adapter.rb:550:in
> `log_no_bench'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/ActiveRecord-
> JDBC-0.5/lib/active_record/connection_adapters/jdbc_adapter.rb:471:in
> `execute'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3
> /lib/active_record/connection_adapters/abstract/schema_statements.rb:104:in
> `create_table'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/ActiveRecord-
> JDBC-0.5/lib/jdbc_adapter/jdbc_mysql.rb:123:in
> `create_table'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:275:in
> `send'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:275:in
> `method_missing'
>    /app/controllers/../../db/migrate//001_initial_schema.rb:21:in
> `say_with_time'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:273:in
> `measure'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:259:in
> `say_with_time'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:273:in
> `method_missing'
>    /app/controllers/../../db/migrate//001_initial_schema.rb:21:in `up'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:212:in
> `send'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:212:in
> `migrate'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:335:in
> `measure'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:212:in
> `migrate'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:335:in
> `migrate'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:297:in
> `each'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:330:in
> `migrate'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:297:in
> `up'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:288:in
> `migrate'
>    /app/controllers/setup_controller.rb:42:in `setup_database'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/base.rb:1095:in
> `send'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/base.rb:1095:in
> `perform_action'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/filters.rb:632:in
> `call_filter'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/filters.rb:638:in
> `call_filter'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/filters.rb:619:in
> `call'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/filters.rb:637:in
> `call_filter'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/filters.rb:619:in
> `perform_action_with_filters'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/benchmarking.rb:66:in
> `perform_action_with_benchmark'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/rescue.rb:83:in
> `measure'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/benchmarking.rb:66:in
> `perform_action_with_benchmark'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/rescue.rb:83:in
> `perform_action_with_rescue'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/base.rb:430:in
> `send'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/base.rb:430:in
> `process'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/filters.rb:624:in
> `process_with_filters'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/session_management.rb:114:in
> `process_with_session_management_support'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/base.rb:330:in
> `process'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/rails-1.2.3
> /lib/dispatcher.rb:41:in
> `dispatch'
>    :1
> --
> View this message in context:
> http://www.nabble.com/Unable-to-setup-sonar-using-mySQL-tp15745457p15745457.html
> Sent from the Sonar mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
>    http://xircles.codehaus.org/manage_email
>
>
>

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Unable to setup sonar using mySQL

Cédric Munger-2
Ok thanks, FYI we've done all our tests with mysql 5.5, so your issue is due to the 3.3 version that we do not support ( more exactly a lib we're using :) )
We've also released version 1.1 of sonar (http://sonar.hortis.ch/downloads/). So I suggest you to give it another try with sonar 1.1 and mysql 5.5.
Sonar 1.0.2 + mysql 5.5 also works without problems.

Regards

On Fri, Feb 29, 2008 at 12:34 AM, Clark, Michael <[hidden email]> wrote:

Sorry I should have included that info
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
sonar 1.0




-----Original Message-----
From: [hidden email] on behalf of Cédric Munger
Sent: Thu 2/28/2008 4:01 PM
To: [hidden email]
Subject: Re: [sonar-user] Unable to setup sonar using mySQL

Hi,

what version of sonar and mysql are you using ?

On Thu, Feb 28, 2008 at 9:37 PM, mclark_114 <[hidden email]> wrote:

>
> trying to use mySQL
>
>
> We're sorry, but something went wrong.
>
> We've been notified about this issue and we'll take a look at it shortly.
>
> <%= link_to "go back projects homepage", :controller=>"project" %>
>
> following it he sonar log
>
>
> 2008.02.28 15:34:30 WARN  c.h.s.c.batch.Batch - Database must be updated.
> Please browse to your sonar server. Database required model version (9)
> does
> not match current version (0)
> 2008.02.28 15:35:40 ERROR rails.sonar -
>
> ActiveRecord::StatementInvalid (NativeException:
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Too big column length
> for column 'group_id' (max = 255). Use BLOB instead: CREATE TABLE projects
> (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `group_id`
> varchar(256) NOT NULL, `artifact_id` varchar(256) NOT NULL, `branch`
> varchar(64) NOT NULL, `name` varchar(256) DEFAULT NULL, `description`
> varchar(2000) DEFAULT NULL, `parent_project_id` integer(10) DEFAULT NULL,
> `enabled` tinyint(1) DEFAULT 1 NOT NULL) ENGINE=InnoDB):
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/ActiveRecord-
> JDBC-0.5/lib/active_record/connection_adapters/jdbc_adapter.rb:550:in
> `log_no_bench'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/ActiveRecord-
> JDBC-0.5/lib/active_record/connection_adapters/jdbc_adapter.rb:471:in
> `execute'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3
> /lib/active_record/connection_adapters/abstract/schema_statements.rb:104:in
> `create_table'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/ActiveRecord-
> JDBC-0.5/lib/jdbc_adapter/jdbc_mysql.rb:123:in
> `create_table'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:275:in
> `send'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:275:in
> `method_missing'
>    /app/controllers/../../db/migrate//001_initial_schema.rb:21:in
> `say_with_time'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:273:in
> `measure'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:259:in
> `say_with_time'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:273:in
> `method_missing'
>    /app/controllers/../../db/migrate//001_initial_schema.rb:21:in `up'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:212:in
> `send'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:212:in
> `migrate'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:335:in
> `measure'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:212:in
> `migrate'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:335:in
> `migrate'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:297:in
> `each'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:330:in
> `migrate'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:297:in
> `up'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/activerecord-
> 1.15.3/lib/active_record/migration.rb:288:in
> `migrate'
>    /app/controllers/setup_controller.rb:42:in `setup_database'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/base.rb:1095:in
> `send'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/base.rb:1095:in
> `perform_action'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/filters.rb:632:in
> `call_filter'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/filters.rb:638:in
> `call_filter'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/filters.rb:619:in
> `call'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/filters.rb:637:in
> `call_filter'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/filters.rb:619:in
> `perform_action_with_filters'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/benchmarking.rb:66:in
> `perform_action_with_benchmark'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/rescue.rb:83:in
> `measure'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/benchmarking.rb:66:in
> `perform_action_with_benchmark'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/rescue.rb:83:in
> `perform_action_with_rescue'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/base.rb:430:in
> `send'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/base.rb:430:in
> `process'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/filters.rb:624:in
> `process_with_filters'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/session_management.rb:114:in
> `process_with_session_management_support'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/actionpack-
> 1.13.3/lib/action_controller/base.rb:330:in
> `process'
>
> /projects/home/build05/sonar/lib/sonar-web/WEB-INF/gems/gems/rails-1.2.3
> /lib/dispatcher.rb:41:in
> `dispatch'
>    :1
> --
> View this message in context:
> http://www.nabble.com/Unable-to-setup-sonar-using-mySQL-tp15745457p15745457.html
> Sent from the Sonar mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
>    http://xircles.codehaus.org/manage_email
>
>
>


Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Unable to setup sonar using mySQL

mclark_114
In reply to this post by mclark_114
Thanks for the direction, that got me a bit further. Now I tried something simple like building my system wide POM and I get the following

[INFO] [checkstyle:checkstyle]
[INFO] Source directory does not exist - skipping report.
[ERROR] Cannot execute the command org.codehaus.sonar:sonar-core-maven-plugin:1.1-beta1:project
org.apache.maven.BuildFailureException: Required goal not found: org.codehaus.sonar:sonar-core-maven-plugin:1.1-beta1:project
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.getMojoDescriptor(DefaultLifecycleExecutor.java:1538)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.segmentTaskListByAggregationNeeds(DefaultLifecycleExecutor.java:386)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:138)
        at ch.hortis.sonar.mvn.SonarMavenEmbedder.execute(SonarMavenEmbedder.java:157)
        at ch.hortis.sonar.mvn.SonarMojo.executeMaven(SonarMojo.java:215)
        at ch.hortis.sonar.mvn.SonarMojo.executeGoals(SonarMojo.java:198)
        at ch.hortis.sonar.mvn.SonarMojo.execute(SonarMojo.java:102)
        at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:443)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:539)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:493)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:463)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:311)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:224)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:143)
        at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:334)
        at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:125)
        at org.apache.maven.cli.MavenCli.main(MavenCli.java:272)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
        at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
        at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
        at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
[INFO] ------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO] ------------------------------------------------------------------------
[INFO] Cannot execute the command org.codehaus.sonar:sonar-core-maven-plugin:1.1-beta1:project

Embedded error: Required goal not found: org.codehaus.sonar:sonar-core-maven-plugin:1.1-beta1:project
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Unable to setup sonar using mySQL

bancha
Try to execute sonar with "mvn org.codehaus.sonar:sonar-maven-plugin::sonar" instead of using 1.1-beta1.

I hope this help.

mclark_114 wrote
Thanks for the direction, that got me a bit further. Now I tried something simple like building my system wide POM and I get the following

[INFO] [checkstyle:checkstyle]
[INFO] Source directory does not exist - skipping report.
[ERROR] Cannot execute the command org.codehaus.sonar:sonar-core-maven-plugin:1.1-beta1:project
org.apache.maven.BuildFailureException: Required goal not found: org.codehaus.sonar:sonar-core-maven-plugin:1.1-beta1:project
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.getMojoDescriptor(DefaultLifecycleExecutor.java:1538)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.segmentTaskListByAggregationNeeds(DefaultLifecycleExecutor.java:386)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:138)
        at ch.hortis.sonar.mvn.SonarMavenEmbedder.execute(SonarMavenEmbedder.java:157)
        at ch.hortis.sonar.mvn.SonarMojo.executeMaven(SonarMojo.java:215)
        at ch.hortis.sonar.mvn.SonarMojo.executeGoals(SonarMojo.java:198)
        at ch.hortis.sonar.mvn.SonarMojo.execute(SonarMojo.java:102)
        at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:443)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:539)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:493)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:463)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:311)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:224)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:143)
        at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:334)
        at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:125)
        at org.apache.maven.cli.MavenCli.main(MavenCli.java:272)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
        at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
        at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
        at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
[INFO] ------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO] ------------------------------------------------------------------------
[INFO] Cannot execute the command org.codehaus.sonar:sonar-core-maven-plugin:1.1-beta1:project

Embedded error: Required goal not found: org.codehaus.sonar:sonar-core-maven-plugin:1.1-beta1:project
Loading...