September 2006 - support - lists.drupal.org

mysql/apache crashing
by Nat Catchpole 25 Sep '06

25 Sep '06

I've made a bit of progress since this last e-mail. Put back in the debian default my.cnf. mysql processes are now about 6-8% of memory, apache is around 3.5% per thread. However, the server is still swapping out, crashing etc. seemingly at random every couple of days. We're _only_ running drupal on it, postfix is installed but only doing sendmail sends from contact.module, not receiving anything, and it's otherwise a fairly vanilla xen/vds/debian sarge installation. I also installed the blockcache.module to see if that would help - this has definitely reduced queries per page by about 20 (still roughly 200-250 queries per page but that's 10% so not bad). There really doesn't seem to be any obvious trigger to the crashing out though - it'll be fine at high traffic levels (for us), so I'm wondering if something is going into a loop etc. As always, any help much appreciated. Nat > > >Im running only Drupal 4.7.3 on a 512mb ram VDS debian sarge mysql 4.1 >apache2 php4 > > > >Memory usage is generally fine overall, cpu can be a bit high sometimes >which I think is down to a lot of 404 errors from the old site. We want to >eliminate some of those 404s first, then switch off drupals handling of >404s altogether, Im not sure this is our mysql memory problem though. > > > >Running top u mysql just after /etc/init.d/mysql restart mysql >processes are between 4.4 and 5% of ram, then I can watch them creep >upwards all the way to 20% each. Eventually this slows things down, the >server starts swapping out, then both apache and mysql crash and require a >restart, then it starts over again. > > > >This may not be drupals fault, but Id appreciate any advice you can offer >with it. > > > >Basic site information: > > > >Around 8000 nodes and 110,000 comments, private message table is around >10mb. Average traffic is 10 logged in users and 20 guests on line rarely >more than double that, often less. Forums index takes about 300 queries due >to lots of subforums (c. 45) but not noticed any other pages that are >significant resource hogs by themselves. > > > >Were using cck, panels, imagecache, contemplate and views a lot. This has >been a persistent problem for months now, which I originally put down to >cache table overhead (sometimes megabytes of overhead within a few minutes >of flushing, have dbmaintenance optimising it every hour now). > > > >Im using a fair amount of contrib modules, so am wondering if it could be >down to one of those notwithstanding my mysql settings. Everything is >pretty much up-to-date by the way using almost entirely 4.7 versions >except for a couple running CVS where theres not an official 4.7 branch. > > > >Full list of contrib. modules below, devel module is generally off. Also >making use of free tagging, forums, tracker and other core modules. >Forum_get_forums runs pretty slow judging by devel modules output, and >administering taxonomy access requires a php memory limit of around 60mb >due to free tagging, so Im wondering if its something to do with one of >those. > > > >bbcode > >tagadelic > >cck > >flatforum > >pathauto > >taxonomy_access > >comment_mover > >image > >privatemsg > >contemplate > >imagecache > >quicktags > >views > >content_moderator > >imagefield > >quote > >db_maintenance > >nodewords > >scheduler > >devel > >panels > >smileys > > > >For completeness, heres my my.cnf settings: > > > >skip-locking > >key_buffer_size = 20M > >max_allowed_packet = 1M > >table_cache = 384 > >sort_buffer_size = 1M > >net_buffer_length = 8K > >read_buffer_size = 256K > >read_rnd_buffer_size = 1M > >myisam_sort_buffer_size = 4M > >query_cache_type = 1 > >query_cache_size = 64M > >query_cache_limit = 4M > >max_connections = 55 > >max_user_connections = 55 > > > >Any help much appreciated. This problem started happening when I had very >few modules installed (mainly flatforum/smileys/cck/views/taxonomy >access/privmsg/quicktags/bbcode). > > > >Thanks! > > > >Nathaniel > >

6 7

Pages with restricted access and menu entries.
by Martin Tomes 25 Sep '06

25 Sep '06

I have defined a page type for pages which should be hidden from anonymous users by writing my own module (an edited copy of page.module) and have set permissions so that only users in specific roles can read those pages. My problem is that if I add that page to a menu that menu entry is shown to anonymous users and I would like it to be hidden from them (they get permission denied on clicking on the menu entry) and only shown to logged in users with view permission. Is there any way to achieve this? -- Martin Tomes.

2 2

Error when enabling modules (Fatal error: Allowed memory size of 8388608 bytes exhausted ...)
by Erik Steffl 25 Sep '06

25 Sep '06

This is a new site, I was able to enable few modules but when tried to add 'audio' modules ('audio' module from http://drupal.org/project/modules) I got the following error: Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 14592 bytes) in /opt/drupal-4.7.3/database/updates.inc on line 1984 any ideas? I looked at the code but it's not clear what the error means, looks more like some php related problem. system: - debian unstable - php5 - mysql 5 - drupal 4.7.3 TIA! erik

3 4

Re: [support] Calendar, event, and timezone problems
by Michelle Cox 24 Sep '06

24 Sep '06

> On 9/24/06, Andrew Cohill <cohill(a)designnine.com> wrote: > > I have two sites running on the same server, with site time and event > > time settings set the same way, and one site handles the time > > correctly, and the other site does not. Make sure you're using the exact same event module on both. I remember people were complaining about this and I had no trouble on my site and someone said they thought it was because I had an older version of events. Going from shakey memory here, but I think the time zone problem came when some other problem was fixed and that's why there's a difference. Michelle

1 0

Migrate content from 4.5.8 to 4.7.3?
by Erik Steffl 24 Sep '06

24 Sep '06

I have an old drupal page that uses drupal 4.5.8, I'd much rather fresh-install 4.7.3 then go through probably (I guess) error prone upgrades. is there any way to migrate content from old 4.5.8 drupal installation to new 4.7.3 installation? I only want to migrate stories etc., not setup/themes etc. TIA, erik

3 2

Possible to hide $submitted when no category is selected?
by Jody Cleveland 22 Sep '06

22 Sep '06

Hello, Is there a way to hide the $submitted info when no category is selected? - jody

2 2

Module for Downloa Files
by Drupal Indonesia 22 Sep '06

22 Sep '06

Is there a module for create Download section with this feature: - able to count how many times file downloaded - able to add screenshot - able to protect original file location or any modules similiar like that?

1 0

warning: Missing argument 2 for drupal_get_path()
by Jody Cleveland 19 Sep '06

19 Sep '06

Hello, I'm running drupal 4.7.3, and just setup a multi-site scenario. If I go to just the main site, I get no errors. But, when I go to any of the sites I have setup under the sites directory, I get this error message: warning: Missing argument 2 for drupal_get_path() in /var/www/html/drupal/includes/common.inc on line 1192. I get that error when I click on Administer - Modules. Line 1192 of common.inc is: Function drupal_get_path($type, $name) { return dirname(drupal_get_filename($type, $name)); } Any ideas how to fix this? - jody

2 1

How to provide users with personal homepages?
by Leo Burd 18 Sep '06

18 Sep '06

Hello there, I am creating a website for youth and my users would really like to be able to configure personal webpages with images, links, text, etc. So far, they only have their personal profile page and that's not attractive at all. What modules do people usually recommend for that? Suggestions are very welcome! Thanks in advance, Leo

4 4

RE: [support] How to provide users with personal homepages?
by Metzler, David 18 Sep '06

18 Sep '06

The bio module is the closest thing that I'm aware of to a personal home page, but you should also of course, look at blogs. Use bio with the views module to provide an index of users with the personal home page. I've also developed a little module based off of blog_theme (I haven't decided if is worthy of project publishing) that lets you, for specific content type's, force the use of the author's selected theme, do give additional flexibility. If there's interest, I'll publish this as well. Dave ________________________________ From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Leo Burd Sent: Monday, September 18, 2006 8:31 AM To: support(a)drupal.org Subject: Re: [support] How to provide users with personal homepages? Hi Ben, thanks for your message! Unfortunately, no one else has replied to my question about personal homepages in Drupal. That's quite intriguing, isn't it? :( Anyway, I'm kind of curious about your block-page idea, but I'm not sure I could visualize it. Would it be possible for your page to be the displayed whenever one goes to a user account (and leave the existing profile as a link on the side)? For me, a page with a large text area that accepted html links and allowed users to include images would be more than good! If that page could be edited using tinymce or similar would be even better! What do you think? Best, .L. ----- Original Message ----- From: Benjamin Melançon <mailto:pwgdarchive@gmail.com> To: support(a)drupal.org Cc: Dan Hakimzadeh <mailto:dan@agaricdesign.com> Sent: Monday, September 18, 2006 10:53 AM Subject: Re: [support] How to provide users with personal homepages? Hi Leo, That's a good question. I wish I had a better answer; maybe someone else will. Enable avatars, of course, for a start. It would also be pretty easy to make a custom block that shows a random picture or pictures from a user's photo gallery and only displays on their user/## page, another block that does the same with their most recent blog entry, etc. I don't know of any module for user pages that users customize themselves, though. I might eventually find the time to put the above blocks into a simple module (if your project has a budget, someone else at Agaric will probably be able to make time!). It would still require customizing the theme to make the place for the blocks. I'd be interested in a report back on what you've found out there, or what you think of throwing blocks onto the user page. - ben http://AgaricDesign.com/ On 9/13/06, Leo Burd <leob(a)media.mit.edu> wrote: Hello there, I am creating a website for youth and my users would really like to be able to configure personal webpages with images, links, text, etc. So far, they only have their personal profile page and that's not attractive at all. What modules do people usually recommend for that? Suggestions are very welcome! Thanks in advance, Leo -- [ Drupal support list | http://lists.drupal.org/ ] ________________________________ -- [ Drupal support list | http://lists.drupal.org/ ]

3 2