Partage
  • Partager sur Facebook
  • Partager sur Twitter

Installation de PostgreSQL sur EasyPHP

Sujet résolu
    27 mai 2011 à 21:03:17

    Edit : Problème résolu, phpPgAdmin est disponible à l'adresse suivante : http://127.0.0.1:8888/home/mysql/

    Bonsoir,

    Je tente désespérément d'installer PostgreSQL sur EasyPHP grâce à ce tuto : http://www.siteduzero.com/tutoriel-3-1 [...] mpserver.html

    J'utilise les logicielles suivant :
    • Postgre SQL 9.0.4-1 32 bits
    • EasyPHP 5.3.6.0
    • phpPgAdmin 5.0.2

    Pour accéder à mon serveur web, je dois rentrer l'url : http://127.0.0.1:8888
    Si je n'ajoute pas le port 8888 je n'arrive pas à accéder au serveur...

    Voici la configuration du serveur web :

    config.inc.php
    <?php
    
    	/**
    	 * Central phpPgAdmin configuration.  As a user you may modify the
    	 * settings here for your particular configuration.
    	 *
    	 * $Id: config.inc.php-dist,v 1.55 2008/02/18 21:10:31 xzilla Exp $
    	 */
    
    	// An example server.  Create as many of these as you wish,
    	// indexed from zero upwards.
    
    	// Display name for the server on the login screen
    	$conf['servers'][0]['desc'] = 'PostgreSQL';
    
    	// Hostname or IP address for server.  Use '' for UNIX domain socket.
    	// use 'localhost' for TCP/IP connection on this computer
    	$conf['servers'][0]['host'] = '127.0.0.1';
    
    	// Database port on server (5432 is the PostgreSQL default)
    	$conf['servers'][0]['port'] = 5432;
    
    	// Database SSL mode
    	// Possible options: disable, allow, prefer, require
    	// To require SSL on older servers use option: legacy
    	// To ignore the SSL mode, use option: unspecified
    	$conf['servers'][0]['sslmode'] = 'allow';
    
    	// Change the default database only if you cannot connect to template1.
    	// For a PostgreSQL 8.1+ server, you can set this to 'postgres'.
    	$conf['servers'][0]['defaultdb'] = 'template1';
    
    	// Specify the path to the database dump utilities for this server.
    	// You can set these to '' if no dumper is available.
    	$conf['servers'][0]['pg_dump_path'] = 'e:\\PostgreSQL\\9.0\\bin\\pg_dump.exe';
    	$conf['servers'][0]['pg_dumpall_path'] = 'e:\\PostgreSQL\\9.0\\bin\\pg_dumpall.exe';
    
    	// Slony (www.slony.info) support?
    	$conf['servers'][0]['slony_support'] = false;
    	// Specify the path to the Slony SQL scripts (where slony1_base.sql is located, etc.)
    	// No trailing slash.
    	$conf['servers'][0]['slony_sql'] = '/usr/share/pgsql';
    
    	// Example for a second server (PostgreSQL for Windows)
    	//$conf['servers'][1]['desc'] = 'Test Server';
    	//$conf['servers'][1]['host'] = '127.0.0.1';
    	//$conf['servers'][1]['port'] = 5432;
    	//$conf['servers'][1]['sslmode'] = 'allow';
    	//$conf['servers'][1]['defaultdb'] = 'template1';
    	//$conf['servers'][1]['pg_dump_path'] = 'C:\\Program Files\\PostgreSQL\\8.0\\bin\\pg_dump.exe';
    	//$conf['servers'][1]['pg_dumpall_path'] = 'C:\\Program Files\\PostgreSQL\\8.0\\bin\\pg_dumpall.exe';
    	//$conf['servers'][1]['slony_support'] = false;
    	//$conf['servers'][1]['slony_sql'] = 'C:\\Program Files\\PostgreSQL\\8.0\\share';
    	
    	
    	// Example of groups definition.
    	// Groups allow administrators to logicaly group servers together under group nodes in the left browser tree
    	//
    	// The group '0' description
    	//$conf['srv_groups'][0]['desc'] = 'group one';
    	//
    	// Add here servers indexes belonging to the group '0' seperated by comma
    	//$conf['srv_groups'][0]['servers'] = '0,1,2'; 
    	//
    	// A server can belong to multi groups
    	//$conf['srv_groups'][1]['desc'] = 'group two';
    	//$conf['srv_groups'][1]['servers'] = '3,1';
    	
    
    	// Default language. E.g.: 'english', 'polish', etc.  See lang/ directory
    	// for all possibilities. If you specify 'auto' (the default) it will use 
    	// your browser preference.
    	$conf['default_lang'] = 'auto';
    
    	// AutoComplete uses AJAX interaction to list foreign key values 
    	// on insert fields. It currently only works on single column 
    	// foreign keys. You can choose one of the following values:
    	// 'default on' enables AutoComplete and turns it on by default.
    	// 'default off' enables AutoComplete but turns it off by default.
    	// 'disable' disables AutoComplete.
    	$conf['autocomplete'] = 'default on';
    	
    	// If extra login security is true, then logins via phpPgAdmin with no
    	// password or certain usernames (pgsql, postgres, root, administrator)
    	// will be denied. Only set this false once you have read the FAQ and
    	// understand how to change PostgreSQL's pg_hba.conf to enable
    	// passworded local connections.
    	$conf['extra_login_security'] = false;
    
    	// Only show owned databases?
    	// Note: This will simply hide other databases in the list - this does
    	// not in any way prevent your users from seeing other database by
    	// other means. (e.g. Run 'SELECT * FROM pg_database' in the SQL area.)
    	$conf['owned_only'] = false;
    
    	// Display comments on objects?  Comments are a good way of documenting
    	// a database, but they do take up space in the interface.
    	$conf['show_comments'] = true;
    
    	// Display "advanced" objects? Setting this to true will show 
    	// aggregates, types, operators, operator classes, conversions, 
    	// languages and casts in phpPgAdmin. These objects are rarely 
    	// administered and can clutter the interface.
    	$conf['show_advanced'] = false;
    
    	// Display "system" objects?
    	$conf['show_system'] = false;
    
    	// Display reports feature?  For this feature to work, you must
    	// install the reports database as explained in the INSTALL file.
    	$conf['show_reports'] = true;
    
    	// Database and table for reports
    	$conf['reports_db'] = 'phppgadmin';
    	$conf['reports_schema'] = 'public';
    	$conf['reports_table'] = 'ppa_reports';
    
    	// Only show owned reports?
    	// Note: This does not prevent people from accessing other reports by
    	// other means.
    	$conf['owned_reports_only'] = false;
    
    	// Minimum length users can set their password to.
    	$conf['min_password_length'] = 1;
    
    	// Width of the left frame in pixels (object browser)
    	$conf['left_width'] = 200;
    	
    	// Which look & feel theme to use
    	$conf['theme'] = 'default';
    	
    	// Show OIDs when browsing tables?
    	$conf['show_oids'] = false;
    	
    	// Max rows to show on a page when browsing record sets
    	$conf['max_rows'] = 30;
    
    	// Max chars of each field to display by default in browse mode
    	$conf['max_chars'] = 50;
    
    	// Send XHTML strict headers?
    	$conf['use_xhtml_strict'] = false;
    
    	// Base URL for PostgreSQL documentation.
    	// '%s', if present, will be replaced with the PostgreSQL version
    	// (e.g. 8.4 )
    	$conf['help_base'] = 'http://www.postgresql.org/docs/%s/interactive/';
    	
    	// Configuration for ajax scripts
    	// Time in seconds. If set to 0, refreshing data using ajax will be disabled (locks and activity pages)
    	$conf['ajax_refresh'] = 3;
    	
    	/*****************************************
    	 * Don't modify anything below this line *
    	 *****************************************/
    
    	$conf['version'] = 19;
    
    ?>
    


    httpd.conf
    Alias /home/pgsql "${path}/phppgadmin"
    
    <Directory "${path}/phppgadmin">
            Options FollowSymLinks Indexes
            AllowOverride None
            Order deny,allow
            allow from 127.0.0.1
            deny from all
    </Directory>


    php.ini
    extension=php_pgsql.dll


    C'est à la verification du bon fonctionnement de phpPgAdmin que je suis bloqué. J'ai essayé plusieurs url :

    http://127.0.0.1:8888/home/phppgadmin/
    http://127.0.0.1:8888/home/pgsql/

    A chaque fois je tombe sur le même message d'erreur :

    Citation


    Objet non trouvé!

    L'URL requise n'a pu etre trouvée sur ce serveur. Si vous avez tapé l'URL à la main, veuillez vérifier l'orthographe et réessayer.

    Si vous pensez qu'il s'agit d'une erreur du serveur, veuillez contacter le gestionnaire du site.
    Error 404
    127.0.0.1
    05/27/11 21:01:00
    Apache/2.2.17 (Win32) PHP/5.3.6



    Merci de m'aider. ;)

    Edit : Problème résolu, phpPgAdmin est disponible à l'adresse suivante : http://127.0.0.1:8888/home/mysql/
    • Partager sur Facebook
    • Partager sur Twitter

    Installation de PostgreSQL sur EasyPHP

    × Après avoir cliqué sur "Répondre" vous serez invité à vous connecter pour que votre message soit publié.
    × Attention, ce sujet est très ancien. Le déterrer n'est pas forcément approprié. Nous te conseillons de créer un nouveau sujet pour poser ta question.
    • Editeur
    • Markdown