[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: <ewiki@xxxxxxxxxxxxx>
> 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: