[OGo-MacOSX] OGo beta can't find Postgres Adaptor Bundle (this one's perplexing)
Tabitha McNerney
macosx@opengroupware.org
Thu, 1 Dec 2005 06:23:22 -1000
------=_Part_36969_8455388.1133454202598
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Hello all,
After successfully configuring, making and installing OGo 1.0 beta 2 rock
several days ago with SOPE 4.5 alpha and PostgreSQL 8.1 (where Postgres was
installed from raw sources in /usr/local following the recommendations of
Marc Liyanage but not using his pre-built pacakge for Postgres 8.0), I
wanted to take the next step and move my entire installation off of my Mac
OS X Server's boot disk. In other words, instead of installing into
/usr/local, I just wanted to put everything on an external volume (a
Firewire disk) that is mounted when my server boots.
I followed my notes very precisely and all of the helpful recommendations
from Helge and others and for some reason when I go to run OGo today, I end
up with the error that the adaptor bundle PostgreSQL can not be found:
macintosh:~ ogo$ /Volumes/vol1/usr/local/OGoRoot/Tools/ogo-webui-1.0 -WOPor=
t
> 20000 -WOHttpAllowHost '("127.0.0.1", localhost)'
> 2005-12-01 15:41:01.560 ogo-webui-1.0[9009] EOAdaptor: cannot find adapto=
r
> bundle: 'PostgreSQL'
> 2005-12-01 15:41:01.560 ogo-webui-1.0[9009] ERROR(-[OGoContextManager
> setupAdaptor]): could not instantiate adaptor for model OGoModel !
> Dec 01 15:41:01 ogo-webui-1.0 [9009]: |ogo-webui-1.0| Could not setup
> OGoContextManager (DB probably not yet configured)!
> Dec 01 15:41:01 ogo-webui-1.0 [9009]: |ogo-webui-1.0| CTI Dialers:
> Dec 01 15:41:01 ogo-webui-1.0 [9009]: |ogo-webui-1.0| OpenGroupware.orgin=
stance initialized.
> Dec 01 15:41:01 ogo-webui-1.0 [9009]: |ogo-webui-1.0| WOHttpAdaptor
> listening on address *:20000
>
For sure, I would think this has to do with the bundle paths in defaults,
but I'm not so sure this time because here's what I've got for my defaults
(thanks to Helge's previous clarification):
macintosh:~ ogo$ defaults read NSGlobalDomain
> {
> LSAttachmentPath =3D "/Volumes/vol1/MachineAgents/ogo/OGoDocs";
> LSConnectionDictionary =3D {
> databaseName =3D ogodb;
> hostName =3D localhost;
> password =3D 12233445;
> port =3D 5433;
> userName =3D ogouser;
> };
> LSNewsImagesPath =3D "/Volumes/vol1/MachineAgents/ogo/OGoNews";
> NGBundlePath =3D
> "/Volumes/vol1/usr/local/OGoRoot/Library/OpenGroupware.org-1.0
> /Commands/:/Volumes/vol1/usr/local/OGoRoot/Library/OpenGroupware.org-1.0
> /DataSources/:/Volumes/vol1/usr/local/OGoRoot/Library/OpenGroupware.org-
> 1.0/WebUI/:/Volumes/vol1/usr/local/OGoRoot/Library/OpenGroupware.org-1.0/=
";
>
> WOHttpAllowHost =3D ("127.0.0.1", localhost, macintosh);
> "skyrix_id" =3D "OGo@macintosh";
> }
>
The bundle paths are complete (not using dollar signs "$") and I double
checked that everything was installed as expected in the paths as follows:
macintosh:/Volumes/vol1/usr/local/OGoRoot/Library/OpenGroupware.org-1.0 ogo=
$
> ls -altr
> total 0
> drwxr-xr-x 4 ogo staff 136 Dec 1 13:38 OGo.model
> drwxr-xr-x 15 ogo staff 510 Dec 1 14:02 Commands
> drwxr-xr-x 11 ogo staff 374 Dec 1 14:02 DataSources
> drwxr-xr-x 32 ogo staff 1088 Dec 1 14:02 WebUI
>
and
macintosh:/Volumes/vol1/usr/local/OGoRoot/Library/OpenGroupware.org-1.0/OG=
o.model/Contents/Resources
> ogo$ ls -altr
> total 584
> -rw-r--r-- 1 ogo staff 1788 Dec 1 14:02 pg-update-schema.psql
> -rw-r--r-- 1 ogo staff 6531 Dec 1 14:02
> pg-build-schema.psql.constraints
> -rw-r--r-- 1 ogo staff 42679 Dec 1 14:02 pg-build-schema.psql
> -rw-r--r-- 1 ogo staff 71 Dec 1 14:02 Version
> -rw-r--r-- 1 ogo staff 235703 Dec 1 14:02
> OpenGroupware.org_PostgreSQL.eomodel
>
>
and
macintosh:/Volumes/vol1/usr/local/OGoRoot/Library/OpenGroupware.org-1.0/Da=
taSources
> ogo$ ls -altr
> total 0
> drwxr-xr-x 3 ogo staff 102 Dec 1 13:39 OGoRawDatabase.ds
> drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 OGoProject.ds
> drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 OGoContacts.ds
> drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 OGoBase.ds
> drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 OGoAccounts.ds
> drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 OGoScheduler.ds
> drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 OGoJobs.ds
> drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 OGoFileSystemProject.ds
> drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 OGoDatabaseProject.ds
>
>
So, what about the PostgreSQL database connection? Well, looking at the
LSConnectionDictionary, I have:
LSConnectionDictionary =3D {
> databaseName =3D ogodb;
> hostName =3D localhost;
> password =3D 12233445;
> port =3D 5433;
> userName =3D ogouser;
> };
>
>
While the database name and user name are not standard as in "OGo" and
"OGo", this doesn't matter because several days ago I had the same settings
for my system when it was running just fine. But to double check, I
connected to the postmaster daemon on port 5433 as the Mac OS X user "ogo"
and the user name "ogouser" and database named "ogodb" just fine, like this=
:
macintosh:~ ogo$ psql -h localhost -p 5433 ogodb ogouser
> Welcome to psql 8.1.0, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> and this shows that I had correctly loaded the schema during my
configuration earlier today:
ogodb=3D> \d
> List of relations
> Schema | Name | Type | Owner
> --------+----------------------------+----------+---------
> public | address | table | ogouser
> public | appointment_resource | table | ogouser
> public | article | table | ogouser
> public | article_category | table | ogouser
> public | article_unit | table | ogouser
> public | company | table | ogouser
> public | company_assignment | table | ogouser
> etc., etc.
>
Could it be that I missed some important step from my earlier notes?
Something really subtle? Is it possible that there might be some hard codin=
g
in OGo to expect PostgreSQL to be installed in /usr/local ? Has anyone trie=
d
with Postgres installed on a mounted volume rather than /usr/local ? I'm
quite sure that all my read/write privileges have been chmod'ed ok (if not
then I wouldn't be able to get to the data base via $ psql -h localhost -p
5433 ogodb ogouser
Is it possible there might be a bug in today's builds? I pulled down both
SOPE 4.5 alpha an OGo 1.0 beta 2 rock out of subversion like this earlier
today (forgive me, I forgot to write down the build numbers):
$ svn co http://svn.opengroupware.org/SOPE/trunk/ SOPE-4.5
$ svn co
http://svn.opengroupware.org/OpenGroupware.org/releases/1.0beta.2-rock/
OGo-1.0b2
Any suggestions are appreciated, and I'd be happy to help debug this
situation if that's what might be required.
Best regards,
Tabitha
P.S. (Separately, I was able to build the module for Apache 2 by
circumventing apxs and I'll post the instructions on the mailing list later
today.)
------=_Part_36969_8455388.1133454202598
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Hello all,<br>
<br>
After successfully configuring, making and installing OGo 1.0 beta 2
rock several days ago with SOPE 4.5 alpha and PostgreSQL 8.1 (where
Postgres was installed from raw sources in /usr/local following the
recommendations of Marc Liyanage but <span style=3D"font-weight: bold;">not=
</span>
using his pre-built pacakge for Postgres 8.0), I wanted to take the
next step and move my entire installation off of my Mac OS X Server's
boot disk. In other words, instead of installing into /usr/local, I
just wanted to put everything on an external volume (a Firewire disk)
that is mounted when my server boots.<br>
<br>
I followed my notes very precisely and all of the helpful
recommendations from Helge and others and for some reason when I go to
run OGo today, I end up with the error that the adaptor bundle
PostgreSQL can not be found:<br>
<br>
<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
0pt 0pt 0.8ex; padding-left: 1ex;" class=3D"gmail_quote"><font size=3D"1">=
macintosh:~ ogo$ /Volumes/vol1/usr/local/OGoRoot/Tools/ogo-webui-1.0 -WOPor=
t 20000 -WOHttpAllowHost '("
<a href=3D"http://127.0.0.1">127.0.0.1</a>", localhost)'<br>
2005-12-01 15:41:01.560 ogo-webui-1.0[9009] EOAdaptor: cannot find adaptor =
bundle: 'PostgreSQL'<br>
2005-12-01 15:41:01.560 ogo-webui-1.0[9009] ERROR(-[OGoContextManager
setupAdaptor]): could not instantiate adaptor for model OGoModel !<br>
Dec 01 15:41:01 ogo-webui-1.0 [9009]: |ogo-webui-1.0| Could not setup OGoCo=
ntextManager (DB probably not yet configured)!<br>
Dec 01 15:41:01 ogo-webui-1.0 [9009]: |ogo-webui-1.0| CTI Dialers: <br>
Dec 01 15:41:01 ogo-webui-1.0 [9009]: |ogo-webui-1.0| OpenGroupware.org ins=
tance initialized.<br>
Dec 01 15:41:01 ogo-webui-1.0 [9009]: |ogo-webui-1.0| WOHttpAdaptor listeni=
ng on address *:20000</font><br>
</blockquote>
<br>
For sure, I would think this has to do with the bundle paths in
defaults, but I'm not so sure this time because here's what I've got
for my defaults (thanks to Helge's previous clarification):<br>
<br>
<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
0pt 0pt 0.8ex; padding-left: 1ex;" class=3D"gmail_quote"><font size=3D"1">=
macintosh:~ ogo$ defaults read NSGlobalDomain =
</font><br>
<font size=3D"1">{</font><br>
<font size=3D"1"> LSAttachmentPath =3D "/Volumes/v=
ol1/MachineAgents/ogo/OGoDocs"; </font><br>
<font size=3D"1"> LSConnectionDictionary =3D {</font><b=
r>
<font size=3D"1"> databaseName =
=3D ogodb; </font><br>
<font size=3D"1"> hostName =3D =
localhost; </font><br>
<font size=3D"1"> password =3D =
12233445; </font><br>
<font size=3D"1"> port =3D 5433=
; </font><br>
<font size=3D"1"> userName =3D =
ogouser; </font><br>
<font size=3D"1"> }; </font><br>
<font size=3D"1"> LSNewsImagesPath =3D "/Volumes/v=
ol1/MachineAgents/ogo/OGoNews"; </font><br>
<font size=3D"1"> NGBundlePath =3D
"/Volumes/vol1/usr/local/OGoRoot/Library/OpenGroupware.org-1.0/Command=
s/:/Volumes/vol1/usr/local/OGoRoot/Library/OpenGroupware.org-1.0/DataSource=
s/:/Volumes/vol1/usr/local/OGoRoot/Library/OpenGroupware.org-1.0/WebUI/:/Vo=
lumes/vol1/usr/local/OGoRoot/Library/OpenGroupware.org-
1.0/";
</font><br>
<font size=3D"1"> WOHttpAllowHost =3D ("<a href=3D=
"http://127.0.0.1">127.0.0.1</a>", localhost, macintosh); </font><br>
<font size=3D"1"> "skyrix_id" =3D "OGo@m=
acintosh"; </font><br>
<font size=3D"1">}</font><br>
</blockquote>
<br>
The bundle paths are complete (not using dollar signs "$") and I =
double
checked that everything was installed as expected in the paths as
follows:<br>
<br>
<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
0pt 0pt 0.8ex; padding-left: 1ex;" class=3D"gmail_quote">macintosh:/Volume=
s/vol1/usr/local/OGoRoot/Library/OpenGroupware.org-1.0 ogo$ ls -altr<br>
total 0<br>
drwxr-xr-x 4 ogo staff 136 Dec 1 =
13:38 OGo.model<br>
drwxr-xr-x 15 ogo staff 510 Dec 1 14:02=
Commands<br>
drwxr-xr-x 11 ogo staff 374 Dec 1 14:02=
DataSources<br>
drwxr-xr-x 32 ogo staff 1088 Dec 1 14:02 WebU=
I<br>
</blockquote>
<br>
and<br>
<br>
<br>
<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
0pt 0pt 0.8ex; padding-left: 1ex;" class=3D"gmail_quote">
<blockquote>macintosh:/Volumes/vol1/usr/local/OGoRoot/Library/OpenGroupwa=
re.org-1.0/OGo.model/Contents/Resources ogo$ ls -altr<br>
total 584<br>
-rw-r--r-- 1 ogo staff 1788 Dec 1=
14:02 pg-update-schema.psql<br>
-rw-r--r-- 1 ogo staff 6531 Dec 1=
14:02 pg-build-schema.psql.constraints<br>
-rw-r--r-- 1 ogo staff 42679 Dec 1 14:0=
2 pg-build-schema.psql<br>
-rw-r--r-- 1 ogo staff 71 D=
ec 1 14:02 Version<br>
-rw-r--r-- 1 ogo staff 235703 Dec 1 14:02 Ope=
nGroupware.org_PostgreSQL.eomodel<br>
</blockquote>
</blockquote>
<br>
and<br>
<br>
<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
0pt 0pt 0.8ex; padding-left: 1ex;" class=3D"gmail_quote">
<blockquote>macintosh:/Volumes/vol1/usr/local/OGoRoot/Library/OpenGroupwa=
re.org-1.0/DataSources ogo$ ls -altr<br>
total 0<br>
drwxr-xr-x 3 ogo staff 102 Dec 1 13:39 =
OGoRawDatabase.ds<br>
drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 =
OGoProject.ds<br>
drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 =
OGoContacts.ds<br>
drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 =
OGoBase.ds<br>
drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 =
OGoAccounts.ds<br>
drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 =
OGoScheduler.ds<br>
drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 =
OGoJobs.ds<br>
drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 =
OGoFileSystemProject.ds<br>
drwxr-xr-x 4 ogo staff 136 Dec 1 14:02 =
OGoDatabaseProject.ds<br>
</blockquote>
</blockquote>
<br>
So, what about the PostgreSQL database connection? Well, looking at the LSC=
onnectionDictionary, I have:<br>
<br>
<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
0pt 0pt 0.8ex; padding-left: 1ex;" class=3D"gmail_quote">
<blockquote> LSConnectionDictionary =3D {<br>
databaseName =3D ogodb; <br>
hostName =3D localhost; <br>
password =3D 12233445; <br>
port =3D 5433; <br>
userName =3D ogouser; <br>
}; <br>
</blockquote>
</blockquote>
<br>
While the database name and user name are not standard as in "OGo"=
; and
"OGo", this doesn't matter because several days ago I had the sam=
e
settings for my system when it was running just fine. But to double
check, I connected to the postmaster daemon on port 5433 as the Mac OS
X user "ogo" and the user name "ogouser" and database n=
amed "ogodb"
just fine, like this:<br>
<br>
<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
0pt 0pt 0.8ex; padding-left: 1ex;" class=3D"gmail_quote">
<blockquote>macintosh:~ ogo$ psql -h localhost -p 5433 ogodb ogouser<br>
Welcome to psql 8.1.0, the PostgreSQL interactive terminal.<br>
<br>
Type: \copyright for distribution terms<br>
\h for help with SQL commands<br>
\? for help with psql commands<br>
\g or terminate with semicolon to exec=
ute query<br>
\q to quit<br>
</blockquote>
</blockquote>
and this shows that I had correctly loaded the schema during my configurati=
on earlier today:<br>
<br>
<br>
<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
0pt 0pt 0.8ex; padding-left: 1ex;" class=3D"gmail_quote">ogodb=3D> \d<b=
r>
&nb=
sp;
List of relations<br>
Schema
|
Name
| Type | Owner <br>
--------+----------------------------+----------+---------<br>
public |
address &n=
bsp;
| table | ogouser<br>
public | appointment_resource | t=
able | ogouser<br>
public |
article &n=
bsp;
| table | ogouser<br>
public | article_category &n=
bsp; | table | ogouser<br>
public |
article_unit &nb=
sp;
| table | ogouser<br>
public |
company &n=
bsp;
| table | ogouser<br>
public | company_assignment =
| table | ogouser<br>
&nb=
sp; etc., etc.<br>
</blockquote>
<br>
Could it be that I missed some important step from my earlier notes?
Something really subtle? Is it possible that there might be some hard
coding in OGo to expect PostgreSQL to be installed in /usr/local ? Has
anyone tried with Postgres installed on a mounted volume rather than
/usr/local ? I'm quite sure that all my read/write privileges have been
chmod'ed ok (if not then I wouldn't be able to get to the data base via
$ psql -h localhost -p 5433 ogodb ogouser<br>
<br>
Is it possible there might be a bug in today's builds? I pulled down
both SOPE 4.5 alpha an OGo 1.0 beta 2 rock out of subversion like this
earlier today (forgive me, I forgot to write down the build numbers):<br>
<br>
$ svn co <a href=3D"http://svn.opengroupware.org/SOPE/trunk/">http://svn.op=
engroupware.org/SOPE/trunk/</a> SOPE-4.5<br>
$ svn co <a href=3D"http://svn.opengroupware.org/OpenGroupware.org/releases=
/1.0beta.2-rock/">http://svn.opengroupware.org/OpenGroupware.org/releases/1=
.0beta.2-rock/</a> OGo-1.0b2<br>
<br>
Any suggestions are appreciated, and I'd be happy to help debug this situat=
ion if that's what might be required.<br>
<br>
Best regards,<br>
<br>
Tabitha<br>
<br>
P.S. (Separately, I was able to build the module for Apache 2 by
circumventing apxs and I'll post the instructions on the mailing list
later today.)<br>
<br>
<br>
------=_Part_36969_8455388.1133454202598--