Topic: Troubleshooting Installation of Mingle / 2.0 installation fails on XP-SP2

Hi David,

your help is highly appriciated.

It was indeed the MySQL configuration. After I changed the 2 entries you mentioned in “my.cnf”, the installation finished successfully.

Kind Regards

Werner

Topic: Troubleshooting Installation of Mingle / 2.0 installation fails on XP-SP2

After successfully trialling mingle 1.1, I wanted to check out the goodies of 2.0 – without success. I checked all log-files etc. No clue what’s wrong here…all hints are welcome…

Installation of 2.0 fails with that message:

“The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.”

Apache 2.2.6, MySQL 5.0.45 are up and running – checked with phpadmin; fresh, empty, utf-8 encoded database “mingle”, all rights for user “root”, no password.

mingle.log says:

2008-04-17 21:42:16,406 [org.mortbay.log] Logging to org.slf4j.impl.Log4jLoggerAdapter(org.mortbay.log) via org.mortbay.log.Slf4jLog
2008-04-17 21:42:16,531 [org.mortbay.log] jetty-6.1.5
2008-04-17 21:42:16,625 [org.mortbay.log] NO JSP Support for /, did not find org.apache.jasper.servlet.JspServlet
2008-04-17 21:42:22,093 [/] JRuby init time: 1625ms
2008-04-17 21:42:33,500 [/] Mingle 2_0 (r8323)

2008-04-17 21:42:33,500 [/] Using data directory D:\mingle

2008-04-17 21:42:33,515 [/] Rails init time: 10844ms
2008-04-17 21:42:33,515 [/] Runtime 0 loaded
2008-04-17 21:42:33,515 [/] Requests can now be processed
2008-04-17 21:42:42,859 [/] Mingle 2_0 (r8323)

2008-04-17 21:42:42,859 [/] Using data directory D:\mingle

2008-04-17 21:42:42,859 [/] Runtime 1 loaded
2008-04-17 21:42:42,906 [/] Could not reconnect because there is no D:\mingle/config/database.yml file

2008-04-17 21:42:42,906 [/] Need install: could not connect to database: ActiveRecord::ConnectionNotEstablished

2008-04-17 21:42:43,281 [org.mortbay.log] Started SelectChannelConnector@0.0.0.0:8080
2008-04-17 21:42:56,453 [/]

Processing ProjectsController#index (for 127.0.0.1 at 2008-04-17 21:42:56) [GET]

2008-04-17 21:42:56,453 [/] Session ID: c17783de2c51457aa4b095b6449a0435

2008-04-17 21:42:56,453 [/] Parameters: {“controller”=>”projects”, “action”=>”index”}

2008-04-17 21:42:56,468 [/] Could not reconnect because there is no D:\mingle/config/database.yml file

2008-04-17 21:42:56,468 [/] Need install: could not connect to database: ActiveRecord::ConnectionNotEstablished

2008-04-17 21:42:56,500 [/] Redirected to http://localhost:8080/install

2008-04-17 21:42:56,500 [/] Filter chain halted as [#<actioncontroller::filters::classmethods::symbolfilter:0xdf550d>] returned false.

2008-04-17 21:42:56,531 [/] Completed in 0.03813 (26 reqs/sec) | 302 Found [http://localhost/]

2008-04-17 21:42:57,140 [/]

Processing InstallController#index (for 127.0.0.1 at 2008-04-17 21:42:57) [GET]

2008-04-17 21:42:57,140 [/] Session ID: c17783de2c51457aa4b095b6449a0435

2008-04-17 21:42:57,140 [/] Parameters: {“controller”=>”install”, “action”=>”index”}

2008-04-17 21:42:57,140 [/] Could not reconnect because there is no D:\mingle/config/database.yml file

2008-04-17 21:42:57,140 [/] Need install: could not connect to database: ActiveRecord::ConnectionNotEstablished

2008-04-17 21:42:57,140 [/] Could not reconnect because there is no D:\mingle/config/database.yml file

2008-04-17 21:42:57,140 [/] Rendering within layouts/application

2008-04-17 21:42:57,140 [/] Rendering install/index

2008-04-17 21:42:57,328 [/] Completed in 0.15647 (6 reqs/sec) | Rendering: 0.15347 (98%) | 200 OK [http://localhost/install]

2008-04-17 21:43:02,984 [/]

Processing InstallController#connect (for 127.0.0.1 at 2008-04-17 21:43:02) [POST]

2008-04-17 21:43:02,984 [/] Session ID: c17783de2c51457aa4b095b6449a0435

2008-04-17 21:43:02,984 [/] Parameters: {“commit”=>”Get started »”, “controller”=>”install”, “action”=>”connect”}

2008-04-17 21:43:03,015 [/] Could not reconnect because there is no D:\mingle/config/database.yml file

2008-04-17 21:43:03,015 [/] Need install: could not connect to database: ActiveRecord::ConnectionNotEstablished

2008-04-17 21:43:03,015 [/] Could not reconnect because there is no D:\mingle/config/database.yml file

2008-04-17 21:43:03,109 [/] Rendering within layouts/application

2008-04-17 21:43:03,109 [/] Rendering install/connect

2008-04-17 21:43:03,375 [/] Completed in 0.37901 (2 reqs/sec) | Rendering: 0.26150 (68%) | 200 OK [http://localhost/install/connect]

2008-04-17 21:43:07,187 [/] Mingle 2_0 (r8323)

2008-04-17 21:43:07,187 [/] Using data directory D:\mingle

2008-04-17 21:43:07,187 [/] Runtime 2 loaded
2008-04-17 21:43:09,296 [/]

Processing InstallController#do_connect (for 127.0.0.1 at 2008-04-17 21:43:09) [POST]

2008-04-17 21:43:09,296 [/] Session ID: c17783de2c51457aa4b095b6449a0435

"commit"=>"Test connection and continue »", "controller"=>"install", "action"=>"do_connect"}

2008-04-17 21:43:09,312 [/] Could not reconnect because there is no D:\mingle/config/database.yml file

2008-04-17 21:43:09,312 [/] Need install: could not connect to database: ActiveRecord::ConnectionNotEstablished

2008-04-17 21:43:09,312 [/] Could not reconnect because there is no D:\mingle/config/database.yml file

2008-04-17 21:43:10,281 [/] Rendering actionconnectlayoutfalse within layouts/application

2008-04-17 21:43:10,281 [/] Rendering install/connect

2008-04-17 21:43:10,312 [/] Completed in 1.01359 (0 reqs/sec) | Rendering: 0.03591 (3%) | 200 OK [http://localhost/install/do_connect]

2008-04-17 21:43:12,890 [/] Could not execute: FragmentCache.flush_all
C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:235:in `retrieve_connection’: (ActiveRecord::ConnectionNotEstablished) from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:1139:in `add_limit!’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:1101:in `construct_finder_sql’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:995:in `find_every’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:418:in `find’ from C:\Programme\Mingle-2_0\app\controllers\caching\fragment_cache.rb:4:in `flush_all’ from
2008-04-17 21:43:12,890 [/] flush_fragement_cache: FragmentCache.flush_all returning JRuby runtime to pool and will restart in 15 minutes.
2008-04-17 21:43:12,984 [/] Could not execute: RevisionsHeaderCaching.run_once
C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:235:in `retrieve_connection’: (ActiveRecord::ConnectionNotEstablished) from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:1456:in `quote_bound_value’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:1427:in `replace_bind_variables’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:1427:in `gsub’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:1427:in `replace_bind_variables’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:1416:in `sanitize_sql_array’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:1387:in `sanitize_sql’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:1163:in `add_conditions!’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:1096:in `construct_finder_sql’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:995:in `find_every’ from C:/Programme/Mingle-2_0/vendor/rails/activerecord/lib/active_record/base.rb:418:in `find’ from C:\Programme\Mingle-2_0\lib\mingle_plugins\source.rb:63:in `find_all_marked_for_deletion’ from C:\Programme\Mingle-2_0\lib\mingle_plugins\source.rb:62:in `each’ from C:\Programme\Mingle-2_0\lib\mingle_plugins\source.rb:62:in `find_all_marked_for_deletion’ from C:\Programme\Mingle-2_0\app\jobs\revisions_header_caching.rb:6:in `run_once’ from
2008-04-17 21:43:12,984 [/] cache_revisions: RevisionsHeaderCaching.run_once returning JRuby runtime to pool and will restart in 15 minutes.
2008-04-17 21:43:24,656 [/] Mingle 2_0 (r8323)

2008-04-17 21:43:24,656 [/] Using data directory D:\mingle

2008-04-17 21:43:24,687 [/] Runtime 3 loaded
2008-04-17 21:43:25,562 [/]

Processing InstallController#do_connect (for 127.0.0.1 at 2008-04-17 21:43:25) [POST]

2008-04-17 21:43:25,593 [/] Session ID: c17783de2c51457aa4b095b6449a0435

"commit"=>"Test connection and continue »", "controller"=>"install", "action"=>"do_connect"}

2008-04-17 21:43:25,781 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:43:26,046 [/] Rendering actionconnectlayoutfalse within layouts/application

2008-04-17 21:43:26,046 [/] Rendering install/connect

2008-04-17 21:43:26,156 [/] Completed in 0.55534 (1 reqs/sec) | Rendering: 0.10975 (19%) | 200 OK [http://localhost/install/do_connect]

2008-04-17 21:43:28,718 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:43:29,593 [/]

Processing InstallController#do_connect (for 127.0.0.1 at 2008-04-17 21:43:29) [POST]

2008-04-17 21:43:29,593 [/] Session ID: c17783de2c51457aa4b095b6449a0435

"commit"=>"Test connection and continue »", "controller"=>"install", "action"=>"do_connect"}

2008-04-17 21:43:30,390 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:43:30,546 [/] Rendering actionconnectlayoutfalse within layouts/application

2008-04-17 21:43:30,546 [/] Rendering install/connect

2008-04-17 21:43:30,593 [/] Completed in 0.99754 (1 reqs/sec) | Rendering: 0.05105 (5%) | 200 OK [http://localhost/install/do_connect]

2008-04-17 21:43:33,687 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:43:38,468 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:43:40,828 [/] Mingle 2_0 (r8323)

2008-04-17 21:43:40,828 [/] Using data directory D:\mingle

2008-04-17 21:43:40,828 [/] Runtime 4 loaded
2008-04-17 21:43:43,281 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:43:43,296 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:43:43,703 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:43:43,890 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:43:49,062 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:43:53,812 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:43:53,828 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:43:55,593 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:00,921 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:02,796 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:04,968 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:05,937 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:09,500 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:12,953 [/] Mingle 2_0 (r8323)

2008-04-17 21:44:12,953 [/] Using data directory D:\mingle

2008-04-17 21:44:12,953 [/] Runtime 5 loaded
2008-04-17 21:44:13,265 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:14,109 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:14,718 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:17,187 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:18,718 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:19,390 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:27,468 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:27,828 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:28,843 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:32,703 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:33,328 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:34,406 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:38,015 [/] Mingle 2_0 (r8323)

2008-04-17 21:44:38,015 [/] Using data directory D:\mingle

2008-04-17 21:44:38,031 [/] Runtime 6 loaded
2008-04-17 21:44:38,703 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:38,812 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:39,296 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:39,890 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:43,406 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:44,671 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:45,546 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:45,718 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:49,109 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:49,703 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:50,046 [/] Need install: could not connect to database: The driver encountered an error: java.sql.SQLException: Unknown initial character set index ‘48’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

2008-04-17 21:44:51,343 [/] Need install: could not connect to database: The driver encountered an error: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

• BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.BindException: Address already in use: connect
-snip-> stacktrace notshown here.