[slim] Re: When should I switch from SQLLite to MySQL?
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 Patrick Dixon Wrote: > 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? -- max.spicer The wild things roared their terrible roars and gnashed their terrible teeth and rolled their terrible eyes and showed their terrible claws but Max stepped into his private boat and waved good-bye max.spicer's Profile: http://forums.slimdevices.com/member.php?userid=23 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Re: When should I switch from SQLLite to MySQL?
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 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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 -- rkeeney rkeeney's Profile: http://forums.slimdevices.com/member.php?userid=351 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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.) -- mrfantasy --Mike mrfantasy's Profile: http://forums.slimdevices.com/member.php?userid=1127 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
rkeeney Wrote: > 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 -- macallf macallf's Profile: http://forums.slimdevices.com/member.php?userid=2782 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
Patrick Dixon Wrote: > 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... -- rkeeney rkeeney's Profile: http://forums.slimdevices.com/member.php?userid=351 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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. -- Patrick Dixon www.at-tunes.co.uk Patrick Dixon's Profile: http://forums.slimdevices.com/member.php?userid=90 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
Patrick Dixon Wrote: > 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 -- rkeeney rkeeney's Profile: http://forums.slimdevices.com/member.php?userid=351 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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 -- Patrick Dixon www.at-tunes.co.uk Patrick Dixon's Profile: http://forums.slimdevices.com/member.php?userid=90 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
treble Wrote: > 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. -- rkeeney rkeeney's Profile: http://forums.slimdevices.com/member.php?userid=351 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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... -- treble treble's Profile: http://forums.slimdevices.com/member.php?userid=2797 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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... -- rkeeney rkeeney's Profile: http://forums.slimdevices.com/member.php?userid=351 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
stinkingpig Wrote: > 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 [EMAIL PROTECTED] 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!) -- Patrick Dixon www.at-tunes.co.uk Patrick Dixon's Profile: http://forums.slimdevices.com/member.php?userid=90 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Re: When should I switch from SQLLite to MySQL?
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 [EMAIL PROTECTED] 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 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
Robin Bowes Wrote: > 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. -- Browny Browny's Profile: http://forums.slimdevices.com/member.php?userid=2295 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Re: When should I switch from SQLLite to MySQL?
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. ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Re: When should I switch from SQLLite to MySQL?
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/) ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Re: When should I switch from SQLLite to MySQL?
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. ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
> You can then use the browser on your XP box.Sorry to be a pain, but what > address do I type in the browser? -- Patrick Dixon www.at-tunes.co.uk Patrick Dixon's Profile: http://forums.slimdevices.com/member.php?userid=90 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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 -- Browny Browny's Profile: http://forums.slimdevices.com/member.php?userid=2295 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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] -- Patrick Dixon www.at-tunes.co.uk Patrick Dixon's Profile: http://forums.slimdevices.com/member.php?userid=90 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
Patrick Dixon Wrote: > 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. -- Browny Browny's Profile: http://forums.slimdevices.com/member.php?userid=2295 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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) -- Patrick Dixon www.at-tunes.co.uk Patrick Dixon's Profile: http://forums.slimdevices.com/member.php?userid=90 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
Patrick Dixon Wrote: > 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 -- Browny Browny's Profile: http://forums.slimdevices.com/member.php?userid=2295 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Re: When should I switch from SQLLite to MySQL?
phpMyAdmin works great, and so does WebMin, although its a little more generic. Dave StricklerMailWise LLC617-933-5810 (direct)www.mailwise.com"Intelligent E-mail Protection">>> [EMAIL PROTECTED] 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 theSlimString Translation Helper (http://www.herger.net/slim/)___Discuss mailing listDiscuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss 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 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Re: When should I switch from SQLLite to MySQL?
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/) ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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 www.at-tunes.co.uk Patrick Dixon's Profile: http://forums.slimdevices.com/member.php?userid=90 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Re: When should I switch from SQLLite to MySQL?
On 25/01/06, Michael Herger <[EMAIL PROTECTED]> 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 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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! 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: Code: 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: Code: Ungrant all on slimserver.* to slimserver; -- oktup oktup's Profile: http://forums.slimdevices.com/member.php?userid=1117 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
> 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 -- Patrick Dixon www.at-tunes.co.uk Patrick Dixon's Profile: http://forums.slimdevices.com/member.php?userid=90 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Re: When should I switch from SQLLite to MySQL?
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/) ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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! -- Patrick Dixon www.at-tunes.co.uk Patrick Dixon's Profile: http://forums.slimdevices.com/member.php?userid=90 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Re: When should I switch from SQLLite to MySQL?
On 24/01/06, max. spicer <[EMAIL PROTECTED]> 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 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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 -- max.spicer The wild things roared their terrible roars and gnashed their terrible teeth and rolled their terrible eyes and showed their terrible claws but Max stepped into his private boat and waved good-bye max.spicer's Profile: http://forums.slimdevices.com/member.php?userid=23 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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 StricklerMailWise LLC617-933-5810 (direct)www.mailwise.com"Intelligent E-mail Protection">>> [EMAIL PROTECTED] 6:22:40 PM Saturday, January 21, 2006 >>>I have updated from using SQLite to MySQL (4.1) and found performance tobe MUCH more to my liking - in particular in relation to doing acomplete rescan. I'm currently running 6000 flacs on a ClarkConnect1.3Ghz Athlon Server with 512Mb RAM. There are no latency issues forthat I can see - searches included.The reason I switch was to allow me to view and update the Slimserverdatabase while slimserver is running.If you look at Slimserver's roadmap you will find that MySQL is the waySlimserver is going for the future. Why not early adopt? It is prettypainless (see the wiki) and you can go back very easily if you don'tlike it.One final note of caution - I have seen a couple of posts relating toissues running on MySQL 5. Stick with 4.1 for now.-- BrownyBrowny's Profile: http://forums.slimdevices.com/member.php?userid=2295 View this thread: http://forums.slimdevices.com/showthread.php?t=20281 ___Discuss mailing listDiscuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss 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 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: When should I switch from SQLLite to MySQL?
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 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss