Dépôt officiel du code source de l'ERP OpenConcerto

/*

 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.

 *

 * Copyright 2011-2019 OpenConcerto, by ILM Informatique. All rights reserved.

 *

 * The contents of this file are subject to the terms of the GNU General Public License Version 3

 * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a

 * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific

 * language governing permissions and limitations under the License.

 *

 * When distributing the software, include this License Header Notice in each file.

 */

 package org.openconcerto.erp.config;

import static java.lang.System.getProperty;

import org.openconcerto.erp.action.NouvelleConnexionAction;

import org.openconcerto.erp.core.common.ui.PanelFrame;

import org.openconcerto.erp.panel.PostgreSQLFrame;

import org.openconcerto.erp.panel.UserExitConf;

import org.openconcerto.erp.panel.UserExitPanel;

import org.openconcerto.erp.preferences.UIPreferencePanel;

import org.openconcerto.erp.rights.ComptaTotalUserRight;

import org.openconcerto.ftp.updater.UpdateManager;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.PropsConfiguration;

import org.openconcerto.sql.RemoteShell;

import org.openconcerto.sql.element.UISQLComponent;

import org.openconcerto.sql.model.SQLBase;

import org.openconcerto.sql.model.SQLDataSource;

import org.openconcerto.sql.model.SQLRequestLog;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLSystem;

import org.openconcerto.sql.request.BaseFillSQLRequest;

import org.openconcerto.sql.request.ComboSQLRequest;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.sql.sqlobject.IComboSelectionItem;

import org.openconcerto.sql.ui.SoftwareInfoPanel;

import org.openconcerto.sql.users.rights.UserRightsManager;

import org.openconcerto.sql.utils.ReOrder;

import org.openconcerto.sql.view.EditPanel;

import org.openconcerto.sql.view.IListFrame;

import org.openconcerto.sql.view.list.IListe;

import org.openconcerto.ui.FrameUtil;

import org.openconcerto.ui.component.ITextCombo;

import org.openconcerto.ui.component.WaitIndeterminatePanel;

import org.openconcerto.ui.preferences.EmailProps;

import org.openconcerto.utils.CompareUtils;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.FileUtils;

import org.openconcerto.utils.ThrowableHandler;

import org.openconcerto.utils.i18n.TranslationManager;

import org.openconcerto.utils.protocol.Helper;

import org.openconcerto.xml.FastXMLProperties;

import java.awt.AWTEvent;

import java.awt.Component;

import java.awt.Desktop;

import java.awt.Image;

import java.awt.Toolkit;

import java.awt.event.AWTEventListener;

import java.awt.event.HierarchyEvent;

import java.awt.event.WindowAdapter;

import java.awt.event.WindowEvent;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.io.BufferedReader;

import java.io.ByteArrayOutputStream;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStreamReader;

import java.io.PrintStream;

import java.lang.Thread.UncaughtExceptionHandler;

import java.net.InetAddress;

import java.net.NetworkInterface;

import java.net.URI;

import java.net.URL;

import java.net.UnknownHostException;

import java.security.AllPermission;

import java.security.Permission;

import java.security.PermissionCollection;

import java.security.Policy;

import java.security.ProtectionDomain;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.Enumeration;

import java.util.HashSet;

import java.util.List;

import java.util.Properties;

import java.util.Set;

import javax.swing.ImageIcon;

import javax.swing.JDialog;

import javax.swing.JFrame;

import javax.swing.JOptionPane;

import javax.swing.SwingUtilities;

public class Gestion {

    static final String MODULES_DIR_NAME = "Modules";

    /**

     * When this system property is set to <code>true</code>, Gestion will hide most of its normal

     * UI. E.g. no SOCIETE selection in the login panel, minimalist menu bar, etc.

     */

    public static final String MINIMAL_PROP = "org.openconcerto.erp.minimal";

    private static List<Image> frameIcon;

    // Check that we are on Mac OS X. This is crucial to loading and using the OSXAdapter class.

    static final boolean MAC_OS_X = System.getProperty("os.name").toLowerCase().startsWith("mac os x");

    static boolean inWebStart() {

        // cannot rely on system properties since they vary from one implementation to another

        try {

            // ATTN on OpenJDK jnlp classes are in rt.jar, so this doesn't throw

            // ClassNotFoundException, we have to check the result

            final String[] names = (String[]) Class.forName("javax.jnlp.ServiceManager").getMethod("getServiceNames").invoke(null);

            return names != null && names.length > 0;

        } catch (Throwable e) {

            return false;

        }

    }

    public static void openPDF(File f) {

        try {

            FileUtils.openFile(f);

        } catch (IOException e) {

            JOptionPane.showMessageDialog(null,

                    "Impossible d'ouvrir le fichier " + f + ".\nVérifiez qu'un logiciel pour lire les fichiers PDF est installé sur votre ordinateur.\nVoir http://get.adobe.com/fr/reader.",

                    "Erreur d'ouverture du PDF", JOptionPane.ERROR_MESSAGE);

        }

    }

    public static final boolean isMinimalMode() {

        return Boolean.getBoolean(MINIMAL_PROP);

    }

    static private final PermissionCollection ALL_PERMS;

    static {

        final AllPermission allPermission = new AllPermission();

        ALL_PERMS = allPermission.newPermissionCollection();

        ALL_PERMS.add(allPermission);

        ALL_PERMS.setReadOnly();

    }

    // install a security manager so that we can restrict modules permissions

    private static void initSecurity() {

        // extensions (like sunjce_provider) need all permissions

        final String[] extDirs = System.getProperty("java.ext.dirs").split(File.pathSeparator);

        final List<String> canonExtDirs = new ArrayList<String>(extDirs.length);

        for (final String extDir : extDirs) {

            try {

                canonExtDirs.add(new File(extDir).getCanonicalPath());

            } catch (IOException e) {

                System.err.println("Couldn't add extension dir : " + extDir);

                e.printStackTrace();

            }

        }

        // our class loader gets all permission

        final ClassLoader mainLoader = Gestion.class.getClassLoader();

        Policy.setPolicy(new Policy() {

            private boolean isExt(ProtectionDomain domain) {

                final URL location = domain.getCodeSource().getLocation();

                if ("file".equals(location.getProtocol())) {

                    try {

                        final String canonPath = new File(location.toURI()).getCanonicalPath();

                        for (final String canonExtDir : canonExtDirs) {

                            if (canonPath.startsWith(canonExtDir))

                                return true;

                        }

                    } catch (Exception e) {

                        e.printStackTrace();

                    }

                }

                return false;

            }

            @Override

            public PermissionCollection getPermissions(ProtectionDomain domain) {

                if (domain != null && (domain.getClassLoader() == mainLoader || isExt(domain))) {

                    return ALL_PERMS;

                } else {

                    return super.getPermissions(domain);

                }

            }

            // have to overload since our superclass caches the permissions of the protection domain

            // of this instance in initPolicy()

            @Override

            public boolean implies(ProtectionDomain domain, Permission permission) {

                if (domain != null && domain.getClassLoader() == mainLoader) {

                    return true;

                }

                // super caches results (avoid calling expensive isExt())

                return super.implies(domain, permission);

            }

        });

        System.setSecurityManager(new SecurityManager());

    }

    public static void main(String[] args) {

        System.setProperty("org.xml.sax.driver", "com.bluecast.xml.Piccolo");

        System.setProperty("org.xml.sax.parser", "com.bluecast.xml.Piccolo");

        System.setProperty("javax.xml.parsers.SAXParserFactory", "com.bluecast.xml.JAXPSAXParserFactory");

        ComptaPropsConfiguration.checkJava();

        // Check MacOS Sandbox

        String cwd = new File(getProperty("user.dir")).toURI().toString();

        if (cwd.startsWith("file:/private/var/folders")) {

            JOptionPane.showMessageDialog(null,

                    "Vous éxecutez OpenConcerto depuis la sandbox de MacOS.\nVous devez déplacer le logiciel dans votre dossier Application.\n\nSi cela ne fonctionne pas, vous pouvez utiliser la commande : \nsudo xattr -r -d com.apple.quarantine /Applications/OpenConcerto",

                    "Sandbox", JOptionPane.ERROR_MESSAGE);

            return;

        }

        Thread.setDefaultUncaughtExceptionHandler(new UncaughtExceptionHandler() {

            @Override

            public void uncaughtException(Thread t, Throwable e) {

                e.printStackTrace();

                ExceptionHandler.handle("UncaughtException on thread " + t, e);

            }

        });

        System.out.println("Java version: " + System.getProperty("java.vendor", "??") + " - " + System.getProperty("java.version", "??"));

        System.out.println("Runtime: Java " + System.getProperty("java.runtime.version", "??") + " - " + System.getProperty("os.name", "??"));

        ExceptionHandler.setForceUI(true);

        ExceptionHandler.setForumURL("http://www.openconcerto.org/forum");

        ExceptionHandler.setSoftwareInformations(SoftwareInfoPanel.FACTORY);

        ExceptionHandler.setShowProbably(true);

        ExceptionHandler.setThrowableHandler(createDefaultThrowableHandler());

        // Guillaume : handle people importing data directly into the DB

        ReOrder.setAutoFixNulls(true);

        System.setProperty(SQLRowAccessor.ACCESS_DB_IF_NEEDED_PROP, "true");

        System.setProperty(PropsConfiguration.REDIRECT_TO_FILE, "true");

        // Mac

        // only works with Aqua laf

        System.setProperty("apple.laf.useScreenMenuBar", "true");

        // ToolTipManager.sharedInstance().setInitialDelay(0);

        if (false) {

            // TODO : regarder si ne pas le forcer fix le bug de carré noir

            // SpeedUp Linux

            System.setProperty("sun.java2d.pmoffscreen", "false");

        }

        System.setProperty(EditPanel.NOBORDER, "true");

        System.setProperty(EditPanel.ADD_AT_THE_END, "true");

        System.setProperty("org.openconcerto.sql.listPanel.deafEditPanel", "true");

        // needed as long as IListFrame title isn't localised

        System.setProperty(IListFrame.SHORT_TITLE, "true");

        // Gérer avec le droit SAVE_LIST

        System.setProperty("org.openconcerto.sql.canSaveInList", "false");

        System.setProperty("org.openconcerto.ui.addComboButton", "true");

        System.setProperty(SQLBase.STRUCTURE_USE_XML, "true");

        // don't put any suffix, rely on Animator

        System.setProperty(UISQLComponent.REQUIRED_SUFFIX_PROP, "");

        System.setProperty(ElementComboBox.CAN_MODIFY, "true");

        System.setProperty("org.openconcerto.ui.removeSwapSearchCheckBox", "true");

        if (System.getProperty("org.openconcerto.oo.useODSViewer") == null) {

            System.setProperty("org.openconcerto.oo.useODSViewer", "true");

        }

        // Workaround for JRE 7 bug: http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=7075600

        System.setProperty("java.util.Arrays.useLegacyMergeSort", "true");

        System.setProperty(ITextCombo.SIMPLE_TRAVERSAL, "true");

        // Must be called before createDefaultInstance()

        TranslationManager.addTranslationStreamFromClass(Gestion.class);

        // Disable FOR SHARE lock

        BaseFillSQLRequest.setDefaultLockSelect(false);

        ComboSQLRequest.setDefaultItemsOrder(CompareUtils.<IComboSelectionItem> naturalOrder());

        // Initialisation du splashScreen

        // ne pas oublier en param -splash:image.png

        try {

            // Ne fonctionne pas sur certains Linux

            java.awt.SplashScreen.getSplashScreen();

        } catch (Throwable e) {

            // Can occur on OpenJDK...

            System.out.println("SplashScreen failed... " + e.getMessage());

        }

        // must be done before creating UserRightsManager (which is done by

        // PropsConfiguration.getRoot())

        UserRightsManager.DEFAULT_MACRO_RIGHTS.add(new ComptaTotalUserRight());

        // Init des caches

        long t1 = System.currentTimeMillis();

        final ComptaPropsConfiguration conf = ComptaPropsConfiguration.create(true);

        if (conf == null) {

            System.out.println("Unable to create configuration, launching ServerFinderPanel");

            ServerFinderPanel.main(new String[0]);

            return;

        }

        // Dump conf directories

        try {

            System.out.println("Application data folder : " + conf.getBaseDirs().getAppDataFolder().getCanonicalPath());

            System.out.println("Application cache folder : " + conf.getBaseDirs().getCacheFolder().getCanonicalPath());

            System.out.println("Application preferences folder : " + conf.getBaseDirs().getPreferencesFolder().getCanonicalPath());

        } catch (IOException ex2) {

            ex2.printStackTrace();

        }

        System.out.println("Application working directory folder : " + conf.getWD().getAbsolutePath());

        System.out.println("Modules folders : " + conf.getModuleManager().getFolders().toString());

        if (inWebStart()) {

            // needed since our classes aren't loaded by the same loader as the library classes

            Helper.setURLStreamHandlerFactory();

            // even if we set <all-permissions/> in the jnlp, this only applies to the main jar, not

            // to dynamically loaded jars. So to allow OOConnexion to work we need to remove the

            // security manager.

            System.setSecurityManager(null);

        }

        Configuration.setInstance(conf);

        ExceptionHandler.setSafeToExit(!conf.getServerIp().contains("file:"));

        try {

            Configuration.migrateToNewDir(conf.getOldDataDir(), conf.getDataDir());

        } catch (IOException ex) {

            throw new IllegalStateException("Couldn't migrate data dir", ex);

        }

        final boolean logRequests = Boolean.valueOf(conf.getProperty("logRequests", "false"));

        if (logRequests) {

            SQLRequestLog.setEnabled(true);

        }

        // columns order/visibility per company

        IListFrame.setConfDirFunction((elem) -> conf.getConfDir(elem.getTable().getDBRoot()));

        if (Boolean.valueOf(conf.getProperty("minimal", "false"))) {

            System.setProperty(MINIMAL_PROP, Boolean.TRUE.toString());

        }

        if (Boolean.valueOf(conf.getProperty("statelessTable", "false"))) {

            System.setProperty(IListe.STATELESS_TABLE_PROP, Boolean.TRUE.toString());

        }

        System.setProperty("org.openconcerto.oo.useODSViewer", Boolean.TRUE.toString());

        if (conf.getProperty("odsViewer") != null) {

            System.setProperty("org.openconcerto.oo.useODSViewer", Boolean.valueOf(conf.getProperty("odsViewer")).toString());

        }

        if (conf.getProperty("rwOnDoubleClick") != null) {

            System.setProperty("org.openconcerto.sql.listPanel.rwOnDoubleClick", Boolean.valueOf(conf.getProperty("rwOnDoubleClick")).toString());

        }

        RemoteShell.startDefaultInstance(conf.getDirectory(), conf.getRoot());

        // Restore L&F and colors

        UIPreferencePanel.initUIFromPreferences();

        UpdateManager.start();

        Toolkit.getDefaultToolkit().setDynamicLayout(true);

        ComboSQLRequest.setDefaultFieldSeparator(" ");

        long t4 = System.currentTimeMillis();

        System.out.println("Ip:" + conf.getServerIp());

        if (conf.getServerIp().startsWith("127.0.0.1:6543")) {

            File f = new File("PostgreSQL/data/postmaster.pid");

            if (!f.exists()) {

                startDB(conf);

            }

        }

        try {

            // test DB connection

            conf.getSystemRoot();

            // Prefetch undefined

            conf.getRoot().getTables().iterator().next().getUndefinedID();

        } catch (Exception e) {

            System.out.println("Init phase 1 error:" + (System.currentTimeMillis() - t4) + "ms");

            if (conf.getSystem() == SQLSystem.H2 && e.getCause() instanceof SQLException) {

                final SQLException sqlExn = (SQLException) e.getCause();

                final String msg;

                if (sqlExn.getErrorCode() == 90020) {

                    msg = "Base de donnée déjà ouverte.";

                } else if (sqlExn.getSQLState().equals("08000")) {

                    msg = "Impossible d'ouvrir la base de donnée. Vérifier les permissions.\n" + conf.getServerIp();

                } else {

                    msg = null;

                }

                if (msg != null) {

                    try {

                        e.printStackTrace();

                        SwingUtilities.invokeAndWait(new Runnable() {

                            @Override

                            public void run() {

                                JOptionPane.showMessageDialog(null, msg, "Erreur fatale", JOptionPane.ERROR_MESSAGE);

                            }

                        });

                    } catch (Exception e1) {

                        ExceptionHandler.die("Erreur fatale", e1);

                    }

                    System.exit(1);

                }

            }

            ExceptionHandler.die("Erreur de connexion à la base de données", e);

        }

        System.out.println("Init phase 1:" + (System.currentTimeMillis() - t1) + "ms");

        // Counter and user agreement

        File fTOS = new File(Configuration.getInstance().getConfDir(), "tos.properties");

        Properties pTOS = new Properties();

        pTOS.setProperty("launchCounter", "1");

        pTOS.setProperty("allowDebug", "false");

        pTOS.setProperty("hasManual", "false");

        pTOS.setProperty("hasCloud", "false");

        if (fTOS.exists()) {

            try {

                FastXMLProperties.load(pTOS, new FileInputStream(fTOS));

            } catch (Exception e1) {

                e1.printStackTrace();

            }

        }

        if (ComptaPropsConfiguration.getInstanceCompta().isOnCloud()) {

            pTOS.setProperty("hasCloud", "true");

        }

        final boolean allowDebug = pTOS.getProperty("allowDebug", "false").equals("true");

        ExceptionHandler.setSubmitErrorAutoEnabled(allowDebug);

        final int launchCounter = Integer.parseInt(pTOS.getProperty("launchCounter", "0"));

        pTOS.setProperty("launchCounter", String.valueOf(launchCounter + 1));

        saveProperties(fTOS, pTOS);

        if (!allowDebug && (launchCounter - 2) % 30 == 0) {

            SwingUtilities.invokeLater(new Runnable() {

                public void run() {

                    Object[] options = { "J'accepte", "Non, merci" };

                    int n = JOptionPane.showOptionDialog(null,

                            "Afin d'améliorer plus rapidement le logiciel, nous avons intégré l'envoi automatique de rapports d'erreur.\nIl contient les informations techniques nécessaires à la corrections de bugs.\nSouhaitez-vous activer l'envoi automatique ?",

                            "Rapport d'erreur", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE, null, options, options[0]);

                    if (n == JOptionPane.YES_OPTION) {

                        pTOS.setProperty("allowDebug", "true");

                        saveProperties(fTOS, pTOS);

                        ExceptionHandler.setSubmitErrorAutoEnabled(true);

                    }

                }

            });

        }

        final boolean hasManual = pTOS.getProperty("hasManual", "false").equals("true");

        if (!hasManual && (launchCounter - 5) % 100 == 0) {

            SwingUtilities.invokeLater(new Runnable() {

                public void run() {

                    Object[] options = { "Je l'ai déjà", "Bonne idée!" };

                    int n = JOptionPane.showOptionDialog(null,

                            "Afin de maîtriser le logiciel, nous conseillons vivement l'acquisition du manuel.\nSon achat vous permet de soutenir les développements d'OpenConcerto et d'avoir une documentation papier de plus de 250 pages.\nVous pouvez le commmander avec port gratuit depuis le site internet : https://www.openconcerto.org ",

                            "Le manuel utilisateur", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE, null, options, options[1]);

                    if (n == JOptionPane.YES_OPTION) {

                        pTOS.setProperty("hasManual", "true");

                        saveProperties(fTOS, pTOS);

                    } else {

                        try {

                            Desktop.getDesktop().browse(new URI("https://www.openconcerto.org/fr/documentation.html"));

                        } catch (Exception e) {

                            e.printStackTrace();

                        }

                    }

                }

            });

        }

        final boolean hasCloud = pTOS.getProperty("hasCloud", "false").equals("true");

        if (!hasCloud && (launchCounter - 30) % 100 == 0 && ComptaPropsConfiguration.getInstanceCompta().isServerless()) {

            SwingUtilities.invokeLater(new Runnable() {

                public void run() {

                    JOptionPane.showMessageDialog(null,

                            "Vous utilisez actuellement le logiciel en version monoposte.\nLes données sont stockées sur votre ordinateur, ce qui peut poser problème en cas de vol ou de panne.\nNous proposons une offre cloud qui vous permet de travailler à plusieurs et de ne plus avoir à vous soucier de la sauvegarde de vos données.\nVous aurez juste besoin d'une connexion internet.\nPlus d'informations sur https://cloud.openconcerto.org",

                            "Cloud", JOptionPane.INFORMATION_MESSAGE);

                    try {

                        Desktop.getDesktop().browse(new URI("https://cloud.openconcerto.org"));

                    } catch (Exception e) {

                        e.printStackTrace();

                    }

                }

            });

        }

        // Email props in .java

        File fMail2 = new File(Configuration.getInstance().getConfDir(), "Email.properties");

        EmailProps.getInstance().setDefaultPropsFileName(fMail2.toString());

        EmailProps.getInstance().setPropsFileName(fMail2.toString());

        SwingUtilities.invokeLater(new Runnable() {

            public void run() {

                long t1 = System.currentTimeMillis();

                IListe.setForceAlternateCellRenderer(true);

                AWTEventListener awtListener = new AWTEventListener() {

                    Set<Integer> frames = new HashSet<Integer>();

                    String prefix;

                    @Override

                    public final void eventDispatched(final AWTEvent event) {

                        assert event != null;

                        if (event instanceof HierarchyEvent && event.getID() == HierarchyEvent.HIERARCHY_CHANGED) {

                            // This event represents a change in the containment hierarcy.

                            // Now let's figure out what kind.

                            final HierarchyEvent hevent = (HierarchyEvent) event;

                            final Component changed = hevent.getChanged();

                            if (changed instanceof JFrame && ((hevent.getChangeFlags() & HierarchyEvent.DISPLAYABILITY_CHANGED) != 0) && changed.isDisplayable()) {

                                final JFrame frame = (JFrame) changed;

                                frame.setIconImages(getFrameIcon());

                                if (!frames.contains(frame.hashCode())) {

                                    frames.add(frame.hashCode());

                                    frame.addPropertyChangeListener(new PropertyChangeListener() {

                                        @Override

                                        public void propertyChange(PropertyChangeEvent evt) {

                                            if (prefix == null) {

                                                if (ComptaPropsConfiguration.getInstance() != null && ComptaPropsConfiguration.getInstanceCompta().getRowSociete() != null) {

                                                    prefix = "[" + ComptaPropsConfiguration.getInstanceCompta().getRowSociete().getString("NOM") + "] ";

                                                } else {

                                                    return;

                                                }

                                            }

                                            String title = frame.getTitle();

                                            if (title != null && !title.startsWith(prefix)) {

                                                frame.setTitle(prefix + title);

                                            }

                                        }

                                    });

                                }

                            }

                        }

                    }

                };

                final Toolkit toolkit = Toolkit.getDefaultToolkit();

                assert toolkit != null;

                toolkit.addAWTEventListener(awtListener, AWTEvent.HIERARCHY_EVENT_MASK);

                if (logRequests) {

                    SQLRequestLog.showFrame();

                }

                JFrame f = null;

                try {

                    f = new NouvelleConnexionAction(conf).createFrame();

                    // happens with quick login

                    if (f != null) {

                        f.pack();

                        f.setResizable(false);

                        f.addWindowListener(new WindowAdapter() {

                            public void windowClosing(WindowEvent e) {

                                try {

                                    askForExit();

                                } catch (Exception ex) {

                                    ex.printStackTrace();

                                    // Broken state

                                    System.exit(2);

                                }

                            };

                        });

                        // f.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

                    }

                } catch (Exception e) {

                    Thread.dumpStack();

                    e.printStackTrace();

                    ExceptionHandler.handle("Erreur lors de la tentative de connexion à la base.", e);

                } finally {

                    if (f != null) {

                        FrameUtil.show(f);

                    }

                    System.out.println("Init phase 2:" + (System.currentTimeMillis() - t1) + "ms");

                }

            }

        });

        // needed so that we can uninstall modules

        System.setProperty(SQLBase.ALLOW_OBJECT_REMOVAL, "true");

        NewsChecker.check(pTOS, conf.getConfDir(), conf.getServer().getSQLSystem().equals(SQLSystem.H2));

    }

    private static void saveProperties(File fTOS, Properties pTOS) {

        try {

            final FileOutputStream outputStream = new FileOutputStream(fTOS);

            FastXMLProperties.store(pTOS, outputStream, "tos");

            outputStream.close();

        } catch (Exception e) {

            e.printStackTrace();

        }

    }

    public static ThrowableHandler createDefaultThrowableHandler() {

        return new ThrowableHandler() {

            @Override

            public boolean handle(String message, Throwable throwable) {

                if (throwable == null)

                    return false;

                throwable.printStackTrace();

                final ByteArrayOutputStream out = new ByteArrayOutputStream();

                throwable.printStackTrace(new PrintStream(out));

                String s = new String(out.toByteArray());

                if (s.contains("Database may be already in use")) {

                    JOptionPane.showMessageDialog(null,

                            "Votre base de données est déjà en cours d'utilisation.\nEn version monoposte, vous ne pouvez lancer qu'un seul programme OpenConcerto à la fois.");

                    System.exit(1);

                    return true;

                } else if (s.contains("PSQLException: Connexion") && ComptaPropsConfiguration.getInstanceCompta().isOnCloud()) {

                    JOptionPane.showMessageDialog(null, "Suite à une coupure de votre connexion internet, vous avez été déconnecté du Cloud.\nMerci de redémarrer le logiciel.");

                    System.exit(1);

                    return true;

                } else if (s.contains("File corrupted while reading")) {

                    JOptionPane.showMessageDialog(null,

                            "Votre fichier de base de données est endommagé.\nLes causes possibles sont variées : problème matériel (mémoire, disque dur...), coupure brutale du PC, virus, antivirus, erreur de fichiers...\n\nIl vous faudra restaurer votre base de données depuis une sauvegarde\nou contacter notre service technique pour réparation (voir https://www.openconcerto.org).");

                    System.exit(1);

                    return true;

                } else if (s.contains("h2") && (s.contains("File corrupted while reading") || s.contains("data leaf table"))) {

                    JOptionPane.showMessageDialog(null,

                            "Votre fichier de base de données est endommagé.\nLes causes possibles sont variées : problème matériel (mémoire, disque dur...), coupure brutale du PC, virus, antivirus, erreur de fichiers...\n\nIl vous faudra restaurer votre base de données depuis une sauvegarde\nou contacter notre service technique pour réparation (voir https://www.openconcerto.org).");

                    System.exit(1);

                    return true;

                } else if (s.contains("/private/var/folders/")) {

                    JOptionPane.showMessageDialog(null,

                            "Votre installation d'OpenConcerto n'est pas correcte!\nOpenConcerto ne doit pas s'executer dans l'app Sandbox de MacOS.\nVeuillez débloquer l'application.");

                    System.exit(1);

                    return true;

                } else if (s.contains("com.sun.java.swing.plaf.windows.WindowsTableHeaderUI")) {

                    // bug connu de Java sur les TableHeader

                    return true;

                } else if (s.contains("WInputMethod.openCandidateWindow") && s.contains("java.lang.NullPointerException: peer")) {

                    // bug windows...

                    // Caused by: java.lang.NullPointerException: peer

                    // at sun.awt.windows.WInputMethod.openCandidateWindow(Native Method)

                    // at sun.awt.windows.WInputMethod.access$400(Unknown Source)

                    // at sun.awt.windows.WInputMethod$1.run(Unknown Source)

                    // at java.awt.event.InvocationEvent.dispatch(Unknown Source)

                    return true;

                }

                else if (s.contains("No application is associated with the specified file for this operation") || s.contains("Error message: Package could not be registered")) {

                    JOptionPane.showMessageDialog(null, "Merci d'installer LibreOffice ou tout autre application succeptible d'ouvrir ce fichier");

                    return true;

                } else if (s.contains("java.net.SocketTimeoutException: connect timed out")) {

                    JOptionPane.showMessageDialog(null, "Le serveur de base de données n'est pas joignable.\n" + message);

                    return true;

                } else if (s.contains("java.lang.NoSuchMethodError")) {

                    JOptionPane.showMessageDialog(null, "Un de vos modules n'est pas à jour.\n" + message);

                    return true;

                } else if (s.contains("InvalidTemplateException")) {

                    JOptionPane.showMessageDialog(null, "Votre modèle de document n'est pas valide.\n" + message, "Modèle incorrect", JOptionPane.ERROR_MESSAGE);

                    return true;

                }

                return false;

            }

        };

    }

    /**

     * Si la base est 127.0.0.1 ou localhost alors on essaye de lancer postgres.

     *

     * @param conf the configuration to connect to.

     */

    private static void startDB(PropsConfiguration conf) {

        List<String> l = new ArrayList<String>();

        l.add("Lancement de la base de données");

        PostgreSQLFrame pgFrame = null;

        try {

            pgFrame = new PostgreSQLFrame("Démarrage en cours");

            pgFrame.setVisible(true);

        } catch (Exception e) {

            e.printStackTrace();

        }

        System.err.println("start DB");

        final WaitIndeterminatePanel panel = new WaitIndeterminatePanel(l);

        final PanelFrame f = new PanelFrame(panel, "Gestion NX");

        f.setResizable(false);

        f.setLocationRelativeTo(null);

        f.setVisible(true);

        // on recupere les properties

        final String serverAdr = conf.getProperty("server.ip");

        // si la base est en local on relance postgres

        if (serverAdr.startsWith("127.0.0.1") || serverAdr.startsWith("localhost")) {

            Runtime runtime = Runtime.getRuntime();

            try {

                File file = new File(".\\PostgreSQL\\bin\\");

                if (!file.canWrite()) {

                    ExceptionHandler.die("Vous n'avez pas le droit en écriture sur la base de données.\nImpossible de lancer le logiciel!");

                }

                final Process p = runtime.exec(new String[] { "cmd.exe", "/C", "launchPostGres.bat" }, null, file);

                // Consommation de la sortie standard de l'application externe dans un Thread

                // separe

                new Thread() {

                    public void run() {

                        try {

                            BufferedReader reader = new BufferedReader(new InputStreamReader(p.getInputStream()));

                            String line = "";

                            try {

                                while ((line = reader.readLine()) != null) {

                                    System.out.println(line);

                                }

                            } finally {

                                reader.close();

                            }

                        } catch (IOException ioe) {

                            ioe.printStackTrace();

                        }

                    }

                }.start();

                // Consommation de la sortie d'erreur de l'application externe dans un Thread

                // separe

                new Thread() {

                    public void run() {

                        try {

                            BufferedReader reader = new BufferedReader(new InputStreamReader(p.getErrorStream()));

                            String line = "";

                            try {

                                while ((line = reader.readLine()) != null) {

                                    System.err.println(line);

                                }

                            } finally {

                                reader.close();

                            }

                        } catch (IOException ioe) {

                            ioe.printStackTrace();

                        }

                    }

                }.start();

                try {

                    p.waitFor();

                } catch (InterruptedException e2) {

                    e2.printStackTrace();

                }

            } catch (IOException e1) {

                e1.printStackTrace();

            }

        } else {

            System.err.println("L'adresse du serveur n'est pas en local (" + serverAdr + ").");

        }

        panel.taskEnded(0);

        if (pgFrame != null) {

            pgFrame.dispose();

        }

        f.dispose();

        String realIp = "127.0.0.1";

        realIp = getIp();

        try {

            pgFrameStart = new PostgreSQLFrame(realIp + " port " + "6543");

            pgFrameStart.setVisible(true);

        } catch (Exception e) {

            e.printStackTrace();

        }

    }

    private static String getIp() {

        String realIp = "127.0.0.1";

        try {

            InetAddress Ip = InetAddress.getLocalHost();

            realIp = Ip.getHostAddress();

        } catch (Exception e) {

            e.printStackTrace();

        }

        try {

            Enumeration<NetworkInterface> e = NetworkInterface.getNetworkInterfaces();

            while (e.hasMoreElements()) {

                NetworkInterface ni = (NetworkInterface) e.nextElement();

                Enumeration<InetAddress> e2 = ni.getInetAddresses();

                while (e2.hasMoreElements()) {

                    InetAddress ip = (InetAddress) e2.nextElement();

                    final String iip = ip.toString().replace('/', ' ').trim();

                    if (iip.startsWith("192")) {

                        return iip;

                    }

                }

            }

        } catch (Exception e) {

            e.printStackTrace();

        }

        return realIp;

    }

    // TODO : n'est plus utilisé

    public static PostgreSQLFrame pgFrameStart = null;

    private static JDialog frameExit = null;

    static public void askForExit() {

        askForExit(UserExitConf.DEFAULT);

    }

    static public void askForExit(UserExitConf conf) {

        JDialog exitDialog = new JDialog();

        exitDialog.setModal(true);

        if (frameExit == null) {

            frameExit = new JDialog();

            frameExit.setTitle("Quitter");

            frameExit.setModal(true);

            frameExit.setIconImages(Gestion.getFrameIcon());

            frameExit.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);

        }

        frameExit.setContentPane(new UserExitPanel(conf));

        frameExit.pack();

        frameExit.setResizable(false);

        frameExit.setLocationRelativeTo(null);

        frameExit.setAlwaysOnTop(true);

        frameExit.setVisible(true);

    }

    public static synchronized List<Image> getFrameIcon() {

        if (frameIcon == null) {

            frameIcon = new ArrayList<Image>();

            int[] sizes = { 16, 32, 48, 96 };

            for (int i = 0; i < sizes.length; i++) {

                int v = sizes[i];

                try {

                    frameIcon.add(new ImageIcon(Gestion.class.getResource(v + ".png")).getImage());

                } catch (Exception e) {

                    ExceptionHandler.die("Impossible de charger l'icone de fenetre " + v + ".png");

                }

            }

        }

        return frameIcon;

    }

}