Data Dynamics Reports with TLSv1.2 trouble

Posted by: woongahkimgmail-com on 3 August 2017, 3:23 pm EST

  • Posted 3 August 2017, 3:23 pm EST

    We are using dynamic report in our projects. By the way after applying MySQL 5.7.11(TLSv1.2), there is an exception error from data dynamic report when I run data dynamic reports.

    I attached a word file what actually happened.

    Please read it and reply me. I really want to hear your answer.

    Thanks!
    2016/04/Please-Fix-it.docx
  • Replied 3 August 2017, 3:23 pm EST

    Hello,

    We are looking into this issue and will get back to you as soon as possible.

    Regards,
    Reema
  • Replied 3 August 2017, 3:23 pm EST

    Isn't there anyone???

    Please help me...

    OTL
  • Replied 3 August 2017, 3:23 pm EST

    Hello,

    I have escalated this issue to the concerned team(202937) for further review on this and will get back to you as soon as I hear back from them.

    Regards,
    Reema
  • Replied 3 August 2017, 3:23 pm EST

    Hello woongah,

    Please refer to the attached project which works correctly at our end with DDR reports bound to MySQL database.
    Also, we were able to observe issues at our end as reported by you [u]since the root password contained some special characters[/u].

    I suggest you to please set a root password that does not contains any special character. Here is the command for the same :
    SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword')


    You may also have a look at the following links wherein similar issues have been discussed :

    http://www.biblewheel.com/forum/showthread.php?3156-MySQL-Connection-Failed-HY000-MySQL-ODBC-3-51-Driver-Access-denied-for-user
    https://support.software.dell.com/spotlight-on-mysql/kb/19126
    https://bugs.mysql.com/bug.php?id=38285
    http://forums.mysql.com/read.php?37,191691,193113#msg-193113
    https://support.software.dell.com/spotlight-on-mysql/kb/19126
    https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-5-1-6.html

    Hope this helps.

    I would like to mention here that this doesn't seems to be a DDR specific issue but a generic issue. Therefore, as a suggestion, you are requested to test the issues against a simple .NET application and see if issues persists while connecting to MySQL database and displaying the data in an MS grid. You may share your observations if the issues seem specific to DDR.

    Regards,
    Reema
    2016/05/ODBCReport.zip
  • Replied 3 August 2017, 3:23 pm EST

    Hello,

    When trying to bind a report with the MySQL database, the report was created correctly. However, we were not able to test the issue with SSL certifications that you have mentioned.

    I request you to please let us know :
    - how you have exactly applied the SSL Certifications(TLSv1.2) on the MySQL.
    - If possible, share a video demonstrating the exact steps to reproduce the issue.

    Meanwhile, we are also looking into this.

    [u]Our Environmental Details : [/u]
    Windows7 32 bit machine + VS2005
    MySQL 5.7.12 (latest)
    DDR version : 1.6.1871.61

    Regards,
    Reema
  • Replied 3 August 2017, 3:23 pm EST

    Hello,

    we're still struggling to solve this issue because there is no one who knows about this module well. That developer went off... OTL

    I don't get what it really means:
    "how you have exactly applied the SSL Certifications(TLSv1.2) on the MySQL."

    we sent MySQL environment about SSL Certifications.

    So could you please send us sample projects or any screenshots??

    we basically want to know how to set DDR variables and any environments.(From A to Z)

    I really appreciate your help.


    Regards,
    woongah kim
  • Replied 3 August 2017, 3:23 pm EST

    Hello Woongah,

    I would request you to please elaborate a bit more on what you exactly meant by "DDR variables and any environments" ? what exactly do the DDr variables refer to here ?

    Please refer to the documentation link which might help you out and let us know the exact terms for the issues faced ?

    Also, what sample project or screenshot you wish to have from us ? Please elaborate..

    Regards,
    Reema
  • Replied 3 August 2017, 3:23 pm EST

    Hello Reema,

    I attached our project file.

    There are screen shot how to make connection string in project and C# source code.

    and I'm curious about it is possible to connect MySQL 5.7.11 with mysql odbc 3.51 driver.

    Because our client program use a "mysql odbc 3.51 driver" and server is MySQL 5.7.11.

    so could you give me a your test environment information or sample project? For example, "connection string", "mysql odbc driver version" , and sample projects that has a correct connection string.


    Our server database version:
    Now: MySQL 5.7.11(Server)
    Previous: MySQL 5.6.14(Server)

    In MySQL 5.7.11(Server)
    mysql> SHOW GLOBAL VARIABLES LIKE 'tls_version';
    +------------------+-------------------------+
    | Variable_name | Value |
    +------------------+-------------------------+
    | tls_version | TLSv1,TLSv1.1,TLSv1.2 |
    +------------------+-------------------------+
    2016/05/Report-Project.zip
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels