MySQL option (2 Viewers)

[dunkstar]

Hi fellow developers

I'm rather new to MediaPortal and C#
But I've been programming C++, PHP for a while.

I want to use and contribute to the TV Server.

I'm using a Via Epia Board for my server, so MS SQL Server Express isn't an option

I've downloaded the SVN sources and have had a look in the code from SharpDevelop.

I've added the Gentle.Provider.MySQL reference.
But it seems like you are using another SQL handler in the SetupDatabaseForm, eg. System.Data.SqlClient or is it just me?

Whatever I do it looks like its using the MS SQL connection.

 

[THDBASED]

OK this is basically my DREAMthread!!!!! I have been waiting for this for a long long time. I also use a VIA EPIA board as my server part of MediaPortal so I am also not able to run MS SQL...

If you need any help just let me know and I will see what I can do...

THDBASED

 

[FlipGer]

Hi,

also try contacting the DEVs on IRC.

Any help is always highly appreciated!

Flip.

 

[dunkstar]

Haven't had an IRC klient on my machine for years
Just have to install one

I want to contribute, just love the MediaPortal 0.2.2.0.

It would be so cool to have my small server run the TV server part...

I've only used SQLite in C# apps so I just have to get the idea with the Gentle Framework...
Have been using MySQL for about 7 years with PHP, so maybe I can get it working...

 

[dunkstar]

I've now come far with implementing MySQL option in the SetupDatabase Form.
But the database.sql file uses a lot of things that MySQL dont support.
I'm not sure to what level the statistics and index tables are used, because I cant create them in MySQL.

Should I send my work to someone from the crew???

 

[THDBASED]

Anyone from the DEV team willing to give him a hand?

I always thought SQL (language) was the standard for developing SQL Databases...

THDBASED

 

[samposoft]

MySql support

I have tested tvengine on mysql 5 and work fine.

I have found the following problems:
The SQL script work only on SQL Server (I have create the database and tables manually on mysql)
The SetupDatabaseForm on SetupTV application works only on SQL Server (I have commented the load of this form in the source code..)

I have modified the connection string and database in Gentle.config
I have add the missing dll from Gentle that is:
Gentle.Provider.MySQL.dll
MySql.Data.dll

I dont know if the develolpers plan to add mysql support to tvengine but this task is very simple ...

Sorry for my bad english...

 

[FlipGer]

Hi,

would be great, if you could cantact the DEVs. Afaik they would like to support different DBMS. MySQL would also be my first choice!

Flip.

 

[THDBASED]

I have tested tvengine on mysql 5 and work fine.

I have found the following problems:
The SQL script work only on SQL Server (I have create the database and tables manually on mysql)
The SetupDatabaseForm on SetupTV application works only on SQL Server (I have commented the load of this form in the source code..)

I have modified the connection string and database in Gentle.config
I have add the missing dll from Gentle that is:
Gentle.Provider.MySQL.dll
MySql.Data.dll

I dont know if the develolpers plan to add mysql support to tvengine but this task is very simple ...

Sorry for my bad english...

Oh my GOD, please would you contact the DEVS so they can implement this, I have been waiting for this from the beginning...

Thank you so much for working on this! You ROCK

THDBASED

 

[dunkstar]

I've already cahnged the SetupDatabaseForm so you can choose MySQL.
I have made it so the .net script converts the database.sql to a MySQL compatilble sql file, so when they update the MSSQL file, the script just converts it.
BUT they use some tables that MySQL dont support, and I cannot see where they are used.
Maybe we can just leave them out.

Anybody interested in seeing my work?