PDA

View Full Version : SQL



2005-04-07, 16:56
How does one go about reading/writing the DB?
what's the port/username/password?
SQLite?

I'm already running MySQL on my server.. could I
configure slimserver to use my already existing DB?

Dan Sully
2005-04-07, 17:19
* bkfake-forum (AT) yahoo (DOT) com shaped the electrons to say...

>How does one go about reading/writing the DB?
>what's the port/username/password? SQLite?
>
>I'm already running MySQL on my server.. could I
>configure slimserver to use my already existing DB?

On the new Wiki -

http://wiki.slimdevices.com/index.cgi?MySQL

should be enough to get you going.

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

2005-04-08, 07:24
Thanks!

Would you expect a performance hit by switching to
MySQL as opposed to the built in SQLite?

Anyhow, this is awsome.. I'm looking forward to
playing with it this weekend.

BKDotCom
2005-04-08, 15:56
On the new Wiki -

http://wiki.slimdevices.com/index.cgi?MySQL

should be enough to get you going.
should be, yes... but:
what privs does my slim user need?
Is MySQL 3.23.58 sufficient?
I'm on Win-XP
(tried this thread: http://forums.slimdevices.com/showthread.php?t=13034)

when I start up slimserver it removes
- dbusername
- dbpassword
- dbsource
from the prefs and loads up the prexisting db

BKDotCom
2005-04-09, 11:02
Upgraded to MySQL 4.1.11... still no love :(
could someone who got this working lend me a tip or trick?

Thanks

webdeck
2005-04-09, 18:28
Make sure you comment out (or remove) this line in your prefs:

dbsource = dbi:SQLite:dbname=%s

-Mike

BKDotCom
2005-04-10, 12:05
Working now..
don't know what I did.
I did reset the user password.. beats me

Any chance the MySQL dbi stuff could be packaged with future releases?

Jonathan Greene
2005-04-10, 13:02
actually AOL and GMail are on Sync

using imap.aol.com for aol IMAP


-----Original Message-----
From: BKDotCom <BKDotCom.1naean (AT) no-mx (DOT) forums.slimdevices.com>
Date: Sunday, Apr 10, 2005 3:08 pm
Subject: [slim] Re: SQL

Working now.. don't know what I did.
I did reset the user password.. beats me

Any chance the MySQL dbi stuff could be packaged with future releases?
--
BKDotCom

Jonathan Greene
2005-04-10, 13:03
sorry totally wrong list!

-----Original Message-----
From: "Jonathan Greene" <atmasphere (AT) atmasphere (DOT) net>
Date: Sunday, Apr 10, 2005 4:02 pm
Subject: Re: [slim] Re: SQL

actually AOL and GMail are on Sync

using imap.aol.com for aol IMAP
-----Original Message-----
From: BKDotCom <BKDotCom.1naean (AT) no-mx (DOT) forums.slimdevices.com>
Date: Sunday, Apr 10, 2005 3:08 pm
Subject: [slim] Re: SQL

Working now.. don't know what I did.
I did reset the user password.. beats me

Any chance the MySQL dbi stuff could be packaged with future releases?
--
BKDotCom

JJZolx
2005-04-10, 13:41
Any chance the MySQL dbi stuff could be packaged with future releases?
That would certainly save some folks a bit of grief.
________
iolite portable vaporizer (http://vaporizers.net/iolite-vaporizer)

kdf
2005-04-10, 14:16
Quoting JJZolx <JJZolx.1naioz (AT) no-mx (DOT) forums.slimdevices.com>:

>
> BKDotCom Wrote:
> > Any chance the MySQL dbi stuff could be packaged with future releases?
> That would certainly save some folks a bit of grief.
>
the fact that the code to allow the option should make it clear that it will be
in a future release. however, it stands now as an unsupported feature. so,
when it will become a standard, supported option depends on when enough of the
other priorities clear up to leave enough time to lend support to it.

-kdf