MySQL option

dunkstar · 2007-01-08, 14:44

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 · 2007-01-08, 18:06

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 · 2007-01-08, 18:32

Hi,

also try contacting the DEVs on IRC.

Any help is always highly appreciated!

Flip.

dunkstar · 2007-01-08, 19:08

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 · 2007-01-11, 11:22

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 · 2007-01-11, 12:41

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 · 2007-01-14, 22:50

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 · 2007-01-14, 23:28

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 · 2007-01-14, 23:31

Quote:

Originally Posted by samposoft

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 · 2007-01-15, 09:06

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?

2007-01-08, 14:44	#1 (permalink)
dunkstar Portal Member Join Date: Jan 2007 Age: 28 Posts: 14 Thanks: 0 Thanked 0 Times in 0 Posts Country:	MySQL option 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.

2007-01-11, 12:41	#6 (permalink)
THDBASED Portal Member Join Date: Jan 2006 Posts: 468 Thanks: 72 Thanked 2 Times in 2 Posts Country: My System	Anyone from the DEV team willing to give him a hand? I always thought SQL (language) was the standard for developing SQL Databases... THDBASED Last edited by THDBASED; 2007-01-11 at 12:44.

2007-01-14, 22:50	#7 (permalink)
samposoft Portal Member Join Date: Jan 2007 Age: 32 Posts: 28 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	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...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Codec isntall option in SVN	Glith	Improvement Suggestions	2	2006-10-24 23:12
REQ: Auto-View option for music (other) folders ala XBMC	HappyTalk	Improvement Suggestions	1	2006-08-29 18:43
MyPrograms view option (really small request)	Waltz	Improvement Suggestions	0	2006-08-09 01:03
Internal SVN update option?	nst6563	Improvement Suggestions	13	2006-05-29 10:38
WDM Drivers Internal Sound Source Option!	dbx	Improvement Suggestions	1	2005-07-06 19:37

2007-01-08, 18:06	#2 (permalink)
THDBASED Portal Member Join Date: Jan 2006 Posts: 468 Thanks: 72 Thanked 2 Times in 2 Posts Country: My System	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

2007-01-08, 18:32	#3 (permalink)
FlipGer Super Moderator Join Date: Apr 2004 Location: Leipzig, Germany Age: 33 Posts: 2,286 Thanks: 33 Thanked 56 Times in 42 Posts Country: My System	Hi, also try contacting the DEVs on IRC. Any help is always highly appreciated! Flip.

2007-01-08, 19:08	#4 (permalink)
dunkstar Portal Member Join Date: Jan 2007 Age: 28 Posts: 14 Thanks: 0 Thanked 0 Times in 0 Posts Country:	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...

2007-01-11, 11:22	#5 (permalink)
dunkstar Portal Member Join Date: Jan 2007 Age: 28 Posts: 14 Thanks: 0 Thanked 0 Times in 0 Posts Country:	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???

2007-01-14, 23:28	#8 (permalink)
FlipGer Super Moderator Join Date: Apr 2004 Location: Leipzig, Germany Age: 33 Posts: 2,286 Thanks: 33 Thanked 56 Times in 42 Posts Country: My System	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.

2007-01-15, 09:06	#10 (permalink)
dunkstar Portal Member Join Date: Jan 2007 Age: 28 Posts: 14 Thanks: 0 Thanked 0 Times in 0 Posts Country:	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?