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
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:
19:06:28 T:140133478438976 NOTICE: Running database version Addons20
19:06:28 T:140133478438976 NOTICE: Running database version ViewModes6
19:06:28 T:140133478438976 NOTICE: Running database version Textures13
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic56 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic55 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic54 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic53 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic52 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic51 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic50 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic49 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic48 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic47 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic46 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic45 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic44 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic43 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic42 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic41 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic40 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic39 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic38 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic37 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic36 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic35 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic34 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic33 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic32 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyMusic56 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to create new database
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos99 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos98 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos97 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos96 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos95 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos94 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos93 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos92 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos91 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos90 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos89 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos88 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos87 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos86 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos85 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos84 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos83 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos82 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos81 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos80 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos79 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos78 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos77 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos76 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos75 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to open database: MyVideos99 [2003](Can't connect to MySQL server on '192.168.10.49' (101))
19:06:28 T:140133478438976 ERROR: Unable to create new database
19:06:28 T:140133478438976 NOTICE: Running database version TV29
19: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
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
From your client, first check with the mysql client to see if it connects.
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
I also found the error in my setup, was the syntax in the xml file.