La liste d'utilisateurs n'est pas rendue car vous ne possédez pas les droits d'accès nécessaires pour afficher les profils utilisateur.
Historique de la page
...
Solution: use the emptySessionPath parameter for the Tomcat connector, for instance:
| Bloc de code |
|---|
<Connector
port="8080"
maxHttpHeaderSize="8192" maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true"
emptySessionPath="true" />
|
| Astuce | ||
|---|---|---|
| ||
If your Tomcat is behind an frontal server (like Apache), don't forget to set the parameter on the corresponding connector (here with mod_jk/AJPv13):
|
...
If you get the following error (Unix platforms only):
| Bloc de code |
|---|
InternalError: Can't connect to X11 window server using 'xxx' as the value of the DISPLAY variable
|
You have to unset the DISPLAY environment variable before launching the application, as shown on the helpdesk.sh script (cf 03 Administration ):
| Bloc de code |
|---|
unset DISPLAY
|
Statistics charts do not appear (NoClassDefFoundError)
If you get the following error:
| Bloc de code |
|---|
java.lang.NoClassDefFoundError
|
It is probably an X11 issue (the AWT library tries to use an unexistant X11 server to generate images). Add the following option when launching the application:
| Bloc de code |
|---|
java -Djava.awt.headless=true ...
|
...
Solution: Obsolete fields and tables can be removed manually using the following SQL statements:
| Bloc de code |
|---|
ALTER TABLE h_acti DROP FOREIGN KEY FKB6E0538EF9CD6EB0;
ALTER TABLE h_acti DROP KEY FKB6E0538EF9CD6EB0;
ALTER TABLE `h_acti`
DROP `faq_conn_afte_id`;
ALTER TABLE `h_cate`
DROP `new_tick_assi_cust_clas`,
DROP `dele`,
DROP `use_defa_tick_temp`;
ALTER TABLE h_depa DROP FOREIGN KEY FKB6E1B7A912177440;
ALTER TABLE h_depa DROP KEY FKB6E1B7A912177440;
ALTER TABLE `h_depa`
DROP `algo_stat`,
DROP `auto_expi`,
DROP `comp_url_cust_clas`,
DROP `new_tick_prop_cust_clas`,
DROP `tick_moni_cust_clas`,
DROP `defa_new_tick_assi_cust_clas`,
DROP `real_cate_id`,
DROP `use_defa_tick_temp`;
ALTER TABLE `h_depa_mana`
DROP `tick_moni_crea_all`,
DROP `tick_moni_crea_mana`,
DROP `tick_moni_crea_cate_memb`,
DROP `tick_moni_crea_free`,
DROP `tick_moni_crea_orph`,
DROP `tick_moni_clos_all`,
DROP `tick_moni_clos_mana`,
DROP `tick_moni_clos_cate_memb`,
DROP `tick_moni_clos_free`,
DROP `tick_moni_clos_orph`,
DROP `tick_moni_othe_all`,
DROP `tick_moni_othe_mana`,
DROP `tick_moni_othe_cate_memb`,
DROP `tick_moni_othe_free`,
DROP `tick_moni_othe_orph`;
ALTER TABLE `h_stat`
DROP `tick_crea_stat_last_time`,
DROP `user_tick_crea_stat_last_time`;
ALTER TABLE `h_tick`
DROP `owne_disp_name`,
DROP `depa_labe`,
DROP `cate_labe`;
ALTER TABLE `h_user`
DROP `pers_tick_moni`,
DROP `invo_tick_moni`,
DROP `lang_id`,
DROP `html_emai_form`,
DROP `text_emai_form`,
DROP `show_new_tick_welc`,
DROP `embo_chan_tick`,
DROP `depa_filt_set`,
DROP `cont_pane_refr_time`,
DROP `cont_pane_stat_filt`,
DROP `cont_pane_invo_filt`,
DROP `sear_page_size`,
DROP `jour_refr_time`,
DROP `jour_date_filt`,
DROP `text_widt`,
DROP `text_heig`,
DROP `last_visi`,
DROP `show_popu_on_tick_clos`,
DROP `cont_pane_orde_by`,
DROP `star_on_cont_pane`;
ALTER TABLE `h_vers_mana`
DROP `inde_upda`;
DROP TABLE `h_faq_dele`;
TRUNCATE TABLE `h_faq_entr`;
TRUNCATE TABLE `h_faq_part`;
TRUNCATE TABLE `h_file`;
TRUNCATE TABLE `h_tick_temp`;
DROP TABLE `h_day_user_tick_crea_stat`;
DROP TABLE `h_hour_tick_crea_stat`;
|
...
| Bloc de code | ||
|---|---|---|
| ||
@import "/esup-helpdesk/media/commons.css";
@import "/esup-helpdesk/media/helpdesk.css";
@import "/esup-helpdesk/media/portlet.css";
|
...
The function timediff is native in MySql but must be added by hand by PostGres users, as well as the function time_to_sec:
| Bloc de code |
|---|
CREATE FUNCTION timediff(t1 timestamptz, t2 "timestamp")
RETURNS "interval" AS
'select ($2-$1)::interval' language sql;
CREATE OR REPLACE FUNCTION time_to_sec(i1 "interval")
RETURNS float8 AS
'SELECT EXTRACT(EPOCH FROM $1) AS result;' language sql;
|
...
To get rid of them, setup your Tomcat pool as shown here (see this thread in French).
How can I improve the response times of the database
Indices are created when running ant init-data, but they are not created when upgrading the database.
Please check that the indices of the SQL commands below are present, and create the indices if not:
| Bloc de code |
|---|
ALTER TABLE h_acti ADD INDEX i_acti_date (date);
ALTER TABLE h_aler ADD INDEX i_aler_emai (emai);
ALTER TABLE h_arch_acti ADD INDEX i_arch_acti_date (date);
ALTER TABLE h_arch_tick ADD INDEX i_arch_tick_tick_id (tick_id);
ALTER TABLE h_arch_tick ADD INDEX i_arch_tick_effe_scop (effe_scop);
ALTER TABLE h_arch_tick ADD INDEX i_arch_tick_crea_date (crea_date);
ALTER TABLE h_arch_tick ADD INDEX i_arch_tick_arch_date (arch_date);
ALTER TABLE h_depa ADD INDEX i_depa_orde (orde);
ALTER TABLE h_depa_sele_conf ADD INDEX i_depa_sele_conf_date (date);
ALTER TABLE h_faq2 ADD INDEX i_faq2_effe_scop (effe_scop);
ALTER TABLE h_icon ADD INDEX i_icon_name (name);
ALTER TABLE h_tick ADD INDEX i_tick_stat (stat);
ALTER TABLE h_tick ADD INDEX i_tick_effe_scop (effe_scop);
ALTER TABLE h_tick ADD INDEX i_tick_crea_date (crea_date);
ALTER TABLE h_tick ADD INDEX i_tick_last_acti_date (last_acti_date); |
Vue d'ensemble
Gestion des contenus