romain75 Posté(e) le 21 février 2010 Posté(e) le 21 février 2010 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; ?> 0 Citer
Patrick21 Posté(e) le 21 février 2010 Posté(e) le 21 février 2010 Bonjour c'est normal, l'utilisateur par defaut c'est "root" sans mdp la 1ere fois ps: tu as bien install 0 Citer
romain75 Posté(e) le 21 février 2010 Auteur Posté(e) le 21 février 2010 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 0 Citer
Patrick21 Posté(e) le 21 février 2010 Posté(e) le 21 février 2010 escuses j'etais hors sujet, j'etais sur phpMyAdmin d 0 Citer
PatrickH Posté(e) le 21 février 2010 Posté(e) le 21 février 2010 Il y a bien Postgresql d'install 0 Citer
romain75 Posté(e) le 27 février 2010 Auteur Posté(e) le 27 février 2010 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"); } ?> 0 Citer
romain75 Posté(e) le 27 février 2010 Auteur Posté(e) le 27 février 2010 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) 0 Citer
romain75 Posté(e) le 27 février 2010 Auteur Posté(e) le 27 février 2010 Liste des bases de donn 0 Citer
romain75 Posté(e) le 4 mars 2010 Auteur Posté(e) le 4 mars 2010 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 0 Citer
Messages recommandés
Rejoindre la conversation
Vous pouvez publier maintenant et vous inscrire plus tard. Si vous avez un compte, connectez-vous maintenant pour publier avec votre compte.