Différences
Ci-dessous, les différences entre deux révisions de la page.
| Les deux révisions précédentes Révision précédente Prochaine révision | Révision précédente | ||
|
actions:oracle [2015/04/02 09:20] catherine.balleydier@grenoble-inp.fr |
actions:oracle [2015/04/02 09:36] (Version actuelle) catherine.balleydier@grenoble-inp.fr [Packages perl] |
||
|---|---|---|---|
| Ligne 103: | Ligne 103: | ||
| ==== Bug sympa avec oracle ==== | ==== Bug sympa avec oracle ==== | ||
| - | err SQLSource::connect() No Database Driver installed for Oracle ; you should download and install DBD::Oracle from CPAN\\ | + | err SQLSource::connect() No Database Driver installed for Oracle ; you should download and install DBD::Oracle from CPAN |
| - | Apr 1 09:43:28 acacia wwsympa[1999]: err List::_load_users_include2() Inclusion include_sql_query failed in list | + | err List::_load_users_include2() Inclusion include_sql_query failed in list |
| http://www.sympa.org/faq/database#errors_when_trying_to_load_dbdoracle | http://www.sympa.org/faq/database#errors_when_trying_to_load_dbdoracle | ||
| Ligne 131: | Ligne 131: | ||
| # cd /usr/lib/oracle/11.2/client/ | # cd /usr/lib/oracle/11.2/client/ | ||
| # vi tnsnames.ora | # vi tnsnames.ora | ||
| - | + | BASE1 = | |
| + | (DESCRIPTION = | ||
| + | (ADDRESS = (PROTOCOL = TCP)(HOST = xxxx.xxxxx.fr)(PORT = 1521)) | ||
| + | (CONNECT_DATA = (SID = BASE1)) | ||
| + | ) | ||
| # chown oracle:dba tnsnames.ora | # chown oracle:dba tnsnames.ora | ||
| Ligne 137: | Ligne 141: | ||
| ==== Test de connexion ==== | ==== Test de connexion ==== | ||
| - | /usr/lib/oracle/11.2/client/bin/sqlplus [login]/[mot de passe]@[Base] | + | # /usr/lib/oracle/11.2/client/bin/**sqlplus** [login]/[mot de passe]**@**BASE |
| ===== Packages perl ===== | ===== Packages perl ===== | ||
| - | Il faut les packages perl suivants (30/03/2015) | + | Il faut les packages perl suivants |
| # perl -MCPAN -e shell | # perl -MCPAN -e shell | ||
| - | |||
| - | * CPAN (maj) | ||
| * DBD::Oracle | * DBD::Oracle | ||
| - | * DBD::ODBC | + | * DBD::ODBC ?? |
| - | * Exporter ??? | + | * Exporter ?? |
| + | |||
| + | ===== Fichier de configuration de la liste ===== | ||
| + | |||
| + | <code> | ||
| + | include_sql_query | ||
| + | db_name BASE | ||
| + | name XXXXXX | ||
| + | db_port 1521 | ||
| + | host XXXX.XXX.fr | ||
| + | passwd XXXXXXX | ||
| + | db_type Oracle | ||
| + | user XXXXXX | ||
| + | sql_query select distinct mel from acces_user where mel like '%@%grenoble-inp.fr' | ||
| + | </code> | ||
