FUDforum: FUDforum Installation Issues » Postgres: Intstalling in non-public schema?

Home » FUDforum » FUDforum Installation Issues » Postgres: Intstalling in non-public schema?

Show: Today's Messages :: Polls :: Message Navigator

Re: Postgres: Intstalling in non-public schema? [message #36075 is a reply to message #35999]

Fri, 02 March 2007 17:33

Drezil

Messages: 7
Registered: February 2007

Karma:

Junior Member

time went on .. and i hacked a bit for myself.

i changed the installer.
now you are explicitly asked to which schema the forum should be installed. if you leave it blank the default (public) schema is used - so its keeps being compatible with all other dbs (sqlite, mysql).

i also changed all sql-templates according to that. mostly they look like:
CREATE TABLE {SQL_SCHEMA}{SQL_TABLE_PREFIX} *blah*

according to that some php-files needed to be changed and a new global var $DBHOST_SCHEMA was introduced (and written by the installer script).

all works fine. even table creation and stuff so i think its nearly bug-free and could be added to the cvs.

the changes are huge. the modified installer is appended. the other stuff can be downloaded here.

installation instruction (until its included in the default installer):
1. download files as normally
2. open install.php in your browser and set file-permissions accordingly (if asked)
3. enter data on the first page & press next.
4. STOP before going to step 2!
5. extract the hacked files and overwrite them in your non-web-dir (default: /var/FUDforum/)
6. overwrite the install.php with the appended version.
7. refresh your browser. a new field "schema" should appear
8. continue installation as normal.
9. you're done.

Note: i got a minor problem. maybe its somewhere in the archive .. i can't figure it out ..
i got a typo. open your index.php and search for $DBHOST['DBHOST_SCHEMA'] and change it to $GLOBALS['DBHOST_SCHEMA']
maybe this is fixed, maybe not. i don't know due to the dynamic generation of the index.php.

NOTE (IMPORTANT!):
due to the circumstance that the admin-interface is coded in another way you havt to replace all occourences of
"$DBHOST_TBL_PREFIX" with "$DBHOST_SCHEMA.$DBHOST_TBL_PREFIX"
and
"$GLOBALS['DBHOST_TBL_PREFIX']" with "$GLOBALS['DBHOST_SCHEMA'].$GLOBALS['DBHOST_TBL_PREFIX']".

DISCLAIMER: Like always: NO WARRENTY Wink

Attachment: install.php
(Size: 47.32KB, Downloaded 1096 times)

[Updated on: Fri, 02 March 2007 18:29]

Report message to a moderator

[Message index]

		Postgres: Intstalling in non-public schema? By: Drezil on Tue, 27 February 2007 14:54
		Re: Postgres: Intstalling in non-public schema? By: Ilia on Wed, 28 February 2007 01:05
		Re: Postgres: Intstalling in non-public schema? By: Drezil on Wed, 28 February 2007 09:49
		Re: Postgres: Intstalling in non-public schema? By: Drezil on Wed, 28 February 2007 11:04
		Re: Postgres: Intstalling in non-public schema? By: Ilia on Thu, 01 March 2007 00:05
		Re: Postgres: Intstalling in non-public schema? By: Drezil on Thu, 01 March 2007 00:17
		Re: Postgres: Intstalling in non-public schema? By: Drezil on Fri, 02 March 2007 17:33
		Re: Postgres: Intstalling in non-public schema? By: Ilia on Sun, 04 March 2007 17:55
		Re: Postgres: Intstalling in non-public schema? By: Drezil on Sun, 04 March 2007 22:54

Previous Topic:	Two more issues...
Next Topic:	Upgrade Errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 11:20:37 GMT 2024

Total time taken to generate the page: 0.04762 seconds