Reply to thread

Message

<blockquote data-quote="doveman" data-source="post: 970163" data-attributes="member: 67412">I'm using Comodo Firewall and I have it set to Allow All on LAN so that should allow access to MySQL from both the local machine and the RPi. As scanning doesn't work anymore even from XBMC running on my PC, you may be right that I've got the advancedsettings.xml wrong (I'm pretty sure it's in the right place though, as otherwise it wouldn't have changed anything and stopped scanning from working by using the normal XBMC database). This is what I've used.&nbsp;[code] &lt;advancedsettings&gt;&nbsp; &lt;videodatabase&gt;&nbsp; &nbsp; &lt;type&gt;mysql&lt;/type&gt;&nbsp; &nbsp; &lt;host&gt;192.168.1.64&lt;/host&gt;&nbsp; &nbsp; &lt;port&gt;3306&lt;/port&gt;&nbsp; &nbsp; &lt;user&gt;xbmc&lt;/user&gt;&nbsp; &nbsp; &lt;pass&gt;xbmc&lt;/pass&gt;&nbsp; &nbsp; &lt;name&gt;xbmc_video&lt;/name&gt;&nbsp; &lt;/videodatabase&gt;&nbsp; &lt;musicdatabase&gt;&nbsp; &nbsp; &lt;type&gt;mysql&lt;/type&gt;&nbsp; &nbsp; &lt;host&gt;192.168.1.64&lt;/host&gt;&nbsp; &nbsp; &lt;port&gt;3306&lt;/port&gt;&nbsp; &nbsp; &lt;user&gt;xbmc&lt;/user&gt;&nbsp; &nbsp; &lt;pass&gt;xbmc&lt;/pass&gt;&nbsp; &nbsp; &lt;name&gt;xbmc_music&lt;/name&gt;&nbsp; &lt;/musicdatabase&gt;&lt;/advancedsettings&gt;[/code]&nbsp;However, Comodo shows me the listening connections and I don't see Mysql in the list at all so that doesn't seem right.[DOUBLEPOST=1361884134][/DOUBLEPOST]&nbsp;I'm not sure as normally I don't login to it, that's all taken care of automatically by MP I guess. However, as per the guide I've done:&nbsp;CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';CREATE database xbmc_video;CREATE database xbmc_music;GRANT ALL ON *.* TO 'xbmc';&nbsp;and doing SELECT host,user from mysql.user;SHOW DATABASES;&nbsp;returns&nbsp;[code]+-----------+------+| host | user |+-----------+------+| % | root || % | xbmc || 127.0.0.1 | root || localhost | || localhost | root |+-----------+------+5 rows in set (0.01 sec)+--------------------+| Database |+--------------------+| information_schema || argustv || mptvdb || mysql || test || xbmc_music || xbmc_video |+--------------------+7 rows in set (0.02 sec)[/code]I note that the guide refers to setting the password when installing MySQL though. As there's already a password of MediaPortal set (I have to use this when opening the commandline tool), perhaps I need to specify this in my xml instead of xbmc. The guide suggests the CREATE USER creates the user/password but perhaps that's wrong and it just creates the user.</blockquote>

[QUOTE="doveman, post: 970163, member: 67412"] I'm using Comodo Firewall and I have it set to Allow All on LAN so that should allow access to MySQL from both the local machine and the RPi. As scanning doesn't work anymore even from XBMC running on my PC, you may be right that I've got the advancedsettings.xml wrong (I'm pretty sure it's in the right place though, as otherwise it wouldn't have changed anything and stopped scanning from working by using the normal XBMC database). This is what I've used. [code] <advancedsettings> <videodatabase> <type>mysql</type> <host>192.168.1.64</host> <port>3306</port> <user>xbmc</user> <pass>xbmc</pass> <name>xbmc_video</name> </videodatabase> <musicdatabase> <type>mysql</type> <host>192.168.1.64</host> <port>3306</port> <user>xbmc</user> <pass>xbmc</pass> <name>xbmc_music</name> </musicdatabase> </advancedsettings>[/code] However, Comodo shows me the listening connections and I don't see Mysql in the list at all so that doesn't seem right.[DOUBLEPOST=1361884134][/DOUBLEPOST] I'm not sure as normally I don't login to it, that's all taken care of automatically by MP I guess. However, as per the guide I've done: CREATE USER 'xbmc' IDENTIFIED BY 'xbmc'; CREATE database xbmc_video; CREATE database xbmc_music; GRANT ALL ON *.* TO 'xbmc'; and doing SELECT host,user from mysql.user; SHOW DATABASES; returns [code]+-----------+------+ | host | user | +-----------+------+ | % | root | | % | xbmc | | 127.0.0.1 | root | | localhost | | | localhost | root | +-----------+------+ 5 rows in set (0.01 sec) +--------------------+ | Database | +--------------------+ | information_schema | | argustv | | mptvdb | | mysql | | test | | xbmc_music | | xbmc_video | +--------------------+ 7 rows in set (0.02 sec)[/code] I note that the guide refers to setting the password when installing MySQL though. As there's already a password of MediaPortal set (I have to use this when opening the commandline tool), perhaps I need to specify this in my xml instead of xbmc. The guide suggests the CREATE USER creates the user/password but perhaps that's wrong and it just creates the user. [/QUOTE]

Verification