PDA

View Full Version : When should I switch from SQLLite to MySQL?



Dave Strickler
2006-01-21, 08:29
I have about 13,000 MP3s ripped down to a dedicated SuSE server, running
Slimserver v6.2. Its not a rockin server, but its got 4GB of RAM and a
1.3GB processor, and normally has a 0.5 to 1.0 LA.

While Slimserver is working perfectly, its a little sluggish to search
for songs, sometimes taking 15-20 seconds to return a search. I am
planning on ripping more CDs, so I fear the response time will lag
further in the future.

My thought is, perhaps its time to switch to MySQL for better
performance. But my question is, would it be worth it? Will I really see
that much of a speed gain?

Thanks,

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

Browny
2006-01-21, 16:22
I have updated from using SQLite to MySQL (4.1) and found performance to be MUCH more to my liking - in particular in relation to doing a complete rescan. I'm currently running 6000 flacs on a ClarkConnect 1.3Ghz Athlon Server with 512Mb RAM. There are no latency issues for that I can see - searches included.

The reason I switch was to allow me to view and update the Slimserver database while slimserver is running.

If you look at Slimserver's roadmap you will find that MySQL is the way Slimserver is going for the future. Why not early adopt? It is pretty painless (see the wiki) and you can go back very easily if you don't like it.

One final note of caution - I have seen a couple of posts relating to issues running on MySQL 5. Stick with 4.1 for now.

Robin Bowes
2006-01-21, 16:27
Dave Strickler said the following on 01/21/2006 03:29 PM:
> I have about 13,000 MP3s ripped down to a dedicated SuSE server, running
> Slimserver v6.2. Its not a rockin server, but its got 4GB of RAM and a
> 1.3GB processor, and normally has a 0.5 to 1.0 LA.

Is this server running other stuff as well as slimserver?

My slimserver is running on a dual 1GHz P3 with 1.5GB RAM. It hardly
shows any load.

> While Slimserver is working perfectly, its a little sluggish to search
> for songs, sometimes taking 15-20 seconds to return a search. I am
> planning on ripping more CDs, so I fear the response time will lag
> further in the future.
>
> My thought is, perhaps its time to switch to MySQL for better
> performance. But my question is, would it be worth it? Will I really see
> that much of a speed gain?

Not if the other stuff on the box is causing the load problem.

It's easy enough to test though; just create the DB and change your
config and re-scan.

R.

Dave Strickler
2006-01-23, 13:11
Sounds like I should give it a shot. I had trouble creating the DBs the
other day, so I will see if I am doing something wrong. I'll let you
know my experiences.

Thanks for the feedback...

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


>>> Browny.220d00 (AT) no-mx (DOT) forums.slimdevices.com 6:22:40 PM Saturday,
January 21, 2006 >>>

I have updated from using SQLite to MySQL (4.1) and found performance
to
be MUCH more to my liking - in particular in relation to doing a
complete rescan. I'm currently running 6000 flacs on a ClarkConnect
1.3Ghz Athlon Server with 512Mb RAM. There are no latency issues for
that I can see - searches included.

The reason I switch was to allow me to view and update the Slimserver
database while slimserver is running.

If you look at Slimserver's roadmap you will find that MySQL is the
way
Slimserver is going for the future. Why not early adopt? It is pretty
painless (see the wiki) and you can go back very easily if you don't
like it.

One final note of caution - I have seen a couple of posts relating to
issues running on MySQL 5. Stick with 4.1 for now.


--
Browny
------------------------------------------------------------------------
Browny's Profile: http://forums.slimdevices.com/member.php?userid=2295

View this thread: http://forums.slimdevices.com/showthread.php?t=20281

max.spicer
2006-01-24, 15:20
Well prompted! I put mysql on my server last week in order to serve another application. Your post prompted me to take the obvious step of making SlimServer use it. Following the wiki entry, it took me an obsolute maximum of 5 minutes to set up. I'd say things definitely seem faster as a result, although I've not had much time to check. I'm convinced that random mix now takes less time to select tracks - the gap between starting a mix and the first song starting to play seems much shorter.

Max

Dr Lovegrove
2006-01-25, 03:15
On 24/01/06, max. spicer <max.spicer.225tzn (AT) no-mx (DOT) forums.slimdevices.com> wrote:
>
> Well prompted! I put mysql on my server last week in order to serve
> another application. Your post prompted me to take the obvious step of
> making SlimServer use it. Following the wiki entry, it took me an
> obsolute maximum of 5 minutes to set up.

I switched yesterday as well, and am pretty impressed with performance
as well.. No more pauses in randommix - yay ! :-)

Few minor gripes though:

Be nice to have better instructions on how to install MySQL itself.. Took me
a while to suss that I had to login as root, create a new user, create the
database, grant root permissions to use the database, grant the new user
permissions, etc.. This was all with 4.1.. Maybe it's better with 5 ?

Slimserver 6.5 kept falling over on startup as it turns out it needed some
CPAN stuff adding..

Oh, also I had to upgrade my version of perl for 6.5 - kept giving a popup
about some kind of memory thing not being supported.. Latest activestate
build did the trick..

--
- Dr Lovegrove
http://www.rusticrhino.com/drlovegrove

Patrick Dixon
2006-01-25, 03:17
Hmm, well I've spent the 5 minutes and I'm getting nowhere ...

I'm getting:

mysql> Ungrant all on slimserver.* to slimserver [identified by 'password'];
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Ungrant all on slimserver.* to slimserver [identified by 'password']' at line 1

and I have no idea what any of it means!

mherger
2006-01-25, 03:28
> Be nice to have better instructions on how to install MySQL itself..
> Took me
> a while to suss that I had to login as root, create a new user, create
> the
> database, grant root permissions to use the database, grant the new user
> permissions, etc.. This was all with 4.1.. Maybe it's better with 5 ?

Install phpMyAdmin. It's so much easier to do these administrative tasks.

> Oh, also I had to upgrade my version of perl for 6.5

....and I'd have to install MySQL 4.x - Slimserver does not like 3.x. :-/

--

Michael

-----------------------------------------------------------
Help translate SlimServer by using the
SlimString Translation Helper (http://www.herger.net/slim/)

Patrick Dixon
2006-01-25, 03:39
Be nice to have better instructions on how to install MySQL itself.. Took me
a while to suss that I had to login as root, create a new user, create the
database, grant root permissions to use the database, grant the new user
permissions, etc.. This was all with 4.1.. Maybe it's better with 5 ?Any chance you could share your knowledge?

I'm blindly following the wiki instructions - I figured out how to login as root -
mysql -u root

and the first line -
create database slimserver;

which I assume creates the db, seems to execute. After that ?????

Thanks

oktup
2006-01-25, 03:43
Hmm, well I've spent the 5 minutes and I'm getting nowhere ...

I'm getting:

mysql> Ungrant all on slimserver.* to slimserver [identified by 'password'];
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Ungrant all on slimserver.* to slimserver [identified by 'password']' at line 1

and I have no idea what any of it means!

Apologies if I'm barking up the wrong tree here, because I'm not using slimserver myself (yet!), but I assume you should be typing something like:


Ungrant all on slimserver.* to slimserver identified by 'your_password_here';

Or, if the user 'slimserver' doesn't have a password defined for them, just:


Ungrant all on slimserver.* to slimserver;

Dr Lovegrove
2006-01-25, 03:50
On 25/01/06, Michael Herger <slim (AT) herger (DOT) net> wrote:
> > Be nice to have better instructions on how to install MySQL itself..
> > Took me
> > a while to suss that I had to login as root, create a new user, create
> > the
> > database, grant root permissions to use the database, grant the new user
> > permissions, etc.. This was all with 4.1.. Maybe it's better with 5 ?
>
> Install phpMyAdmin. It's so much easier to do these administrative tasks.

I gave up with the command-line and installed "MySQL Administrator 1.1" in
the end.. Nicely designed front-end, even has a trayicon..

--
- Dr Lovegrove
http://www.rusticrhino.com/drlovegrove

Patrick Dixon
2006-01-25, 04:02
Thanks, but that gives the same result.

I think I probably need to create MySQL user 'slimserver' first (the wiki doesn't mention this at all) but I'm new to SQL ;-(

Also the MySQL doc doesn't seem to mention Ungrant. GRANT and REVOKE, but not Ungrant. WTF is Ungrant?

Patrick Dixon
2006-01-25, 04:09
Thanks.

I'm installing this via ssh/putty on a headless Ubuntu machine - I don't think tray icons are going to work for me!

mherger
2006-01-25, 05:29
> I'm installing this via ssh/putty on a headless Ubuntu machine - I
> don't think tray icons are going to work for me!

I'm repeating myself: phpMyAdmin has been the "headless" MySQL
administrator's best friend for years.

--

Michael

-----------------------------------------------------------
Help translate SlimServer by using the
SlimString Translation Helper (http://www.herger.net/slim/)

Browny
2006-01-25, 05:50
Thanks.

I'm installing this via ssh/putty on a headless Ubuntu machine - I don't think tray icons are going to work for me!

Download the MySQL PHP Admin Client from:

http://www.phpmyadmin.net/home_page/index.php

This gives you a browser interface into MySQL on your Ubuntu machine.

From here it should be pretty straightforward to create a database, create a MySQL user account (e.g. Mine is called SlimDB), Make sure the account has full priviliges on your new database and can access locally.

You then should be able to follow the wiki ok.

Hope this helps. I'm at work at the moment so don't have access to my server. If you need any more info I can check this evening.

Browny

Patrick Dixon
2006-01-25, 05:51
I think the answer to the thread title is:

Not until the wiki is updated with much more comprehensive instructions, unless you are very familiar with MySQL and updating Perl modules.

Patrick Dixon
2006-01-25, 05:54
Thanks for the help.

I'll try that when my machine come back after it's update of CPAN.

(I was only tring to get DBD::mysql in case that was what was causing my error/slimserver crash)

Dave Strickler
2006-01-25, 05:55
phpMyAdmin works great, and so does WebMin, although its a little more
generic.

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


>>> slim (AT) herger (DOT) net 7:29:49 AM Wednesday, January 25, 2006 >>>
> I'm installing this via ssh/putty on a headless Ubuntu machine - I
> don't think tray icons are going to work for me!

I'm repeating myself: phpMyAdmin has been the "headless" MySQL
administrator's best friend for years.

--

Michael

-----------------------------------------------------------
Help translate SlimServer by using the
SlimString Translation Helper (http://www.herger.net/slim/)

Browny
2006-01-25, 06:05
I think the answer to the thread title is:

Not until the wiki is updated with much more comprehensive instructions, unless you are very familiar with MySQL and updating Perl modules.
Good Point - to be fair to Slimdevices though SQLite is still the default for now. I suppose the wiki will catch up when MySQL is the default.

One of the things that I believe the developers are looking at for the switch is how to automate all this.

In the meantime it should be possible to create a little script that can be run on MySQL to set things up - I'll have a look into this.

Robin Bowes
2006-01-25, 06:18
Patrick Dixon said the following on 01/25/2006 10:17 AM:
> Hmm, well I've spent the 5 minutes and I'm getting nowhere ...
>
> I'm getting:
>
> mysql> Ungrant all on slimserver.* to slimserver [identified by
> 'password'];
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'Ungrant all on slimserver.* to slimserver
> [identified by 'password']' at line 1

A few problems there...

Assuming you've done the initial MySQL setup, changed the root password,
etc., you need to use the following:

# mysqladmin -u root -p create slimserver
Enter password: (enter slimserver root password)
# mysql -u root -p
Enter password: (enter slimserver root password)
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2415 to server version: 4.1.7-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on slimserver.* to 'slimserver'@'localhost' identified
by 'password';
Query OK, 0 rows affected (0.11 sec)
mysql> quit
Bye

HTH,

R.

Patrick Dixon
2006-01-25, 06:21
I'm not blaming SD, I'm blaming Max Spicer who said it was a 5 minute job following the wiki ;-)

I'm not sure that phpMyAdmin will work for me either as I don't understand how to install it: am I installing it on the headless Ubuntu machine, or the XP desktop? And I don't have a webserver running on either anyway!

[RANT ON]Why, oh why, don't Open Source people put a short description of, what their product is, what it does, and what you need to use it, on their home page. Everyone seems to assume a level of expertise and familiarity that most of us just don't have. It's a bit like me sticking them in a machine and telling them that you control it with the cyclic, pedals and collective - and don't forget to start the engine up first. They probably would even know it was a helicopter - let alone get it airbourne. [RANT OFF]

Browny
2006-01-25, 06:30
Install it onto your Ubuntu box. You can then use the browser on your XP box. You don't need to install a web server (bit like Slimserver in that respect.

re your rant - thats why I use ClarkConnect. Simple web interface - I installed MySQL by selecting it in a list. It even installed MyPHPAdmin automatically for me. Linux purists will wince at this, but it was very easy to do.

Better leave it now though - Don't want to start a Linux distro war on this thread!!!!

Patrick Dixon
2006-01-25, 06:32
Patrick Dixon said the following on 01/25/2006 10:17 AM:
> Hmm, well I've spent the 5 minutes and I'm getting nowhere ...
>
> I'm getting:
>
> mysql> Ungrant all on slimserver.* to slimserver [identified by
> 'password'];
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'Ungrant all on slimserver.* to slimserver
> [identified by 'password']' at line 1

A few problems there...

Assuming you've done the initial MySQL setup, changed the root password,
etc., you need to use the following:

# mysqladmin -u root -p create slimserver
Enter password: (enter slimserver root password)
# mysql -u root -p
Enter password: (enter slimserver root password)
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2415 to server version: 4.1.7-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on slimserver.* to 'slimserver'@'localhost' identified
by 'password';
Query OK, 0 rows affected (0.11 sec)
mysql> quit
Bye

HTH,

R.
Thanks - I've installed MySQL but I haven't set any SQL passwords (I don't really need/want any).

But what exactly is "slimserver root password"

The slimserver user has no password , and there is a root password on the machine running MySQL.

root@musicserver:/home/musicserver # mysqladmin -u root -p create slimserver
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

Patrick Dixon
2006-01-25, 06:44
You can then use the browser on your XP box.Sorry to be a pain, but what address do I type in the browser?

mherger
2006-01-25, 07:01
>> You can then use the browser on your XP box.
> Sorry to be a pain, but what address do I type in the browser?

The server's IP or host name. But you'll need to install Apache as well...

--

Michael

-----------------------------------------------------------
Help translate SlimServer by using the
SlimString Translation Helper (http://www.herger.net/slim/)

Robin Bowes
2006-01-25, 07:04
Browny said the following on 01/25/2006 01:30 PM:
> Install it onto your Ubuntu box. You can then use the browser on your
> XP box. You don't need to install a web server (bit like Slimserver in
> that respect.

To use phpmyadmin? Yes you do.

phpMyAdmin uses (surprisingly enough) php which needs a web server, e.g.
apache.

R.

Patrick Dixon
2006-01-25, 07:29
Life's too short ....

But I finally got it working!!! - see http://forums.slimdevices.com/showthread.php?p=80962#post80962
;-) ;-)

Thanks for the help everyone ... just a simple 5hr job.

Patrick Dixon
2006-01-25, 07:31
Sorry, forgot to mention ...

You probably need to put fuel in your helicopter - before the engine will start ... oh, and don't forget to use the right sort!

(I'm gonna try Clarke Connect)

Browny
2006-01-25, 07:43
To use phpmyadmin? Yes you do.

phpMyAdmin uses (surprisingly enough) php which needs a web server, e.g.
apache.

R.

Yup - my mistake (it's turning into a long day!).

Nice to hear Patrick's got it working.....

stinkingpig
2006-01-25, 13:05
Patrick Dixon wrote:
> Hmm, well I've spent the 5 minutes and I'm getting nowhere ...
>
> I'm getting:
>
> mysql> Ungrant all on slimserver.* to slimserver [identified by
> 'password'];
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'Ungrant all on slimserver.* to slimserver
> [identified by 'password']' at line 1
>
> and I have no idea what any of it means!
>
>
>
try this:

mysql> grant all on slimserver.* to slimserver@localhost identified by
'password';

the wiki forgets to specify where the user is, and assumes that people
know what [] means (it means --identified by 'password'-- is optional).

--
Jack at Monkeynoodle dot Org: It's a Scientific Venture...
Riding the Emergency Third Rail Power Trip Since 1996

Patrick Dixon
2006-01-25, 15:51
Patrick Dixon wrote:
> Hmm, well I've spent the 5 minutes and I'm getting nowhere ...
>
> I'm getting:
>
> mysql> Ungrant all on slimserver.* to slimserver [identified by
> 'password'];
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'Ungrant all on slimserver.* to slimserver
> [identified by 'password']' at line 1
>
> and I have no idea what any of it means!
>
>
>
try this:

mysql> grant all on slimserver.* to slimserver@localhost identified by
'password';

the wiki forgets to specify where the user is, and assumes that people
know what [] means (it means --identified by 'password'-- is optional).

--
Jack at Monkeynoodle dot Org: It's a Scientific Venture...
Riding the Emergency Third Rail Power Trip Since 1996


Thanks Jack. I got it working using:
GRANT ALL PRIVILEGES ON slimserver.* TO 'slimserver'@'localhost';

(The wiki also uses 'Ungrant', for some reason I really don't understand!)

rkeeney
2006-01-25, 21:14
OK, I installed MySQL 4.1
Using MySQL Administrator, I added a user ('slimserver' w/ no password) and a schema (slimdb) and assigned all available privileges to the user.

I installed DBD::mysql

I edited the slimserver.pref file as indicated in other posts.

Now, Slimserver just sits in the tray saying 'Slimserver starting' but never starts. I'm running all on a WinXP box.

What am I missing?

Regards,
Rob...........

treble
2006-01-25, 23:07
Try starting slim.exe from the 'command line' (open a start->run->cmd window, cd to the slimserver directory, and execute slim). I found out that way that DBD::mysql was the problem... (if you haven't installed your own perl see the wiki on how to install DBD::mysql on Windows).

rkeeney
2006-01-26, 07:06
Try starting slim.exe from the 'command line' (open a start->run->cmd window, cd to the slimserver directory, and execute slim). I found out that way that DBD::mysql was the problem... (if you haven't installed your own perl see the wiki on how to install DBD::mysql on Windows).

That does indicate the problem. However, I have ActiveState Perl installed and I installed DBD::mysql but slimserver is not finding it in the right place.

Where is the wiki you refer to?

Regards,
Rob.............

Patrick Dixon
2006-01-26, 08:00
I'm not actually using XP but I have installed Perl modules on XP before using PPM

IIRC, you do something like this:

In a command window:
cd C:\Perl\bin (or wherever your Perl is)
ppm
install DBD-mysql
exit

rkeeney
2006-01-26, 09:09
I'm not actually using XP but I have installed Perl modules on XP before using PPM

IIRC, you do something like this:

In a command window:
cd C:\Perl\bin (or wherever your Perl is)
ppm
install DBD-mysql
exit

Thanks, but I've already done that. The module's installed in a sub-directory of my Perl installation. Slimserver doesn't 'see' it for some reason.

The wiki on the SD site says the following:


For Windows platform without Perl installed: Get the latest DBD-mysql from ActiveState... http://ppm.activestate.com/PPMPackages/zips/8xx-builds-only/Windows/ The files in blib/arch should be copied to server/CPAN/arch/5.8/MSWin32-x86-multi-thread and those in blib/lib should be copied to server/CPAN. This will make them available to SlimServer.

This doesn't make any sense. You get a zip file but nothing that maps to these instructions. Anyway, sorry to be a pest!

Regards,
Rob............

Patrick Dixon
2006-01-26, 09:30
If you download DBD-mysql-2.9008.zip you'll see it contains a file called DBD-mysql-2.9008.tar.gz. Unzip that file and you will see the all files with paths under /blib/arch, blib/html and blib/lib.

I assume that's what you're looking for.

Alternatively you could start slimserver using your ActiveState Perl installation. In a command window type:

cd "C:\Program Files\Slimserver\Server"
slimserver.pl

You need to keep the command window open in the background for slimserver to continue running.

rkeeney
2006-01-26, 20:54
If you download DBD-mysql-2.9008.zip you'll see it contains a file called DBD-mysql-2.9008.tar.gz. Unzip that file and you will see the all files with paths under /blib/arch, blib/html and blib/lib.
I assume that's what you're looking for.

OK, that was helpful. I copied the aforementioned files into the specified directories (choosing to overwrite some directories already there). Now, slimserver starts and creates the tables but just stalls. According to MySQL Administrator, there are now 145 rows in the newly created tracks table, 1 row in the metainformation table and nothing else. I started over again and it gets to that point again and stalls. No indication in the cmd window what's happening. The tray icon will say it is running but it will not open in the browser.

This is getting very frustrating. I suspect I'm missing something obvious but I don't know what.

Regards,
Rob...........

macallf
2006-01-29, 06:55
OK, that was helpful. I copied the aforementioned files into the specified directories (choosing to overwrite some directories already there). Now, slimserver starts and creates the tables but just stalls. According to MySQL Administrator, there are now 145 rows in the newly created tracks table, 1 row in the metainformation table and nothing else. I started over again and it gets to that point again and stalls. No indication in the cmd window what's happening. The tray icon will say it is running but it will not open in the browser.

This is getting very frustrating. I suspect I'm missing something obvious but I don't know what.

Regards,
Rob...........

I had the same problem using MySql 5. Removed 5 and installed 4.1, recreated the slimserver database and assigned all permissions to user slimserver.

Started slimserver and the tables were created and all of the tables were then being populated, as viewed in mysqladministrator.

Hope this helps ..Mark

mrfantasy
2006-01-29, 08:11
I got MySQL running last night. It was fun, and I even updated the wiki page a bit with some pointers.

I haven't run it through its paces yet but it seems a bit more responsive. The catch for me is I'm using a bit more memory (slimserver uses less, mysqld uses more than the difference) and with a 128 MB Kuro Box there's not much room to play.

Also of note is my album count went from 1018 to 994. I think some of this might be that I've renamed a few albums (incorrect tagging from freedb) and perhaps the SQLLite database wasn't cleaned up correctly. Either that or I'm missing some albums (but I haven't noticed any yet.)

rkeeney
2006-01-30, 08:04
I had the same problem using MySql 5. Removed 5 and installed 4.1, recreated the slimserver database and assigned all permissions to user slimserver.

Thanks, Mark. I had noticed warnings from others about using v5 so I installed v4.1 and no luck. I completely uninstalled everything and reinstalled SS and went back to the default DB. Maybe I'll give it one more try. If still unsuccessful I will await the SS version that fully supports MySQL, maybe v6.5?

Anyway, thanks to all who offered suggestions. This forum is a great resource!

Regards,
Rob............

stinkingpig
2006-01-30, 09:56
rkeeney wrote:
> macallf Wrote:
>
>> I had the same problem using MySql 5. Removed 5 and installed 4.1,
>> recreated the slimserver database and assigned all permissions to user
>> slimserver.
>>
>
> Thanks, Mark. I had noticed warnings from others about using v5 so I
> installed v4.1 and no luck. I completely uninstalled everything and
> reinstalled SS and went back to the default DB. Maybe I'll give it one
> more try. If still unsuccessful I will await the SS version that fully
> supports MySQL, maybe v6.5?
>
> Anyway, thanks to all who offered suggestions. This forum is a great
> resource!
>
> Regards,
> Rob............
>

If you didn't get the slimserver preference file edit just right, it
would act like this. Took me a couple of tries.

--
Jack at Monkeynoodle dot Org: It's a Scientific Venture...
Riding the Emergency Third Rail Power Trip Since 1996

max.spicer
2006-01-31, 07:11
I've never heard of ungrant. To be honest, if you're not comfortable with MySQL already, you may be better off using the supported solution i.e. the sqllite db.

You don't need to specifically create the slimserver user. 'grant all on slimserver.* to slimserver' implicitly creates the user called slimserver.

Max


Thanks, but that gives the same result.

I think I probably need to create MySQL user 'slimserver' first (the wiki doesn't mention this at all) but I'm new to SQL ;-(

Also the MySQL doc doesn't seem to mention Ungrant. GRANT and REVOKE, but not Ungrant. WTF is Ungrant?