Alcatel-Lucent OpenTouch - Diagnose Search Problem; Database Content Checking Using Postgresql Tools; Pgadmin (Lev 3)

Alcatel-Lucent OpenTouch R1.x Troubleshooting guide
TG0064
134/182
Ed.15 / June 2013
12 juil. 2011 14:35:41,514 INFO [phonebookdir_801 Load Thread]
(AlcPublicPhoneBookLoadThread.java:67) - Number of downloaded entries from
'phonebookdir_801' directory = 129 in 1753 milliseconds
17.2.4 Diagnose search problem
When UDAS search gives no results
Causes
Trace in log file / command to check
Directory not
synchronized
Trace : SQLException <table_xxx> does not exists
Tape those command line on server :select * from pg_tables where tablename like ‘ldapdir%’ OR
like ‘internaldir%’ OR like ‘phonebookdir%’
1. psql –U htuser DIRECTORIES;
2. select * from pg_tables where tablename like '%ldapdir%' OR tablename like
'%internaldir%';
This command will gives the synchronized directories
Trace : Synchro date for directory with ID [xxxx ]=null, so skipping …
1. Check in admin interface to see if synchro date or synchro time is set for the desired
directory
Error while connecting to the external LDAP
- check ldap parameters and try to connect to the external ldap by using en ldap browser
to validate connection parameters
17.2.5 Database content checking using PostgreSQL tools / pgAdmin (Lev 3)
In order to look at directories databases content, it is also possible to use the pgAdmin tool accessible at
(http://www.pgadmin.org/)
After installation, create a new entry: menu file/add server
Create an entry for the requested type of directory(ies).
Following information are required
 Host
 Maintenance DB
 Username:
 Password
Table here after shows a configuration example:
For LDAP users
For OXE user