Re: PostgreSQL and perl script ->perl.core

Previous thread: OT: Cloud Computing Security by Brad Tilley on Thursday, February 25, 2010 - 5:44 pm. (1 message)

Next thread: proxychains on openbsd 4.6 by Beavis on Thursday, February 25, 2010 - 9:47 pm. (1 message)
From: Stuart Henderson
Date: Thursday, February 25, 2010 - 7:06 pm

oh, please also keep /tmp/pkglist around in case anyone wants to see it..


From: Chris Bennett
Date: Thursday, February 25, 2010 - 8:57 pm

This did not work. I am two sets behind on non X stuff.
I will upgrade to latest now.



-- 
A human being should be able to change a diaper, plan an invasion,
butcher a hog, conn a ship, design a building, write a sonnet, balance
accounts, build a wall, set a bone, comfort the dying, take orders,
give orders, cooperate, act alone, solve equations, analyze a new
problem, pitch manure, program a computer, cook a tasty meal, fight
efficiently, die gallantly. Specialization is for insects.
   -- Robert Heinlein

From: Chris Bennett
Date: Thursday, February 25, 2010 - 9:28 pm

This is the script causing the problem.
The problem seems to disappear when I added print "What is commented out\n";

at every comment.

#!/usr/bin/perl
#------------------------------------------------------------------------------
#    mwForum - Web-based discussion forum
#    Copyright (c) 1999-2010 Markus Wichitill
#
#    This program is free software; you can redistribute it and/or modify
#    it under the terms of the GNU General Public License as published by
#    the Free Software Foundation; either version 3 of the License, or
#    (at your option) any later version.
#
#    This program is distributed in the hope that it will be useful,
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#    GNU General Public License for more details.
#------------------------------------------------------------------------------

use strict;
use warnings;
no warnings qw(uninitialized redefine);

# Imports
use Getopt::Std ();
use MwfMain;

#------------------------------------------------------------------------------

# Get arguments
my %opts = ();
Getopt::Std::getopts('f:', \%opts);
my $forumId = $opts{f};

# Init
my ($m, $cfg, $lng) = MwfMain->newShell(forumId => $forumId);
exit if !$cfg->{subsDigest};
$m->dbBegin();

# Get last sent time   
my $lastSentTime = $m->max($m->getVar('crnSubLst') || 0, $m->{now} - 
86400 * 5);

# Get boards
my $boards = $m->fetchAllHash("
    SELECT * FROM boards WHERE lastPostTime > ?", $lastSentTime);

# Board subscriptions
for my $board (@$boards) {
    # Get posts
    my $posts = $m->fetchAllHash("
        SELECT posts.postTime, posts.body, posts.userNameBak,
            topics.subject
        FROM posts AS posts
            INNER JOIN topics AS topics
                ON topics.id = posts.topicId
        WHERE posts.postTime > :lastSentTime
            AND posts.boardId = :boardId
            AND posts.approved = 1
        ORDER BY ...
From: Chris Bennett
Date: Thursday, February 25, 2010 - 10:27 pm

No go.
Updated to latest.
no packages got updated.

Still get Segmentation faults
"debug" version still works clean

-- 
A human being should be able to change a diaper, plan an invasion,
butcher a hog, conn a ship, design a building, write a sonnet, balance
accounts, build a wall, set a bone, comfort the dying, take orders,
give orders, cooperate, act alone, solve equations, analyze a new
problem, pitch manure, program a computer, cook a tasty meal, fight
efficiently, die gallantly. Specialization is for insects.
   -- Robert Heinlein

From: Chris Bennett
Date: Friday, February 26, 2010 - 6:47 am

I have now given myself a new problem

Apache is now blown out:
runs but I get
[Fri Feb 26 07:44:14 2010] [notice] child pid 26552 exit signal 
Segmentation fault (11)

for every access

-- 
A human being should be able to change a diaper, plan an invasion,
butcher a hog, conn a ship, design a building, write a sonnet, balance
accounts, build a wall, set a bone, comfort the dying, take orders,
give orders, cooperate, act alone, solve equations, analyze a new
problem, pitch manure, program a computer, cook a tasty meal, fight
efficiently, die gallantly. Specialization is for insects.
   -- Robert Heinlein

From: Stuart Henderson
Date: Friday, February 26, 2010 - 6:51 am

httpd ABI got changed. Until we can get new packages out you will need
to rebuild your apache modules (php/etc).

From: Chris Bennett
Date: Friday, February 26, 2010 - 7:04 am

ok. How do I do that?
Or will ports have the right versions?
Which ones of these do I need to rebuild?

This is my package list

GeoIP-1.4.6         find the country where IP address/hostname 
originates from
GraphicsMagick-1.3.6-no_x11 image processing tools with stable ABI
ImageMagick-6.4.5.6p0-no_x11 image processing tools
amavisd-new-2.6.4p0 interface between mailer MTA and content checkers
arc-5.21op1         create & extract files from DOS .ARC files
autoconf-2.61p3     automatically configure source code on many Un*x 
platforms
bzip2-1.0.5         block-sorting file compressor, unencumbered
cabextract-1.2p0    extracts files from Microsoft CAB archives
clamav-0.95.3       virus scanner
colorls-4.6p0       ls that can use color to display file attributes
curl-7.19.7p0       get files from FTP, Gopher, HTTP or HTTPS servers
db-4.6.21p0         Berkeley DB package, revision 4
dovecot-1.1.20-postgresql compact IMAP/POP3 server
e2fs-uuid-1.41.4p0  unique id generator library
e2fsprogs-1.41.4p0  utilities to manipulate ext2 filesystems
femail-0.97p1       simple SMTP client
freetype-1.3.1p3    free and portable TrueType font rendering engine
freeze-2.5p0        FREEZE / MELT compression program - often used in QNX
gawk-3.1.7p0        GNU awk
gd-2.0.35p0         library for dynamic creation of images
gettext-0.17p0      GNU gettext
ghostscript-8.63p11-no_x11 GNU PostScript interpreter
ghostscript-fonts-8.11p1 35 standard PostScript fonts with Adobe name 
aliases
gmake-3.81p0        GNU make
gmp-4.3.1           library for arbitrary precision arithmetic
gnupg-1.4.10        GNU privacy guard - a free PGP replacement
gsed-4.1.5          GNU stream editor
gtar-1.22p0         GNU version of the traditional tape archiver
help2man-1.29p0     GNU help2man
ijs-0.35            raster image transmission library
jasper-1.900.1p1    reference implementation of JPEG-2000
jbigkit-1.6p1       lossless image compression library
jpeg-7              IJG's JPEG compression ...
Previous thread: OT: Cloud Computing Security by Brad Tilley on Thursday, February 25, 2010 - 5:44 pm. (1 message)

Next thread: proxychains on openbsd 4.6 by Beavis on Thursday, February 25, 2010 - 9:47 pm. (1 message)