On Mar 8, 2005, at 1:53 PM, Daniel Chamberland-Tremblay wrote:
> Hello all,
>
> My friend and I are trying to setup a slash site on spatial news (gis,
> remote sensing and all). I managed to get slashcode somewhat running
> but am missing lots of functionalities. I would surely appreciate any
> hits that could stir us in the right direction. I provide some
> information about the system and the errors, but I realise that it may
> not be complete (I did not exactly know what was needed).
>
> I followed instruction from the "Debian Slash Installation" webpage
> and from the INSTALL.debian and INSTALL of Slash installation. I have
> installed PERL modules form cpan and cross-checked manually that all
> the modules/bundles within Bundle::Slash were installed correctly.
>
> Here is information about my set up :
> - Debian stable with apache and libapache-mod-perl
> - Slashcode version R41
> - site is implemented with simlink
> - The site main page is up with partial functionnality, I am able to
> browse the pages referenced on the main page and get the images of the
> site. I am able to login with the admin account created during
> installation.
>
>
> Here is a description of some of the problems I encountered:
> - I cannot create new users. I get the message:
> "Maximum Login Forms Exceeded
>
> You've reached your maximum number of login forms you can submit: 4
> forms over 4 hours.
>
> Chances are, you're behind a firewall or proxy, or clicked the Back
> button to accidentally reuse a form. Please try again. If the problem
> persists, and all other options have been tried, contact the site
> administrator."
> I am able to login with the administrator id and passwd, though. I
> tried different user names but none appeared in the DB (I checked the
> users table manually).
>
> - Some buttons work, other don't:
> I was able to create a submission with the administrator account, but
> not to accept it after preview.
>
> I include some snips of the access log and error log. The admin.pl
> error message has got us worried :
> - Access log
> 192.168.2.1 - - [06/Mar/2005:18:43:35 +0000] "GET /images/gr.gif
> HTTP/1.1" 304 -
> 192.168.2.1 - - [06/Mar/2005:18:43:35 +0000] "GET /images/660000.gif
> HTTP/1.1" 304 -
> 192.168.2.1 - - [06/Mar/2005:18:43:35 +0000] "GET
> /images/wr_cccccc.gif HTTP/1.1" 304 -
> 192.168.2.1 - - [06/Mar/2005:18:43:35 +0000] "GET /images/sdlogo.gif
> HTTP/1.1" 304 -
> 192.168.2.1 - - [06/Mar/2005:18:43:36 +0000] "GET /images/rssicon.gif
> HTTP/1.1" 304 -
> 192.168.2.1 - - [06/Mar/2005:18:43:36 +0000] "GET
> /images/slashlogo.gif HTTP/1.1" 304 -
> 192.168.2.1 - - [06/Mar/2005:18:43:36 +0000] "GET /favicon.ico
> HTTP/1.1" 404 12822
> 192.168.2.1 - - [06/Mar/2005:18:43:40 +0000] "GET
> /admin.pl?op=edit&sid=00/01/25/1430236 HTTP/1.1" 200 22832
> 192.168.2.1 - - [06/Mar/2005:18:43:41 +0000] "GET
> /admin-topic-popup.css HTTP/1.1" 404 12832
> 192.168.2.1 - - [06/Mar/2005:18:43:42 +0000] "GET
> /admin-topic-popup.js HTTP/1.1" 404 12831
>
> - Error log
> [Sun Mar 6 18:42:58 2005] [error] [client 192.168.2.1] File does not
> exist: /usr/local/slash/site/192.168.2.2/htdocs/admin-topic-popup.css
> [Sun Mar 6 18:42:59 2005] [error] [client 192.168.2.1] File does not
> exist: /usr/local/slash/site/192.168.2.2/htdocs/admin-topic-popup.js
> [Sun Mar 6 18:43:01 2005] [error] [client 192.168.2.1] File does not
> exist: /usr/local/slash/site/192.168.2.2/htdocs/favicon.ico
> [Sun Mar 6 18:43:29 2005] [error] [client 192.168.2.1] File does not
> exist: /usr/local/slash/site/192.168.2.2/htdocs/favicon.ico
> [Sun Mar 6 18:43:36 2005] [error] [client 192.168.2.1] File does not
> exist: /usr/local/slash/site/192.168.2.2/htdocs/favicon.ico
> [Sun Mar 6 18:43:39 2005] [error]
> /admin.pl:Slash::DB::MySQL:/usr/local/lib/perl/5.6.1/Slash/DB/
> MySQL.pm:9814:DB='myvirtualuser' -- hostinfo='Localhost via UNIX
> socket' -- Table 'mydatabase.uncommonstorywords' doesn't exist --
> SELECT word FROM uncommonstorywords
> [Sun Mar 6 18:43:39 2005] [error] Which was called
> by:Slash::DB::MySQL:/usr/local/lib/perl/5.6.1/Slash/DB/MySQL.pm:9841:
> DB='myvirtualuser' -- hostinfo='Localhost via UNIX socket' -- Table
> 'mydatabase.uncommonstorywords' doesn't exist -- SELECT word FROM
> uncommonstorywords
> [Sun Mar 6 18:43:41 2005] [error] [client 192.168.2.1] File does not
> exist: /usr/local/slash/site/192.168.2.2/htdocs/admin-topic-popup.css
> [Sun Mar 6 18:43:41 2005] [error] [client 192.168.2.1] File does not
> exist: /usr/local/slash/site/192.168.2.2/htdocs/admin-topic-popup.js
>
> We would appreciate any help on knowing if we've made the right choice
> in taking R41 (it seemed to solve some security issues as seen on
> slashcode), why there are files that do not exist on the site (were
> not created during installation?), what is this uncommonstorywords
> problem and any other pertinent information to get our site running
> quickly.
> [...]
For "Maximum Login Forms Exceeded" is the slashd daemon running? That
daemon is what would periodically run all your tasks, one of which will
clear out old formkeys. (see runtask -h for more info). See
http://slash.lottadot.com/faqster.pl?op=view&faqid=1 for a possible
better explanation of tasks and such in regard to Slash itself.
Personally, I always use latest-CVS. But that's just me. Maybe I love
pain ;)
Use symlink-tool to show what files are in your themes and plugins, but
are not installed in your site. It will also try and fix any it finds
missing. See -h cmdline option for help.
For 'uncommonstorywords' I would look through
/{slashsrc}/themes/slashcode/*.sql
and
/{slashsrc/sql/mysql/upgrades
ie:
coolio:~ shane$ cd /usr/local/src/slash/slash.new/sql/mysql/
coolio:/usr/local/src/slash/slash.new/sql/mysql shane$ grep
"uncommonstorywords" upgrades
INSERT INTO vars (name, value, description) VALUES
('uncommonstorywords', '', 'Uncommon words found in recent stories');
INSERT INTO vars (name, value, description) VALUES
('uncommonstorywords_maxlen', '65000', 'Maximum length of the uncommon
words list');
DROP TABLE IF EXISTS uncommonstorywords;
CREATE TABLE uncommonstorywords (
# perl -MSlash::Test=virtusername -e '@usw = split / /,
$constants->{uncommonstorywords}; for $w (@usw) {
$slashdb->sqlInsert("uncommonstorywords", { word => $w }) }'
DELETE FROM vars WHERE name='uncommonstorywords';
From that upgrades file, per the above's location within that file, you
should be able to tell what CVS-Rtag the table was created at. It may
be that R41, which you've said you're using, should have had the schema
in place in either the slashcode theme or
/{slashsrc}/sql/mysql/slashschema_create.sql
I just did a fresh install on a Fedora Core3 machine this past week,
using cvs-head from a few weeks ago. I don't see that table in my
schema for this installation either.
So I cvs updated'd it, and I'm looking through the schema files and I
don't see anything for table.uncommonstorywords. Maybe it's coming from
a plugin that I don't have installed, but I don't think so.
From what I can see, this is a bug. I just filed a bug report for it on
http://sourceforge.net/tracker/?group_id=4421&atid=104421
We'll see what happens.
Shane
--
http://shane.lottadot.com/
|