[mxlance]

first time mysql user issues.
mac osx 10.8 serving to 1 chromebox/xubuntu 15.04 - kodi 16 on both.

i have mysql working and the library is working fine and updating. Thank You!
however i can not get playlists to work or show on the client

trying to follow: http://kodi.wiki/view/MySQL/Sync_other_parts_of_Kodi

this is my advancedsettings.xml

(EDIT)
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.2.100</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.2.100</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
<pathsubstitution>
<substitute>
<from>special://profile/playlists/</from>
<to>smb://192.168.2.100/DeepCat/Users/DeepCat/Library/Application_Support/kodi/userdata/playlists/</to>
</substitute>
</pathsubstitution>
</advancedsettings>

The client error: "couldn't connect to network server"

any ideas what i am doing wrong?
thank you

[Memphiz]

that smb path looks wrong - are you sure that "/Users/DeepCat" in there is correct? (looks much better to me without it...)

[mxlance]

thanks for the reply.
tried removing that and no go.

the sever (mac) can see and create playlists with the advancedsettings.xml as above.
however the client can not.
not server/mac or client could with the address as you suggested.

if i understand this right then the address is correct?
i thought it might be a permissions issue but nothing i tray works.

thank you

[black_eagle]

I agree that it is most likely a permissions issue. Grab yourself a debug log (wiki) and check in there. I have tried substituting playlists across a network but I get this in my log

PHP Code:

07:02:56 T:2997180288   ERROR: Create - Error( Read-only file system )
07:02:56 T:2997180288   ERROR: Create - Error creating /home/xbmc/.kodi/userdata/playlists/
07:02:56 T:2997180288   ERROR: Create - Error creating special://profile/playlists/
07:02:56 T:2997180288   ERROR: Create - Error( Read-only file system )
07:02:56 T:2997180288   ERROR: Create - Error creating /home/xbmc/.kodi/userdata/playlists/music
07:02:56 T:2997180288   ERROR: Create - Error creating special://profile/playlists/music
07:02:56 T:2997180288   ERROR: Create - Error( Read-only file system )
07:02:56 T:2997180288   ERROR: Create - Error creating /home/xbmc/.kodi/userdata/playlists/video
07:02:56 T:2997180288   ERROR: Create - Error creating special://profile/playlists/video
07:02:56 T:2997180288   ERROR: Create - Error( Read-only file system )
07:02:56 T:2997180288   ERROR: Create - Error creating /home/xbmc/.kodi/userdata/playlists/mixed
07:02:56 T:2997180288   ERROR: Create - Error creating special://profile/playlists/mixed 


In this case, /home/xbmc/.kodi/userdata/playlists/ is the local machine but it's substituted with the following

PHP Code:

<substitute>
    <from>special://profile/playlists/</from>
    <to>smb://DIAMOND/userdata/playlists/</to>
  </substitute> 


This is in spite of the permissions being open on those directories on the server.

[mxlance]

sorry but my brain is fried.
not sure where to start with this.
questions:
1. do i check the log on the server or client or both?
2. in your example above (<to>smb://DIAMOND/userdata/playlists/</to>) the path is short.
are you saying i should use somthing like:
<to>smb://192.168.2.100/userdata/playlists/</to>
or
<to>smb://DeepCat/userdata/playlists/</to>

or am i completely confused?
thank you for the help

[edit] tried those did not work.

[black_eagle]

Sorry, I didn't mean to confuse you.

1. Check the debug log on the client that you are trying to connect to the server with.
2. The path is short because my SMB share starts from the userdata folder
3. I am saying that I have never got this to work properly, in spite of all the permissions set correctly for the smb share, guest access with read/write access enabled etc. The only thing that I can suggest is that you periodically copy the playlist directory from your server to your client machine(s). rsync on Linux (Grsync on Mac) is one example of a utility you could use to do this, however I realise this is less than ideal.

[mxlance]

@black_eagle
thanks for the help.
you did not confuse me, that comes naturally.
i only had a one and half day opportunity to get this working - other priorities.
so this will be placed on hold for a few weeks and moved to the future project list.
although this does not sound like it can work with a mac.

thanks again for the advice.