#75 1.2.2: Installation problem: blank page (pgsql)

[jeff mckenna]

OK common problem, but I see no answers out there. So
here we go...my setup (i'm using postgresql as the
back-end):

linux redhat 9
postgresql 7.4
php433 with pgsql enabled
phpwiki 1.2.2
apache2

When i first loaded the index.php page I saw some
"LOADFILE..." messages...and my 'public.wiki' table in
the 'wiki' database contains 20 records of phpwiki
pages now...however the index.php page is totally blank
now in the browser. So postgresql and php and
definitely talking, so that is not an issue....however
i am not sure why i cannot see anything now???? Is it
a table permissions issue? The apache user 'nobody'
does not have permissions to access the table in pg
maybe???

Does anyone have a link to a doc explaining this?

What kind of permissions do i need to set on the 'wiki'
database in postgresql????

I'm not giving up on this, i'm so damn close.

jeff

[jeff mckenna]

Logged In: YES
user_id=996055

also:

When i list the tables in the 'wiki' database I get the
following:

       List of relations

Schema | Name | Type | Owner
--------+-----------+-------+----------
public | archive | table | postgres
public | hitcount | table | postgres
public | hottopics | table | postgres
public | wiki | table | postgres
public | wikilinks | table | postgres
public | wikiscore | table | postgres

When i list the users for these tables I get:

  List of database users

User name | User ID | Attributes
-----------+---------+------------
(0 rows)

Is this my problem? no table users?

[jeff mckenna]

Logged In: YES
user_id=996055

for the heck of it i re-ran the following:

psql wiki -f schemas/schema.psql

and all tables were created and permissions granted. Then i
went to the browser and viewed index.php 'for the first
time' and the following was displayed in the browser:

/home/CAAP/phpwiki-1.2.2/pgsrc/Inserting page AddingPages,
version 1 from text file
Inserting page ConvertSpacesToTabs, version 1 from text file
Inserting page EditText, version 1 from text file
Inserting page FindPage, version 1 from text file
Inserting page FrontPage, version 1 from text file
Inserting page GoodStyle, version 1 from text file
Inserting page HowToUseWiki, version 1 from text file
Inserting page MoreAboutMechanics, version 1 from text file
Inserting page MostPopular, version 1 from text file
Inserting page PhpWiki, version 1 from text file
Inserting page PhpWikiAdministration, version 1 from text file
Inserting page RecentChanges, version 1 from text file
Inserting page RecentVisitors, version 1 from text file
Inserting page ReleaseNotes, version 1 from text file
Inserting page SandBox, version 1 from text file
Inserting page SteveWainstead, version 1 from text file
Inserting page TestPage, version 1 from text file
Inserting page TextFormattingRules, version 1 from text file
Inserting page WabiSabi, version 1 from text file
Inserting page WikiWikiWeb, version 1 from text file

then i refreshed the browser and STILL A BLANK PAGE!!!!!

please someone help me. thanks.

jeff

[jeff mckenna]

Logged In: YES
user_id=996055

an update:

This blank page problem was that I had 'register_globals=ON'
in my php.ini. Good lord. A friend noticed that. This
'should' be mentioned in the INSTALL readme file. However
now I get the 'FrontPage' page appearing correctly in my
browser, but none of the links do anything. If I click on
'AddingPages' the page is submitted quickly and returns
'FrontPage' again..same for all links. The URL that
AddingPages is trying to load is:

http://134.117.194.150/caap/wiki/?AddingPages

I can see AddingPages in the postgresql database....but why
do none for the links do anything?

I have a soft link of 'wiki' set to ~/phpwiki-1.2.2/ and
in /lib/config.php i have:

$ScriptUrl = "http://134.117.194.150/caap/wiki/";

anyone see anything wrong????

txs.

jeff

[jeff mckenna]

Logged In: YES
user_id=996055

well another update:

I set $QUERY_STRING = getenv('QUERY_STRING'); in
display.php. Another user mentioned php not recognizing
QUERY_STRING any more as a global.....this should also be
mentioned in the INSTALL readme. now another problem (if
anyone at all is reading this):

when i click on'EditText' link the FrontPage is always shown
and it does not go into 'edit mode'.....the page URL
displayed looks right
(http://134.117.194.150/caap/wiki/?edit=RecentVisitors) and
the QUERY_STRING is right (edit=RecentVisitors)..???

anyone got an idea? seems like i'm hitting all the typical
(and not documented) errors.

jeff

[Nobody/Anonymous]

Logged In: NO

Try this:

Q. After configuration, I load up the index page and all I
get is a document that contains no data. What's up?
Try un-commenting this line in index.php:
define('COMPRESS_OUTPUT', false);

Martin

[Nobody/Anonymous]

Logged In: NO

Try this:

Q. After configuration, I load up the index page and all I
get is a document that contains no data. What's up?
Try un-commenting this line in index.php:
define('COMPRESS_OUTPUT', false);

Martin

[Reini Urban]

Logged In: YES
user_id=13755

Sorry, we cannot do support on postgres permission problems.
esp. for 1.2.x.
Please see the postgres docs, how to get select and update
user permissions for your database.