Unable to setup sonar using mySQL
Locked
Unable to setup sonar using mySQL
 
|
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 |
Re: 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:
|
RE: Unable to setup sonar using mySQL
|
|
Sorry I should have included that info |
Re: Unable to setup sonar using mySQL
|
|
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:
|
Re: Unable to setup sonar using mySQL
|
|
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 |
|
Try to execute sonar with "mvn org.codehaus.sonar:sonar-maven-plugin::sonar" instead of using 1.1-beta1.
I hope this help.
|
| Powered by Nabble | Edit this page |