[ewiki] Re: ewiki - postgreSQL

Hello 



First thanks for replay,Andy, Larry, Thomas. Here is some new update in my 
progress:

part of config file:

if (function_exists("pg_connect")) {
include("plugins/db/any.php");
$ok = anydb_connect('127.0.0.1', 'postgres', 'password', 'ewiki_database', 
'pgsql') ; 
}

if ($ok) {

echo "CONNECTED";

}


if (!$ok) {
 define("EWIKI_DBFILES_DIRECTORY", "/tmp");
   include_once("plugins/db/flat_files.php");
}


I get message that database is connected also I can see that in log file:

2006-05-05 11:21:46 [5379] LOG:  connection received: host=127.0.0.1 port=33430
2006-05-05 11:21:47 [5379] LOG:  connection authorized: user=postgres 
database=e wiki_database


/var/log/postgresql$ psql -l
           List of databases
      Name      |  Owner   | Encoding
----------------+----------+-----------
 ewiki_database | postgres | LATIN1
 template0      | postgres | LATIN1
 template1      | postgres | LATIN1



then when I click on "[InitializeWikiDatabase]" I get into EditThisPage 
'FrontPage'. So I can not get it initialize. The init-pages/ directory is in 
correct place because when I try to use only flat files everything seems to be 
fine.

I must be doing something wrong.

can anyone please have a look on my config what basics I'm missing there? Thank 
you

<?php  chdir(dirname(__FILE__));

/*
  This EXAMPLARY config script just opens the database connection
  and loads a few extensions plugins and the core lib (ewiki.php).
  There is no need to keep it, or to stuck with the format used
  herein.
  You could as well put all the include() and define() statements
  into your own Wiki wrapper script (index.php) instead.
*/


#-- open mysql database connection if available,
#   or load the flat file database backend as fallback
#
/*if (function_exists("mysql_connect")) {
   $ok = @mysql_connect("localhost", "root", $password="")
         &amp;&amp; mysql_query("USE test");
}

*/





#-- only loaded if it exists
@include_once("local/config.php");

#-- predefine some of the configuration constants
define("EWIKI_LIST_LIMIT", 25);
define("EWIKI_HTML_CHARS", 1);
@define("EWIKI_PRINT_TITLE", 1);
 // define("EWIKI_SCRIPT", "?id=");
 // define("EWIKI_SCRIPT_URL", "http://www.example.com/wiki/index.php/";);
 // ...
 // setlocale(LC_TIME, "nl");
   #
   # Note: constants in PHP can be defined() just once, so defining them
   # here makes sense, the settings won't get overridden by the defaults
   # in "ewiki.php" - you should likewise copy other settings from there
   # to here, if you wish to change some of them


#-- helper scripts for broken/outdated PHP configurations
include_once("plugins/lib/fix.php");
include_once("plugins/lib/upgrade.php");


#-- load plugins, before core script
 include_once("plugins/init.php");            # you can disable this later
 include_once("plugins/page/README.php");     # this too
# include_once("plugins/pluginloader.php");
 include_once("plugins/email_protect.php");
 include_once("plugins/page/powersearch.php");
 include_once("plugins/page/pageindex.php");
# include_once("plugins/page/wordindex.php");
# include_once("plugins/page/aboutplugins.php");
# include_once("plugins/page/imagegallery.php");
# include_once("plugins/page/orphanedpages.php");
# include_once("plugins/spages.php") &amp;&amp; ewiki_spages_init("tools/");
# include_once("plugins/filter/search_highlight.php");
# include_once("plugins/appearance/fancy_list_dict.php");
# include_once("plugins/patchsaving.php");
# include_once("plugins/action/diff.php");
# include_once("plugins/action/like_pages.php");
# include_once("plugins/jump.php");
 include_once("plugins/notify.php");
 include_once("plugins/feature/imgresize_gd.php");
# include_once("plugins/feature/imgresize_magick.php");
# include_once("plugins/module/calendar.php");
# include_once("plugins/appearance/title_calendar.php");
# include_once("plugins/module/downloads.php");
# include_once("plugins/aview/downloads.php");
 include_once("plugins/markup/css.php");
# include_once("plugins/markup/paragraphs.php");
# include_once("plugins/markup/footnotes.php");
# include_once("plugins/markup/rescuehtml.php");
# include_once("plugins/interwiki/intermap.php");
# include_once("plugins/linking/link_css.php");
# include_once("plugins/linking/link_icons.php");
# include_once("plugins/linking/link_target_blank.php");
# include_once("plugins/mpi/mpi.php");
# include_once("plugins/aview/linktree.php");
# include_once("plugins/aview/backlinks.php");
# include_once("plugins/filter/fun_wella.php");
# include_once("plugins/filter/fun_upsidedown.php");
# include_once("plugins/filter/fun_chef.php");
# include_once("plugins/page/textupload.php");
# include_once("plugins/auth/auth_perm_ring.php");
# include_once("plugins/userdb_registry.php");
# include_once("plugins/auth/auth_method_http.php");
# include_once("plugins/db/binary_store.php");
# ...
if (function_exists("pg_connect")) {
include("DB.php"); 
include("plugins/db/any.php");
$ok = anydb_connect('127.0.0.1', 'postgres', 'password', 'ewiki_database', 
'pgsql') ;
//function anydb_connect($host="localhost", $user="", $pw="", $dbname="test", 
$dbtype="mysql") 
}

if ($ok) {

echo "CONNECTED";

}


if (!$ok) {
 define("EWIKI_DBFILES_DIRECTORY", "/tmp");
   include_once("plugins/db/flat_files.php");
}

#-- and finally load the core library
include_once("ewiki.php");


?> 

Thank You
______________________________________________________________
> Od: larry@xxxxxxxxxx
> Komu: ewiki@xxxxxxxxxxxxx
> CC: 
> Datum: 02.05.2006 18:42
> Předmět: [ewiki] Re: ewiki - postgreSQL
>
> I's not very apparent in the documentation but you need to run the config
> utility: t_setupwiz.php (it is in the tools subfolder) it will create your
> config.php file and set up the any db connect command for postgres
> support. I had another glitch with postgres (might have been needing to
> add the schema name in the any dbconnect call...).
> 
> That's all I can recall, I went back to MySQL, Postgres was just too
> frustrating.,
> 
> Good luck!
> Larry Anderson
> 
> 
> On May 2, 2006, at 8:48 AM, Andy Fundinger wrote:
> 
> > I just scanned back and didn't see a reply to this, you're on the right
> > track with anydb, but I've not used it with Postgres myself. As for >
> the
> > Admin password, you can create an admin account in or define() the
> > EWIKI_ADMIN_PW constant to set one. Without either of those you won't
> > have access to the admin tools.
> >
> > - Andy
> >
> >> -----Original Message-----
> >> From: ewiki-bounce@xxxxxxxxxxxxx
> >> [mailto:ewiki-bounce@xxxxxxxxxxxxx] On Behalf Of luxana@xxxxxxxxxx
> >> Sent: Sunday, April 30, 2006 10:39 PM
> >> To: ewiki@xxxxxxxxxxxxx
> >> Subject: [ewiki] ewiki - postgreSQL
> >>
> >> Hello ewiki users &amp; developers,
> >>
> >> I'm trying to migrate from PHPwiki to erfurtwiki and having
> >> some difficulties along the way so I believe that this is the
> >> correct place where I can get some of my questions answered.
> >>
> >> 1) I did research on google but could not find any documents
> >> which will help me to install ewiki with postgresql database.
> >> Is there any startup config.php file which I can use?
> >>
> >> 2)I did managed to connect to database but that is all what I
> >> was able to do. When I try to edit homepage I get error:
> >>
> >>>> Warning: dbx: module 'mysql' not loaded. in
> >>>> /var/www/ewiki-R1.02b/plugins/db/any.php on line 339
> >>
> >> You don't have any pages in your Wiki yet, so we should try
> >> to read-in the default ones from init-pages/ now.
> >>
> >> DatabaseBackend _anydb (looks ok) WikiSoftware ewiki R1.02b
> >>
> >> [InitializeWikiDatabase] button just open edit text window.
> >>
> >> when click to initialize and I still do not have any
> >> relations in my database.
> >>
> >> 3) does the administrator password gets set during initialization?
> >>
> >>
> >> thank you
> >>
> >>
> >>
> >>
> >>
> >
> >
> 
> 
>

Other related posts: