2012-12-05, 04:14
I am trying, without success, to setup MySQL to access my video library. I have successfully installed and setup MySQL:
I can access MySQL locally on the MySQL server machine:
I can access MySQL remotely from a client machine on the network:
After setting up MySQL I exported my video library to a single file, deleted MyVideos72.db, textures13.db and Thumbnails folder. I then modified advancedsettings.xml:
Now when I run XBMC I get the error "service.skin.widgets":
And when I attempt to import the exported video library, nothing happens. What am I missing?
Debug Log
Code:
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
GRANT ALL ON *.* TO 'xbmc';
CREATE DATABASE xbmc_video DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci;
FLUSH PRIVILEGES;
I can access MySQL locally on the MySQL server machine:
Code:
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 754
Server version: 5.5.28-log Source distribution
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select user,host from mysql.user;
+-------+-----------+
| user | host |
+------+------------+
| xbmc | % |
| root | 127.0.0.1 |
| root | ::1 |
| | WebServer |
| root | WebServer |
| | localhost |
| root | localhost |
+------+-----------+
7 rows in set (0.00 sec)
mysql> show grants for 'xbmc';
+--------------------------------------------------------------------------------------------------------------+
| Grants for xbmc@% |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD '*EC4F5173DE994BFEAB7040A4A32B4ED6DE26F6F0' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
| xbmc_video |
+--------------------+
5 rows in set (0.00 sec)
I can access MySQL remotely from a client machine on the network:
Code:
/usr/local/mysql/bin/mysql -h 10.0.1.250 -P 3306 -u xbmc -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 755
Server version: 5.5.28-log Source distribution
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select user,host from mysql.user;
+------+-----------+
| user | host |
+------+-----------+
| xbmc | % |
| root | 127.0.0.1 |
| root | ::1 |
| | WebServer |
| root | WebServer |
| | localhost |
| root | localhost |
+------+-----------+
7 rows in set (0.01 sec)
mysql> show grants for 'xbmc';
+--------------------------------------------------------------------------------------------------------------+
| Grants for xbmc@% |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD '*EC4F5173DE994BFEAB7040A4A32B4ED6DE26F6F0' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
| xbmc_video |
+--------------------+
5 rows in set (0.00 sec)
After setting up MySQL I exported my video library to a single file, deleted MyVideos72.db, textures13.db and Thumbnails folder. I then modified advancedsettings.xml:
Code:
<advancedsettings>
<fullscreen>true</fullscreen>
<splash>false</splash>
<videodatabase>
<type>mysql</type>
<host>10.0.1.250</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<Videolibrary>
<cleanonupdate>true</cleanonupdate>
</Videolibrary>
<video>
<!-- Number of seconds to ignore at video start after which a resume point is created -->
<ignoresecondsatstart>15</ignoresecondsatstart>
</video>
</advancedsettings>
Now when I run XBMC I get the error "service.skin.widgets":
And when I attempt to import the exported video library, nothing happens. What am I missing?
Debug Log