Jump to content


Photo

Kodi MySQL support is not compiled


  • Please log in to reply
10 replies to this topic

#1 sasfioka

  • New Member
  • 2 posts

0
Neutral

Posted 19 April 2021 - 11:08

Hi all,

I have a problem, I use Zgemma H9 Combo boxes, and I started using the Kodi 18.9 (built-in ext.).
The program works fine until I connect to the database. 
My advancedsettings.xml: 

  <videodatabase>
    <type>mysql</type>
    <name>username</name>
    <host>192.168.178.254</host>
    <port>3307</port>
    <user>user</user>
    <pass>pass</pass>
  </videodatabase>
  <musicdatabase>
     <type>mysql</type>
     <name>username</name>
     <host>192.168.178.254</host>
    <port>3307</port>
     <user>user</user>
     <pass>pass</pass>
  </musicdatabase>

This file works well on other devices. (Android, Windows etc.)

Debug log in Enigma2 (Zgemma H9 Combo box):
2021-04-19 09:55:37.825 T:2895115168  NOTICE: Running database version Addons27
2021-04-19 09:55:37.826 T:2895115168  NOTICE: Running database version ViewModes6
2021-04-19 09:55:37.828 T:2895115168  NOTICE: Running database version Textures13
2021-04-19 09:55:37.828 T:2895115168   ERROR: MySQL library requested but MySQL support is not compiled in. Falling back to sqlite3.
2021-04-19 09:55:37.830 T:2895115168   FATAL: SqliteDatabase: can't open 192.168.178.254/dbname.db
2021-04-19 09:55:37.832 T:2895115168   ERROR: Process error processing job

What is my chance for access to my SQL Dbase? (I use MariaDB 10 in Synology NAS)

Thank you! 

SF



Re: Kodi MySQL support is not compiled #2 WanWizard

  • PLi® Core member
  • 58,391 posts

+1,273
Excellent

Posted 19 April 2021 - 12:42

Compile your own image and add mariadb-client as an image or kodi dependency?

 

I'm not in favour of adding it to the standard build for the odd user who needs it, as compiling mariadb adds about 25 minutes to the build of an image (and we need to build almost 80 of them).


Currently in use: VU+Duo 4K (2xFBC S2), Amiko Viper T2C (T2+fallback), Octagon SF8008 (S2+T2), Zgemma H9.2H (T2+fallback)

Many answers to your question can be found in our new and improved wiki.

Because to health reasons, I will not be active online very often anymore.


Re: Kodi MySQL support is not compiled #3 sasfioka

  • New Member
  • 2 posts

0
Neutral

Posted 19 April 2021 - 15:06

Compile your own image and add mariadb-client as an image or kodi dependency?

 

I'm not in favour of adding it to the standard build for the odd user who needs it, as compiling mariadb adds about 25 minutes to the build of an image (and we need to build almost 80 of them).

 

Hello WanWizard! 

 

Thank you your fast answer!

 

I think, the kodi dependency is better, if possible. 
I have been using the OpenPLI for a very long time and if it could be resolved to be able to use it with KODI in the future.

Therefore, it would be a good solution to make an dependency rather than a specific unique image.

 

Thank you! 

 

SF



Re: Kodi MySQL support is not compiled #4 WanWizard

  • PLi® Core member
  • 58,391 posts

+1,273
Excellent

Posted 19 April 2021 - 15:24

Eh, that was part of "compile your own image".

 

As I wrote, I'm not looking forward to an automated build lasting 80 x 25 minutes ( = 33,3 hours ! ) longer, just to to compile mariadb for the odd user that needs it.


Currently in use: VU+Duo 4K (2xFBC S2), Amiko Viper T2C (T2+fallback), Octagon SF8008 (S2+T2), Zgemma H9.2H (T2+fallback)

Many answers to your question can be found in our new and improved wiki.

Because to health reasons, I will not be active online very often anymore.


Re: Kodi MySQL support is not compiled #5 Trial

  • Senior Member
  • 1,057 posts

+31
Good

Posted 19 April 2021 - 16:22

Hi sasfioka,

do not expect to much. The last time I checked (2-3 years ago) it did not really make sense as the default E2 mediaplayer does not play files like nfs:\\share\file or smb:\\share\file which is used in the data base of a real kodi. Android had problems with nfs.

 

Ralf



Re: Kodi MySQL support is not compiled #6 WanWizard

  • PLi® Core member
  • 58,391 posts

+1,273
Excellent

Posted 19 April 2021 - 16:24

That still doesn't work, those links are handled by FUSE on a full linux distro, which isn't available on the box.


Currently in use: VU+Duo 4K (2xFBC S2), Amiko Viper T2C (T2+fallback), Octagon SF8008 (S2+T2), Zgemma H9.2H (T2+fallback)

Many answers to your question can be found in our new and improved wiki.

Because to health reasons, I will not be active online very often anymore.


Re: Kodi MySQL support is not compiled #7 umtauscher

  • Senior Member
  • 163 posts

+1
Neutral

Posted 5 May 2021 - 18:38

I have the exact same problem as the original poster.

Sadly this is a dealbreaker for me.

I have several different Kodi installations in my network and was hoping to be able to switch to my vu+ instead of needing to use an additional hardware. so the centralized mysql database is essential for my needs.

 

It really sounds odd to me that the argument is that the build would take longer.

Sigh…



Re: Kodi MySQL support is not compiled #8 WanWizard

  • PLi® Core member
  • 58,391 posts

+1,273
Excellent

Posted 5 May 2021 - 20:57

If it is so much of a bother, why don't you build it yourself? Or donate a few more buildservers?

 

For us it would be better to dump Kodi completely, on a clean build run that would save us 82 x 35 minutes...


Currently in use: VU+Duo 4K (2xFBC S2), Amiko Viper T2C (T2+fallback), Octagon SF8008 (S2+T2), Zgemma H9.2H (T2+fallback)

Many answers to your question can be found in our new and improved wiki.

Because to health reasons, I will not be active online very often anymore.


Re: Kodi MySQL support is not compiled #9 A.A.

  • Senior Member
  • 251 posts

+5
Neutral

Posted 5 May 2021 - 21:36

I agree it's really a beast to build...



Re: Kodi MySQL support is not compiled #10 umtauscher

  • Senior Member
  • 163 posts

+1
Neutral

Posted 6 May 2021 - 15:34

 
For us it would be better to dump Kodi completely, on a clean build run that would save us 82 x 35 minutes...

I don‘t understand. Kodi is a plugin, right?
Are you saying you build it for every box seperately?

Re: Kodi MySQL support is not compiled #11 WanWizard

  • PLi® Core member
  • 58,391 posts

+1,273
Excellent

Posted 6 May 2021 - 16:08

Kodi is not a plugin, Kodi is the complete Kodi application (like you would run it on a HTPC). It is largely coded in C++ which needs to be compiled. Due to the hardware interface it needs, it is binary unique for every box.

 

The plugin is only the interface to glue Kodi to Enigma.


Currently in use: VU+Duo 4K (2xFBC S2), Amiko Viper T2C (T2+fallback), Octagon SF8008 (S2+T2), Zgemma H9.2H (T2+fallback)

Many answers to your question can be found in our new and improved wiki.

Because to health reasons, I will not be active online very often anymore.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users