Error Getting Domain Accounts

[smcelroy]

Hello,

I have a problem with jscape reading user and group information from a postgresql database. I have created a database using the schema below and configured jscape to use this for logging, user and group data. I can create users and groups successfully, but when I start the Jscape Secure FTP Server Manager I get a dialog box with the message 'Error Getting Domain Accounts'.

Can anyone tell me why this is happening? I think it may be something to do with the database schema using the text type and not blob's but postgresql handles blob's in a peculiar manner.

Thanks,

Sean


/**
* Table structure for table "accounts"
**/
DROP TABLE IF EXISTS "accounts";
CREATE TABLE "accounts" (
login character varying(255) NOT NULL,
data text NOT NULL
);
ALTER TABLE "accounts"
ADD CONSTRAINT accounts_pk PRIMARY KEY(LOGIN);


/**
* Table structure for table "groups"
**/
DROP TABLE IF EXISTS "groups";
CREATE TABLE "groups" (
name character varying(255) NOT NULL,
data text NOT NULL
);
ALTER TABLE "groups"
ADD CONSTRAINT groups_pk PRIMARY KEY(NAME);

/*
* Table structure for table "log"
**/
DROP TABLE IF EXISTS "log";
CREATE TABLE "log" (
id bigserial NOT NULL,
record_date timestamp NOT NULL,
server_ip character varying(255) NOT NULL,
server_port integer,
client_ip character varying(255) NOT NULL,
client_port integer,
username character varying(255) NOT NULL,
client_request character varying(1024) NOT NULL,
client_message character varying(1024) NOT NULL,
server_status character varying(1024) NOT NULL,
server_message character varying(1024) NOT NULL,
inbound_bytes integer,
outbound_bytes integer
);

ALTER TABLE "log"
ADD CONSTRAINT log_pk PRIMARY KEY(ID);

[vglass]

Hi,

For both the groups and accounts tables the data field should be a blob as JSCAPE Secure FTP Server is expected to store/read binary data in this field.

[smcelroy]

Thanks. Postgresql doesn't have a blob type, but I got around this by using the bytea type.