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).
Troubles with Shibboleth
I had a problem with Shibboleth and esup-hepldesk :
Shibboleth worked fine but I couldn't authenticate myself on helpdesk... When I clicked on "Shibboleth" on the hekpldesk's front page, I were redirected to my WAYF and my CAS, but after my CAS' authentication, I came back the front page without being authenticated...
Note : I'm using the helpdesk as a servlet in Tomcat with an Apache front-end.
To solve this problem, you have to add this lines in your apache configuration :
<Location /helpdesk/stylesheets/shibboleth.faces>
AuthType shibboleth
ShibRequireSession On
ShibUseHeaders On
require valid-user
</Location>