Install OpenSuse Build Dated 26 Jun on Centos5 with Yum: Table ctags missing in schema

[Marc Schaefer-5]

Hello list,
I just subscribed to ask for a solution to a problem that I managed to
clear myself. I think other people will stumble over it so I'm posting
to preserve the info for others:

SETUP:

Centos 5.3 Base install with Gnome Desktop

Added following repository:

[server_OpenGroupware]
name=OpenGroupware.Org Groupware Server & Collaberation Platform (CentOS_5)
type=rpm-md
baseurl=http://download.opensuse.org/repositories/server:/OpenGroupware/CentOS_5/
gpgcheck=1
gpgkey=http://download.opensuse.org/repositories/server:/OpenGroupware/CentOS_5/repodata/repomd.xml.key
enabled=1



INSTALL:

yum install ogo-meta-5.5-8.2 ogo-database-setup-1.1-14.2
Everthing installs nice an the server is up and running.
Browsing http://localhost/OpenGroupware works fine


PROBLEM:

Changing the password leads to a "Check Password" Error which links to
following line in the logs:

name:   PostgreSQL72FatalError  reason: fatal pgsql error
(channel=<0x0x9cb52c4[PostgreSQL72Channel]:
connection=<0x0x9cb54ac[PGConnection]:  connection=0x0x9cb5ce0>>):
ERROR:  relation "ctags" does not exist



SOLUTION:
The Suse Build is from the 26-Jun
I found
http://mail.opengroupware.org/pipermail/developer/2009-June/003812.html
which was already checked in before 26 Jun.

Apparently the schema files

/usr/lib/opengroupware.org-5.5/commands/OGo.model/Resources/pg-build-schema.psql
/usr/share/opengroupware.org-1.1/dbsetup/PostgreSQL/pg-build-schema.psql

were not updated to represent this change and are missing the ctags table.


So just add it:

CREATE TABLE ctags (
  entity VARCHAR NOT NULL,
  ctag  INTEGER NOT NULL DEFAULT 0
);

INSERT INTO ctags (entity) VALUES ('Person');
INSERT INTO ctags (entity) VALUES ('Enterprise');
INSERT INTO ctags (entity) VALUES ('Date');
INSERT INTO ctags (entity) VALUES ('Job');
INSERT INTO ctags (entity) VALUES ('Team');


Hope that my description is clear enough and helps others.
Should I open a bug somewhere or post to developper list?

Have fun Marc



--
OpenGroupware.org Users
users@...
http://mail.opengroupware.org/mailman/listinfo/users

[Adam Tauno Williams-2]

On Fri, 2009-09-04 at 13:14 +0200, Marc Schaefer wrote:

> Hello list,
> I just subscribed to ask for a solution to a problem that I managed to
> clear myself. I think other people will stumble over it so I'm posting
> to preserve the info for others:
> SETUP:
> Centos 5.3 Base install with Gnome Desktop
> Added following repository:
> [server_OpenGroupware]
> name=OpenGroupware.Org Groupware Server & Collaberation Platform (CentOS_5)
> type=rpm-md
> baseurl=http://download.opensuse.org/repositories/server:/OpenGroupware/CentOS_5/
> gpgcheck=1
> gpgkey=http://download.opensuse.org/repositories/server:/OpenGroupware/CentOS_5/repodata/repomd.xml.key
> enabled=1
> INSTALL:
> yum install ogo-meta-5.5-8.2 ogo-database-setup-1.1-14.2
> Everthing installs nice an the server is up and running.
> Browsing http://localhost/OpenGroupware works fine
> PROBLEM:
> Changing the password leads to a "Check Password" Error which links to
> following line in the logs:
> name:   PostgreSQL72FatalError  reason: fatal pgsql error
> (channel=<0x0x9cb52c4[PostgreSQL72Channel]:
> connection=<0x0x9cb54ac[PGConnection]:  connection=0x0x9cb5ce0>>):
> ERROR:  relation "ctags" does not exist
> SOLUTION:
> The Suse Build is from the 26-Jun
> I found
> http://mail.opengroupware.org/pipermail/developer/2009-June/003812.html
> which was already checked in before 26 Jun.
> Apparently the schema files
> /usr/lib/opengroupware.org-5.5/commands/OGo.model/Resources/pg-build-schema.psql
> /usr/share/opengroupware.org-1.1/dbsetup/PostgreSQL/pg-build-schema.psql
> were not updated to represent this change and are missing the ctags table.
> So just add it:
> CREATE TABLE ctags (
>   entity VARCHAR NOT NULL,
>   ctag  INTEGER NOT NULL DEFAULT 0
> );
> INSERT INTO ctags (entity) VALUES ('Person');
> INSERT INTO ctags (entity) VALUES ('Enterprise');
> INSERT INTO ctags (entity) VALUES ('Date');
> INSERT INTO ctags (entity) VALUES ('Job');
> INSERT INTO ctags (entity) VALUES ('Team');
> Hope that my description is clear enough and helps others.
> Should I open a bug somewhere or post to developper list?

That change may be insufficient; see
<http://whitemiceconsulting.blogspot.com/2009/07/database-changes-to-opengroupware-v55.html> which was also a post to this list.  If you use the v5.5 (trunk) packages I'd advise you to stay subscribed to this list or watch my BLOG as there may be additional DB changes.  

The code repository contains a DB upgrade script.
<http://svn.opengroupware.org/OpenGroupware.org/trunk/Database/PostgreSQL/pg-update-1.x-to-5.5.psql>

--
OpenGroupware.org Users
users@...
http://mail.opengroupware.org/mailman/listinfo/users