Login at Kodi Home

micksel · 2016-08-01, 15:02

Running 2 Jarvis 16.1 installation,
Have followed the Wiki guide but can't get it do work.

I have a Ubuntu server with Mysql running on 192.168.0.12 (I have verified login with kodi/kodi remote)

I have created a advancedsettings.xml file containing:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.0.12<host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.0.12</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>

I have placed this file on both Machines in userdata folder and I have all my info on a NAS (access by NFS)

What have I missed? No database is created on the MYSQL

zerocool_ie · 2016-08-01, 22:56

are there any errors in your kodi.log?

http://kodi.wiki/view/Log_file/Easy

morol · 2016-08-02, 22:13

Hi I have the same problem,

Mysql server (ip: 192.168.10.49)
Newly installed 16.04.1 LTS (LAMP)

Code:
Database server

•Server: Localhost via UNIX socket

•Server type: MySQL

•Server version: 5.7.13-0ubuntu0.16.04.2 - (Ubuntu)

•Protocol version: 10

•User: root@localhost

• Server charset:  UTF-8 Unicode (utf8)  

Web server

•Apache/2.4.18 (Ubuntu)

•Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - 

•PHP extension: mysqli Documentation

•PHP version: 7.0.8-0ubuntu0.16.04.1

/etc/mysql/mysql.conf.d/mysqld.cnf
bind-address = 0.0.0.0

SQLUser

Code:
User name  Host name   Password    Global privileges       User group   Grant

kodi          %         Yes        ALL PRIVILEGES                        No

advancedsettings.xml

Code:
<advancedsettings>

  <videodatabase>

    <type>mysql</type>

    <host>192.168.10.49</host>

    <port>3306</port>

    <user>kodi</user>

    <pass>kodi</pass>

  </videodatabase> 

  <musicdatabase>

    <type>mysql</type>

    <host>192.168.10.49</host>

    <port>3306</port>

    <user>kodi</user>

    <pass>kodi</pass>

  </musicdatabase>

  <videolibrary>

    <importwatchedstate>true</importwatchedstate>

    <importresumepoint>true</importresumepoint>

  </videolibrary>

</advancedsettings>

01_Kodi.log

Code:
06:28 T:140133478438976  NOTICE: Running database version Addons20

06:28 T:140133478438976  NOTICE: Running database version ViewModes6

06:28 T:140133478438976  NOTICE: Running database version Textures13

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic56 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic55 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic54 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic53 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic52 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic51 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic50 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic49 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic48 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic47 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic46 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic45 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic44 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic43 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic42 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic41 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic40 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic39 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic38 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic37 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic36 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic35 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic34 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic33 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic32 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyMusic56 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to create new database

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos99 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos98 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos97 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos96 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos95 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos94 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos93 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos92 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos91 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos90 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos89 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos88 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos87 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos86 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos85 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos84 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos83 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos82 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos81 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos80 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos79 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos78 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos77 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos76 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos75 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to open database: MyVideos99 [2003](Can't connect to MySQL server on '192.168.10.49' (101))

06:28 T:140133478438976   ERROR: Unable to create new database

06:28 T:140133478438976  NOTICE: Running database version TV29

06:28 T:140133478438976  NOTICE: Running database version Epg11

I had a this setup befor but for some reason the old server (10.04) gave up on me Sad

so I figured I start from the beginning with a newer version of ubuntu

Any help or hint how to proced would be much appreciative

Best Regards
Johan

nickr · 2016-08-02, 22:26

From your client, first check with the mysql client to see if it connects.

morol · 2016-08-02, 22:48

Hi,

For some reason i forgot to write that i use OpenElec 6.95.3.7.0
however I just tried with my Laptop (windows 10) and Kodi 16.1 RC2 and it worked, and now the OpenElec also work.
I guess that the windows version was successful to create the database and now Openlelec can read/write to it.
thanks for the fast repply btw Smile



micksel · 2016-08-03, 08:51

I also found the error in my setup, was the syntax in the xml file.