| Welcome to the Zimbra - Forums! | |
Welcome, if you would like to post a comment please register.
We also encourage you to explore all things Zimbra with our team and members of the community.
|  | 
08-28-2009, 11:17 PM
| | | UNAUTHORIZED ACCESS Totally fouled up install I am running Ubuntu Jaunty, and attempted to install zimbra.
After all the install stuff is done, when I click the desktop icon I get a blank window that says UNAUTHORIZED ACCESS. But it seems the entire installation fails. I installed the 1.0.2 version with no issues, so I am at a loss here. Any help will be appreciated. If you need more info, let me know.
BTW the error in red makes no sense, as I deleted the entire zimbra folder right before trying to install again. Code: daniel@mypos:~$ sh zdesktop_1_0_3_build_1691_linux_i686.sh
Unpacking JRE ...
Preparing JRE ...
Starting Installer ...
Warning: Cannot convert string "-b&h-lucidasans-medium-r-normal-sans-*-140-*-*-p-*-iso8859-1" to type FontStruct
/usr/share/themes/Human/gtk-2.0/gtkrc:51: error: lexical error or unexpected token, expected valid token
ij version 10.3
ij> CONNECT 'jdbc:derby:/home/daniel/zimbra/zdesktop/derby;create=true';
ERROR XJ041: Failed to create database '/home/daniel/zimbra/zdesktop/derby', see the next exception for details.
ERROR XBM0J: Directory /home/daniel/zimbra/zdesktop/derby already exists.
ij> RUN '/home/daniel/zimbra/zdesktop/db/db.sql';
ij> --
-- ***** BEGIN LICENSE BLOCK *****
--
-- Zimbra Collaboration Suite Server
-- Copyright (C) 2007 Zimbra, Inc.
--
-- The contents of this file are subject to the Yahoo! Public License
-- Version 1.0 ("License"); you may not use this file except in
-- compliance with the License. You may obtain a copy of the License at
-- http://www.zimbra.com/license.
--
-- Software distributed under the License is distributed on an "AS IS"
-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied.
--
-- ***** END LICENSE BLOCK *****
--
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '16384');
IJ ERROR: Unable to establish connection
ij> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageCacheSize', '1000');
IJ ERROR: Unable to establish connection
ij> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.logQueryPlan', 'true');
IJ ERROR: Unable to establish connection
ij> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.logStatementText', 'true');
IJ ERROR: Unable to establish connection
ij> CREATE SCHEMA zimbra;
IJ ERROR: Unable to establish connection
ij> SET SCHEMA zimbra;
IJ ERROR: Unable to establish connection
ij> -- -----------------------------------------------------------------------
-- volumes
-- -----------------------------------------------------------------------
-- list of known volumes
CREATE TABLE volume (
id SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
type SMALLINT NOT NULL, -- 1 = primary msg, 2 = secondary msg, 10 = index
name VARCHAR(255) NOT NULL,
path VARCHAR(32672) NOT NULL,
file_bits SMALLINT NOT NULL,
file_group_bits SMALLINT NOT NULL,
mailbox_bits SMALLINT NOT NULL,
mailbox_group_bits SMALLINT NOT NULL,
compress_blobs SMALLINT NOT NULL,
compression_threshold BIGINT NOT NULL,
CONSTRAINT pk_volume PRIMARY KEY (id),
CONSTRAINT ui_volume_name UNIQUE (name),
CONSTRAINT ui_volume_path UNIQUE (path)
);
IJ ERROR: Unable to establish connection
ij> -- This table has only one row. It points to message and index volumes
-- to use for newly provisioned mailboxes.
CREATE TABLE current_volumes (
message_volume_id SMALLINT NOT NULL,
secondary_message_volume_id SMALLINT,
index_volume_id SMALLINT NOT NULL,
next_mailbox_id INTEGER NOT NULL,
CONSTRAINT pk_current_volumes_message_volume_id PRIMARY KEY (message_volume_id),
CONSTRAINT fk_current_volumes_message_volume_id FOREIGN KEY (message_volume_id) REFERENCES volume(id),
CONSTRAINT fk_current_volumes_secondary_message_volume_id FOREIGN KEY (secondary_message_volume_id) REFERENCES volume(id),
CONSTRAINT fk_current_volumes_index_volume_id FOREIGN KEY (index_volume_id) REFERENCES volume(id)
);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_message_volume_id ON current_volumes(message_volume_id);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_secondary_message_volume_id ON current_volumes(secondary_message_volume_id);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_index_volume_id ON current_volumes(index_volume_id);
IJ ERROR: Unable to establish connection
ij> -- -----------------------------------------------------------------------
-- mailbox info
-- -----------------------------------------------------------------------
CREATE TABLE mailbox (
id INTEGER NOT NULL,
group_id INTEGER NOT NULL, -- mailbox group
account_id VARCHAR(127) NOT NULL, -- e.g. "d94e42c4-1636-11d9-b904-4dd689d02402"
index_volume_id SMALLINT NOT NULL,
item_id_checkpoint INTEGER NOT NULL DEFAULT 0,
contact_count INTEGER DEFAULT 0,
size_checkpoint BIGINT NOT NULL DEFAULT 0,
change_checkpoint INTEGER NOT NULL DEFAULT 0,
tracking_sync INTEGER NOT NULL DEFAULT 0,
tracking_imap SMALLINT NOT NULL DEFAULT 0,
last_backup_at INTEGER, -- last full backup time, UNIX-style timestamp
comment VARCHAR(255), -- usually the main email address originally associated with the mailbox
last_soap_access INTEGER NOT NULL DEFAULT 0,
new_messages INTEGER NOT NULL DEFAULT 0,
idx_deferred_count INTEGER NOT NULL DEFAULT 0,
CONSTRAINT pk_mailbox PRIMARY KEY (id),
CONSTRAINT ui_mailbox_account_id UNIQUE (account_id),
CONSTRAINT fk_mailbox_index_volume_id FOREIGN KEY (index_volume_id) REFERENCES volume(id)
);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_mailbox_index_volume_id ON mailbox(index_volume_id);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_last_backup_at ON mailbox(last_backup_at, id);
IJ ERROR: Unable to establish connection
ij> -- -----------------------------------------------------------------------
-- deleted accounts
-- -----------------------------------------------------------------------
CREATE TABLE deleted_account (
email VARCHAR(255) NOT NULL,
account_id VARCHAR(127) NOT NULL,
mailbox_id INTEGER NOT NULL,
deleted_at INTEGER NOT NULL, -- UNIX-style timestamp
CONSTRAINT pk_deleted_account PRIMARY KEY (email)
);
IJ ERROR: Unable to establish connection
ij> -- -----------------------------------------------------------------------
-- mailbox metadata info
-- -----------------------------------------------------------------------
CREATE TABLE mailbox_metadata (
mailbox_id INTEGER NOT NULL,
section VARCHAR(64) NOT NULL, -- e.g. "imap"
metadata CLOB,
CONSTRAINT pk_metadata PRIMARY KEY (mailbox_id, section),
CONSTRAINT fk_metadata_mailbox_id FOREIGN KEY (mailbox_id) REFERENCES mailbox(id) ON DELETE CASCADE
);
IJ ERROR: Unable to establish connection
ij> -- -----------------------------------------------------------------------
-- out-of-office reply history
-- -----------------------------------------------------------------------
CREATE TABLE out_of_office (
mailbox_id INTEGER NOT NULL,
sent_to VARCHAR(255) NOT NULL,
sent_on TIMESTAMP NOT NULL,
CONSTRAINT pk_out_of_office PRIMARY KEY (mailbox_id, sent_to),
CONSTRAINT fk_out_of_office_mailbox_id FOREIGN KEY (mailbox_id) REFERENCES mailbox(id) ON DELETE CASCADE
);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_out_of_office_sent_on ON out_of_office(sent_on);
IJ ERROR: Unable to establish connection
ij> -- -----------------------------------------------------------------------
-- etc.
-- -----------------------------------------------------------------------
-- table for global config params
CREATE TABLE config (
name VARCHAR(255) NOT NULL,
value CLOB,
description CLOB,
modified TIMESTAMP,
CONSTRAINT pk_config PRIMARY KEY (name)
);
IJ ERROR: Unable to establish connection
ij> -- Tracks scheduled tasks
CREATE TABLE scheduled_task (
class_name VARCHAR(255) NOT NULL,
name VARCHAR(255) NOT NULL,
mailbox_id INTEGER NOT NULL,
exec_time TIMESTAMP,
interval_millis INTEGER,
metadata CLOB,
CONSTRAINT pk_scheduled_task PRIMARY KEY (name, mailbox_id, class_name),
CONSTRAINT fk_st_mailbox_id FOREIGN KEY (mailbox_id)
REFERENCES mailbox(id) ON DELETE CASCADE
);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_scheduled_task_mailbox_id ON scheduled_task(mailbox_id);
IJ ERROR: Unable to establish connection
ij> RUN '/home/daniel/zimbra/zdesktop/db/directory.sql';
ij> --
-- ***** BEGIN LICENSE BLOCK *****
--
-- Zimbra Collaboration Suite Server
-- Copyright (C) 2007 Zimbra, Inc.
--
-- The contents of this file are subject to the Yahoo! Public License
-- Version 1.0 ("License"); you may not use this file except in
-- compliance with the License. You may obtain a copy of the License at
-- http://www.zimbra.com/license.
--
-- Software distributed under the License is distributed on an "AS IS"
-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied.
--
-- ***** END LICENSE BLOCK *****
--
-- -----------------------------------------------------------------------
-- directory
-- -----------------------------------------------------------------------
CREATE TABLE directory (
entry_id INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY,
entry_type CHAR(4) NOT NULL,
entry_name VARCHAR(128) NOT NULL,
zimbra_id CHAR(36),
modified SMALLINT NOT NULL,
CONSTRAINT pk_directory PRIMARY KEY (entry_id),
CONSTRAINT ui_directory_entry_type_name UNIQUE(entry_type, entry_name)
);
IJ ERROR: Unable to establish connection
ij> CREATE UNIQUE INDEX ui_directory_zimbra_id ON directory(zimbra_id);
IJ ERROR: Unable to establish connection
ij> CREATE TABLE directory_attrs (
entry_id INTEGER NOT NULL,
name VARCHAR(255) NOT NULL,
value VARCHAR(32672) NOT NULL,
CONSTRAINT fk_dattr_entry_id FOREIGN KEY (entry_id) REFERENCES directory(entry_id)
ON DELETE CASCADE
);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_dattr_entry_id_name ON directory_attrs(entry_id, name);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_dattr_name ON directory_attrs(name);
IJ ERROR: Unable to establish connection
ij> CREATE TABLE directory_leaf (
entry_id INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY,
parent_id INTEGER NOT NULL,
entry_type CHAR(4) NOT NULL,
entry_name VARCHAR(128) NOT NULL,
zimbra_id CHAR(36) NOT NULL,
CONSTRAINT pk_dleaf PRIMARY KEY (entry_id),
CONSTRAINT ui_dleaf_zimbra_id UNIQUE (zimbra_id),
CONSTRAINT ui_dleaf_parent_entry_type_name UNIQUE (parent_id, entry_type, entry_name),
CONSTRAINT fk_dleaf_entry_id FOREIGN KEY (parent_id) REFERENCES directory(entry_id)
ON DELETE CASCADE
);
IJ ERROR: Unable to establish connection
ij> CREATE TABLE directory_leaf_attrs (
entry_id INTEGER NOT NULL,
name VARCHAR(255) NOT NULL,
value VARCHAR(32672) NOT NULL,
CONSTRAINT fk_dleafattr_entry_id FOREIGN KEY (entry_id) REFERENCES directory_leaf(entry_id)
ON DELETE CASCADE
);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_dleafattr_entry_id_name ON directory_leaf_attrs(entry_id, name);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_dleafattr_name ON directory_leaf_attrs(name);
IJ ERROR: Unable to establish connection
ij> CREATE TABLE directory_granter (
granter_name VARCHAR(128) NOT NULL,
granter_id CHAR(36) NOT NULL,
grantee_id CHAR(36) NOT NULL,
CONSTRAINT pk_dgranter PRIMARY KEY (granter_name, grantee_id)
);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_dgranter_gter_name ON directory_granter(granter_name);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_dgranter_gter_id ON directory_granter(granter_id);
IJ ERROR: Unable to establish connection
ij> CREATE INDEX i_dgranter_gtee_id ON directory_granter(grantee_id);
IJ ERROR: Unable to establish connection
ij> RUN '/home/daniel/zimbra/zdesktop/db/versions-init.sql';
ij> -- AUTO-GENERATED .SQL FILE - Generated by the Derby versions tool
INSERT INTO zimbra.config(name, value, description) VALUES
('db.version', '53', 'db schema version'),
('index.version', '2', 'index version'),
('redolog.version', '1.24', 'redolog version'),
('offline.db.version', '3', 'offline db schema version');
IJ ERROR: Unable to establish connection
ij> INSERT INTO volume (id, type, name, path, file_bits, file_group_bits,
mailbox_bits, mailbox_group_bits, compress_blobs, compression_threshold)
VALUES (1, 1, 'message1', '/home/daniel/zimbra/zdesktop/store', 12, 8, 12, 8, 0, 4096);
IJ ERROR: Unable to establish connection
ij> INSERT INTO volume (id, type, name, path, file_bits, file_group_bits,
mailbox_bits, mailbox_group_bits, compress_blobs, compression_threshold)
VALUES (2, 10, 'index1', '/home/daniel/zimbra/zdesktop/index', 12, 8, 12, 8, 0, 4096);
IJ ERROR: Unable to establish connection
ij> INSERT INTO current_volumes (message_volume_id, index_volume_id, next_mailbox_id) VALUES (1, 2, 1);
IJ ERROR: Unable to establish connection
ij> EXIT; | | Thread Tools | | | | Display Modes | Linear Mode | | Why Join? Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.  |