Kodi Community Forum
Linux XBMCbuntu and mysql server running on ReadyNAS - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Linux XBMCbuntu and mysql server running on ReadyNAS (/showthread.php?tid=138864)

XBMCbuntu and mysql server running on ReadyNAS - Spacedementia87 - 2012-08-22

I followed this (http://wiki.xbmc.org/index.php?title=HOW-TO:Sync_multiple_libraries) guide to try and set up multiple libraries.

However I seem to be having problems.

When I add the media to my xbmcbuntu the database in mysql isn't created.

Also if I try to boot xbmc in my windows machine it just hangs on the splash screen

RE: XBMCbuntu and mysql server running on ReadyNAS - Ned Scott - 2012-08-23

debug logs (wiki) needed from both machines.

RE: XBMCbuntu and mysql server running on ReadyNAS - Spacedementia87 - 2012-08-23

This is from the windows machine

Code:
00:45:34 T:3480  NOTICE: Loaded settings file from special://profile/advancedsettings.xml
00:45:34 T:3480  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>192.198.0.9</host>
                                                <port>3306</port>
                                                <user>xbmc</user>
                                                <pass>xbmc</pass>
                                              </videodatabase>
                                              <musicdatabase>
                                                <type>mysql</type>
                                                <host>192.198.0.9</host>
                                                <port>3306</port>
                                                <user>xbmc</user>
                                                <pass>xbmc</pass>
                                              </musicdatabase>
                                              <loglevel hide="false">2</loglevel>
                                            </advancedsettings>
00:45:34 T:3480  NOTICE: Log level changed to 2
00:45:34 T:3480 WARNING: VIDEO database configuration is experimental.
00:45:34 T:3480  NOTICE: Getting hardware information now...
00:45:34 T:3480    INFO: Using analog output
00:45:34 T:3480    INFO: AC3 pass through is enabled
00:45:34 T:3480    INFO: DTS pass through is enabled
00:45:34 T:3480    INFO: AAC pass through is disabled
00:45:34 T:3480    INFO: MP1 pass through is disabled
00:45:34 T:3480    INFO: MP2 pass through is disabled
00:45:34 T:3480    INFO: MP3 pass through is disabled
00:45:34 T:3480  NOTICE: Checking resolution 12
00:45:34 T:3480  NOTICE: Default DVD Player: dvdplayer
00:45:34 T:3480  NOTICE: Default Video Player: dvdplayer
00:45:34 T:3480  NOTICE: Default Audio Player: paplayer
00:45:34 T:3480  NOTICE: Disabled debug logging due to GUI setting. Level 1.
00:45:34 T:3480  NOTICE: Log level changed to 1
00:45:34 T:3480  NOTICE: Loading media sources from special://masterprofile/sources.xml

00:45:34 T:3480   DEBUG: ADDON: cpluff: 'Not all directories were successfully scanned.'
00:45:34 T:3480   DEBUG: PERIPHERALS::CPeripherals::LoadMappings - loaded node "Motorola Nyxboard Hybrid"
00:45:34 T:3480   DEBUG: PERIPHERALS::CPeripherals::LoadMappings - loaded node "Pulse-Eight CEC Adaptor"
00:45:34 T:3688   DEBUG: Thread XBMC Peripherals start, auto delete: 0
00:45:34 T:5024   DEBUG: Thread CRemoteControl start, auto delete: 0
00:45:34 T:3480   DEBUG: CWinEventsWin32::WndProc: window resize event
00:45:34 T:3480   DEBUG: CWinEventsWin32::WndProc: window move event
00:45:34 T:3480   DEBUG: CWinSystemWin32::ResizeInternal - resizing due to size change (0,0,1366,768 fullscreen)->(0,0,1366,768 fullscreen)
00:45:34 T:3480   DEBUG: CWinEventsWin32::WndProcWindow is active
00:45:34 T:5024   DEBUG: CRemoteControl::Connect - connecting to: ::1:24000 ...
00:45:35 T:3480   DEBUG: CRenderSystemDX::InitRenderSystem - trying D3D9Ex...
00:45:35 T:3480   DEBUG: CRenderSystemDX::InitRenderSystem - using D3D9Ex
00:45:35 T:3480   DEBUG: CRenderSystemDX::CreateDevice on adapter 0
00:45:35 T:3480   DEBUG: CRenderSystemDX::CreateDevice - using hardware vertex processing
00:45:35 T:3480   DEBUG: CRenderSystemDX::CreateDevice - adapter 0: igdumdx32.dll, Intel(R) HD Graphics, VendorId 32902, DeviceId 70
00:45:35 T:3480   DEBUG: CRenderSystemDX::CreateDevice - using D3DCAPS2_DYNAMICTEXTURES
00:45:35 T:3480   DEBUG: CRenderSystemDX::CreateDevice - texture caps: 0x0021EC45
00:45:35 T:3480   DEBUG: CRenderSystemDX::CreateDevice - RENDER_CAPS_DXT
00:45:35 T:3480   DEBUG: CRenderSystemDX::CreateDevice - RENDER_CAPS_NPOT
00:45:35 T:3480   DEBUG: CRenderSystemDX::CreateDevice - RENDER_CAPS_DXT_NPOT
00:45:35 T:3480   DEBUG: CRenderSystemDX::CreateDevice - Intel workaround - specifying minimum pitch for compressed textures.
00:45:35 T:3480   DEBUG: CWinSystemWin32::SetFullScreen (windowed fullscreen) on screen 0 with size 1366x768, refresh 60.000000
00:45:35 T:3480   DEBUG: CRenderManager::UpdateDisplayLatency - Latency set to 0 msec
00:45:35 T:3480    INFO: load default splash image: C:\Program Files (x86)\XBMC\media\Splash.png
00:45:35 T:3480   DEBUG: SECTION:LoadDLL(special://xbmcbin/system/ImageLib.dll)

00:45:35 T:3480    INFO: Loading special://xbmc/system/IRSSmap.xml
00:45:35 T:3480    INFO: * Adding remote mapping for device 'Microsoft MCE'
00:45:35 T:3480    INFO: * Adding remote mapping for device 'Abstract'
00:45:35 T:3480   DEBUG: CButtonTranslator::Load - no userdata IRSSmap.xml found, skipping
00:45:35 T:3480    INFO: GUI format 1366x768 1366x768 @ 60.00 - Full Screen
00:45:35 T:3480   DEBUG: guilib: Fill viewport always for solving rendering passes
00:45:35 T:3480   DEBUG: SECTION:LoadDLL(special://xbmcbin/system/libcurl.dll)
00:45:35 T:3480  NOTICE: initializing playlistplayer
00:45:35 T:3480  NOTICE: DONE initializing playlistplayer
00:45:35 T:3480   DEBUG: DPMS: supported power-saving modes: OFF STANDBY
00:45:35 T:5024   DEBUG: CRemoteControl::Connect - connecting to: 127.0.0.1:24000 ...
00:45:35 T:3480    INFO: Unloading old skin ...
00:45:35 T:3480    INFO:   load skin from:C:\Program Files (x86)\XBMC\addons\skin.confluence
00:45:35 T:3480    INFO:   load fonts for skin...
00:45:35 T:3480    INFO: Loading fonts from C:\Program Files (x86)\XBMC\addons\skin.confluence\720p\Font.xml
00:45:36 T:3480    INFO: Loading skin includes from C:\Program Files (x86)\XBMC\addons\skin.confluence\720p\includes.xml
00:45:36 T:3480    INFO:   load new skin...
00:45:36 T:3480    INFO: Loading skin file: Home.xml
00:45:36 T:5024   ERROR: CRemoteControl::Connect - failed to connect
00:45:36 T:5024    INFO: CRemoteControl::Process - failed to connect to irss, will keep retrying every 5 seconds
(I removed some things to stay in the character limit)
XBMC will load up if the mysql lines are removed from the advancedsettings.xml

And on the XBMCbuntu I have been getting lots of these:
Code:
00:24:07 T:3014654832   ERROR: Unable to open database: MyVideos60 [2003](Can't connect to MySQL server on '192.168.0.9' (111))

I have tried fiddling with the mysql settings with no luck

Last library update left none of those errors at all. Still no mysql database made though

RE: XBMCbuntu and mysql server running on ReadyNAS - Ned Scott - 2012-08-23

Use pastebin.com or xbmclogs.com to post the whole logs. It sounds like XBMC might not have the right access on the MySQL server, but I'm not sure.

RE: XBMCbuntu and mysql server running on ReadyNAS - Spacedementia87 - 2012-08-23

Windows: http://pastebin.com/Jcd98zjt

I can't paste the ubuntu log at the moment. It is too big.

I'll boot it up tomorrow and post the log then