Hi all,
I've been looking on how to set up a mart on kubuntu linux 8.04. After
some problems (to which answers mostly was found with google like path
of axsp2 and so forth) I have it now up and running on a test setup.
There is though few questions that I have with regards to martview and
using marteditor to set it up.
1. Numbers in filters. I have some columns in database that uses
numbers. I would like to allow users to add filters like '>170'. How
should I do this? And is it possible to allow a range of values like
'150-170' or something like this?
2. The documentation suggests changing qualifier from '=' to '>', but it
neglects to tell me why or what alternatives there are. Any
documentation on that?
3. I would like to restrict some filters to different values. There was
column regexp, but no documentation on it. After browsing web I decided
to try it. And it seems that it does it. While this allows me to define
a text field into integers (\d+) or float for that matter ('[\d.]+'
should work), I'm wondering if there is a better way to restrict only to
range of numbers (like 0 - 100).
Note that with regex '\d+' in column, the martview website allows me to
write '>150' to that column, but result is not valid to more than 150 on
the column which I specified.
One problem that I encountered that I wasn't able to find answer from
web directly was problem that my apache killed itself immediately after
starting. I'll put the workaround for that here (in case someone else
hits this as well). It died with following in log
[Tue Jul 01 14:46:02 2008] [alert] getpwuid: couldn't determine user
name from uid 4294967295, you probably need to modify the User directive
[Tue Jul 01 14:46:02 2008] [notice] Apache/2.2.8 (Ubuntu) mod_perl/2.0.3
Perl/v5.8.8 configured -- resuming normal operations
[Tue Jul 01 14:46:02 2008] [alert] Child 3693 returned a Fatal error...
Apache is exiting!
I tried to run it with sudo or as root. Eventually I figured that it
tried to resolve unix user above from '/etc/passwd', which obviously
will fail. So adding following row to httpd.conf fixed this
User www-data
www-data is user defined in system (at least on kubuntu and most likely
on ubuntu).
Regards,
--
Henrikki Almusa
