[jira] Updated: (STONEHENGE-53) Make .Net stack work with MySQL

["Joby Abragan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/STONEHENGE-53?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Joby Abragan updated STONEHENGE-53:
-----------------------------------

    Attachment: Stonehenge53_3.patch

Here's a patch to make dotnet work with MySQL.

To make this work, you need to do the following:
  1)  Make sure that the MySql server database is set up.  We did this by running the mysql scripts in the php folder (..\php\resources\db_scripts\mysql).
  2) run the following in MySql command line:
          -  use stocktraderdb;
          -  insert into bstoops(bs, ops)
              values('DOTNET_BS', 'DOTNET_OPS');
          - insert into clienttobs(client, bs)
             values('DOTNET_CLIENT', 'DOTNET_BS');
          - update dbconfig set active = 'N' where dbname = 'MSSQL';
          - INSERT INTO dbconfig(dbname,hostname,port,active)
             VALUES ('MySQL', '127.0.0.1', 3306, 'Y');
  3) run the following in SQL Server:
          - update dbo.dbconfig set active = 'N' where dbname = 'MSSQL'
          - INSERT INTO dbo.dbconfig(dbname,hostname,port,active)
              VALUES ('MySQL', '127.0.0.1', 3306, 'Y')

> Make .Net stack work with MySQL
> -------------------------------
>
>                 Key: STONEHENGE-53
>                 URL: https://issues.apache.org/jira/browse/STONEHENGE-53
>             Project: Stonehenge
>          Issue Type: New Feature
>            Reporter: Chintana Wilamuna
>            Assignee: Joby Abragan
>             Fix For: M2
>
>         Attachments: Stonehenge53_3.patch
>
>
> .Net stack should work with MySQL database.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.