esup-helpdesk




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.

Arborescence des pages

Comparaison des versions

Ancienne version 31

changes.mady.by.user utilisateur-6a717

Sauvegardée le

comparé à

Nouvelle version 32

changes.mady.by.user Pascal Aubry

Sauvegardée le

Légende

  • Ces lignes ont été ajoutées. Ce mot a été ajouté.
  • Ces lignes ont été supprimées. Ce mot a été supprimé.
  • La mise en forme a été modifiée.

...

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" />

{tip:title=Apache frntal server}}If your Tomcat is behind an frontal server (like Apache), don't forget to set the parameter on the corresponding connector , (here we are using with mod_jk/AJPv13):

Bloc de code

<!-- Define an AJP 1.3 Connector on port 8009 -->
<Connector port="8009"
     enableLookups="false" redirectPort="8443" protocol="AJP/1.3" emptySessionPath="true" />
tip
Astuce

Statistics charts do not appear (InternalError)

At first check that the emptySessionPath parameter is correctly set as shown above.

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 ...

See:

There are unused things in the database

Description: upgrading the database structures with Hibernate creates new tables and fields but does not remove obsolete structures. Depending on the version you started with, there may effectively be unused tables and fields.

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`;

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
...