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):
|
Statistics charts do not appear (InternalError)
...
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`;
|
Astuce |
---|
With MySql, the name of the foreign keys is shown with SHOW CREATE TABLE h_acti; (resp. h_depa); once known, the foreign keys can be dropped with ALTER TABLE h_acti DROP FOREIGN KEY FKB6E0538EF9CD6EB0; (resp. h_depa et FKB6E1B7A961B67C78), cf http://lists.mysql.com/mysql/204151). |
Astuce |
---|
In portlet deployment, the menu entries appear as ugly buttons
...
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;
|
...
This may happen if your server is behind a HTTP proxy. In this refer to the Ant manual to pass options to ant.
MalformedUrlException after database inactivity
These exceptions are often throw oby the first request after an inactivity period of the database.
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>