PDA

View Full Version : How I got SlimServer v6.2.1 working with MySQL



Dave Strickler
2006-01-25, 06:20
Warning: I am a PostgreSQL guy, and I don't know beans about MySQL. I
also don't profess to be a Linux expert. I can get around in SuSE, but
I'm no expert with it either.

Understanding that, I thought I would let you know how I got MySQL
working, as the Wiki was a great help, but wasn't complete (perhaps I
should post this there).

First off, I use SuSE, which has to be the easiest Linux in the world.
To get MySQL up and running, I start Yast (their installer GUI), picked
MySQL, and it installed it for me. No CDs, and a 2 minute install. Did I
mention I love Yast? ;-)

Then I used WebMin (already installed on the server) to make sure MySQL
was indeed running. It was. I used WebMin to create a user in MySQL
called "admin", and gave it all the privs I could find.

Now I looked at the DB/Tables I would need to create in MySQL.
Unfortunately you need to do this by hand, as SlimServer doesn't do this
for you when you switch over. Thankfully its all laid out in
/usr/local/slimserver/SQL/mysql in a small text file called
dbcreate.sql. Note that this file isn't part of SQL, it's just a text
file.

Then I fired up MySQL by typing "mysql -u admin" which logged me into
MySQL as Admin. While inside of MySQL, I needed to create the DB, so I
typed "create database slimserver;" to create the database. And then
"use slimserver;" to start using it.

Now I needed to create the Tables, so I typed "\.
/usr/local/slimserver/SQL/mysql/dbcreate.sql". Note the backslash-dot in
the beginning. This tells MySQL to read in the text file as a series of
commands. This will return a bunch of OKs, indicating it has created all
the DB/Tables. Now type "exit ;" to quit MySQL.

Now that the DB/Tables are all set up, follow the Wiki's instructions
about altering your slimserver.conf file. It will need the username, in
my case "admin", the password for that account that I set up when I
created the account, and the name the of DB (I used "slimserver"
above).

Once the config file is edited, stop Slimserver and restart it. Check
to see that its still running after 5 seconds. If not, the config file
isn't set right to get into MySQL. Check for typos, and also check the
privs for the MySQL account (I used "admin"). I had these set wrong on
my 1st attempt, and Slimserver wouldn't attach to MySQL, and also would
silently crash.

If Slimserver stays loaded, go get a cup of coffee and let it
automatically read all your songs from disk. I have about 12k of them,
and it took under 2 min.

No go into the web interface, or fire up your SB, just like normal.
You'll notice both interfaces are fast, especially the web interface.
Zoom - this back-end with MySQL is super fast!

I hope this long email helps out someone who's struggling. Trust me, in
the end, its worth the struggle!



Dave Strickler
MailWise LLC
617-933-5810 (direct)
www.mailwise.com
"Intelligent E-mail Protection"


----------------------------
This message has been certified virus-free by MailWise Filter - The real-time, intelligent, e-mail firewall used to scan inbound and outbound messages for SPAM, Viruses and Content. For more info visit: http://www.mailwise.com

Patrick Dixon
2006-01-25, 07:26
Many thanks Dave.

I finally got this to work using this method on Ubuntu:

(as root)
# apt-get install mysql-server-4.1

# mysql -u root

create database slimserver;
GRANT ALL PRIVILEGES ON slimserver.* TO 'slimserver'@'localhost';
use slimserver;
\. /usr/local/slimserver/SQL/mysql/dbcreate.sql;
exit

#

Then edit /etc/slimserver.pref to change these lines:

dbusername: slimserver
dbpassword: ''
dbsource: dbi:mysql:database=slimserver

Then restart slimserver

Browny
2006-01-25, 08:23
Unfortunately you need to do this by hand, as SlimServer doesn't do this for you when you switch over.

So long as you've granted the user account that Slimserver uses 'create' permissions on the database Slimserver will run the dbcreate.sql script automatically at startup if it finds an empty database.

Tried this on mine and it worked.

Fancy doing a wiki update?!

=?ISO-8859-1?Q?Mr_N=F5u?=
2006-01-26, 04:53
Dave Strickler wrote:
> Warning: I am a PostgreSQL guy, and I don't know beans about MySQL. I
> also don't profess to be a Linux expert. I can get around in SuSE, but
> I'm no expert with it either.
>
> Understanding that, I thought I would let you know how I got MySQL
> working, as the Wiki was a great help, but wasn't complete (perhaps I
> should post this there).
>
> First off, I use SuSE, which has to be the easiest Linux in the world.
> To get MySQL up and running, I start Yast (their installer GUI), picked
> MySQL, and it installed it for me. No CDs, and a 2 minute install. Did I
> mention I love Yast? ;-)
>
> Then I used WebMin (already installed on the server) to make sure MySQL
> was indeed running. It was. I used WebMin to create a user in MySQL
> called "admin", and gave it all the privs I could find.
>
> Now I looked at the DB/Tables I would need to create in MySQL.
> Unfortunately you need to do this by hand, as SlimServer doesn't do this
> for you when you switch over. Thankfully its all laid out in
> /usr/local/slimserver/SQL/mysql in a small text file called
> dbcreate.sql. Note that this file isn't part of SQL, it's just a text file.
>
> Then I fired up MySQL by typing "mysql -u admin" which logged me into
> MySQL as Admin. While inside of MySQL, I needed to create the DB, so I
> typed "create database slimserver;" to create the database. And then
> "use slimserver;" to start using it.
>
> Now I needed to create the Tables, so I typed "\.
> /usr/local/slimserver/SQL/mysql/dbcreate.sql". Note the backslash-dot in
> the beginning. This tells MySQL to read in the text file as a series of
> commands. This will return a bunch of OKs, indicating it has created all
> the DB/Tables. Now type "exit ;" to quit MySQL.
>
> Now that the DB/Tables are all set up, follow the Wiki's instructions
> about altering your slimserver.conf file. It will need the username, in
> my case "admin", the password for that account that I set up when I
> created the account, and the name the of DB (I used "slimserver" above).
>
> Once the config file is edited, stop Slimserver and restart it. Check to
> see that its still running after 5 seconds. If not, the config file
> isn't set right to get into MySQL. Check for typos, and also check the
> privs for the MySQL account (I used "admin"). I had these set wrong on
> my 1st attempt, and Slimserver wouldn't attach to MySQL, and also would
> silently crash.
>
> If Slimserver stays loaded, go get a cup of coffee and let it
> automatically read all your songs from disk. I have about 12k of them,
> and it took under 2 min.
>
> No go into the web interface, or fire up your SB, just like normal.
> You'll notice both interfaces are fast, especially the web interface.
> Zoom - this back-end with MySQL is super fast!
>
> I hope this long email helps out someone who's struggling. Trust me, in
> the end, its worth the struggle!
>

Thanks for the write-up. I've tried making the switch before without
luck, You encouraged me to try again. I've followed instructions on wiki
and here in forum, but my scan process only manages to successfully add
17 from 20.000 tracks. Error reports are similar (below) for every
unsuccessful track. This is W2000Server, Mysql5.0 and latest ActiveState
Perl. How do I know if my process uses "my Perl", or the libs included
in the slim_perlscript.zip distro?:

Thanks a million,
peter

2006-01-26 12:43:14.9154 DBD::mysql::st execute failed: Data truncated
for column 'secs' at row 1 at C:\Slimserver\CPAN/DBIx/ContextualFetch.pm
line 51.
2006-01-26 12:43:14.9573 Backtrace:

frame 0: Slim::DataStores::DBI::DBIStore::newTrack
(C:/Slimserver/Slim/DataStores/DBI/DBIStore.pm line 595)
frame 1: Slim::DataStores::DBI::DBIStore::updateOrCreate
(C:/Slimserver/Slim/DataStores/DBI/DBIStore.pm line 226)
frame 2: Slim::DataStores::DBI::DBIStore::objectForUrl
(C:/Slimserver/Slim/Web/Pages.pm line 1484)
frame 3: Slim::Web::Pages::browsetree
(C:/Slimserver/Slim/Web/HTTP.pm line 769)
frame 4: Slim::Web::HTTP::generateHTTPResponse
(C:/Slimserver/Slim/Web/HTTP.pm line 678)
frame 5: Slim::Web::HTTP::processURL (C:/Slimserver/Slim/Web/HTTP.pm
line 539)
frame 6: Slim::Web::HTTP::processHTTP
(C:/Slimserver/Slim/Networking/Select.pm line 111)
frame 7: Slim::Networking::Select::select
(C:\Slimserver\slimserver.pl line 634)
frame 8: main::idle (C:\Slimserver\slimserver.pl line 570)
frame 9: main::main (C:\Slimserver\slimserver.pl line 1226)

Browny
2006-01-26, 06:06
Looks like your Slimserver is talking to the database ok, but does appear that one of your tracks is overflowing the track length field (secs) field in the database - wierd.

I have seen a couple of posts elsewhere about issues running Slimserver on MySQL 5 - is it possible to try it on MySQL 4.1?

Cheers,

Browny

=?UTF-8?B?TXIgTsO1dQ==?=
2006-01-26, 09:24
Browny wrote:
> Looks like your Slimserver is talking to the database ok, but does
> appear that one of your tracks is overflowing the track length field
> (secs) field in the database - wierd.
>

yeah, really weird. I thought maybe the schema was corrupted somehow,
and am rebuilding a virgin empty mysql database as we are writing this.
sorry, no go on downgrading mysql here - three other apps are dependent
on the installation being 5.x

thanks,
peter

> I have seen a couple of posts elsewhere about issues running Slimserver
> on MySQL 5 - is it possible to try it on MySQL 4.1?
>
> Cheers,
>
> Browny

Dan Sully
2006-01-26, 10:16
* Mr Nõu shaped the electrons to say...

>yeah, really weird. I thought maybe the schema was corrupted somehow,
>and am rebuilding a virgin empty mysql database as we are writing this.
>sorry, no go on downgrading mysql here - three other apps are dependent
>on the installation being 5.x

The schema for 6.2.x is broken for MySQL.

In SQL/mysql/dbcreate.sql - change the definition of 'secs' to be:

secs float unsigned,

And alter the table:

ALTER TABLE tracks CHANGE secs float unsigned;

-D
--
"A good messenger expects to get shot." --Larry Wall

=?UTF-8?B?TXIgTsO1dQ==?=
2006-01-26, 10:17
Mr Nõu wrote:
> Browny wrote:
>> Looks like your Slimserver is talking to the database ok, but does
>> appear that one of your tracks is overflowing the track length field
>> (secs) field in the database - wierd.
>>
>
> yeah, really weird. I thought maybe the schema was corrupted somehow,
> and am rebuilding a virgin empty mysql database as we are writing this.

Errors are more varied upon a clean rebuild... If anyone cares to look,
a snippet of my error log.txt is attached

thanks,
peter

=?UTF-8?B?TXIgTsO1dQ==?=
2006-01-26, 11:39
Dan Sully wrote:
> * Mr Nõu shaped the electrons to say...
>
>> yeah, really weird. I thought maybe the schema was corrupted somehow,
>> and am rebuilding a virgin empty mysql database as we are writing
>> this. sorry, no go on downgrading mysql here - three other apps are
>> dependent on the installation being 5.x
>
> The schema for 6.2.x is broken for MySQL.
>
> In SQL/mysql/dbcreate.sql - change the definition of 'secs' to be:
>
> secs float unsigned,

Thanks!

I created a new db. I updated dbcreate.sql with above. I "imported" the
schema. I started slimserver. This time I let it run, and the process
picked up about half of my tracks (9000 from 20000). Significant
improvement. But still. (And I also know that this is unsupported, so
don't bend over backwards to understand...)

One of the errors is "data truncated for column 'bitrate'". Should this
variable be re-defined as well? Should I move to 6.5-branch instead?

I did NOT alter the table (below), since I started with a fresh db, ok?

/peter

>
> And alter the table:
>
> ALTER TABLE tracks CHANGE secs float unsigned;
>
> -D

Dan Sully
2006-01-26, 11:40
* Mr Nõu shaped the electrons to say...

>I created a new db. I updated dbcreate.sql with above. I "imported" the
>schema. I started slimserver. This time I let it run, and the process
>picked up about half of my tracks (9000 from 20000). Significant
>improvement. But still. (And I also know that this is unsupported, so
>don't bend over backwards to understand...)
>
>One of the errors is "data truncated for column 'bitrate'". Should this
>variable be re-defined as well? Should I move to 6.5-branch instead?

bitrate needs that conversion too. thanks for the catch.

>I did NOT alter the table (below), since I started with a fresh db, ok?

Yes - that's ok.

-D
--
<dr.pox> what're the units of the coefficient of agnosticity? I don't knows per hour?

=?UTF-8?B?TXIgTsO1dQ==?=
2006-01-26, 12:18
Dan Sully wrote:
> * Mr Nõu shaped the electrons to say...
>
>> I created a new db. I updated dbcreate.sql with above. I "imported"
>> the schema. I started slimserver. This time I let it run, and the
>> process picked up about half of my tracks (9000 from 20000).
>> Significant improvement. But still. (And I also know that this is
>> unsupported, so don't bend over backwards to understand...)
>>
>> One of the errors is "data truncated for column 'bitrate'". Should
>> this variable be re-defined as well? Should I move to 6.5-branch instead?
>
> bitrate needs that conversion too. thanks for the catch.
>

Next time around (server is scanning so I can't tell if there are more
captchas):

Incorrect interger value: '' for column 'year'

Howto redefine this variable?

thanks from stockholm, sweden,
peter

Patrick Dixon
2006-01-26, 12:39
ALTER TABLE tracks CHANGE bitrate float unsigned;

... at a guess

jimwillsher
2006-01-26, 15:47
To Patrick: I've just followed your simple steps and they have worked a treat! I too am using Ubuntu, and already had mysql 4.1 installed, so it was a breeze! Thank you!

I only have 330 albums, and in a local browser it's not perceptibly faster, but I'm happier having my stuff in MySql where I can browse it through phpMyAdmin.

Jim

=?UTF-8?B?TXIgTsO1dQ==?=
2006-01-27, 01:57
Mr Nõu wrote:
> Dan Sully wrote:
>> * Mr Nõu shaped the electrons to say...
>>

The scanning process on w2000server, latest Mysql 5.0, latest perl, and
slimserver 6.2.2, spews error and fails to pick up anything in a multi
disc set, when I assignd disc # as 01/04, 02/04 etc. Changing numbering
sequence to 01, 02... helps. Is the former notation within spec - i.e.
should I update, or is this fixed/different behaviour in the 6.5-branch?

thanks,
peter

Patrick Dixon
2006-01-27, 02:13
Thanks Jim - I'm really glad to have helped.

But I feel a little embarassed to be singled out. I stumbled around fairly blindly and (as usual) relied heavily on expert help from others here. So thanks to them too!

jimwillsher
2006-01-27, 02:13
Peter, no problem. I guess I was just lucky that we both have Ubuntu :-)

Really hope Slim find a way to release a Ubuntoe .deb package, it'll make lfie easier for upgrades....



PS To previous poster: I've a feeling it'll be the MySql 5.0 that's causing the errors.

Jim

=?UTF-8?B?TXIgTsO1dQ==?=
2006-01-27, 10:29
Mr Nõu wrote:
> Dan Sully wrote:
>> * Mr Nõu shaped the electrons to say...
>>
>>> I created a new db. I updated dbcreate.sql with above. I "imported"
>>> the schema. I started slimserver. This time I let it run, and the
>>> process picked up about half of my tracks (9000 from 20000).
>>> Significant improvement. But still. (And I also know that this is
>>> unsupported, so don't bend over backwards to understand...)
>>>
>>> One of the errors is "data truncated for column 'bitrate'". Should
>>> this variable be re-defined as well? Should I move to 6.5-branch
>>> instead?
>>
>> bitrate needs that conversion too. thanks for the catch.
>>
>
> Next time around (server is scanning so I can't tell if there are more
> captchas):
>
> Incorrect interger value: '' for column 'year'
>

Scanning doesn't pick up anything that doesn't have a year assigned.
Seems like a bugfeature, since it forces me to re-tag more carefully.

Can anyone suggest a simlpe way of searching a collection of music for
stuff that "has no year assigned"? How do I find the diff between tracks
on file, and tracks in the db? (Watch the scanning process for errors,
or manually stepping through the collection with tag&rename are really
time consuming...)

thanks,
peter

cliveb
2006-01-28, 12:55
Having followed this thread, I thought I would try to get MySQL working on my FreeBSD box. As far as I can tell, everything is OK with the MySQL database, and the creation of the Slimserver schema worked.

But when I try to switch Slimserver over to the MySQL database, it dies on startup. Are there any debugging flags I can set which will generate a log of what it's doing when trying to connect to the database?

And can anyone tell me precisely which user Slimserver runs as? There's a user named "slimserv" which has been created, and most of the config files belong to that user. But when I take a look at the processes running, slimserver appears to be running as root. And yet when I inadvertantly changed the owner of slimserver.conf to root, there was a message that it couldn't be written to on Slimserver startup, which suggests to me that it does not run as root. Does it start up running as slimserv, then replace itself with another program that has a root suid attribute?

Patrick Dixon
2006-01-29, 02:37
I don't know about debug flags, but you could check slimserver.log (/tmp/slimserver.log on my installation), for a basic error message. I found that you had to set SQL permissions for user 'slimserver@localhost' to get it to run properly.

AFAIK, slimserver runs with user 'slimserver' - the 'er' may be trucated somewhere on your display.

cliveb
2006-01-29, 10:17
I don't know about debug flags, but you could check slimserver.log (/tmp/slimserver.log on my installation), for a basic error message.
Thanks for the pointer. I found slimserver.log in /var/log on my system, and the error message was:

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC [followed by more details about @INC]

I searched for this file and it's simply nowhere on my system. So clearly it wasn't installed along with Slimserver. I'm currently running version 6.0.2 - was MySQL support added in a later version?


AFAIK, slimserver runs with user 'slimserver' - the 'er' may be trucated somewhere on your display.
I'm pretty sure the user on my system is 'slimserv' - that's how it appears in /etc/passwd. And just to make sure usernames weren't being truncated to 8 characters on display, I created another user called 'testlongname', and it was included to full length in /etc/passwd. (Presumably there are some peculiarities with the FreeBSD version).

Patrick Dixon
2006-01-29, 11:50
I searched for this file and it's simply nowhere on my system. So clearly it wasn't installed along with Slimserver. I'm currently running version 6.0.2 - was MySQL support added in a later version?I think that's probably it. I'm running a 6.2 nightly.

klausbgva
2006-01-30, 02:00
This Thread was of great help and did convince me to move to mySQL.

I have pretty good SQL experience Oracle and Microsoft but had never done mysql.

I did download the RPM's from my SQL and did an install on my test slimserver 32bit and had no problems.
The mysql admin tool made me feel pretty much at home.
Spent a bit of time playing with mysql to understand how it worked.

The configuraiton of the slimserver was realy easy: define the connection. stop start done. amazing and simple.

after that test I did apply the same thing on the real slimserver.
Did install the 64bit version of mysql 5.018 with rpm - i (for some reasons Yast would not install it for me)
Changed the config file. Stop Start. Done

Works much faster, It used to takes several hours to scan my songs not it takes less than 1.
Browsing from the slimbox has no delay at all. My eyes are now the slowest part when I browse the files.

If you have a large library it is time well spent to switch to mysql.

I run slimserver on a:
AMD Athlon 2.8Ghz 1.5GB Ram
Suse 10 64bit
My songs are stored on a LSI Raid in the system
1 GB Ethernet

nicky6
2006-02-16, 14:43
Hi,

I can't seem to get slimserver and mySQL work together. I'm using slimserver 6.2.2. (nightly build 2006.02.14) and MySQL 4.1 (Essentials).

I installed MySQL and then did:

create database slimserver;
GRANT ALL PRIVILEGES ON slimserver.* TO slimserver@localhost;
use slimserver;
\. C:\Program Files\SlimServer\server\SQL\mysql\dbcreate.sql;
exit

(Everything above went ok according to mySQL) Then I changed the slimserver.pref to read

dbpassword: ''
dbsource: dbi:mysql:database=slimserver
dbusername: slimserver


I stopped Slimserver and restarted it, but with no luck.

Does anyone have a solution on what might be the problem?

kdf
2006-02-16, 15:00
Quoting nicky6 <nicky6.23cdpc (AT) no-mx (DOT) forums.slimdevices.com>:

> (Everything above went ok according to mySQL) Then I changed the
> slimserver.pref to read
>
> dbpassword: ''
> dbsource: dbi:mysql:database=slimserver
> dbusername: slimserver
>
>
> I stopped Slimserver and restarted it, but with no luck.
>
run from command prompt:
c:\program files\slimserver\slim.exe

and see what the server says.

-kdf

nicky6
2006-02-17, 12:22
2006-02-17 20:21:07.7458 install_driver(mysql) failed: Can't locate DBD/mysql.pm
in @INC (@INC contains: C:\program files\slimserver\server\Plugins c:/program f
iles/slimserver/server C:\program files\slimserver\server\CPAN C:\program files\
slimserver\server\CPAN\arch\5.8.7\MSWin32-x86-multi-thread C:\program files\slim
server\server\CPAN\arch\5.8.7\MSWin32-x86-multi-thread\auto C:\program files\sli
mserver\server\CPAN\arch\5.8\MSWin32-x86-multi-thread C:\program files\slimserve
r\server\CPAN\arch\5.8\MSWin32-x86-multi-thread\auto C:\program files\slimserver
\server\CPAN\arch\MSWin32-x86-multi-thread c:\program files\slimserver\server) a
t (eval 341) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, SQLite, Sponge.
at /PerlApp/Slim/DataStores/DBI/DataModel.pm line 147

mac
2006-02-19, 10:41
The following Perl modules are likely not installed in your environment:

DBI
DBD::mysql

You will also need a Perl runtime like ActivePerl ( http://www.activestate.com/Products/Download/Download.plex?id=ActivePerl) in order to install the MySQL driver for the Perl5 Database Interface.

There may be some additional code changes that need to be made to the SlimServer distribution. If that is the case then you would have to compile SlimServer from the source. It sure would be nice if the Windows SlimServer distribution had MySql support built in.

nicky6
2006-02-19, 13:35
Now I've installed the DBI and the DBD::mysql by using the "ppm" and then typing "install dbi" and then "install dbd-mysql" (I already had ActiveState 5.8.7-815 installed, before I installed mySQL 4.1)

Still no luck:


2006-02-19 21:20:19.8779 install_driver(mysql) failed: Can't locate DBD/mysql.pm
in @INC (@INC contains: C:\Program Files\SlimServer\server\Plugins C:/Program F
iles/SlimServer/server C:\Program Files\SlimServer\server\CPAN C:\Program Files\
SlimServer\server\CPAN\arch\5.8.7\MSWin32-x86-multi-thread C:\Program Files\Slim
Server\server\CPAN\arch\5.8.7\MSWin32-x86-multi-thread\auto C:\Program Files\Sli
mServer\server\CPAN\arch\5.8\MSWin32-x86-multi-thread C:\Program Files\SlimServe
r\server\CPAN\arch\5.8\MSWin32-x86-multi-thread\auto C:\Program Files\SlimServer
\server\CPAN\arch\MSWin32-x86-multi-thread C:\Program Files\SlimServer\server) a
t (eval 341) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, SQLite, Sponge.
at /PerlApp/Slim/DataStores/DBI/DataModel.pm line 147

If I copy the C:\Perl\site\lib\DBD folder to c:\SlimServer\server\plugins folder, I get a whole lot less error messages, but still no luck:


2006-02-19 21:26:40.2065 install_driver(mysql) failed: Can't load 'auto/DBD/mysq
l/mysql.dll' for module DBD::mysql: load_file:The specified module could not be
found at /PerlApp/DynaLoader.pm line 212.
at (eval 341) line 3
Compilation failed in require at (eval 341) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /PerlApp/Slim/DataStores/DBI/DataModel.pm line 147

Perhaps I shouldn't copy the DBD-folder to the plugins folder? Perhaps I should edit some fields somewhere to make slim find the necessary modules that I obviously have installed on my PC?

mac
2006-02-20, 15:26
Available drivers: DBM, ExampleP, File, Proxy, SQLite, Sponge.
at /PerlApp/Slim/DataStores/DBI/DataModel.pm line 147


Perhaps a required shared library or dll isn't installed where expected
at /PerlApp/Slim/DataStores/DBI/DataModel.pm line 147


That's as far as I got. I'm afraid the rest will require some minor code changes to DataModel.pm. Perhaps one of the Perl guru's here can help?

fcm4711
2006-02-20, 15:57
Hi all

Did the switch today. The only minor problem was the DBD:mysql thing, but Yast2 (I'm running SuSE 9.2) was able to install that for me.

Thanks
Felix

nicky6
2006-02-21, 11:24
Any Perl guru that can help out getting the DataMmodel.pm to work?

/Niclas

tfish77
2006-03-05, 16:10
Mr Nõu wrote:
Incorrect interger value: '' for column 'year'
Scanning doesn't pick up anything that doesn't have a year assigned.



I am having the exact same problem. Running MySQL 5 on Windows and after jumping through many, many hoops to make Slimserver connect to it properly, I am now presented with this problem. Should I set the default value of that column to 0? Would that help or make things worse?