Thanks....just realized that...but like many people I am sure, I already
have a running instance of mysql so how do I set it up to use the existing
instance...no point in running two and I am getting errors in
/tmp/slimserver.log which seem to point to a prob lem
InnoDB: Unable to lock ./ibdata1, error:
11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
060921 15:53:45 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
060921 15:53:45 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
060921 15:53:45 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060921 15:53:45 [ERROR] Do you already have another mysqld server running on port: 9092 ?
060921 15:53:45 [ERROR] Aborting
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
060921 15:53:45 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
060921 15:53:45 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
060921 15:53:45 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060921 15:53:45 [ERROR] Do you already have another mysqld server running on port: 9092 ?
060921 15:53:45 [ERROR] Aborting
060921 15:53:45 [Note]
/usr/local/slimserver/Bin/i386-linux/mysqld: Shutdown complete
File '/usr/share/mysql/charsets/?.conf' not
found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
2006-09-21 15:57:03.4647 scanPathOrURL: Finding valid files in: /mnt/Media/Music/Classic Rock/Led Zeppelin
2006-09-21 15:57:03.4655 About to look for files in /mnt/Media/Music/Classic Rock/Led Zeppelin
2006-09-21 15:57:03.4686 For files with extensions in: [(?i-xsm:\.(?:ape|wma|asf|wax|asx|lnk|wpl|shn|wav|wave|mp3|mp2|m3u|pls|xspf|flc|flac|m4a|mov|m4b|mp4|cue|mp+|mpc|ogg|aif|aiff)$)]
2006-09-21 15:57:03.5063 Found 51 files in /mnt/Media/Music/Classic Rock/Led Zeppelin
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
2006-09-21 16:02:13.2894 About to look for files in /mnt/Media/Playlists
2006-09-21 16:02:13.2915 For files with extensions in: [(?i-xsm:\.(?:asf|wax|asx|lnk|wpl|m3u|pls|xspf|cue)$)]
2006-09-21 16:02:13.2972 Found 1 files in /mnt/Media/Playlists
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
2006-09-21 15:57:03.4647 scanPathOrURL: Finding valid files in: /mnt/Media/Music/Classic Rock/Led Zeppelin
2006-09-21 15:57:03.4655 About to look for files in /mnt/Media/Music/Classic Rock/Led Zeppelin
2006-09-21 15:57:03.4686 For files with extensions in: [(?i-xsm:\.(?:ape|wma|asf|wax|asx|lnk|wpl|shn|wav|wave|mp3|mp2|m3u|pls|xspf|flc|flac|m4a|mov|m4b|mp4|cue|mp+|mpc|ogg|aif|aiff)$)]
2006-09-21 15:57:03.5063 Found 51 files in /mnt/Media/Music/Classic Rock/Led Zeppelin
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
2006-09-21 16:02:13.2894 About to look for files in /mnt/Media/Playlists
2006-09-21 16:02:13.2915 For files with extensions in: [(?i-xsm:\.(?:asf|wax|asx|lnk|wpl|m3u|pls|xspf|cue)$)]
2006-09-21 16:02:13.2972 Found 1 files in /mnt/Media/Playlists
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
From: Ben Sandee [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 21, 2006 4:06 PM
To: Slim Devices Discussion
Subject: Re: [slim] With 6.5, how to switch to mysql?On 9/21/06, Johnny Stork <[EMAIL PROTECTED]> wrote:
I just upgraded to 6.5 on a RHES4 box, and would like to use the mysql db. Are there some configuration docs on where I switch to mysql? Obviously the default still uses the sql-lite db.
No, mysql is the default and if you're running 6.5 you're already using it. sqllite is long gone.
Ben
_______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
