mysql Raq4 User Quotas

Anon

Hi,

I apologise if this is an issue previously dealt with, I have spent time in the archieves and did not see a similar problem.

I recently installed MySQL on my raq4 and it would appear to have gone well. It is a .pkg file and auto installs after loading.

My problem is that the install created a user called MySQL on the raq. This user needs to have X amount of disk space allocated to it in order for MySQL to function correctly, and it doesnt.

As the user was created by the install program it is not associated with any one specific site and as such I can not adjust the disk quota using the servers GUI, and I am only a novice with linux so I do not know if there is a command I could use.

Has anyone come across this before and if so do you have a solution. I am almost ready to call my ISP at $100 for 15mins of tech support.

Thanks for your help,

Adam

razorsedgeuk

What is raq4?

My name is Richard Alan Quadling.

But I'm not 4.

Ha ha!

Anon

Its a server manufactured by Cobalt ( which was just bought by Sun Systems ),

It has a server management GUI which is 'supposed' to eliminate the need for a unix/linux admin.

Anon

I am not sure that I understand completly but will take a stab at it.

For users who want mySQL access, why not set them up a seperate mySQL username and password using the mysqladmin command line. and then install phpMyAdmin for them.

I don't see why this would not work.

shanx24

Hi Adam, David,

I'd be really interested in knowing if David's suggestion worked for you. We might be going in for a raq4 client soon, so I would really appreciate if you could let me know if I should foresee any obstacles!

Thanks!

Anon

I did not try Davids suggestion as, at this time, I am the only user of the box. I have installed phpMyAdmin but I havent got it to work yet.

I found out how to increase the disk quota of the user 'MySql'. That was the problem, as soon as I got past that MySql works perfectly.

Heres how

from a root shell

export EDITOR=pico
(change the default editor to something easier to use than vi)

edquota mysql
(edit the quota for the mysql user)
(this will open up the quota file for editing)
(once in, change the "user =" and "group =" parts)
(size is in K😎
(<ctrl>-x to exit)

Now you're done!

My problem was inexperience with linux admininistration more than anything, the raq GUI is fine for most tasks but there are times, like this, when it is left wanting.

befriend

This will not work. As the original poster noted, his installation of MySQL runs as the user "mysql". As a result, on the filesystem all databases are owned by the user "mysql" and he needed to increase that user's quota. MySQL itself uses its own internal privilege (user access and more) system which is separate from that of the operating system. So though your idea to create separate MySQL users is a smart idea it won't help his problem.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/

Anon

I'm going for a raq4 also to use as an email server. Does anyone know if IMAP functions compiled in PHP works well in Cobalts, or it's an OS issue.