[ewiki] Re: ewiki - postgreSQL
- From: "Andy Fundinger" <andy@xxxxxxxxxxx>
- To: <ewiki@xxxxxxxxxxxxx>
- Date: Fri, 19 May 2006 09:39:42 -0400
Good, puzzling over your next glitch.
________________________________
From: ewiki-bounce@xxxxxxxxxxxxx [mailto:ewiki-bounce@xxxxxxxxxxxxx] On
Behalf Of luxana@xxxxxxxxxx
Sent: Thursday, May 18, 2006 11:28 PM
To: ewiki@xxxxxxxxxxxxx
Subject: [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="")
> > > > && 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") &&
> > > > 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 & 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: