Phpmyadmin root login not possible

yammers · 9 March 2020 20:35

000 i wrong i know i have just left out the last part of my Ip address did not want to give it away

yammers · 9 March 2020 21:01

thanks i have solved it i think. it is now just re-scanning data.

darwindesign · 9 March 2020 21:08

If you went the path substitution route and did it correctly then you wouldn’t be re-scanning anything as your original library would be working as it had been before you moved to MySQL. If you are going to start fresh then remove the path substitution and delete your library and start over from scratch.

yammers · 9 March 2020 21:18

i re did my advanced setting to this

<advancedsettings>

[-](#) <videodatabase>

  <type>mysql</type>

  <host>192.168.1.118</host>

  <port>3306</port>

  <user>osmc</user>

  <pass>osmc</pass>

  </videodatabase>

[-](#) <musicdatabase>

  <type>mysql</type>

  <host>192.168.1.118</host>

  <port>3306</port>

  <user>osmc</user>

  <pass>osmc</pass>

  </musicdatabase>

[-](#) <videolibrary>

  <importwatchedstate>true</importwatchedstate>

  <importresumepoint>true</importresumepoint>

  </videolibrary>

  </advancedsettings>

however i appear to have two copies now in my libary one where by it says vdeio file not found and the other where it is found and it plays

Moderator’s note: reformatted to improve readability.

ActionA · 9 March 2020 21:44

Run a library clean to remove the duplicates.

yammers · 9 March 2020 23:16

its playing up again here is my advanced setting xml. and sources xml

?xml version="1.0" encoding="utf-8"?>
<advancedsettings>
	<videodatabase>
		<name>Osmc _Videos</name>
		<host>192.168.1.118</host>
		<user>osmc</user>
		<pass>osmc</pass>
		<type>mysql</type>
		<port>3306</port>
	</videodatabase>
	<musicdatabase>
		<name>Osmc_Music</name>
		<host>192.168.1.118</host>
		<user>osmc</user>
		<pass>osmc</pass>
		<type>mysql</type>
		<port>3306</port>
	</musicdatabase>
	<videolibrary>
		<importwatchedstate>true</importwatchedstate>
		<importresumepoint>true</importresumepoint>
	</videolibrary>
</advancedsettings>

yammers · 9 March 2020 23:23

sources

BODY{font:x-small ‘Verdana’;margin-right:1.5em} .c{cursor:hand} .b{color:red;font-family:‘Courier New’;font-weight:bold;text-decoration:none} .e{margin-left:1em;text-indent:-1em;margin-right:1em} .k{margin-left:1em;text-indent:-1em;margin-right:1em} .t{color:#990000} .xt{color:#990099} .ns{color:red} .dt{color:green} .m{color:blue} .tx{font-weight:bold} .db{text-indent:0px;margin-left:1em;margin-top:0px;margin-bottom:0px;padding-left:.3em;border-left:1px solid #CCCCCC;font:small Courier} .di{font:small Courier} .d{color:blue} .pi{color:blue} .cb{text-indent:0px;margin-left:1em;margin-top:0px;margin-bottom:0px;padding-left:.3em;font:small Courier;color:#888888} .ci{font:small Courier;color:#888888} PRE{margin:0px;display:inline}

-

Auto-mounted drives

smb://192.168.1.118:445/Elements/Plex/Shared Movies/Movies/

true

-

Auto-mounted drives

/media/

true

-

darwindesign · 9 March 2020 23:24

There is a “</>” icon in the toolbar that allows you to post preformatted text. I edited your previous post. Please do it yourself in the future.

If you posted the entirety of the advancedsettings.xml file then your missing the first character.

yammers · 9 March 2020 23:25

advanced setting was done in note pad +

yammers · 9 March 2020 23:28

sorry thank you

darwindesign · 9 March 2020 23:29

That is not XML or a valid source file.

yammers · 9 March 2020 23:34

the sources file is what OSMC creates and its file extension shows .xml.

    <sources>
<programs>
    <default pathversion="1"></default>
</programs>
<video>
    <default pathversion="1"></default>
    <source>
        <name>Auto-mounted drives</name>
        <path pathversion="1">smb://192.168.1.118:445/Elements/Plex/Shared Movies/Movies/</path>
        <allowsharing>true</allowsharing>
    </source>
</video>
<music>
    <default pathversion="1"></default>
    <source>
        <name>Auto-mounted drives</name>
        <path pathversion="1">/media/</path>
        <allowsharing>true</allowsharing>
    </source>
</music>
<pictures>
    <default pathversion="1"></default>
</pictures>
<files>
    <default pathversion="1"></default>
</files>
<games>
    <default pathversion="1"></default>
</games>

darwindesign · 9 March 2020 23:41

The file extension is superficial and what you posted here is not the same as you posted above. This is also either not the full file that Kodi created or you are not posting all of it as Kodi would not create an invalid file.

If you have installed notepad++ then you should set the language to xml and install the xml tools add-on and run the validation from that add-on.

yammers · 9 March 2020 23:56

i have run it on the sources file and come back fine for validation

yammers · 9 March 2020 23:59

i have done the same on advancedsettings and errors found, using the xml validation tool. i cant see where the issue is .

yammers · 10 March 2020 00:44

Think i have solved it again

yammers · 17 March 2020 22:47

HI there

I have ditched the php m admin however and everything else has been set up as per normal. however on my tablet with the advanced setting coppied over when i click on a film i get file no longer avalaible do i want to remove it.

do i have to set something up like this in my advanced settings

<pathsubstitution>
    <substitute>
      <from>/Users/admin/Movies/</from>
      <to>nfs://192.168.0.10/Users/admin/Movies/</to>
    </substitute>
  </pathsubstitution>
</advancedsettings>

or where the sources folder is in do i edit the path or rescan

bmillham · 17 March 2020 23:04

What do the sources look like on the ‘Master’ system? That’s the one where you do the scraping from to create the MySQL database.

The snippet you posted looks like it’s a Windows share, and if it’s on OSMC it’s using very non-standard paths.

darwindesign · 17 March 2020 23:22

If you bring up the information window on a video in Kodi and then highlight over the “refresh” option most skins display the file path that is in the database. You should be able to figure out the <from> by looking at this. Regarding the rest…

yammers · 18 March 2020 00:29

This is the advanced settings file copied over from osmc to tablet

    <?xml version="1.0" encoding="utf-8"?>
<advancedsettings>
	<videolibrary>
		<importwatchedstate>true</importwatchedstate>
		<importresumepoint>true</importresumepoint>
	</videolibrary>
	<videodatabase>
		<name>MyVideos</name>
		<host>192.168.1.xxx</host>
		<user>osmc</user>
		<pass>password</pass>
		<type>mysql</type>
		<port>3306</port>
	</videodatabase>
</advancedsettings>

Here is the sources file copied from osmc and copied to my tablet.

<sources>
<programs>
    <default pathversion="1"></default>
</programs>
<video>
    <default pathversion="1"></default>
    <source>
        <name>Auto-mounted drives</name>
        <path pathversion="1">smb://192.168.1.118/Elements/Plex/Shared Movies/Movies/</path>
        <allowsharing>true</allowsharing>
    </source>
</video>
<music>
    <default pathversion="1"></default>
    <source>
        <name>Auto-mounted drives</name>
        <path pathversion="1">/media/</path>
        <allowsharing>true</allowsharing>
    </source>
</music>
<pictures>
    <default pathversion="1"></default>
</pictures>
<files>
    <default pathversion="1"></default>
</files>
<games>
    <default pathversion="1"></default>
</games>