[ewiki] Re: ewiki - postgreSQL

Really looks ok, does your database user have rights to create tables?  
Initialize needs them temporarily to setup. 

> -----Original Message-----
> From: ewiki-bounce@xxxxxxxxxxxxx 
> [mailto:ewiki-bounce@xxxxxxxxxxxxx] On Behalf Of luxana@xxxxxxxxxx
> Sent: Friday, May 05, 2006 12:39 AM
> To: ewiki@xxxxxxxxxxxxx
> Subject: [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: