SQL help please

Monkeypox · 2012-02-18 20:00

I've attempted to follow the wiki for Eden and MySQL. I've also tried going through several threads to no avail.

I've done:

Type in: CREATE USER 'xbmc' IDENTIFIED BY 'xbmc'; and press return
Type in: GRANT ALL ON *.* TO 'xbmc'; and press return

And then tried:

GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%';

Code:

58:25 T:4136   ERROR: Unable to open database: MyMusic [1044](Access denied for user 'xbmc'@'192.168.0.%' to database 'mymusic')

58:25 T:4136   ERROR: SQL: Can't create new database: 'MyMusic18' (1044)

58:25 T:4136   ERROR: Unable to open database: MyMusic18 (0)

58:25 T:4136   ERROR: Unable to open database: MyVideos60 [1044](Access denied for user 'xbmc'@'192.168.0.%' to database 'myvideos60')

Any help would be greatly appreciated.

Monkeypox · 2012-02-18 20:38

After reinstalling, those errors are gone but now I'm getting:

Code:

13:34:21 T:5708   ERROR: SQL: Undefined MySQL error: Code (1062)

                                            Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'S:\\Videos\\','','')

13:34:21 T:5708   ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'S:\\Videos\\','',''))

13:34:21 T:5708   ERROR: SQL: Undefined MySQL error: Code (1062)

                                            Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'S:\\Kids\\','','')

13:34:21 T:5708   ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'S:\\Kids\\','',''))

13:34:21 T:5708   ERROR: SQL: Undefined MySQL error: Code (1062)

                                            Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'S:\\Stand Up\\','','')

13:34:21 T:5708   ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'S:\\Stand Up\\','',''))

My advancedsettings.xml

Code:

<advancedsettings>

    <videodatabase>

        <type>mysql</type>

        <host>192.168.0.5</host>

        <port>3306</port>

        <user>xbmc</user>

        <pass>xbmc</pass>

    </videodatabase> 

    <musicdatabase>

        <type>mysql</type>

        <host>192.168.0.5</host>

        <port>3306</port>

        <user>xbmc</user>

        <pass>xbmc</pass>

    </musicdatabase>

</advancedsettings>

**jmarshall** · 2012-02-18 21:29

1. Run XBMC and turn full debugging on (Settings->System->Debugging).
2. Exit XBMC.
3. Go into mysql and delete all MyVideo* and MyMusic* databases (google will show you how).
4. Run XBMC and grab the full debug log.
5. Pastebin.com the log and link to it from here.

Cheers,
Jonathan

Monkeypox · 2012-02-19 00:36

After playing around I think I found the culprit. Mysql didn't like my Windows share name. Once I changed the shares to their SMB source it worked perfectly.

It might be worth making a note in the wiki to cover that.

davor · 2012-03-30 13:28

(2012-02-19 00:36)Monkeypox Wrote: After playing around I think I found the culprit. Mysql didn't like my Windows share name. Once I changed the shares to their SMB source it worked perfectly.

It might be worth making a note in the wiki to cover that.

I can also confirm this. The errors I had:

Code:

13:06:25 T:3972   ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'M:\\Videos\\Movies\\USA\\','',''))

13:06:25 T:3972   ERROR: SQL: Undefined MySQL error: Code (1062)

                                            Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'M:\\Videos\\Movies\\USA\\','','')

13:06:25 T:3972   ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'M:\\Videos\\Movies\\USA\\','',''))

13:06:25 T:3972   ERROR: SQL: Undefined MySQL error: Code (1062)

                                            Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'M:\\Videos\\Movies\\USA\\','','')

...

mwkurt · 2012-03-30 13:42

(2012-02-19 00:36)Monkeypox Wrote: After playing around I think I found the culprit. Mysql didn't like my Windows share name. Once I changed the shares to their SMB source it worked perfectly.

It might be worth making a note in the wiki to cover that.

So could you please explain what exactly you changed and to what? I am having the same problems with my upgrade to Eden.

Thanks,
Mark

Sureguy · 2012-03-30 14:36

You need to access your media via a network mount like SMB or NFS, not drive letters or mapped drives. To do this you delete your current media sources and add them as Network drives, even if they are local. MySQL isn't handling the backslash (\) properly.

mwkurt · 2012-03-30 14:38

(2012-03-30 14:36)Sureguy Wrote: You need to access your media via a network mount like SMB or NFS, not drive letters or mapped drives. To do this you delete your current media sources and add them as Network drives, even if they are local. MySQL isn't handling the backslash (\) properly.

Thanks...I'll give that a try later today.

Mark

Dam0 · 2012-05-27 08:01

UM, i have had the same problem for quiet a while since migrating to alpha/beta Eden.

Code:

39:15 T:19148   ERROR: Unable to open database: MyVideos60 [1045](Access denied for user 'xbmc'@'localhost' (using password: YES))

39:15 T:19148   ERROR: Unable to open database: MyVideos59 [1045](Access denied for user 'xbmc'@'localhost' (using password: YES))

39:15 T:19148   ERROR: Unable to open database: MyVideos58 [1045](Access denied for user 'xbmc'@'localhost' (using password: YES))

** for testing, i used xbmc.log from localhost, not remote, but both are nearly identical

the shared libraries works 100%, just leaves a messy logfile.

furthermore, i have been unable to get android remote to function with library support, i suspect as xbmc running on the pc, has no cached local copy to export to the android?

i also suspect xbmc defaults to new library table name since Eden, and therefore my old name(which was originally setup via MediaPortal plugin years ago, and has many entries)

the mysql server pc and the playback xbmc pc are both running Eden PVR V2, but had same errors with all alphas/betas

debug log is here

http://pastebin.com/U8b857E7

** All share paths are smb, not local btw

thanks in advance,
Dam0

kdbarrett · 2012-05-28 01:11

I was having the same problem and switching to SMB - even though the instance of XBMC I was working with is on the same machine as the video files - and this worked. However, I only ran into this issue when I created a profile and tried to use the Lifehacker/HowToNerd instructions for setting up MySQL in order to share library data across instances. The master profile had no problem saving the lettered drive path.

Monkeypox Member Posts: 67 Joined: Oct 2011 Reputation: 0	2012-02-19 00:36 Post: #4 After playing around I think I found the culprit. Mysql didn't like my Windows share name. Once I changed the shares to their SMB source it worked perfectly. It might be worth making a note in the wiki to cover that.
	find quote

Sureguy Member+ Posts: 163 Joined: Sep 2010 Reputation: 3	2012-03-30 14:36 Post: #7 You need to access your media via a network mount like SMB or NFS, not drive letters or mapped drives. To do this you delete your current media sources and add them as Network drives, even if they are local. MySQL isn't handling the backslash (\) properly.
	find quote

mwkurt Posting Freak Posts: 973 Joined: Mar 2010 Reputation: 9	2012-03-30 14:38 Post: #8 (2012-03-30 14:36)Sureguy Wrote: You need to access your media via a network mount like SMB or NFS, not drive letters or mapped drives. To do this you delete your current media sources and add them as Network drives, even if they are local. MySQL isn't handling the backslash (\) properly. Thanks...I'll give that a try later today. Mark
	find quote