27 replies to this topic

[sasfioka]

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

[WanWizard]

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).

[sasfioka]

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

[WanWizard]

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.

[Trial]

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

[WanWizard]

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

[umtauscher]

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…

[WanWizard]

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...

[A.A.]

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

[umtauscher]

 
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?

[WanWizard]

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.

[umtauscher]

Well, I just tried the 8.1 release in the hopes, this would have been enhanced - but it doesn‘t

 

I have to say, if the Kodi implementation is crippled like that, for me you could just leave it out. It‘s really no use, if I have to keep a separate hardware to really use it.

Thanks for you work.

[A.A.]

FYI

 

just add mysql to PACKAGECONFIG here

 

https://github.com/O...kodi_18.bb#L126

 

and add this line few lines after

 

PACKAGECONFIG[mysql] = "-DENABLE_MYSQLCLIENT=ON,-DENABLE_MYSQLCLIENT=OFF,mysql5"

 

NOTE:

This is in the meta-kodi original repo.

This is not recommended for stb boxes so we did not even bother to add the knob.

[umtauscher]

Thanks, I appreciate your help.

But I don't want to compile or keep a separate fork  for myself.

 

I have a kodi box that runs perfectly with an official build. I just don't see the benefit to compile it into Openpli if the team isn't up to making it fully functional.
Every answer to a problem I read,  basically says: We don't support it.

So I won't bother using it.
Sadly I don't have time nor expertise to help with that.

 

Cheers

[WanWizard]

We don't supported it because we don't have anyone with the required knowledge, we don't even have a single Kodi user in the team.

 

If not for the great efforts of A.A., it would not be there at all...

[A.A.]

Sorry, the option is already there

https://github.com/O...kodi_18.bb#L147

 

Again, nobody has asked for it.

 

A.A.

 

P.S.

Weird enough the samba client is still there: I think it is for standalone kodi but is not necessary on stb, you can browse your nas using the local filesystem.

[umtauscher]

Are you saying, Mysql should be compiled in? 

[A.A.]

not really, I would remove samba as well

[umtauscher]

I don't get it. Samba on Kodi at least works, in contrast to Openpli.

[A.A.]

@WanWizard

 

it is just compile time, it should not add much.

if the users asks about it we can add (there is still pulseaudio not enabled fwiw).

 

Kodi will be soon officially in OE (so I heard).

My plan is to have just a kodi_xx.bbappend in meta-openpli where we override the default values, i.e. PACKAGECONFIG

 

Cheers

A.A.