[ewiki] Re: ewiki - postgreSQL

thanks Andy now it is working...


______________________________________________________________
> Od: andy@xxxxxxxxxxx
> Komu: <ewiki@xxxxxxxxxxxxx>
> CC: 
> Datum: 15.05.2006 16:59
> Předmět: [ewiki] Re: ewiki - postgreSQL
>
> Hmm, next would be does the table get created? 
> 
> > -----Original Message-----
> > From: ewiki-bounce@xxxxxxxxxxxxx 
> > [mailto:ewiki-bounce@xxxxxxxxxxxxx] On Behalf Of luxana@xxxxxxxxxx
> > Sent: Thursday, May 11, 2006 11:11 PM
> > To: ewiki@xxxxxxxxxxxxx
> > Subject: [ewiki] Re: ewiki - postgreSQL
> > 
> > 
> > Hi Andy,
> > 
> > Yep, the user has write access to database, after all it is 
> > postgres user so there should not be any problem with 
> > permitions. I really have no idea what is going on and what I 
> > should try next. Any other ideas? 
> > 
> > thank you
> > 
> > 
> > 
> > ______________________________________________________________
> > > Od: andy@xxxxxxxxxxx
> > > Komu: 
> > > CC: 
> > > Datum: 09.05.2006 16:39
> > > Předmět: [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
> > > > 
> > > > > > 
> > > > /*
> > > >   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: