bellow i listed my table schemas - this may help.
currently, i'm using postgresql 7.0.2 as my database backend.
all tables and data sets were created as desired.
schemas
-------
turbine=# \dt
List of relations
Name | Type | Owner
----------------+-------+-------
id_table | table | pgsql
jobentry | table | pgsql
permission | table | pgsql
rolepermission | table | pgsql
userrole | table | pgsql
visitor | table | pgsql
visitorrole | table | pgsql
(7 rows)
id_table description
--------------------
turbine=# \d id_table
Table "id_table"
Attribute | Type | Modifier
-------------+--------------+----------
id_table_id | integer | not null
table_name | varchar(255) | not null
next_id | integer |
quantity | integer |
Indices: id_table_id_table_id,
id_table_pkey
id_table content
----------------
turbine=# select * from id_table;
id_table_id | table_name | next_id | quantity
-------------+------------+---------+----------
1 | Permission | 20 | 10
2 | UserRole | 20 | 10
3 | Visitor | 20 | 10
4 | Jobentry | 20 | 10
(4 rows)
jobentry description
--------------------
turbine=# \d jobentry
Table "jobentry"
Attribute | Type | Modifier
--------------+-------------+---------------------
job_id | integer | not null
minute | integer | not null default -1
hour | integer | not null default -1
weekday | integer | not null default -1
day_of_month | integer | not null default -1
task | varchar(99) | not null
email | varchar(99) |
Index: jobentry_pkey
jobentry content
----------------
turbine=# select * from jobentry;
job_id | minute | hour | weekday | day_of_month | task | email
--------+--------+------+---------+--------------+------+-------
(0 rows)
permission description
----------------------
turbine=# \d permission
Table "permission"
Attribute | Type | Modifier
--------------+-------------+---------------------------------------------------------------
permissionid | integer | not null default nextval('permission_permissionid_seq'::text)
permission | varchar(99) | not null
Indices: permission_permission,
permission_pkey
permission content
------------------
turbine=# select * from permission;
permissionid | permission
--------------+-------------------
1 | view_user
2 | add_user
3 | modify_user
4 | view_group
5 | add_group
6 | modify_group
7 | view_permission
8 | add_permission
9 | modify_permission
10 | view_role
11 | add_role
12 | modify_role
(12 rows)
rolepermission description
--------------------------
turbine=# \d rolepermission
Table "rolepermission"
Attribute | Type | Modifier
--------------+---------+----------
roleid | integer | not null
permissionid | integer | not null
Indices: rolepermission_pkey,
rolepermission_roleid_permissio
Note: One index got truncated so this may be a bug in the create
scripts provided with turbine - maybe postgresql only allows names
up to 30 characters?!
rolepermission content
----------------------
turbine=# select * from rolepermission;
roleid | permissionid
--------+--------------
1 | 1
1 | 2
1 | 3
1 | 4
1 | 5
1 | 6
1 | 7
1 | 8
1 | 9
1 | 10
1 | 11
1 | 12
(12 rows)
userrole description
--------------------
turbine=# \d userrole
Table "userrole"
Attribute | Type | Modifier
-----------+-------------+-------------------------------------------------------
roleid | integer | not null default nextval('userrole_roleid_seq'::text)
rolename | varchar(99) | not null
Indices: userrole_pkey,
userrole_rolename
userrole content
----------------
turbine=# select * from userrole;
roleid | rolename
--------+--------------
1 | turbine_root
(1 row)
visitor description
-------------------
turbine=# \d visitor
Table "visitor"
Attribute | Type | Modifier
----------------+--------------+---------------------------------------------------------
visitorid | integer | not null default nextval('visitor_visitorid_seq'::text)
loginid | varchar(32) | not null
password_value | varchar(32) | not null
first_name | varchar(99) | not null
last_name | varchar(99) | not null
address1 | varchar(255) |
address2 | varchar(255) |
city | varchar(255) |
state | varchar(32) |
postalcode | varchar(32) |
country | varchar(99) |
citizenship | varchar(32) |
phone | varchar(32) |
altphone | varchar(32) |
fax | varchar(32) |
cell | varchar(32) |
pager | varchar(32) |
email | varchar(99) |
modified | timestamp |
created | timestamp |
lastlogin | timestamp |
objectdata | oid |
prefix_name | varchar(16) |
middle_name | varchar(99) |
suffix_name | varchar(16) |
company | varchar(255) |
confirm_value | varchar(99) |
Indices: visitor_loginid,
visitor_pkey
Rules: visitor_delete_lo,
objectdata_delete_lo
visitor content
-----------------------
turbine=# select * from visitor;
visitorid | loginid | password_value | first_name | last_name | address1 | address2 | city | state | postalcode | country | citizenship | phone | altphone | fax | cell | pager | email | modified | created | lastlogin | objectdata | prefix_name | middle_name | suffix_name | company | confirm_value
-----------+---------+----------------+------------+-----------+----------+----------+------+-------+------------+---------+-------------+-------+----------+-----+------+-------+--------------------------------+----------+---------------------------+-----------+------------+-------------+-------------+-------------+---------+---------------
2 | haischt | access4odin | Daniel | Haischt | | | | | | | | | | | | | [EMAIL PROTECTED] | | 2000-07-26 06:20:36.47+02 | | | | | | | 6yw7jt7d61
(1 row)
visitorrole description
--------------------------------
turbine=# \d visitorrole
Table "visitorrole"
Attribute | Type | Modifier
-----------+---------+----------
visitorid | integer | not null
roleid | integer | not null
Indices: visitorrole_pkey,
visitorrole_visitorid_roleid_in
visitorrole content
-----------------------------
turbine=# select * from visitorrole;
visitorid | roleid
-----------+--------
(0 rows)
if there are some errors in my schemas, please notify me ;-)
regards
daniel haischt
--
At 09:20 26.07.00 +0200, you wrote:
Hi,-- -------------------------------------------------------------- Please read the FAQ!
We have a similar problem storing this new user's data in our sybase db.
We get an error "VisitorID doesn't accept null values".
The form element in the NewAccount screen doesn't give a value for this
field which is requiered in the DB.
Did you get any results like this ? Did anything arrive in your DB ?
Stefan
-----Original Message-----
From: Diethelm Guallar, Gonzalo [SMTP:[EMAIL PROTECTED]]
Sent: 25 July 2000 22:47
To: 'JetSpeed'
Subject: Create new user in Jetspeed fails
Hello,
I'm trying to create a new user in Jetspeed.
Jetspeed starts up Ok, no error messages in the log
file (other than a few "URL is not available" messages
due to my proxy server). I enter all the information
on the NewAccount page (user, pwd (twice), first and
last name, email), and hit Create New Account, and
nothing happens.
I have set mail.server=mail.sonda.com in TurbineResources,
and have tested that this server works (despite the message
saying "inconsistent address..."):
telnet mail.sonda.com 25
220 sonda.com Server ESMTP ready at Tue, 25 Jul 2000 15:24:54
-0400
helo sonda.com
250-That hostname is inconsistent with your address to name
mapping.
250 sonda.com expected "helo banco108.sonda.com"
mail from:<[EMAIL PROTECTED]>
250 Ok
rcpt to:<[EMAIL PROTECTED]>
250 Ok
data
354 Start mail input; end with <CRLF>.<CRLF>
Subject: test
test1
test2
.
250 Roger
quit
221 sonda.com Out
I end up receiving the test message. With Jetspeed, I never
receive a thing... The log doesn't show anything related
to e-mail. Is there a way to get more output on the log
file? Any hints regarding e-mail handling? Should I even
be creating a new user?
Thanks,
--
Gonzalo A. Diethelm
[EMAIL PROTECTED]
If this mail is in HTML format, blame Exchange Server: Q222508
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
