Menu
▾
▴
[Slashcode-general] NetBSD install/run problem (Similar to OpenBSD)
|
From: Robert S. <rsc...@ra...> - 2003-09-24 03:43:23
|
In response to the OpenBSD question of a couple of days ago, I too am
having problems with SlashVirtualUser but I am not seeing the core
dumps. If I comment out SlashVirtualUser, apache starts but the
slashsite can't realy run.
I am using NetBSD 1.6.1 with postgresql. I have had difficulty with
mysql under 1.6.1 and there is some evidence that the current package
of mysql for netbsd is not stable.
I have also had problems with the sql schema for postgresql. I had to
change the datetime fields to timestamp fields to get it to work but I
still had several problems.
What follows is an edited form of the results of my install attempt. I
have edited out 195 instances of a repeated error. Any insight anyone
can offer will help out.
Thanks
Robert Schmid
DBD::Pg::db do failed: ERROR: pg_atoi: zero-length string at
bin/install-slashsite line 341.
Failed on 'INSERT INTO site_info VALUES ('','form','submissions','user
submissions form')'
DBD::Pg::db do failed: ERROR: pg_atoi: zero-length string at
bin/install-slashsite line 341.
Failed on 'INSERT INTO site_info VALUES ('','form','comments','comments
submission form')'
DBD::Pg::db do failed: ERROR: value too long for type character(3) at
bin/install-slashsite line 341.
Failed on 'INSERT INTO tzcodes (tz, off_set, description) VALUES
('WEST',3600,'Western European Summer')'
DBD::Pg::db do failed: ERROR: value too long for type character(3) at
bin/install-slashsite line 341.
Failed on 'INSERT INTO tzcodes (tz, off_set, description) VALUES
('CEST',7200,'Central European Summer')'
DBD::Pg::db do failed: ERROR: value too long for type character(3) at
bin/install-slashsite line 341.
Failed on 'INSERT INTO tzcodes (tz, off_set, description) VALUES
('EEST',10800,'Eastern Europe Summer')'
DBD::Pg::db do failed: ERROR: value too long for type character
varying(127) at bin/install-slashsite line 341.
Failed on 'INSERT INTO vars (name, value, description) VALUES
('backup_db_user','','The virtual user of the database that the code
should use for intensive database access that may bring down the live
site. If you don\'t know what this is for, you should leave it blank.')'
DBD::Pg::db do failed: ERROR: value too long for type character
varying(127) at bin/install-slashsite line 341.
Failed on 'INSERT INTO vars (name, value, description) VALUES
('breaking','100','Establishes the maximum number of comments the
system will display when reading comments from a "live" discussion. For
stories that exceed this number of comments, there will be "page
breaks" printed at the bottom. This setting does not affect "archive"
mode.')'
DBD::Pg::db do failed: ERROR: value too long for type character
varying(127) at bin/install-slashsite line 341.
Failed on 'INSERT INTO vars (name, value, description) VALUES
('m2_modlog_pos', '0', 'Value of ID of last ID processed by a
Meta-Moderator. Basically, this an indicator as to where the next set
of M2 comments will be.')'
DBD::Pg::db do failed: ERROR: value too long for type character
varying(127) at bin/install-slashsite line 341.
Failed on 'INSERT INTO vars (name, value, description) VALUES
('moderatord_lag_threshold','100000','The number of updates replication
must be within before moderatord will run using the replicated handle.
If this threshold isn\'t met, moderatord will not run.')'
DBD::Pg::db do failed: ERROR: value too long for type character
varying(127) at bin/install-slashsite line 341.
Failed on 'INSERT INTO vars (name, value, description) VALUES
('moderatord_debug_info', '1', 'Add in more detailed information into
slashd.log for moderation task info. This WILL increase the size by
slashd.log quite a bit, so use only if you need to.')'
DBD::Pg::db do failed: ERROR: value too long for type character
varying(127) at bin/install-slashsite line 341.
Failed on 'INSERT INTO vars (name, value, description) VALUES
('rootdir','//forums.slashdot.org','Base URL of site; used for creating
on-site links that need protocol-inspecific URL (so site can be used
via HTTP and HTTPS at the same time)')'
DBD::Pg::st execute failed: ERROR: Function last_insert_id() does not
exist at
/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/Slash/DB/Utility.pm
line 280.
Error in
library:Slash::DB::MySQL:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-
netbsd/Slash/DB/MySQL.pm:204:SELECT LAST_INSERT_ID()
Which was called
by:Slash::DB::MySQL:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/
Slash/DB/MySQL.pm:5177:SELECT LAST_INSERT_ID()
====== The preceding three lines are repeated 15 times =========
Error in
library:Slash::DB::Utility:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-
netbsd/Slash/DB/Utility.pm:521:INSERT INTO templates
(template,lang,page,name,section,description,seclev,title) VALUES(
'<TABLE BGCOLOR="[% user.bg.2 %]" BORDER="0" WIDTH="100%"
CELLPADDING="2" CELLSPACING="0">
<TR><TD><FONT SIZE="2">[[% FOR i = items %]
<A HREF="[% i.value %]">[% i.label %]</A>
[% " | " UNLESS loop.last %]
[% END %]]</FONT></TD></TR></TABLE>
',
'en_US',
'menu',
'messages',
'default',
'',
'100
',
'')
Which was called
by:Slash::DB::MySQL:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/
Slash/DB/MySQL.pm:5176:INSERT INTO templates
(template,lang,page,name,section,description,seclev,title) VALUES(
'<TABLE BGCOLOR="[% user.bg.2 %]" BORDER="0" WIDTH="100%"
CELLPADDING="2" CELLSPACING="0">
<TR><TD><FONT SIZE="2">[[% FOR i = items %]
<A HREF="[% i.value %]">[% i.label %]</A>
[% " | " UNLESS loop.last %]
[% END %]]</FONT></TD></TR></TABLE>
',
'en_US',
'menu',
'messages',
'default',
'',
'100
',
'')
DBD::Pg::st execute failed: ERROR: Function last_insert_id() does not
exist at
/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/Slash/DB/Utility.pm
line 280.
Error in
library:Slash::DB::MySQL:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-
netbsd/Slash/DB/MySQL.pm:204:SELECT LAST_INSERT_ID()
Which was called
by:Slash::DB::MySQL:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/
Slash/DB/MySQL.pm:5177:SELECT LAST_INSERT_ID()
====== The preceding three lines are repeated 181 times =========
DBD::Pg::db do failed: ERROR: Relation "spamarmors" does not exist at
/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/Slash/DB/Utility.pm
line 531, <FILE> line 27.
Error in
library:Slash::Install:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-
netbsd/Slash/Install.pm:410:DELETE FROM spamarmors
Which was called by:main:/usr/local/slash/bin/reload_armor:55:DELETE
FROM spamarmors
DBD::Pg::db do failed: ERROR: Relation "spamarmors" does not exist at
/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/Slash/DB/Utility.pm
line 531, <FILE> line 27.
Error in
library:Slash::DB::Utility:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-
netbsd/Slash/DB/Utility.pm:521:INSERT INTO spamarmors
(armor_id,name,code) VALUES(
null,
'Example #1',
's/^(.+?)\134@(.+)$/{$1} {at} {$2}/')
Which was called
by:Slash::Install:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/
Slash/Install.pm:413:INSERT INTO spamarmors (armor_id,name,code) VALUES(
null,
'Example #1',
's/^(.+?)\134@(.+)$/{$1} {at} {$2}/')
DBD::Pg::db do failed: ERROR: Relation "spamarmors" does not exist at
/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/Slash/DB/Utility.pm
line 531, <FILE> line 27.
Error in
library:Slash::DB::Utility:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-
netbsd/Slash/DB/Utility.pm:521:INSERT INTO spamarmors
(armor_id,name,code) VALUES(
null,
'Example #2 - (Reverse of #1)',
's/^(.+?)\134@(.+)$/\134}$1\134{ \134}at\134{ \134}$2\134{/;@a =
split //;$_ = "reversethis-" . scalar reverse @a;')
Which was called
by:Slash::Install:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/
Slash/Install.pm:413:INSERT INTO spamarmors (armor_id,name,code) VALUES(
null,
'Example #2 - (Reverse of #1)',
's/^(.+?)\134@(.+)$/\134}$1\134{ \134}at\134{ \134}$2\134{/;@a =
split //;$_ = "reversethis-" . scalar reverse @a;')
DBD::Pg::db do failed: ERROR: Relation "spamarmors" does not exist at
/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/Slash/DB/Utility.pm
line 531, <FILE> line 27.
Error in
library:Slash::DB::Utility:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-
netbsd/Slash/DB/Utility.pm:521:INSERT INTO spamarmors
(armor_id,name,code) VALUES(
null,
'Example #3',
's/^(.+?)\134@(.+)$/${1}NO\134@SPAM$2/')
Which was called
by:Slash::Install:/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/
Slash/Install.pm:413:INSERT INTO spamarmors (armor_id,name,code) VALUES(
null,
'Example #3',
's/^(.+?)\134@(.+)$/${1}NO\134@SPAM$2/')
DBD::Pg::db do failed: ERROR: parser: parse error at or near "REPLACE"
at character 1 at
/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/Slash/DB/Utility.pm
line 531.
Error in
library:Slash::DB::Static::MySQL:/usr/pkg/lib/perl5/site_perl/5.8.0/
powerpc-netbsd/Slash/DB/Static/MySQL.pm:989:REPLACE INTO authors_cache
SELECT users.uid, nickname, GREATEST(fakeemail, ''), GREATEST(homepage,
''), 0, GREATEST(bio, ''), author FROM users, users_info WHERE
users.author =1 AND users.uid=users_info.uid
Which was called by:main:bin/install-slashsite:426:REPLACE INTO
authors_cache SELECT users.uid, nickname, GREATEST(fakeemail, ''),
GREATEST(homepage, ''), 0, GREATEST(bio, ''), author FROM users,
users_info WHERE users.author =1 AND users.uid=users_info.uid
DBD::Pg::db do failed: ERROR: parser: parse error at or near "REPLACE"
at character 1 at
/usr/pkg/lib/perl5/site_perl/5.8.0/powerpc-netbsd/Slash/DB/Utility.pm
line 531.
Error in
library:Slash::DB::Static::MySQL:/usr/pkg/lib/perl5/site_perl/5.8.0/
powerpc-netbsd/Slash/DB/Static/MySQL.pm:998:REPLACE INTO authors_cache
SELECT users.uid, nickname, GREATEST(fakeemail, ''), GREATEST(homepage,
''), count(stories.uid), GREATEST(bio, ''), author FROM users, stories,
users_info WHERE stories.uid=users.uid AND users.uid=users_info.uid
GROUP BY stories.uid
Which was called by:main:bin/install-slashsite:426:REPLACE INTO
authors_cache SELECT users.uid, nickname, GREATEST(fakeemail, ''),
GREATEST(homepage, ''), count(stories.uid), GREATEST(bio, ''), author
FROM users, stories, users_info WHERE stories.uid=users.uid AND
users.uid=users_info.uid GROUP BY stories.uid
|