Phppgadmin Configuration

[romain75]

Bonjour j'ai un problème de configuration avec mon phppgadmin, je n'arrive pas à me connecter avec l'utilisateur Admin.

<?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 au Maudit';


	// Hostname or IP address for server.  Use '' for UNIX domain socket.

	// use 'localhost' for TCP/IP connection on this computer

	$conf['servers'][0]['host'] = 'localhost';


	// 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'] = 'disable';


	// 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'] = 'photo';


	// 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'] = '/usr/syno/pgsql/bin/pg_dump';

	$conf['servers'][0]['pg_dumpall_path'] = '/usr/syno/pgsql/bin/pg_dumpall';


	// 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/syno/pgsql/share';


	// 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';


	// 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'] = false;


	// 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. 7.3 )

	$conf['help_base'] = 'http://www.postgresql.org/docs/%s/interactive/';


	/*****************************************

 	* Don't modify anything below this line *

 	*****************************************/


	$conf['version'] = 19;


?>

[Patrick21]

Bonjour

c'est normal, l'utilisateur par defaut c'est "root" sans mdp la 1ere fois

ps: tu as bien install

[romain75]

Re,

je n'ai pas installé le paquet syno mais PHPPGADMIN depuis les sources sourceforge.

J'ai bien l'interface de connexion mais pas moyen de se connecter même avec root et sans mot de passe.

Romain

Bonjour

c'est normal, l'utilisateur par defaut c'est "root" sans mdp la 1ere fois

ps: tu as bien installé le paquet syno ?, n'oublie pas de renommer le dossier par defaut

Patrick

[Patrick21]

escuses j'etais hors sujet, j'etais sur phpMyAdmin

d

[PatrickH]

Il y a bien Postgresql d'install

[romain75]

Il y a bien Postgresql d'installé sur le syno (en particulier pour PhotoStation) parcontre je ne connais pas du tout le mot de passe pour cette base de donnée (ni le login à utiliser admin ou root ou autre...)

Patrick

/usr/syno/synoman/phpsrc/photo/include/database.php

<?php

$username = "admin";

$dbname = "photo";

$conn_string = "dbname=".$dbname." user=".$username;


if (!isset($GLOBALS['dbconn_photo']) || $GLOBALS['dbconn_photo'] == null) {

	$GLOBALS['dbconn_photo'] = pg_connect($conn_string) or die("Failed to connect");

}


$dbname = "mediaserver";

$conn_string = "dbname=".$dbname." user=".$username;


if (!isset($GLOBALS['dbconn_media']) || $GLOBALS['dbconn_media'] == null) {

	$GLOBALS['dbconn_media'] = pg_connect($conn_string) or die("Failed to connect");

}

?>

[romain75]

Pour se connecter à postgresql.

Il faut tout d'abord se connecter en admin et à une base de données connue.

/usr/syno/pgsql/bin/psql -d photo

ou

/usr/syno/pgsql/bin/psql -d mediacenter

Liste des tables :

SELECT c.relname FROM pg_class c INNER JOIN pg_namespace n ON (c.relnamespace = n.oid);

relname                    

-----------------------------------------------

 sql_sizing

 pg_toast_10563

 pg_toast_10563_index

 sql_sizing_profiles

 table_constraints

 table_privileges

 tables

 triggered_update_columns

 triggers

 usage_privileges

 view_column_usage

 view_routine_usage

 view_table_usage

 views

 data_type_privileges

 element_types

 role_table_grants

 role_usage_grants

 routine_privileges

 routines

 schemata

 sequences

 pg_toast_10533

 pg_toast_10533_index

 sql_features

 pg_toast_10538

 pg_toast_10538_index

 pg_toast_2604

 pg_toast_2604_index

 pg_toast_2606

 pg_toast_2606_index

 pg_toast_2609

 pg_toast_2609_index

 pg_toast_1255

 pg_toast_1255_index

 pg_toast_2618

 pg_toast_2618_index

 pg_toast_2619

 pg_toast_2619_index

 pg_toast_1260

 pg_toast_1260_index

 pg_toast_1262

 pg_toast_1262_index

 pg_toast_2396

 pg_toast_2396_index

 pg_aggregate_fnoid_index

 pg_am_name_index

 pg_am_oid_index

 pg_amop_opc_strat_index

 pg_amop_opr_opc_index

 pg_amproc_opc_proc_index

 pg_attrdef_adrelid_adnum_index

 pg_attrdef_oid_index

 pg_attribute_relid_attnam_index

 pg_attribute_relid_attnum_index

 pg_authid_rolname_index

 pg_authid_oid_index

 pg_auth_members_role_member_index

 pg_auth_members_member_role_index

 pg_autovacuum_vacrelid_index

 pg_cast_oid_index

 pg_cast_source_target_index

 pg_class_oid_index

 pg_class_relname_nsp_index

 pg_constraint_conname_nsp_index

 pg_constraint_conrelid_index

 pg_constraint_contypid_index

 pg_constraint_oid_index

 pg_conversion_default_index

 pg_conversion_name_nsp_index

 pg_conversion_oid_index

 pg_database_datname_index

 pg_database_oid_index

 pg_depend_depender_index

 pg_depend_reference_index

 pg_description_o_c_o_index

 pg_shdescription_o_c_index

 pg_index_indrelid_index

 pg_index_indexrelid_index

 pg_inherits_relid_seqno_index

 pg_language_name_index

 pg_language_oid_index

 pg_largeobject_loid_pn_index

 pg_namespace_nspname_index

 pg_namespace_oid_index

 pg_opclass_am_name_nsp_index

 pg_opclass_oid_index

 pg_operator_oid_index

 pg_operator_oprname_l_r_n_index

 pg_pltemplate_name_index

 pg_proc_oid_index

 pg_proc_proname_args_nsp_index

 pg_rewrite_oid_index

 pg_rewrite_rel_rulename_index

 pg_shdepend_depender_index

 pg_shdepend_reference_index

 pg_statistic_relid_att_index

 pg_tablespace_oid_index

 pg_tablespace_spcname_index

 pg_trigger_tgconstrname_index

 pg_trigger_tgconstrrelid_index

 pg_trigger_tgrelid_tgname_index

 pg_trigger_oid_index

 pg_type_oid_index

 pg_type_typname_nsp_index

 sql_implementation_info

 pg_toast_10543

 pg_toast_10543_index

 pg_authid

 sql_languages

 pg_toast_10548

 pg_toast_10548_index

 sql_packages

 pg_shadow

 pg_toast_10553

 pg_toast_10553_index

 sql_parts

 pg_toast_10558

 pg_toast_10558_index

 column_domain_usage

 column_privileges

 column_udt_usage

 columns 

 constraint_column_usage

 constraint_table_usage

 domain_constraints

 domain_udt_usage

 domains 

 pg_statistic

 enabled_roles

 key_column_usage

 parameters

 referential_constraints

 role_column_grants

 pg_settings

 role_routine_grants

 pg_cursors

 pg_prepared_xacts

 pg_prepared_statements

 pg_timezone_abbrevs

 pg_timezone_names

 pg_stat_all_tables

 pg_stat_sys_tables

 pg_stat_user_tables

 pg_statio_all_tables

 pg_statio_sys_tables

 pg_statio_user_tables

 pg_stat_all_indexes

 pg_stat_sys_indexes

 pg_stat_user_indexes

 pg_statio_all_indexes

 pg_statio_sys_indexes

 pg_statio_user_indexes

 pg_statio_all_sequences

 pg_statio_sys_sequences

 pg_statio_user_sequences

 pg_stat_activity

 pg_stat_database

 information_schema_catalog_name

 applicable_roles

 administrable_role_authorizations

 attributes

 check_constraint_routine_usage

 check_constraints

 pg_type 

 pg_attribute

 pg_proc 

 pg_class

 pg_autovacuum

 pg_attrdef

 pg_constraint

 pg_inherits

 pg_toast_16477

 photo_user_pkey

 photo_user_username_key

 pg_toast_16477_index

 pg_toast_16853_index

 blog_config

 photo_access_right

 blog_config_config_id_seq

 pg_index

 pg_operator

 pg_opclass

 pg_am   

 pg_amop 

 pg_amproc

 pg_language

 pg_largeobject

 pg_aggregate

 pg_rewrite

 pg_trigger

 pg_listener

 pg_description

 pg_cast 

 pg_namespace

 pg_conversion

 pg_depend

 pg_tablespace

 pg_pltemplate

 pg_shdepend

 pg_shdescription

 pg_database

 pg_auth_members

 pg_roles

 pg_group

 pg_user 

 pg_rules

 pg_views

 pg_tables

 pg_indexes

 pg_stats

 pg_locks

 pg_toast_16860

 pg_toast_16860_index

 blog_label

 pg_toast_16822

 pg_toast_16822_index

 photo_log_pkey

 blog_article

 photo_access_right_pkey

 blog_article_article_id_seq

 blog_article_autosave

 blog_article_autosave_article_autosave_id_seq

 blog_label_label_id_seq

 blog_module

 photo_comment

 pg_toast_16839

 photo_config

 photo_image_id_seq

 pg_toast_16839_index

 pg_toast_16500

 pg_toast_16500_index

 blog_article_label

 photo_pkey

 photo_image_path_key

 photo_comment_id_seq

 blog_article_label_article_label_id_seq

 pg_toast_16513

 pg_toast_16513_index

 blog_article_autosave_pkey

 photo_comment_pkey

 pg_toast_16846

 blog_comment_pkey

 pg_toast_16846_index

 blog_article_label_pkey

 video_comment_id_seq

 blog_comment

 pg_toast_16528

 pg_toast_16528_index

 blog_config_pkey

 video_comment_pkey

 video_desc_id_seq

 blog_comment_comment_id_seq

 pg_toast_16538

 pg_toast_16538_index

 blog_label_label_name_key

 video_pkey

 video_path_key

 photo_comment_photoid_index

 blog_article_pkey

 pg_toast_16853

 blog_label_pkey

 blog_module_pkey

 photo_config_config_id_seq

 photo_image

 pg_toast_16895

 pg_toast_16895_index

 photo_config_pkey

 photo_log

 photo_share

 photo_user

 video_comment

 video_desc

 pg_toast_16915

 pg_toast_16915_index

 photo_share_pkey

 photo_share_sharename_key

(277 rows)

[romain75]

Liste des bases de donn

[romain75]

A ce que j'en ai compris il n'y a pas de mot de passe pour l'utilisateur admin de la base de donn