2 XBMC PCs and 1 Database on the shared NAS

2 XBMC PCs and 1 Database on the shared NAS - Printable Version

+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+---- Forum: Windows support (/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77

- mwkurt - 2010-08-27 15:32

So the password that I need to put into mysql when setting it up is the same password that I use to log into my computer? Or am I wrong about that. When you say "Asministrator account" you mean Admin for MySQL and not my computer as a whole?

- charrua - 2010-08-27 16:32

mwkurt Wrote:So the password that I need to put into mysql when setting it up is the same password that I use to log into my computer? Or am I wrong about that. When you say "Asministrator account" you mean Admin for MySQL and not my computer as a whole?

No, is not the administrator password of your PC, I meant that "root" is the administrator user of MySQL server.

- mwkurt - 2010-08-27 22:31

charrua,

I tried resetting my root password according to the url that you posted. Here is what I did and what happened:

I installed mysql to the C: folder ---> C:\mysql

I created a text named mysql-init.txt with the following inside of it:

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

I was going to use PASSWORD as my new pasword.

Opened a command prompt and entered the following:

C:\mysql\bin\mysqld-nt --init-file=C:\\mysql-init.txt

I got the following error message:

C:\mysql\bin\mysql-nt' is not recognized as an internal or external command, operable program or batch file

Looks like I am F-cked!

I am at a loss now.

I also tried HeidiSQL and got the following error:

SQL error (1045): Access denied for user 'root@localhost (using password: YES)

Any other suggestions?

Thanks,
Mark

- charrua - 2010-08-27 23:05

mwkurt Wrote:charrua,
I tried resetting my root password according to the url that you posted. Here is what I did and what happened:
I installed mysql to the C: folder ---> C:\mysql
I created a text named mysql-init.txt with the following inside of it:
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
I was going to use PASSWORD as my new pasword.
Opened a command prompt and entered the following:
C:\mysql\bin\mysqld-nt --init-file=C:\\mysql-init.txt
I got the following error message:
C:\mysql\bin\mysql-nt' is not recognized as an internal or external command, operable program or batch file

Try C:\mysql\bin\mysqld.exe --init-file=C:\\mysql-init.txt

- mwkurt - 2010-08-27 23:08

Charrua,

Here is an update to my problem.

I went through my computer and found all instances of mysql, and deleted them. This allowed me to go back and reinstall mysql and enter new passwords. In my case I made the passwrord "xbmc", without the quotes.

I started XBMC and expected something to happen in the way of making a datbase and nothing happened. Here is my log file:

http://pastebin.com/RzDKYg3W

XBMC still can't open the database and it says (1045) but HeidlSQL works now and I can open my db structure when I enter the password "xbmc".

How do I get XBMC to integrate with mysql now?

Thanks,
Mark

- charrua - 2010-08-27 23:17

mwkurt Wrote:Charrua,
Here is an update to my problem.
I went through my computer and found all instances of mysql, and deleted them. This allowed me to go back and reinstall mysql and enter new passwords. In my case I made the passwrord "xbmc", without the quotes.
I started XBMC and expected something to happen in the way of making a datbase and nothing happened. Here is my log file:

http://pastebin.com/RzDKYg3W

XBMC still can't open the database and it says (1045) but HeidlSQL works now and I can open my db structure when I enter the password "xbmc".

How do I get XBMC to integrate with mysql now?

Thanks,
Mark

Did you create the user 'xbmc' ?
If not you need to do it and give that user all permissions.
You can do that with HeidiSQL, from the menu choose tools>user manager and from there you can create the new user and assign all the permissions.

- mwkurt - 2010-08-28 02:46

Charrua,

I wanted to thank you for all of your help so far...so thanks!

Anyway, I finally figured what I was doing, sort of.

I created the db using HeidiSQL and the user "xbmc" with password "xbmc"

I closed HeidiSQL, opened XBMC, waited a minute then closed XBMC.
Reopened HeidiSQL and this is the result:

There are two items under xbmc_video > bookmark & version.

I don't really know what to look for to see if it is working as it should nor do I know how to test XBMC to see if it is working.

I highly doubt that it is set up correctly as my latest XBMC log is filled with errors:

http://pastebin.com/NeLSvKCr

I did not import my video db into XBMC the first time I reopened after I created the DB. I did however reopen after looking at HeidiSQl and imported at that time.

Do you have any more advice for me, please?

Also...I mentioned this before but never received an answer. When I added the mysqldb information to my advancedsettings.xml, the MOVIE and TVSHOWS entries on the HOME SCREEN are no longer there and I can no longer get into LIBRARY mode. Is this normal behaviour under these circumstances? If it is, All of this may be moot because I don't want to be without those entries and library mode.

Thanks,
Mark

- charrua - 2010-08-28 04:43

mwkurt Wrote:charrua,
Another update...I am getting closer.
When looking in HeidiSQL, Tools, User Manager, besides the root@localhost user, there is now an xbmc@localhost user as well.
The xbmc@localhost user has:
username - xbmc
Password - xbmc (however it changes to a rather long string when reopened)
From Host - Localhost (there was an % in this box but I changed it to localhost)

Open HeidiSQL again and revert the From Host to % as it was (that tells MySQL to allow user xbmc to log from every host).

mwkurt Wrote:Underneath that is a box that says "add privileges". There are two check boxes underneath....Sever Privileges & All Databases. They both have all items inside checked.
Is that all right?

Yes, that's ok.

mwkurt Wrote:Looking back through this thread, I saw where someone else had a similar problem and I think it was the character set. I chose Latin when I installed mysql:

Great. Cause if the collation is set to utf8 some indexes and tables won't be created.

mwkurt Wrote:Also I noticed an entry about a bug in mysql:
Reading your log, I think we've just found a bug in the MySQL functionality:
I don't have any local media sources in XBMC database, so I've never hit this error before, but it seems that the SQL for storing/querying local paths has a bug: it's trying to store the paths with "\" instead of "/" and for MySQL "\" is an special character, so it's returning a syntax error when trying to store a local path with that character. Note that network paths don't have that problem, because they are stored in the format "smb://NETWORK_ADDRESS/SHARED_PATH/".
Could this be affecting me? I am doing everything on the same computer.

Also true, if you define the media sources as local paths you will have a problem, cause they won't be scanned. To avoid this you can share the folders where the media is and then define the media sources over the shared paths.

mwkurt Wrote:I am still getting the following error when opening XBMC:
20:26:54 T:3756 M:234545152 ERROR: Unable to open database: xbmc_video (0)
20:26:54 T:3756 M:234545152 ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)
20:26:54 T:3756 M:234541056 ERROR: Unable to open database: xbmc_video (0)
20:26:54 T:3756 M:234541056 ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)
20:26:54 T:3756 M:234221568 ERROR: Unable to open database: xbmc_video (0)
20:26:54 T:3756 M:234221568 ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)
20:26:54 T:3756 M:234221568 ERROR: Unable to open database: xbmc_video (0)
20:26:54 T:3756 M:234221568 ERROR: Unable to open database at host: localhost db: xbmc_video (old version?)
Any more ideas?
Thanks,
Mark

Try connecting to the db with HeidiSQL using user: xbmc and the password you've defined for it (it should be the same that the one you have in the <password> tag inside advancedsettings.xml) if you can connect to the dbs from HeidiSQL you should be able to connect from XBMC.

- charrua - 2010-08-28 04:57

mwkurt Wrote:Charrua,
I wanted to thank you for all of your help so far...so thanks!
Anyway, I finally figured what I was doing, sort of.

You're welcome. It's a good thing that you've started to read the whole thread, there's a lot of info already here.

mwkurt Wrote:I created the db using HeidiSQL and the user "xbmc" with password "xbmc"
I closed HeidiSQL, opened XBMC, waited a minute then closed XBMC.
Reopened HeidiSQL and this is the result:

There are two items under xbmc_video > bookmark & version.

I don't really know what to look for to see if it is working as it should nor do I know how to test XBMC to see if it is working.

I highly doubt that it is set up correctly as my latest XBMC log is filled with errors:

http://pastebin.com/NeLSvKCr

I did not import my video db into XBMC the first time I reopened after I created the DB. I did however reopen after looking at HeidiSQl and imported at that time.

Do you have any more advice for me, please?

Yes, make shure the dbs collation is really defined as latin1. In HeidiSQL right click the db and select Edit, the character set should be latin1, and collation could be latin1_general_ci, if not select them and click OK. After that delete all tables and views already created and start XBMC again, this time it should create all tables and views. As you did before, you can check that with HeidiSQL, there is no need to close XBMC while you connect to MySQL from HeidiSQL.

mwkurt Wrote:Also...I mentioned this before but never received an answer. When I added the mysqldb information to my advancedsettings.xml, the MOVIE and TVSHOWS entries on the HOME SCREEN are no longer there and I can no longer get into LIBRARY mode. Is this normal behaviour under these circumstances? If it is, All of this may be moot because I don't want to be without those entries and library mode.
Thanks,
Mark

As I wrote in my previous post, remember to share the paths where the media is and then define the media sources within XBMC using the networked paths instead of the local paths.

- mwkurt - 2010-08-29 16:08

Charrua,

Well.....I think it is working as it should!!!! Big Grin

I unistalled XBMC and put the latest nightlie in. I let it import everything overnight and low and behold, I still have my MOVIES and TVSHOWS entries on the home screen. I looked through my XBMC log and did not see any errors. So it looks good. Is there a way I can check to see if it is indeed working as it should.

I think I had to change two things in my mysql DB. First, the language was set latin1_swedish_ci, I changed it as you said to latin1_general_ci. And I changed all of my video libraries to Windows smb shares.

So everything looks good. Thanks so much for all of your help!

Mark