SQL help please

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
Monkeypox Offline
Member
Posts: 71
Joined: Oct 2011
Reputation: 0
Post: #1
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:
12:58:25 T:4136   ERROR: Unable to open database: MyMusic [1044](Access denied for user 'xbmc'@'192.168.0.%' to database 'mymusic')
12:58:25 T:4136   ERROR: SQL: Can't create new database: 'MyMusic18' (1044)
12:58:25 T:4136   ERROR: Unable to open database: MyMusic18 (0)
12: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.
(This post was last modified: 2012-02-18 20:02 by Monkeypox.)
find quote
Monkeypox Offline
Member
Posts: 71
Joined: Oct 2011
Reputation: 0
Post: #2
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>
(This post was last modified: 2012-02-18 20:47 by Monkeypox.)
find quote
jmarshall Offline
Team-XBMC Developer
Posts: 26,181
Joined: Oct 2003
Reputation: 175
Post: #3
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

Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


[Image: badge.gif]
find quote
Monkeypox Offline
Member
Posts: 71
Joined: Oct 2011
Reputation: 0
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
davor Offline
Junior Member
Posts: 30
Joined: Jul 2011
Reputation: 0
Post: #5
(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\\','','')
...
(This post was last modified: 2012-03-30 13:29 by davor.)
find quote
mwkurt Offline
Posting Freak
Posts: 1,064
Joined: Mar 2010
Reputation: 10
Post: #6
(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
find quote
Sureguy Offline
Donor
Posts: 162
Joined: Sep 2010
Reputation: 3
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 Offline
Posting Freak
Posts: 1,064
Joined: Mar 2010
Reputation: 10
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
Dam0 Offline
Fan
Posts: 428
Joined: Jun 2008
Reputation: 0
Post: #9
UM, i have had the same problem for quiet a while since migrating to alpha/beta Eden.

Code:
15:39:15 T:19148   ERROR: Unable to open database: MyVideos60 [1045](Access denied for user 'xbmc'@'localhost' (using password: YES))
15:39:15 T:19148   ERROR: Unable to open database: MyVideos59 [1045](Access denied for user 'xbmc'@'localhost' (using password: YES))
15: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
(This post was last modified: 2012-05-27 08:05 by Dam0.)
find quote
kdbarrett Offline
Junior Member
Posts: 5
Joined: May 2012
Reputation: 0
Post: #10
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.
find quote
Dam0 Offline
Fan
Posts: 428
Joined: Jun 2008
Reputation: 0
Post: #11
im still using master profile for all pcs xbmc installs
find quote
Monkeypox Offline
Member
Posts: 71
Joined: Oct 2011
Reputation: 0
Post: #12
(2012-03-30 13:42)mwkurt Wrote:  
(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

I know this is a bit late, but I missed this change to the thread.

My windows share had space in the name, that the database didn't like. I changed "Windows Server" to "Windows_Server" and all was right with the world.
find quote
Dam0 Offline
Fan
Posts: 428
Joined: Jun 2008
Reputation: 0
Post: #13
[SOLVED]

on a machine with complete local copy of eden video60 and music18 databases(found in user dir)

So i used this tool
Code:
http://www.devart.com/dbforge/mysql/studio/download.html

to delete my dharma format tables. (xbmc_video+xbmc_music)

then open xbmc again, and xbmc will look for the missing tables in your myslq database, when it finds it missing, it will copy the local copy across to the mysql server. This instance of xbmc.log will complain about this is missing etc. but next shutdown and restart, xbmc.log will be sweet again.

i hope this may help others who have had messy log output since migrating to Eden.

Dam0
find quote