I am receiving this error when I attempt to test the Fisheye connection, even though I unchecked the Crucible option during the initial setup.
I setup a mySQL database and user as seen below. The SQL database is running on a separate server from the Fisheye install.
CREATE DATABASE fish_db character set utf8;
CREATE USER 'fishdbuser'@'%' IDENTIFIED BY 'passwd';
GRANT ALL PRIVILEGES ON fish_db.* TO 'fishdbuser'@'192.168.200.14' IDENTIFIED BY 'passwd' WITH GRANT OPTION;
On the Database Configuration page my settings are:
Type: MySQL
Driver Location: Bundled
URL: jdbc:mysql:192.168.200.14:3306/fish_db
User Name: fishdbuser
Password: passwd
Minimum Pool Connections: 5
Maxiumum Pool Connections: 20
Parameters: useUnicode=true
characterEncoding=UTF8
connectionCollation=UTF8_bin
I've logged into the SQL server and performed the following with success:
use fish_db;
show databases;
+--------------------------------------+
| Database |
+---------------------------------------
| information_schema |
| crowd_db |
| fish_db |
| jira_db |
| mysql |
+---------------------------------------+
As you can see, I have both jira and crowd databases working from this same instance. I don't understand why Crucible is even being considered when I unchecked the box for the Crucible setup.
I've dropped the database and user a few times and recreated, but that hasn't resolved the issue. I've flushed the privileges as well, but nothing seems to work.
Use collation utf8_bin for the database and it should work.
Hi All,
I am getting the same error for MSSQL server 2008. I have given connectionCollation='SQL_Latin1_General_CP1_CI_AS' but same error.
Can any one please guide what are the require parameters need to defined for SQLSERVER2008 connection?
Thanks,
Suchi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.