MySQL

Discussion in 'Call Flow Designer' started by mv.ape, Jun 8, 2017.

Thread Status:
Not open for further replies.
  1. mv.ape

    Joined:
    Feb 16, 2015
    Messages:
    24
    Likes Received:
    3
    Hello,

    In the "old" 3CX VAD it was possible to connect to a MySQL Database via ODBC.
    In the new 3CX CFD i read that only SQL Server and PostgreSQL are supported.

    Is there a way to connect to MySQL?

    Thanks
     
  2. edossantos

    edossantos Support Team
    Staff Member 3CX Support

    Joined:
    Jun 27, 2007
    Messages:
    1,262
    Likes Received:
    97
    Hi @mv.ape,

    Currently the database access component only supports SQL Server and PostgreSQL databases. We'll add other databases in the future, but MySQL is not available currently.

    However, what you can do is connecting to the database from a C# code file that you can write, and call that code from a "Launch External Script" component. Please note that you will need to write .NET Core C# code, so you will need the following connector:
    http://insidemysql.com/mysql-connector-net-for-net-core-1-0/

    This will also require that you copy the required DLLs from the connector to the 3CX installation folder.

    If you're running 3CX on Windows and want to use ODBC, you can create a web service in .NET that uses ODBC to connect to the database, and then consume this web service from the CFD app.

    Kind regards.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Gloria D

    Joined:
    Jul 11, 2017
    Messages:
    1
    Likes Received:
    0
    We are on 3CX v.15 trying to connect with BI and running into an error where the BI only supports PostgreSQL version 9.3. The current database PostgreSQL version is 9.2 for 3CX. Is there an upgrade available for 3CX to version 9.3?
     
  4. edossantos

    edossantos Support Team
    Staff Member 3CX Support

    Joined:
    Jun 27, 2007
    Messages:
    1,262
    Likes Received:
    97
    Hi @Gloria D,

    3CX comes with that version. You need to use 2 different databases, you will need to install it in another server and configure your software to access it remotely.

    Kind regards.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. tvdir

    Joined:
    Feb 17, 2017
    Messages:
    58
    Likes Received:
    15
    Hi @edossantos

    Is there an ETA for MySQL support?

    Rgds
     
  6. edossantos

    edossantos Support Team
    Staff Member 3CX Support

    Joined:
    Jun 27, 2007
    Messages:
    1,262
    Likes Received:
    97
    There is no ETA, and to be honest I'm not sure if it will be implemented at all... Please suggest the feature in the 3CX Ideas site, and if it gets enough votes, it might be developed.

    Meanwhile, if you really need to access MySQL you need to use the approach I suggested previously in this thread.

    Kind regards.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Thread Status:
Not open for further replies.