|
From: Barry <we...@i1...> - 2006-12-12 02:52:50
|
OK - a little more info after some more testing - It does indeed seem I am running into a low memory condition. How much memory does miniserv/webmin need anyway? Miniserv.error gives me the sparse message: Out of memory! which doesn't help me help it :( For now this seems to be happening most consistently in the virtualmin module (I have ! 10 domains, with form 1 to 6 or so aliases in each one, possibly up to about 5 subdomains in a few of them. This seems to be happening regardless of the theme - the "old webmin theme" has the same issue. I do notice that the new framed thems reports the memory usage at some instant in time. But it doesn't seem to be anything close to what top is reporting. For instance, webmin reports: 128 MB total, 110 MB used, while top is showing Mem: 131072k total, 88856k used, That is a big difference in a tight space - so how is webmin calculating the amount? Best, Barry |
|
From: Barry <we...@i1...> - 2006-12-12 03:42:28
|
I noticed the error message: /unauthenticated/toggleview.js : File not found in miniserv.error when I select the new framed theme. I do have: # locate toggleview.js /usr/libexec/webmin/blue-theme/toggleview.js so maybe a file either got dropped from the theme (or this is evidence of the upgrade not being fully completed as I thought might have happened earlier?) Best, Barry |
|
From: Jamie C. <jca...@we...> - 2006-12-12 05:53:38
|
On 11/Dec/2006 19:41 Barry wrote .. > I noticed the error message: > > /unauthenticated/toggleview.js : File not found > > in miniserv.error when I select the new framed theme. > > I do have: > > # locate toggleview.js > /usr/libexec/webmin/blue-theme/toggleview.js > > so maybe a file either got dropped from the theme (or this is evidence > of the upgrade not being fully completed as I thought might have > happened earlier?) Thanks for pointing this out - that is minor bug, as the functions in toggleview.js aren't used anywhere except the left frame, which does use the correct path. But it is bad to generate so many messages in the error log, so I'll fix this in the next release. - Jamie |
|
From: Barry <we...@i1...> - 2006-12-12 03:43:08
|
Barry wrote: > OK - a little more info after some more testing - > > It does indeed seem I am running into a low memory condition. > > How much memory does miniserv/webmin need anyway? > > Miniserv.error gives me the sparse message: > > Out of memory! > > which doesn't help me help it :( > > For now this seems to be happening most consistently in the virtualmin > module (I have ! 10 domains, with form 1 to 6 or so aliases in each > one, possibly up to about 5 subdomains in a few of them. > > This seems to be happening regardless of the theme - the "old webmin > theme" has the same issue. > > I do notice that the new framed thems reports the memory usage at some > instant in time. But it doesn't seem to be anything close to what top is > reporting. For instance, webmin reports: 128 MB total, 110 MB used, > while top is showing Mem: 131072k total, 88856k used, > > That is a big difference in a tight space - so how is webmin calculating > the amount? > > Best, > > Barry > OK, I stopped a bunch of the larger memory using services - mysql and httpd, and then just ran the webmin upgrade again. Still no indication in the browser it completed, but when the load in top went down I assumed all was well. then I rebooted my server, and now webmin shows: 128 MB total, 80 MB used while top shows: Mem: 131072k total, 67184k used, 63888k free Better, but still a big gap. I suppose as my server runs, the memory usage might creep up to a point, but for now webmin seems able to load the virtualmin page. But I am not happy about the gap in memory usage reported,nor the idea that it might take on the order of 30MB of memory just to load the virtualmin summary page.... that sounds like an awful lot! Any tips appreciated, as I can't really increase the memory or create swap space on this server. Can I tune webmin/virtualmin/miniserv to use less memory? How about mysql? apache is already down to just about nada - I suppose I could make a thin server and a thick one with php and perl, but given that I only have maxservers=3 for http, I don't know how much is to be gained by reducing it to 2... Best, Barry |
|
From: Jamie C. <jca...@we...> - 2006-12-12 05:51:07
|
On 11/Dec/2006 18:52 Barry wrote .. > OK - a little more info after some more testing - > > It does indeed seem I am running into a low memory condition. > > How much memory does miniserv/webmin need anyway? > > Miniserv.error gives me the sparse message: > > Out of memory! > > which doesn't help me help it :( It really doesn't use much memory.. on one of my systems it uses 95 MB with a bunch of Webmin libraries pre-loaded to speed up modules. On another machine without preloading, only 10MB is used. By default, module preloading is only setup automatically if using Virtualmin pro. > For now this seems to be happening most consistently in the virtualmin > module (I have ! 10 domains, with form 1 to 6 or so aliases in each > one, possibly up to about 5 subdomains in a few of them. > > This seems to be happening regardless of the theme - the "old webmin > theme" has the same issue. > > I do notice that the new framed thems reports the memory usage at some > instant in time. But it doesn't seem to be anything close to what top is > reporting. For instance, webmin reports: 128 MB total, 110 MB used, > while top is showing Mem: 131072k total, 88856k used, > > That is a big difference in a tight space - so how is webmin calculating > the amount? >From /proc/meminfo file. The 'free' command should show the same thing. Does your system only have 128MB RAM? That may be too little .. - Jamie |
|
From: Barry <we...@i1...> - 2006-12-12 06:32:54
|
Jamie Cameron wrote: > On 11/Dec/2006 18:52 Barry wrote .. >> OK - a little more info after some more testing - >> >> It does indeed seem I am running into a low memory condition. >> >> How much memory does miniserv/webmin need anyway? >> >> Miniserv.error gives me the sparse message: >> >> Out of memory! >> >> which doesn't help me help it :( > > It really doesn't use much memory.. on one of my systems it uses 95 MB with a bunch > of Webmin libraries pre-loaded to speed up modules. On another machine without > preloading, only 10MB is used. > > By default, module preloading is only setup automatically if using Virtualmin pro. It kinda looks now like the modules that display lists are the most likely to cause this error. I have seen this behavior before, but I guess I didn't make the connection until now. Maybe it is not miniserv itself as much as teh perl programs? Virtual min is one, I have seen it when listing aliases and especially when listing email for a user account, or the results of a query on email. I also saw it just now when trying to compose an email by a brand new user. Maybe there is some peak usage there? Also I wonder if the new frames them causes extra hits on the server, causing it to spawn new children more often then it would have before? Is there some configuration I can do in that area, like I can with apache> As for the discrepancy between the system info display in webmin and top and free, the latter two seem to be in close alignment, a lot closer the webmin display is to either. BTW, I just noticed I had pop/pop3s and smtp active in zinetd, and I also had sendmail and dovecot running as services. I just turned off the xinetd ones, will see if that helps any. Best, Barry |
|
From: Jamie C. <jca...@we...> - 2006-12-12 18:16:11
|
On 11/Dec/2006 22:32 Barry wrote .. > Jamie Cameron wrote: > > On 11/Dec/2006 18:52 Barry wrote .. > >> OK - a little more info after some more testing - > >> > >> It does indeed seem I am running into a low memory condition. > >> > >> How much memory does miniserv/webmin need anyway? > >> > >> Miniserv.error gives me the sparse message: > >> > >> Out of memory! > >> > >> which doesn't help me help it :( > > > > It really doesn't use much memory.. on one of my systems it uses 95 MB > with a bunch > > of Webmin libraries pre-loaded to speed up modules. On another machine > without > > preloading, only 10MB is used. > > > > By default, module preloading is only setup automatically if using Virtualmin > pro. > > It kinda looks now like the modules that display lists are the most > likely to cause this error. I have seen this behavior before, but I > guess I didn't make the connection until now. > > Maybe it is not miniserv itself as much as teh perl programs? Virtual > min is one, I have seen it when listing aliases and especially when > listing email for a user account, or the results of a query on email. I > also saw it just now when trying to compose an email by a brand new > user. Maybe there is some peak usage there? > > Also I wonder if the new frames them causes extra hits on the server, > causing it to spawn new children more often then it would have before? > Is there some configuration I can do in that area, like I can with apache> > > As for the discrepancy between the system info display in webmin and top > and free, the latter two seem to be in close alignment, a lot closer the > webmin display is to either. > > BTW, I just noticed I had pop/pop3s and smtp active in zinetd, and I > also had sendmail and dovecot running as services. I just turned off the > xinetd ones, will see if that helps any. I suspect that Webmin is using up too much memory when you do things that cause large perl libraries to be loaded, in particular those in the Virtualmin module (which has a huge -lib.pl file). It would be useful to know the peak size of a miniserv.pl process before it exits ... I imagine they are running out of memory and dieing. - Jamie |
|
From: Barry <we...@i1...> - 2006-12-12 19:46:44
|
Jamie Cameron wrote: > On 11/Dec/2006 22:32 Barry wrote .. >> Jamie Cameron wrote: >>> On 11/Dec/2006 18:52 Barry wrote .. >>>> OK - a little more info after some more testing - >>>> >>>> It does indeed seem I am running into a low memory condition. >>>> >>>> How much memory does miniserv/webmin need anyway? >>>> >>>> Miniserv.error gives me the sparse message: >>>> >>>> Out of memory! >>>> >>>> which doesn't help me help it :( >>> It really doesn't use much memory.. on one of my systems it uses 95 MB >> with a bunch >>> of Webmin libraries pre-loaded to speed up modules. On another machine >> without >>> preloading, only 10MB is used. >>> >>> By default, module preloading is only setup automatically if using Virtualmin >> pro. >> >> It kinda looks now like the modules that display lists are the most >> likely to cause this error. I have seen this behavior before, but I >> guess I didn't make the connection until now. >> >> Maybe it is not miniserv itself as much as teh perl programs? Virtual >> min is one, I have seen it when listing aliases and especially when >> listing email for a user account, or the results of a query on email. I >> also saw it just now when trying to compose an email by a brand new >> user. Maybe there is some peak usage there? >> >> Also I wonder if the new frames them causes extra hits on the server, >> causing it to spawn new children more often then it would have before? >> Is there some configuration I can do in that area, like I can with apache> >> >> As for the discrepancy between the system info display in webmin and top >> and free, the latter two seem to be in close alignment, a lot closer the >> webmin display is to either. >> >> BTW, I just noticed I had pop/pop3s and smtp active in zinetd, and I >> also had sendmail and dovecot running as services. I just turned off the >> xinetd ones, will see if that helps any. > > I suspect that Webmin is using up too much memory when you do things > that cause large perl libraries to be loaded, in particular those in > the Virtualmin module (which has a huge -lib.pl file). It would be > useful to know the peak size of a miniserv.pl process before it exits ... > I imagine they are running out of memory and dieing. > > - Jamie Is there a way for me to find out the peak size? There doesn't seem to be anything in the log file, at least for now... Best, Barry |
|
From: Jamie C. <jca...@we...> - 2006-12-12 19:47:55
|
On 12/Dec/2006 11:46 Barry wrote .. > Jamie Cameron wrote: > > On 11/Dec/2006 22:32 Barry wrote .. > >> Jamie Cameron wrote: > >>> On 11/Dec/2006 18:52 Barry wrote .. > >>>> OK - a little more info after some more testing - > >>>> > >>>> It does indeed seem I am running into a low memory condition. > >>>> > >>>> How much memory does miniserv/webmin need anyway? > >>>> > >>>> Miniserv.error gives me the sparse message: > >>>> > >>>> Out of memory! > >>>> > >>>> which doesn't help me help it :( > >>> It really doesn't use much memory.. on one of my systems it uses 95 > MB > >> with a bunch > >>> of Webmin libraries pre-loaded to speed up modules. On another machine > >> without > >>> preloading, only 10MB is used. > >>> > >>> By default, module preloading is only setup automatically if using > Virtualmin > >> pro. > >> > >> It kinda looks now like the modules that display lists are the most > >> likely to cause this error. I have seen this behavior before, but I > >> guess I didn't make the connection until now. > >> > >> Maybe it is not miniserv itself as much as teh perl programs? Virtual > >> min is one, I have seen it when listing aliases and especially when > >> listing email for a user account, or the results of a query on email. > I > >> also saw it just now when trying to compose an email by a brand new > >> user. Maybe there is some peak usage there? > >> > >> Also I wonder if the new frames them causes extra hits on the server, > >> causing it to spawn new children more often then it would have before? > >> Is there some configuration I can do in that area, like I can with apache> > >> > >> As for the discrepancy between the system info display in webmin and > top > >> and free, the latter two seem to be in close alignment, a lot closer > the > >> webmin display is to either. > >> > >> BTW, I just noticed I had pop/pop3s and smtp active in zinetd, and I > >> also had sendmail and dovecot running as services. I just turned off > the > >> xinetd ones, will see if that helps any. > > > > I suspect that Webmin is using up too much memory when you do things > > that cause large perl libraries to be loaded, in particular those in > > the Virtualmin module (which has a huge -lib.pl file). It would be > > useful to know the peak size of a miniserv.pl process before it exits > ... > > I imagine they are running out of memory and dieing. > > > > - Jamie > > Is there a way for me to find out the peak size? There doesn't seem to > be anything in the log file, at least for now... I guess all you can do is keep running the top command, to see how high memory usage gets.. - Jamie |
|
From: Barry <we...@i1...> - 2006-12-12 23:13:22
|
Jamie Cameron wrote: >>> I imagine they are running out of memory and dieing. >>> >>> - Jamie >> Is there a way for me to find out the peak size? There doesn't seem to >> be anything in the log file, at least for now... > > I guess all you can do is keep running the top command, to see how high > memory usage gets.. > > - Jamie > Jamie - I am seeing some modules that are crashing when top is reporting memory usage as low as ~20MB on a 128MB (no swap) system. In addition to virtualmin, the mail handling modules seem to be pretty memory hungry. So are user deletion modules - I had trouble deleting a system user, ultimately had to hand edit the passwd file to drop the user. Is is possible to have the large libraries split up and loaded only as needed? Otherwise, it looks like both webmin and virtualmin (and probably usermin too) have outgrown their general usefulness, including for use managing relatively small machines. That might be OK if it is your intention, or if it just evolved that way, maybe you can live with it - but can you let us know if you can/will make efforts to reel memory usage back in? I suppose I can help you with additional tests .... Best, Barry |
|
From: Barry <we...@i1...> - 2006-12-13 00:48:35
|
> That might be OK if it is your intention, or if it just evolved that
> way, maybe you can live with it - but can you let us know if you
> can/will make efforts to reel memory usage back in?
>
> I suppose I can help you with additional tests ....
>
>
Jamie - here is a snapshot of top right after a reboot:
top - 18:43:58 up 2 min, 0 users, load average: 0.07, 0.02, 0.00
Tasks: 34 total, 1 running, 33 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi,
0.0% si
Mem: 131072k total, 58840k used, 72232k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
24362 mysql 16 0 132m 24m 29m S 0.0 19.4 0:00.06 mysqld
24533 root 16 0 42308 10m 34m S 0.0 7.9 0:00.00 miniserv.pl
24507 root 16 0 38824 9732 31m S 0.0 7.4 0:00.00 miniserv.pl
24499 apache 18 0 99788 8432 94m S 0.0 6.4 0:00.00 httpd
24456 root 16 0 99788 8412 94m S 0.0 6.4 0:00.04 httpd
24426 root 16 0 32924 3796 30m S 0.0 2.9 0:00.01 sendmail
24440 smmsp 18 0 27796 3116 25m S 0.0 2.4 0:00.00 sendmail
25656 root 16 0 25596 2332 24m S 0.0 1.8 0:00.01 sshd
25773 root 16 0 25596 2332 24m S 0.0 1.8 0:00.01 sshd
25777 barry 16 0 24552 2328 23m S 0.0 1.8 0:00.00 sshd
25687 barry 16 0 24552 2320 23m S 0.0 1.8 0:00.00 sshd
24373 root 16 0 29860 2184 28m S 0.0 1.7 0:00.00 dovecot-auth
24251 root 16 0 21968 2092 21m S 0.0 1.6 0:00.06 sshd
24378 dovecot 16 0 14224 1852 13m S 0.0 1.4 0:00.00 imap-login
24379 dovecot 16 0 14224 1852 13m S 0.0 1.4 0:00.00 imap-login
24380 dovecot 16 0 14224 1848 13m S 0.0 1.4 0:00.00 imap-login
24374 dovecot 16 0 14216 1844 13m S 0.0 1.4 0:00.00 pop3-login
24375 dovecot 16 0 14216 1844 13m S 0.0 1.4 0:00.00 pop3-login
24377 dovecot 16 0 14216 1844 13m S 0.0 1.4 0:00.00 pop3-login
24480 root 18 0 20984 1572 20m S 0.0 1.2 0:00.00 saslauthd
24485 root 18 0 20984 1572 20m S 0.0 1.2 0:00.00 saslauthd
25737 root 16 0 6544 1508 6200 S 0.0 1.2 0:00.00 bash
25829 root 16 0 6544 1504 6200 S 0.0 1.1 0:00.00 bash
25778 barry 16 0 6548 1408 6200 S 0.0 1.1 0:00.00 bash
25693 barry 15 0 6544 1404 6200 S 0.0 1.1 0:00.01 bash
24327 root 17 0 6400 1208 6200 S 0.0 0.9 0:00.00 mysqld_safe
25732 root 16 0 21844 1180 20m S 0.0 0.9 0:00.00 su
25812 root 15 0 21844 1180 20m S 0.0 0.9 0:00.00 su
24466 root 16 0 9736 1116 8792 S 0.0 0.9 0:00.00 crond
25874 root 16 0 6148 1112 5924 R 0.0 0.8 0:00.03 top
24262 root 17 0 8712 916 8336 S 0.0 0.7 0:00.00 xinetd
24242 root 16 0 3764 796 3552 S 0.0 0.6 0:00.00 dovecot
1 root 16 0 4752 624 4536 S 0.0 0.5 0:00.08 init
24232 root 16 0 3632 620 3444 S 0.0 0.5 0:00.00 syslogd
Even this is not enough memory to add a database to a virtualmin managed
account (that I could only make earlier when I turned off a bunch of
services, including mysql and so the database wasn't made at domain
creation time.
So it looks like you need > 75 MB Ram to do that function ....how much
more, I don't know.
Best,
Barry
|
|
From: Jamie C. <jca...@we...> - 2006-12-13 01:00:01
|
On 12/Dec/2006 16:47 Barry wrote .. > > > That might be OK if it is your intention, or if it just evolved that > > way, maybe you can live with it - but can you let us know if you > > can/will make efforts to reel memory usage back in? > > > > I suppose I can help you with additional tests .... > > > > > Jamie - here is a snapshot of top right after a reboot: > > top - 18:43:58 up 2 min, 0 users, load average: 0.07, 0.02, 0.00 > Tasks: 34 total, 1 running, 33 sleeping, 0 stopped, 0 zombie > Cpu(s): 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, > 0.0% si > Mem: 131072k total, 58840k used, 72232k free, 0k buffers > Swap: 0k total, 0k used, 0k free, 0k cached > > PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND > 24362 mysql 16 0 132m 24m 29m S 0.0 19.4 0:00.06 mysqld > 24533 root 16 0 42308 10m 34m S 0.0 7.9 0:00.00 miniserv.pl > 24507 root 16 0 38824 9732 31m S 0.0 7.4 0:00.00 miniserv.pl > 24499 apache 18 0 99788 8432 94m S 0.0 6.4 0:00.00 httpd > 24456 root 16 0 99788 8412 94m S 0.0 6.4 0:00.04 httpd > 24426 root 16 0 32924 3796 30m S 0.0 2.9 0:00.01 sendmail > 24440 smmsp 18 0 27796 3116 25m S 0.0 2.4 0:00.00 sendmail > 25656 root 16 0 25596 2332 24m S 0.0 1.8 0:00.01 sshd > 25773 root 16 0 25596 2332 24m S 0.0 1.8 0:00.01 sshd > 25777 barry 16 0 24552 2328 23m S 0.0 1.8 0:00.00 sshd > 25687 barry 16 0 24552 2320 23m S 0.0 1.8 0:00.00 sshd > 24373 root 16 0 29860 2184 28m S 0.0 1.7 0:00.00 dovecot-auth > 24251 root 16 0 21968 2092 21m S 0.0 1.6 0:00.06 sshd > 24378 dovecot 16 0 14224 1852 13m S 0.0 1.4 0:00.00 imap-login > 24379 dovecot 16 0 14224 1852 13m S 0.0 1.4 0:00.00 imap-login > 24380 dovecot 16 0 14224 1848 13m S 0.0 1.4 0:00.00 imap-login > 24374 dovecot 16 0 14216 1844 13m S 0.0 1.4 0:00.00 pop3-login > 24375 dovecot 16 0 14216 1844 13m S 0.0 1.4 0:00.00 pop3-login > 24377 dovecot 16 0 14216 1844 13m S 0.0 1.4 0:00.00 pop3-login > 24480 root 18 0 20984 1572 20m S 0.0 1.2 0:00.00 saslauthd > 24485 root 18 0 20984 1572 20m S 0.0 1.2 0:00.00 saslauthd > 25737 root 16 0 6544 1508 6200 S 0.0 1.2 0:00.00 bash > 25829 root 16 0 6544 1504 6200 S 0.0 1.1 0:00.00 bash > 25778 barry 16 0 6548 1408 6200 S 0.0 1.1 0:00.00 bash > 25693 barry 15 0 6544 1404 6200 S 0.0 1.1 0:00.01 bash > 24327 root 17 0 6400 1208 6200 S 0.0 0.9 0:00.00 mysqld_safe > 25732 root 16 0 21844 1180 20m S 0.0 0.9 0:00.00 su > 25812 root 15 0 21844 1180 20m S 0.0 0.9 0:00.00 su > 24466 root 16 0 9736 1116 8792 S 0.0 0.9 0:00.00 crond > 25874 root 16 0 6148 1112 5924 R 0.0 0.8 0:00.03 top > 24262 root 17 0 8712 916 8336 S 0.0 0.7 0:00.00 xinetd > 24242 root 16 0 3764 796 3552 S 0.0 0.6 0:00.00 dovecot > 1 root 16 0 4752 624 4536 S 0.0 0.5 0:00.08 init > 24232 root 16 0 3632 620 3444 S 0.0 0.5 0:00.00 syslogd > > Even this is not enough memory to add a database to a virtualmin managed > account (that I could only make earlier when I turned off a bunch of > services, including mysql and so the database wasn't made at domain > creation time. > > So it looks like you need > 75 MB Ram to do that function ....how much > more, I don't know. All I can say is that the smallest machine I've run Webmin/Virtualmin on lately has 256 MB of RAM .. - Jamie |
|
From: Barry <we...@i1...> - 2006-12-13 01:33:59
|
Jamie - Due to the memory issues I described earlier, a domain was created via virtualmin that didn't have a db associated with it. Now I'd like to add that missing db. When I bring up the domain frame in virtualmin, there is no button for "edit databases" as there is on the domains that have databases. So it looks like the only way to add the database would be to click on the checkbox for "MySQL database enabled?" and then "Save virtual server" But given the memory problems, that seems overkill and in fact won't run at all if I have mysqld running. Is there another way to create a database, maybe via the mysql module (or even by hand - I am willing to do it from the shell if necessary) and then associate it with a virtualmin domain? Maybe there is a webmin/virtualmin command line tool I can use instead of the web interface? Best, Barry |
|
From: Jamie C. <jca...@we...> - 2006-12-13 01:49:52
|
On 12/Dec/2006 17:33 Barry wrote .. > Jamie - > > Due to the memory issues I described earlier, a domain was created via > virtualmin that didn't have a db associated with it. > > Now I'd like to add that missing db. > > When I bring up the domain frame in virtualmin, there is no button for > "edit databases" as there is on the domains that have databases. > > So it looks like the only way to add the database would be to click on > the checkbox for "MySQL database enabled?" and then "Save virtual server" > > But given the memory problems, that seems overkill and in fact won't run > at all if I have mysqld running. > > Is there another way to create a database, maybe via the mysql module > (or even by hand - I am willing to do it from the shell if necessary) > and then associate it with a virtualmin domain? > > Maybe there is a webmin/virtualmin command line tool I can use instead > of the web interface? That depends .. did the MySQL login for your virtual server get created? The fix depends on that. However, I would strongly recommend against trying to use it on a machine that is running out of memory like this .. you'll just end up with broken configurations. - Jamie |
|
From: Barry <we...@i1...> - 2006-12-13 05:19:57
|
Jamie Cameron wrote: > On 12/Dec/2006 17:33 Barry wrote .. >> Jamie - >> >> Due to the memory issues I described earlier, a domain was created via >> virtualmin that didn't have a db associated with it. >> >> Now I'd like to add that missing db. >> >> When I bring up the domain frame in virtualmin, there is no button for >> "edit databases" as there is on the domains that have databases. >> >> So it looks like the only way to add the database would be to click on >> the checkbox for "MySQL database enabled?" and then "Save virtual server" >> >> But given the memory problems, that seems overkill and in fact won't run >> at all if I have mysqld running. >> >> Is there another way to create a database, maybe via the mysql module >> (or even by hand - I am willing to do it from the shell if necessary) >> and then associate it with a virtualmin domain? >> >> Maybe there is a webmin/virtualmin command line tool I can use instead >> of the web interface? > > That depends .. did the MySQL login for your virtual server get created? > The fix depends on that. Yes, it looks like both the db and the user are there aty this point, but the virtualmin domain summary screen says "Databases: None created" > > However, I would strongly recommend against trying to use it on a machine that > is running out of memory like this .. you'll just end up with broken configurations. Yeah I know :( I am hoping to find some intermediate workarounds. Anyway I don't create domains that often, so in the worst case I am willing to take down some services for a few minutes to get it done. But like you said, if I end up in an incomplete state like this, I'd like to be able to recover so webmin/virtualmin is in sync with the actual machine config. Best, Barry |
|
From: Jamie C. <jca...@we...> - 2006-12-13 05:53:23
|
On 12/Dec/2006 21:19 Barry wrote .. > Jamie Cameron wrote: > > On 12/Dec/2006 17:33 Barry wrote .. > >> Jamie - > >> > >> Due to the memory issues I described earlier, a domain was created via > >> virtualmin that didn't have a db associated with it. > >> > >> Now I'd like to add that missing db. > >> > >> When I bring up the domain frame in virtualmin, there is no button for > >> "edit databases" as there is on the domains that have databases. > >> > >> So it looks like the only way to add the database would be to click > on > >> the checkbox for "MySQL database enabled?" and then "Save virtual server" > >> > >> But given the memory problems, that seems overkill and in fact won't > run > >> at all if I have mysqld running. > >> > >> Is there another way to create a database, maybe via the mysql module > >> (or even by hand - I am willing to do it from the shell if necessary) > >> and then associate it with a virtualmin domain? > >> > >> Maybe there is a webmin/virtualmin command line tool I can use instead > >> of the web interface? > > > > That depends .. did the MySQL login for your virtual server get created? > > The fix depends on that. > > Yes, it looks like both the db and the user are there aty this point, > but the virtualmin domain summary screen says "Databases: None created" In that case, try editing the virtual server's file under /etc/webmin/virtual-server/domains, add changing the mysql=0 line to mysql=1. This will make the Edit Databases page appear, and on that page you can associate the existing database with the domain. - Jamie |
|
From: John H. <web...@ew...> - 2006-12-13 14:18:53
|
Barry wrote: > Jamie Cameron wrote: > >>>> I imagine they are running out of memory and dieing. >>>> >>>> - Jamie >>>> >>> Is there a way for me to find out the peak size? There doesn't seem to >>> be anything in the log file, at least for now... >>> >> I guess all you can do is keep running the top command, to see how high >> memory usage gets.. >> >> - Jamie >> >> > > Jamie - > > I am seeing some modules that are crashing when top is reporting memory > usage as low as ~20MB on a 128MB (no swap) system. > 128mb with no swap? I'm not sure that was enough for a server 10 years ago. How many instances of Apache does your config allow. If 10, that'll be half your ram. I saw mysql in the top report... and that can vary widely up to needing more than you have. But with as little as you have you'll likely need to tweak the my.cnf down to almost nothing.. maybe you can find a tinymy.cnf example file somewhere. IIRC, back when 128megs was pretty common, Redhat was suggesting a swap of twice the size of the ram. I'd say put more ram in it and if you have to rebuild the system and be sure to include a swap of at least the size of the ram, if not twice the amount. Best, John Hinton |
|
From: Barry <we...@i1...> - 2006-12-12 20:25:17
|
I just noticed that the Edit Mailbox frame, reached from VirtualminGPL displays the password in the clear next to the Leave Unchanged option. This is probably not a "Good Idea (TM)". Best, Barry |
|
From: Jamie C. <jca...@we...> - 2006-12-12 21:30:03
|
On 12/Dec/2006 12:24 Barry wrote .. > I just noticed that the Edit Mailbox frame, reached from VirtualminGPL > displays the password in the clear next to the Leave Unchanged option. > > This is probably not a "Good Idea (TM)". Actually, I think it is :-) Virtualmin stores the plain-text password for mailbox users whenever it can, as it is needed if MySQL or DAV access is enabled for a user after he is created. So I figured I might as well display that password too .. after all, anyone who has permissions to see it could change it anyway. - Jamie |
|
From: Barry <we...@i1...> - 2006-12-12 21:35:06
|
Jamie Cameron wrote: > On 12/Dec/2006 12:24 Barry wrote .. >> I just noticed that the Edit Mailbox frame, reached from VirtualminGPL >> displays the password in the clear next to the Leave Unchanged option. >> >> This is probably not a "Good Idea (TM)". > > Actually, I think it is :-) > > Virtualmin stores the plain-text password for mailbox users whenever it can, > as it is needed if MySQL or DAV access is enabled for a user after he is created. > So I figured I might as well display that password too .. after all, anyone who > has permissions to see it could change it anyway. > > - Jamie > Jamie - I'd argue that saving the passwords in the clear is not a good idea either ... I'd also argue separately that having permission to change a pw is not the same as saying you might as well display it because shoulder surfing becomes an issue in the latter case, and since people are likely to use weak and repeated passwords in places, showing a user's password to an admin could be abused too... Best, Barry |