JOSSO

Test Connection and Test Query not working

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: JOSSO 2.0.2
  • Fix Version/s: None
  • Component/s: None
  • Description:
    Hide
    I create a DB Identity source

    Name : DB-ID1
    Driver: JDBC ODBC Bridge
    connection url : jdbc:mysql://localhost:3306/test_db
    username=xyz
    password=xyz

    and clicked Test Connection. I didnt get any response. I'm using MySQL not sure whether I should give a different driver. Drop down is showing only one item though

    Thank You
    Marshal
    Show
    I create a DB Identity source Name : DB-ID1 Driver: JDBC ODBC Bridge connection url : jdbc:mysql://localhost:3306/test_db username=xyz password=xyz and clicked Test Connection. I didnt get any response. I'm using MySQL not sure whether I should give a different driver. Drop down is showing only one item though Thank You Marshal
  • Environment:
    Windows 7

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Marshal Jayason added a comment - 15/Feb/11 2:05 PM
I forgot to mention that I'm facing this issue while using Josso2 visual designer
Show
Marshal Jayason added a comment - 15/Feb/11 2:05 PM I forgot to mention that I'm facing this issue while using Josso2 visual designer
Gianluca Brigandi made changes - 15/Feb/11 2:52 PM
Field Original Value New Value
Assignee Sebastian Gonzalez Oyuela [ sgonzalez ] Gianluca Brigandi [ gbrigand ]
Hide
Permalink
Gianluca Brigandi added a comment - 15/Feb/11 3:05 PM
Make sure that :
* The MySQL ODBC driver is installed in the host running JOSSO2
* A DSN (Data Source Name) for the database holding user and entitlement tables has been setup

The connection URL should have the following format :
jdbc:odbc:DSN[;user=xxx][;password=xxx]
Show
Gianluca Brigandi added a comment - 15/Feb/11 3:05 PM Make sure that : * The MySQL ODBC driver is installed in the host running JOSSO2 * A DSN (Data Source Name) for the database holding user and entitlement tables has been setup The connection URL should have the following format : jdbc:odbc:DSN[;user=xxx][;password=xxx]
Gianluca Brigandi made changes - 15/Feb/11 3:05 PM
Resolution Fixed [ 1 ]
Status Open [ 1 ] Resolved [ 5 ]
Hide
Permalink
Marshal Jayason added a comment - 15/Feb/11 3:40 PM
How to ensure MySQL ODBC driver is installed in the host running JOSSO2 ?
Show
Marshal Jayason added a comment - 15/Feb/11 3:40 PM How to ensure MySQL ODBC driver is installed in the host running JOSSO2 ?
Hide
Permalink
Gianluca Brigandi added a comment - 16/Feb/11 6:50 AM
Go to your control panel then Administrative Tools > Data Sources(ODBC)
Preview

The System DSN tab should show the MySQL entry.

For more information refer to Microsoft official documentation.


Show
Gianluca Brigandi added a comment - 16/Feb/11 6:50 AM Go to your control panel then Administrative Tools > Data Sources(ODBC) Preview The System DSN tab should show the MySQL entry. For more information refer to Microsoft official documentation.
Gianluca Brigandi made changes - 16/Feb/11 6:50 AM
Status Resolved [ 5 ] Closed [ 6 ]
Hide
Permalink
Srdjan added a comment - 27/Oct/12 7:01 AM
Hello,

I have the same problem, when I click test database I don't get any action at all, not any error or response, like program is dead.
I have tried mysql and sql server connection trough ODBC Data Source Administrator and test was successful.
Can you help me please.

Thanks,

Srdjan
Show
Srdjan added a comment - 27/Oct/12 7:01 AM Hello, I have the same problem, when I click test database I don't get any action at all, not any error or response, like program is dead. I have tried mysql and sql server connection trough ODBC Data Source Administrator and test was successful. Can you help me please. Thanks, Srdjan
This list of changesets may be incomplete, as errors occurred retrieving changesets from the following repositories:
This list of reviews may be incomplete, as errors occurred retrieving data from the following repositories:

People

Dates

  • Created:
    14/Feb/11 10:56 AM
    Updated:
    27/Oct/12 7:01 AM
    Resolved:
    15/Feb/11 3:05 PM
Atlassian JIRA (v4.1.2#531) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for JOSSO. Try JIRA - bug tracking software for your team.