Shared database, from windows cannot connect to linux mysql database
Gilderoy
Newbie
Posts: 6
#1
2012-01-22, 08:38
Hi all Smile
I'm having a problem i'm not able to fix, I've searched everywhere.. still no luck.
in my usual setup I have mysql installed on a win7 machine and everyone else connect to him. Since I just bought a miniserver I decided to drop that library and create a new one on the linux (ubuntu 11.10) machine.
So I followed all the procedure again from the scratch and, on the linux machine, everithing is working fine.
BUT! on the windows machine it does not work, this is the log:

Code:
06:53:59 T:9164  NOTICE: -----------------------------------------------------------------------
06:53:59 T:9164  NOTICE: Starting XBMC, Platform: Windows 7, 64-bit (WoW) Service Pack 1 build 7601. Built on Dec 23 2011 (Git:20111222-22ad8e4, compiler 1600)
06:53:59 T:9164  NOTICE: Intel(R) Core(TM) i5-2500K CPU @ 3.30GHz
06:53:59 T:9164  NOTICE: Desktop Resolution: 1920x1080 32Bit at 60Hz
06:53:59 T:9164  NOTICE: Running with administrator rights
06:53:59 T:9164  NOTICE: Aero is enabled
06:53:59 T:9164  NOTICE: special://xbmc/ is mapped to: E:\Program Files (x86)\XBMC
06:53:59 T:9164  NOTICE: special://xbmcbin/ is mapped to: E:\Program Files (x86)\XBMC
06:53:59 T:9164  NOTICE: special://masterprofile/ is mapped to: C:\Users\Utente\AppData\Roaming\XBMC\userdata
06:53:59 T:9164  NOTICE: special://home/ is mapped to: C:\Users\Utente\AppData\Roaming\XBMC\
06:53:59 T:9164  NOTICE: special://temp/ is mapped to: C:\Users\Utente\AppData\Roaming\XBMC\cache
06:53:59 T:9164  NOTICE: The executable running is: E:\Program Files (x86)\XBMC\XBMC.exe
06:53:59 T:9164  NOTICE: Log File is located: C:\Users\Utente\AppData\Roaming\XBMC\xbmc.log
06:53:59 T:9164  NOTICE: -----------------------------------------------------------------------
06:53:59 T:9164  NOTICE: Setup SDL
06:53:59 T:9164  NOTICE: Found screen: Monitor generico Plug and Play on NVIDIA GeForce GTX 560 Ti, adapter 0.
06:53:59 T:9164  NOTICE: Primary mode: 1920x1080 @ 60.00 - Full Screen
[snip]
06:53:59 T:9164  NOTICE: load settings...
06:53:59 T:9164  NOTICE: special://profile/ is mapped to: special://masterprofile/
06:53:59 T:9164  NOTICE: loading special://masterprofile/guisettings.xml
06:53:59 T:9164  NOTICE: Getting hardware information now...
06:53:59 T:9164  NOTICE: Checking resolution 12
06:53:59 T:9164  NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
06:53:59 T:9164  NOTICE: Loaded playercorefactory configuration
06:53:59 T:9164  NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
06:53:59 T:9164  NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
06:53:59 T:9164  NOTICE: No settings file to load to load (special://xbmc/system/advancedsettings.xml)
06:53:59 T:9164  NOTICE: Loaded settings file from special://profile/advancedsettings.xml
06:53:59 T:9164  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>192.168.0.107</host>
                                                <port>3306</port>
                                                <user>xbmc</user>
                                                <pass>xbmc</pass>
                                                <name>xbmc_video</name>
                                              </videodatabase>
                                              <musicdatabase>
                                                <type>mysql</type>
                                                <host>192.168.0.107</host>
                                                <port>3306</port>
                                                <user>xbmc</user>
                                                <pass>xbmc</pass>
                                                <name>xbmc_music</name>
                                              </musicdatabase>
                                              <pathsubstitution>
                                                <substitute>
                                                  <from>special://masterprofile/Thumbnails/</from>
                                                  <to>smb://MAGISYSTEM/condivisa/share/Thumbnails/</to>
                                                </substitute>
                                              </pathsubstitution>
                                              <substitute>
                                                <from>special://masterprofile/playlists/</from>
                                                <to>smb://MAGISYSTEM/condivisa/share/playlists/</to>
                                              </substitute>
                                            </advancedsettings>
06:53:59 T:9164 WARNING: VIDEO database configuration is experimental.
06:53:59 T:9164  NOTICE: Getting hardware information now...
06:53:59 T:9164  NOTICE: Checking resolution 12
06:53:59 T:9164  NOTICE: Default DVD Player: dvdplayer
06:53:59 T:9164  NOTICE: Default Video Player: dvdplayer
06:53:59 T:9164  NOTICE: Default Audio Player: paplayer
06:53:59 T:9164  NOTICE: Disabled debug logging due to GUI setting. Level 0.
06:53:59 T:9164  NOTICE: Log level changed to 0
06:53:59 T:9164  NOTICE: Loading media sources from special://masterprofile/sources.xml
06:53:59 T:9164  NOTICE: Enabled Joystick: Logitech G13 Joystick
06:53:59 T:9164  NOTICE: Details: Total Axis: 2 Total Hats: 0 Total Buttons: 1
06:53:59 T:9164  NOTICE: initializing playlistplayer
06:53:59 T:9164  NOTICE: DONE initializing playlistplayer
06:54:01 T:2228   ERROR: CRemoteControl::Connect - failed to connect
06:54:04 T:9164   ERROR: Unable to open database: xbmc_video58 [1049](Unknown database 'xbmc_video58')
06:54:09 T:9164   ERROR: Unable to open database: xbmc_video57 [1049](Unknown database 'xbmc_video57')
06:54:14 T:9164   ERROR: Unable to open database: xbmc_video56 [1049](Unknown database 'xbmc_video56')
06:54:19 T:9164   ERROR: Unable to open database: xbmc_video55 [1049](Unknown database 'xbmc_video55')
06:54:24 T:9164   ERROR: Unable to open database: xbmc_video54 [1049](Unknown database 'xbmc_video54')
06:54:29 T:9164   ERROR: Unable to open database: xbmc_video53 [1049](Unknown database 'xbmc_video53')
06:54:34 T:9164   ERROR: Unable to open database: xbmc_video52 [1049](Unknown database 'xbmc_video52')
06:54:39 T:9164   ERROR: Unable to open database: xbmc_video51 [1049](Unknown database 'xbmc_video51')
06:54:45 T:9164   ERROR: Unable to open database: xbmc_video50 [1049](Unknown database 'xbmc_video50')
06:54:50 T:9164   ERROR: Unable to open database: xbmc_video49 [1049](Unknown database 'xbmc_video49')
06:54:55 T:9164   ERROR: Unable to open database: xbmc_video48 [1049](Unknown database 'xbmc_video48')
06:55:00 T:9164   ERROR: Unable to open database: xbmc_video47 [1049](Unknown database 'xbmc_video47')
06:55:05 T:9164   ERROR: Unable to open database: xbmc_video46 [1049](Unknown database 'xbmc_video46')
06:55:10 T:9164   ERROR: Unable to open database: xbmc_video45 [1049](Unknown database 'xbmc_video45')
06:55:15 T:9164   ERROR: Unable to open database: xbmc_video44 [1049](Unknown database 'xbmc_video44')
06:55:20 T:9164   ERROR: Unable to open database: xbmc_video43 [1049](Unknown database 'xbmc_video43')
06:55:25 T:9164   ERROR: Unable to open database: xbmc_video42 [1049](Unknown database 'xbmc_video42')
06:55:30 T:9164   ERROR: Unable to open database: xbmc_video41 [1049](Unknown database 'xbmc_video41')
06:55:35 T:9164   ERROR: Unable to open database: xbmc_video40 [1049](Unknown database 'xbmc_video40')
06:55:40 T:9164   ERROR: Unable to open database: xbmc_video39 [1049](Unknown database 'xbmc_video39')
06:55:45 T:9164   ERROR: Unable to open database: xbmc_video38 [1049](Unknown database 'xbmc_video38')
06:55:50 T:9164   ERROR: Unable to open database: xbmc_video37 [1049](Unknown database 'xbmc_video37')
06:55:55 T:9164   ERROR: Unable to open database: xbmc_video36 [1049](Unknown database 'xbmc_video36')
06:56:00 T:9164   ERROR: Unable to open database: xbmc_video35 [1049](Unknown database 'xbmc_video35')
06:56:05 T:9164   ERROR: Unable to open database: xbmc_video34 [1049](Unknown database 'xbmc_video34')
06:56:15 T:9164   ERROR: Unable to open database: xbmc_video33 [1049](Unknown database 'xbmc_video33')
06:56:22 T:9164   ERROR: Unable to open database: xbmc_video32 [1049](Unknown database 'xbmc_video32')

I cannot understand what's wrong, the mysql server on the linux machine should be open to connection from everywhere.. and what about xbmc_video58 ecc?

I alse tryed to create a new empty database on ubuntu and connect to that from the windows machine, still no luck, same error..
what can I do?

Thank a lot for your help! ^__^
Find
Reply
TeKo
Posting Freak
Posts: 964
#2
2012-01-22, 16:31
Eden Beta?

First change that:
Quote:<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails/</from>
<to>smb://MAGISYSTEM/condivisa/share/Thumbnails/</to>
</substitute>
</pathsubstitution>
<substitute>
<from>special://masterprofile/playlists/</from>
<to>smb://MAGISYSTEM/condivisa/share/playlists/</to>
</substitute>

to:
Quote:<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails/</from>
<to>smb://MAGISYSTEM/condivisa/share/Thumbnails/</to>
</substitute>

<substitute>
<from>special://masterprofile/playlists/</from>
<to>smb://MAGISYSTEM/condivisa/share/playlists/</to>
</substitute>
</pathsubstitution>

Then you could try to remove the:
<name>xbmc_video</name>
<name>xbmc_music</name>
tags.

Is the mySQL db empty or did you used the Server with another client?
If you never connected with XBMC try to create the database yourself.

Quote:CREATE database xbmc_video;
CREATE database xbmc_music;
BobDroid - Control boblight from Android (now on Play)

Boblight for Windows (Tutorial + latest build + Config Creator)
Find
Reply
Gilderoy
Newbie
Posts: 6
#3
2012-01-23, 01:47
Yes I was on eden beta1, today I tryed on eden beta2.
I made the first change, and then tried to delete the <name> fields.
i then tryed to connect to the database from windoes eden beta2.
A database called MyVideos58 was created.
So I edited the advancedsettings.xml with <name>MyVideos58</name>
And got the error
Code:
ERROR: Unable to open database: xbmc_video58 [1049](Unknown database 'MyVideos5858')
Notice the double 58.
So i played it "smart" and edited the advancedsettings.xml to connect to <name>MyVideos</name>
This crash eden beta 2 the error:
Code:
16:12:51 T:8960   ERROR: SQL: The table does not exist
                                            Query: SELECT idVersion FROM version
I have the xbmc_crashlog.dmp available if you need it..

So i tryed something else.
I destroyed all databases on the linux machine.
I left the names <name>xbmc_video</name> and <name>xbmc_music</name> in the LINUX machine and opened xbmc beta1 on the linux machine.
it connected to the dabase no problem and created 2 databases: xbmc_video58 and xbmc_music18.
Now i went back to the windows machine and used the usual names <name>xbmc_video</name> and <name>xbmc_music</name>
Surprise surprise it connected!
BUT!
Every single action took 10+second to perform.
everything at all, from changing subdirectory to going one directory up, everything spawn a "Working.." and make me wait 10+sec.
so again what's wrong? on the linux machine the operation are instant and when i used mysql on the windows machine everything was istant, why mysql on the linux need 10+sec for every single operation?
This is a sow stopper for me, i cannot wait 10 sec if i press a key to scroll a list for every entry of the list..
Pls help me Smile
Find
Reply
darkscout
Posting Freak
Posts: 2,145
#4
2012-01-23, 01:54
My signature.
Code:
GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%';
IF you have a mysql problem, find one of the 4 dozen threads already open.
Find
Reply
Gilderoy
Newbie
Posts: 6
#5
2012-01-23, 02:35
And.. i resolved it!
I added skyp-name-resolve to my /etc/mysql/my.cnf and it did the trick!
the "problem" i encountered was mainly that if we have in the advancedsettings a <name>xbmc_video</name> in truth the database that is created is called xbmc_video58.
I do not know why this happen but is rather confusing, for me at least.. ^__^
BTW thanks for the help! I'm happy is working now Smile
EDIT: darkscout wasn't your signature the problem, was the skyp-name-resolve Smile
Find
Reply
MrLobster
Member
Posts: 84
#6
2012-01-23, 06:19
I think you mean "skip-name-resolve" not skyp
Find
Reply
TeKo
Posting Freak
Posts: 964
#7
2012-01-23, 06:40
Thats why I told you to create the db manually.
xbmc starts at xbmc_video58 and counts down to xbmc_video.

And you should still be able to remove the <name> had no problems without it on eden.
BobDroid - Control boblight from Android (now on Play)

Boblight for Windows (Tutorial + latest build + Config Creator)
Find
Reply

Home
Search
Help
Logout Mark Read Team Forum Stats Members Help
Shared database, from windows cannot connect to linux mysql database0