Updated to SVN 14436 tonight and restarted server. When I started the WebUI
(trying to access default skin), I got the Setup Assistant. I tried using the
query string param to skip the wizard.
SC reported 0 items in my library, and the settings seemed to be lost.
I looked in .\server\prefs\server.prefs, and I can see my normal prefs
settings, so for some reason SC is not looking in there for the settings any
more.
I run my own MySQL instance. I looked in the log, and saw the following:
[00:13:07.4944] Slim::Schema::forceCommit (1348) Warning: Trying to commit
transactions before DB is initialized!
[00:13:07.4986] Slim::Schema::Storage::throw_exception (67) Error: DBI
Connection failed: DBI
connect('hostname=127.0.0.1;port=9092;database=slimserver','slimserver',...)
failed: Lost connection to MySQL server during query at
P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 652
[00:13:07.4994] Slim::Schema::Storage::throw_exception (67) Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm line 67)
frame 1: Slim::Schema::Storage::throw_exception
(P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 658)
frame 2: DBIx::Class::Storage::DBI::_connect
(P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 616)
frame 3: DBIx::Class::Storage::DBI::_populate_dbh
(P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 543)
frame 4: DBIx::Class::Storage::DBI::ensure_connected
(P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm line 27)
frame 5: (eval) (P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm
line 27)
frame 6: Slim::Schema::Storage::dbh
(P:/Music/SlimServer/trunk/server/Slim/Schema.pm line 244)
frame 7: (eval) (P:/Music/SlimServer/trunk/server/Slim/Schema.pm line 244)
frame 8: Slim::Schema::disconnect
(P:\Music\SlimServer\trunk\server\slimserver.pl line 961)
frame 9: main::cleanup (P:/Music/SlimServer/trunk/server/Slim/bootstrap.pm
line 368)
frame 10: Slim::bootstrap::sigint
(P:/Music/SlimServer/trunk/server/Slim/bootstrap.pm line 402)
frame 11: Slim::bootstrap::theEND
(P:\Music\SlimServer\trunk\server\slimserver.pl line 998)
frame 12: main::END (P:\Music\SlimServer\trunk\server\slimserver.pl line 0)
frame 13: (eval) (P:\Music\SlimServer\trunk\server\slimserver.pl line 0)
[00:13:07.5018] Slim::Schema::Storage::dbh (38) Warning: Unable to connect to
the database - trying to bring it up!
[00:13:08.4845] Slim::Utils::MySQLHelper::startServer (271) Error: Couldn't
install MySQL as a service! Will run as a process!
[00:13:23.4846] Slim::bootstrap::sigterm (376) Got sigterm
[00:13:23.4852] Slim::Schema::forceCommit (1348) Warning: Trying to commit
transactions before DB is initialized!
[00:13:24.5627] Slim::Schema::Storage::throw_exception (67) Error: DBI
Connection failed: DBI
connect('hostname=127.0.0.1;port=9092;database=slimserver','slimserver',...)
failed: Can't connect to MySQL server on '127.0.0.1' (10061) at
P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 652
[00:13:24.5634] Slim::Schema::Storage::throw_exception (67) Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm line 67)
frame 1: Slim::Schema::Storage::throw_exception
(P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 658)
frame 2: DBIx::Class::Storage::DBI::_connect
(P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 616)
frame 3: DBIx::Class::Storage::DBI::_populate_dbh
(P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 543)
frame 4: DBIx::Class::Storage::DBI::ensure_connected
(P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm line 27)
frame 5: (eval) (P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm
line 27)
frame 6: Slim::Schema::Storage::dbh
(P:/Music/SlimServer/trunk/server/Slim/Schema.pm line 244)
frame 7: (eval) (P:/Music/SlimServer/trunk/server/Slim/Schema.pm line 244)
frame 8: Slim::Schema::disconnect
(P:\Music\SlimServer\trunk\server\slimserver.pl line 961)
frame 9: main::cleanup (P:/Music/SlimServer/trunk/server/Slim/bootstrap.pm
line 378)
frame 10: Slim::bootstrap::sigterm
(P:\Music\SlimServer\trunk\server\CPAN/DBD/mysql.pm line 140)
frame 11: (eval) (P:\Music\SlimServer\trunk\server\CPAN/DBD/mysql.pm line
140)
frame 12: DBD::mysql::dr::connect
(P:\Music\SlimServer\trunk\server\CPAN/DBI.pm line 617)
frame 13: DBI::__ANON__ (P:\Music\SlimServer\trunk\server\CPAN/DBI.pm line
681)
frame 14: DBI::connect
(P:/Music/SlimServer/trunk/server/Slim/Utils/MySQLHelper.pm line 478)
frame 15: (eval) (P:/Music/SlimServer/trunk/server/Slim/Utils/MySQLHelper.pm
line 478)
frame 16: Slim::Utils::MySQLHelper::dbh
(P:/Music/SlimServer/trunk/server/Slim/Utils/MySQLHelper.pm line 289)
frame 17: Slim::Utils::MySQLHelper::startServer
(P:/Music/SlimServer/trunk/server/Slim/Utils/MySQLHelper.pm line 115)
frame 18: Slim::Utils::MySQLHelper::init
(P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm line 42)
frame 19: Slim::Schema::Storage::dbh
(P:/Music/SlimServer/trunk/server/Slim/Schema.pm line 244)
frame 20: (eval) (P:/Music/SlimServer/trunk/server/Slim/Schema.pm line 244)
frame 21: Slim::Schema::disconnect
(P:\Music\SlimServer\trunk\server\slimserver.pl line 961)
frame 22: main::cleanup (P:/Music/SlimServer/trunk/server/Slim/bootstrap.pm
line 368)
frame 23: Slim::bootstrap::sigint
(P:/Music/SlimServer/trunk/server/Slim/bootstrap.pm line 402)
frame 24: Slim::bootstrap::theEND
(P:\Music\SlimServer\trunk\server\slimserver.pl line 998)
frame 25: main::END (P:\Music\SlimServer\trunk\server\slimserver.pl line 0)
frame 26: (eval) (P:\Music\SlimServer\trunk\server\slimserver.pl line 0)
I looked at my Application event log, and see the following:
Type: Information
Date: 07/11/2007
Time: 00:14:54
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
P:\Music\SLIMSE~1\trunk\server\Bin\MSWIN3~1\mysqld.exe: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 9092 MySQL Community Edition
(GPL)
For more information, see Help and Support Center at http://www.mysql.com.
Type: Information
Date: 07/11/2007
Time: 00:14:46
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
P:\Applications\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition
(GPL)
For more information, see Help and Support Center at http://www.mysql.com.
Type: Information
Date: 07/11/2007
Time: 00:14:44
Event: 1
Source: AVGEMS
Category: None
User: N/A
Computer: HERGEST
Description:
Service started
Type: Information
Date: 07/11/2007
Time: 00:14:40
Event: 1
Source: Avg7UpdSvc
Category: None
User: N/A
Computer: HERGEST
Description:
Service started
Type: Information
Date: 07/11/2007
Time: 00:14:39
Event: 2570
Source: Adobe Active File Monitor 5.0
Category:
User: N/A
Computer: HERGEST
Description:
Adobe Active File Monitor Service has Started.
Type: Information
Date: 07/11/2007
Time: 00:13:23
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
P:\Applications\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
For more information, see Help and Support Center at http://www.mysql.com.
Type: Information
Date: 07/11/2007
Time: 00:13:09
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
P:\Music\SLIMSE~1\trunk\server\Bin\MSWIN3~1\mysqld.exe: Shutdown complete
For more information, see Help and Support Center at http://www.mysql.com.
Type: Information
Date: 07/11/2007
Time: 00:13:07
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
P:\Music\SLIMSE~1\trunk\server\Bin\MSWIN3~1\mysqld.exe: Normal shutdown
For more information, see Help and Support Center at http://www.mysql.com.
Type: Information
Date: 07/11/2007
Time: 00:08:37
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
P:\Applications\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition
(GPL)
For more information, see Help and Support Center at http://www.mysql.com.
Type: Information
Date: 07/11/2007
Time: 00:08:28
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
P:\Applications\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
For more information, see Help and Support Center at http://www.mysql.com.
Type: Information
Date: 07/11/2007
Time: 00:08:19
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
P:\Applications\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
For more information, see Help and Support Center at http://www.mysql.com.
Type: Information
Date: 06/11/2007
Time: 23:02:24
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
P:\Music\SLIMSE~1\trunk\server\Bin\MSWIN3~1\mysqld.exe: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 9092 MySQL Community Edition
(GPL)
For more information, see Help and Support Center at http://www.mysql.com.
Type: Information
Date: 06/11/2007
Time: 23:02:15
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
P:\Music\SLIMSE~1\trunk\server\Bin\MSWIN3~1\mysqld.exe: Shutdown complete
For more information, see Help and Support Center at http://www.mysql.com.
Type: Information
Date: 06/11/2007
Time: 23:02:13
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
P:\Music\SLIMSE~1\trunk\server\Bin\MSWIN3~1\mysqld.exe: Normal shutdown
For more information, see Help and Support Center at http://www.mysql.com.
Type: Information
Date: 06/11/2007
Time: 23:02:11
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
P:\Music\SLIMSE~1\trunk\server\Bin\MSWIN3~1\mysqld.exe: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 9092 MySQL Community Edition
(GPL)
For more information, see Help and Support Center at http://www.mysql.com.
Type: Warning
Date: 06/11/2007
Time: 23:02:11
Event: 100
Source: MySQL
Category: None
User: N/A
Computer: HERGEST
Description:
Can't open and lock time zone table: Table 'mysql.time_zone_leap_second'
doesn't exist trying to live without them
For more information, see Help and Support Center at http://www.mysql.com.
For some reason, it appears that SqueezeCenter is starting/stopping the
internal MySQL instance frequently at startup, and also trying to connect to my
own MySQL instance. Maybe this is just a side-effect of not seeing my prefs
properly.
Any ideas what is going on?
Phil
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/beta
