PDA

View Full Version : Can't install Squeezecenter on Vista



gsgweb
2008-03-11, 10:36
Tried upgrading Slimserver 6.5 to Squeezecenter on the weekend. After the install, the tray icon will show "Squeezecenter starting" but it never starts. Event viewer shows an error message that MYSQL is aborting right after it starts up, then it shuts down. Have tried uninstalling everything & re-installing clean. Turned off windows firewall and UAC during the install. No luck. Tried running both Squeezecenter and MYSQL as a windows service, but MYSQL still aborts when you try to start it. I'm installing it on a new Dell Vista Home Premium PC with almost no other apps installed. 6.5 had been running perfectly for a few months. I ended up using an old W2K PC, and Squeezecenter 7.0 installs successfully on it. The new Duet and SB3 synch up and play flawlessly even though the old PC is sloooowww!! Has anyone had the same problem with MYSQL dying on Vista? Any ideas?

Jeff Flowerday
2008-03-11, 10:58
Have you looked here?

http://forums.slimdevices.com/showthread.php?t=32578

The second issue sounds similar.

mherger
2008-03-11, 23:47
> Tried upgrading Slimserver 6.5 to Squeezecenter on the weekend. After
> the install, the tray icon will show "Squeezecenter starting" but it
> never starts. Event viewer shows an error message that MYSQL is
> aborting right after it starts up, then it shuts down. Have tried

What is it saying _exactly_? Using McAfee?

Michael

gsgweb
2008-03-12, 12:21
>
What is it saying _exactly_? Using McAfee?

Michael

Not using McAfee. Virus S/W is AVG. The message in event viewer is only "MYSQL is aborting" nothing else. Are there any other system logs I can look for error messages in?

George

mherger
2008-03-12, 14:50
> Not using McAfee. Virus S/W is AVG. The message in event viewer is only
> "MYSQL is aborting" nothing else. Are there any other system logs I can
> look for error messages in?

AVG should be fine - I'm using it myself too. Do you see anything in server.log?

--

Michael

gsgweb
2008-03-12, 15:21
This is wht shows up in server log. No other indication that I can find anywhere to show why MySQL aborts.

[08-03-12 12:47:54.8082] Slim::Utils::MySQLHelper::createSystemTables (433) FATAL: Couldn't connect to database: [Can't connect to MySQL server on '127.0.0.1' (10061)]
[08-03-12 12:47:55.8094] Slim::Schema::forceCommit (1363) Warning: Trying to commit transactions before DB is initialized!
[08-03-12 13:00:02.6252] Slim::Utils::MySQLHelper::createSystemTables (433) FATAL: Couldn't connect to database: [Can't connect to MySQL server on '127.0.0.1' (10061)]
[08-03-12 13:00:03.6264] Slim::Schema::forceCommit (1363) Warning: Trying to commit transactions before DB is initialized!

gsgweb
2008-03-13, 10:25
Did some more troubleshooting last night. In comparing the folders/files created on the W2K install of SC7 there are missing files on the Vista machine. Tried copying over the missing folders and now I can get MySQL to start successfully via the CMD line, but SC7 will not connect to it and I get the following error in the server log. I suspect there are still missing files or maybe I'm not starting MySQL with all the correct options as defined in the my.CNF file. I can't figure tha part out. But clearly the vista install isn't creating all the required files for SC7 to run on my PC.

I called and emailed tech support last week, but can't get a response from them. It shouldn't be this hard!

[08-03-13 08:56:05.9914] Slim::Schema::init (124) Error: Couldn't connect to database! Fatal error: [Bad file descriptor] Exiting!
[08-03-13 08:56:05.9919] Slim::Schema::init (124) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/<C:\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Schema.pm line 124)
frame 1: Slim::Schema::init (/<C:\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Music/Info.pm line 76)
frame 2: Slim::Music::Info::init (slimserver.pl line 348)
frame 3: main::init (slimserver.pl line 451)
frame 4: main::main (slimserver.pl line 86)
frame 5: PerlSvc::Interactive (perlsvc line 855)
frame 6: PerlSvc::_interactive (slimserver.pl line 0)
frame 7: (eval) (slimserver.pl line 0)

[08-03-13 08:56:05.9923] Slim::Schema::forceCommit (1363) Warning: Trying to commit transactions before DB is initialized!
[08-03-13 08:56:06.9870] Slim::Schema::Storage::throw_exception (67) Error: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=sli mserver','slimserver',...) failed: Can't connect to MySQL server on '127.0.0.1' (10061) at C:\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 652
[08-03-13 08:56:06.9874] Slim::Schema::Storage::throw_exception (67) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (C:/SQUEEZ~1/server/Slim/Schema/Storage.pm line 67)
frame 1: Slim::Schema::Storage::throw_exception (C:\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 658)
frame 2: DBIx::Class::Storage::DBI::_connect (C:\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 616)
frame 3: DBIx::Class::Storage::DBI::_populate_dbh (C:\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 543)
frame 4: DBIx::Class::Storage::DBI::ensure_connected (C:/SQUEEZ~1/server/Slim/Schema/Storage.pm line 27)
frame 5: (eval) (C:/SQUEEZ~1/server/Slim/Schema/Storage.pm line 27)
frame 6: Slim::Schema::Storage::dbh (/<C:\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Schema.pm line 244)
frame 7: (eval) (/<C:\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Schema.pm line 244)
frame 8: Slim::Schema::disconnect (slimserver.pl line 964)
frame 9: main::cleanup (/<C:\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/bootstrap.pm line 368)
frame 10: Slim::bootstrap::sigint (/<C:\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/bootstrap.pm line 402)
frame 11: Slim::bootstrap::theEND (slimserver.pl line 1001)
frame 12: main::END (slimserver.pl line 0)
frame 13: (eval) (slimserver.pl line 0)

[08-03-13 08:56:27.9870] Slim::Utils::MySQLHelper::stopServer (382) FATAL: Server didn't shutdown in 20 seconds!
[08-03-13 08:56:27.9875] main:: (0) Warning: FATAL: Server didn't shutdown in 20 seconds! at /<C:\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Utils/MySQLHelper.pm line 382
END failed--call queue aborted.

amcluesent
2008-03-13, 12:26
Is you login account to Vista a member of Administrators?

gsgweb
2008-03-13, 14:19
Yes, full admin rights. Even tried changing properties on all the executables to run as administrator. No good. Vista SP1 is available next week. I've read that installing it solves some weird installation issues with iTunes, so maybe I'll get lucky.

I also thought about installing MySQL on it's own to see if that would work. Is it possible to configure SC7 to use an existing instance of MySQL instead of the distributable version it comes with?

gsgweb
2008-03-14, 14:27
Is it possible to configure SC7 to use an existing instance of MySQL instead of the distributable version it comes with?

Anyone know the answer this one? It'd be nice if I could get this this to work.

Still haven't heard a peep from anyone in tech support. 7 days and counting.

George

radish
2008-03-14, 17:59
Is it possible to configure SC7 to use an existing instance of MySQL instead of the distributable version it comes with?

Try this: http://wiki.slimdevices.com/index.cgi?ExistingMySQLInstance

brucegrr
2008-03-14, 18:05
you can get the vista sp1 now if you want.

http://www.winmatrix.com/forums/index.php?showtopic=16968

It is a Microsoft sanctioned hack. It works. I have used it on three different computers.

brucegrr
2008-03-14, 18:10
you mentioned turning off uac during install. Is it still off? If you turned it back on it "may" be causing the problem.

are your music files on the same vista system?
I had problem with squeezecenter being on a vista computer and my music files on a win xp (home ed) computer. Big file permission problem. There was no way to make te win xp files accessible to vista. I had to download a third party add on that allowed me to change the permissions (which you can do in win xp professional but not home)

pfarrell
2008-03-14, 18:11
radish wrote:
>
> Try this: http://wiki.slimdevices.com/index.cgi?ExistingMySQLInstance

I tried to follow these just last week and could not get it to work.
Does anyone know if the wiki has been updated to SC7 specs?

Specifically, my server.prefs has lines:

dbpassword: ''
dbsource: dbi:mysql:hostname=127.0.0.1;port=9092;database=%s
dbusername: slimserver

which do not match the wiki. I can't find any
place in the properties file that defines the %s that is filled in with
the database name (or schema name).


--
Pat Farrell
http://www.pfarrell.com/

gsgweb
2008-03-16, 16:01
you mentioned turning off uac during install. Is it still off? If you turned it back on it "may" be causing the problem.

are your music files on the same vista system?

Yep, it's still off & the music files are on the same machine. I think I've isolated the problem though. It looks like the SC7 install is failing to write the MySQL sub-directories under c:\programdata\squeezecenter\ on my PC. I compared my install to a friend's also running Vista and from what I could see that's what is missing, which would explain why MySQL is aborting. Next step is to try and figure out why the write is failing. All the permissions look OK so I hope SP1 fixes the issue.

I might also try using the existing MySQL instance instructions pointed to in the wiki.

Thanks all!

gsgweb
2008-03-22, 01:31
Update on this problem. After I installed Vista SP1, Squeezecenter 7.0 installed successfully. Eveything seems to be working perfectly now.

SP1 install was painless, took about 40 mins.

-G