[RÉGLÉ] connexion à la base de données

[sultanb]

Bonsoir à tous,
mon site était en sous domaine et fonctionnait bien mais depuis j'ai acheté un serveur dédié sur lequel j'ai transfére mon site, le fichier configuration n'arrive pas à se connecter à la base de données pourtant tout est bien configuré.
voici le message d'erreur: " Error displaying the error page: Application Instantiation Error: Could not connect to MySQL."
mon site tourne avec joomla 3.5.1 et le serveur php5.5

merci d'avance pour vos réponses

[SimonG]

Re : connexion à la base de données

Bonjour,

as-tu bien modifié ce fichier configuration.php avec les bonnes valeurs ?
Cela peut être fait avec MoovJla :

http://www.joomxtensions.com/moovjla.html

[sultanb]

Re : connexion à la base de données

Bonjour SimonG,
malgré la configuration avec moovla c'est le même message d'erreur qui s'affiche. Mon serveur dédié est chez LWS

[chabi01]

Re : connexion à la base de données

Bonjour,
Reprends les choses du début :
- as tu bien créé une base de données pour ton site sur ton dédié ?
- as tu bien tous les codes nécessaires pour t'y connecter (serveur, nom de la base, nom utilisateur, mot de passe) ?

Cordialement,

[sultanb]

Re : connexion à la base de données

[EDIT MODO] Arrêter de mettre vos mots de passe en clair !!!! [/MODO]

<?php 
class JConfig {
  public $offline = '0';
  public $offline_message = 'Ce site est en maintenance.<br /> Merci de revenir ultérieurement.';
    public $display_offline_message = '1';
    public $offline_image = '';
  public $sitename = 'EW Enterprise';
  public $editor = 'jce';
    public $captcha = '0';
  public $list_limit = '20';
  public $access = '1';
  public $debug = '';
  public $debug_lang = '0';
  public $dbtype = 'mysql';
  public $host = '192.162.69.190';
  public $user = 'xxxxxx';
  public $password = 'xxxxxxx';
  public $db = 'xxxxxxx';
  public $dbprefix = 'xxxxx_';
  public $live_site = '';
  public $secret = 'xxxxx';
  public $gzip = '0';
  public $error_reporting = 'default';
  public $helpurl = 'https://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}';
  public $ftp_host = '';
  public $ftp_port = '';
  public $ftp_user = '';
  public $ftp_pass = '';
  public $ftp_root = '';
  public $ftp_enable = '0';
  public $offset = 'UTC';
    public $mailonline = '1';
  public $mailer = 'smtp';
  public $mailfrom = 'xxx@xxxx.net';
  public $fromname = 'xxxxx';
  public $sendmail = '/usr/sbin/sendmail';
  public $smtpauth = '1';
  public $smtpuser = 'xxxx@xxxxxx';
  public $smtppass = 'xxxxx';
  public $smtphost = 'xxxxxx;
  public $smtpsecure = 'none';
  public $smtpport = '25';
  public $caching = '0';
  public $cache_handler = 'file';
  public $cachetime = '15';
  public $MetaDesc = 'agence web à abidjan, conception de site web, webmarketing, smspro, logiciel...';
  public $MetaKeys = '';
  public $MetaTitle = '1';
  public $MetaAuthor = '1';
  public $MetaVersion = '0'; 
    public $robots = '';
  public $sef = '1';
  public $sef_rewrite = '0';
  public $sef_suffix = '0';
  public $unicodeslugs = '0';
  public $feed_limit = '10';
  public $log_path = '/var/www/clients/client2/web20/web/logs';
  public $tmp_path = '/var/www/clients/client2/web20/web/tmp';
  public $lifetime = '15';
  public $session_handler = 'database'; 
  public $memcache_persist = '1'; 
  public $memcache_compress = '0'; 
  public $memcache_server_host = 'localhost'; 
  public $memcache_server_port = '11211'; 
  public $memcached_persist = '1'; 
  public $memcached_compress = '0'; 
  public $memcached_server_host = 'localhost'; 
  public $memcached_server_port = '11211'; 
  public $massmailoff = '0'; 
  public $MetaRights = '';
  public $sitename_pagetitles = '0';
  public $force_ssl = '0';
  public $frontediting = '1';
  public $feed_email = 'author';
  public $cookie_domain = '';
  public $cookie_path = '';
  public $asset_id = '1';
  public $proxy_enable = '0';
  public $proxy_host = '';
  public $proxy_port = '';
  public $proxy_user = '';
  public $proxy_pass = '';
  public $session_memcache_server_host = 'localhost'; 
  public $session_memcache_server_port = '11211'; 
  public $session_memcached_server_host = 'localhost'; 
  public $session_memcached_server_port = '11211'; 
  public $redis_persist = '1'; 
  public $redis_server_host = 'localhost'; 
  public $redis_server_port = '6379'; 
  public $redis_server_auth = ''; 
  public $redis_server_db = '0'; 
}

C'est le fichier configuration qui est sur le serveur dedié

[sultanb]

Re : connexion à la base de données

voici le site en sous demaine qui marche très bien http://services.evasionweb.net
maintenant sur mon serveur dédié j'ai pris un nouveau nom de domaine http://www.ewtechnologie.com.
Voici le fichier configuration dans le sous domaine
[EDIT MODO]Vous vous rendez compte que vous êtes sur un forum public ? ARRETEZ DE POSTER VOS MOTS DE PASSE EN CLAIR !!!![/MODO]

<?php
class JConfig {
    public $offline = '0';
    public $offline_message = 'Ce site est en maintenance.<br /> Merci de revenir ultérieurement.';
    public $display_offline_message = '1';
    public $offline_image = '';
    public $sitename = 'xxxxxxx';
    public $editor = 'jce';
    public $captcha = '0';
    public $list_limit = '20';
    public $access = '1';
    public $debug = '0';
    public $debug_lang = '0';
    public $dbtype = 'mysql';
    public $host = '91.216.107.248';
    public $user = 'xxxxxx';
    public $password = 'xxxxxxxxx';
    public $db = 'xxxxxxx';
    public $dbprefix = 'xxxxxx_';
    public $live_site = '';
    public $secret = 'xxxxxxx';
    public $gzip = '0';
    public $error_reporting = 'default';
    public $helpurl = 'https://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}';
    public $ftp_host = '';
    public $ftp_port = '';
    public $ftp_user = '';
    public $ftp_pass = '';
    public $ftp_root = '';
    public $ftp_enable = '0';
    public $offset = 'UTC';
    public $mailonline = '1';
    public $mailer = 'smtp';
    public $mailfrom = 'xxxxx@xxxxxxx';
    public $fromname = 'xxxxxxx';
    public $sendmail = '/usr/sbin/sendmail';
    public $smtpauth = '1';
    public $smtpuser = 'xxxxx@xxxxx.net';
    public $smtppass = 'xxxxx';
    public $smtphost = 'xxxxxxxx';
    public $smtpsecure = 'none';
    public $smtpport = '25';
    public $caching = '0';
    public $cache_handler = 'file';
    public $cachetime = '15';
    public $MetaDesc = 'agence web Ã* abidjan, conception de site web, webmarketing, smspro, logiciel...';
    public $MetaKeys = '';
    public $MetaTitle = '1';
    public $MetaAuthor = '1';
    public $MetaVersion = '0';
    public $robots = '';
    public $sef = '1';
    public $sef_rewrite = '0';
    public $sef_suffix = '0';
    public $unicodeslugs = '0';
    public $feed_limit = '10';
    public $log_path = '/htdocs/styltech/logs';
    public $tmp_path = '/htdocs/styltech/tmp';
    public $lifetime = '15';
    public $session_handler = 'database';
    public $memcache_persist = '1';
    public $memcache_compress = '0';
    public $memcache_server_host = 'localhost';
    public $memcache_server_port = '11211';
    public $memcached_persist = '1';
    public $memcached_compress = '0';
    public $memcached_server_host = 'localhost';
    public $memcached_server_port = '11211';
    public $redis_persist = '1';
    public $redis_server_host = 'localhost';
    public $redis_server_port = '6379';
    public $redis_server_auth = '';
    public $redis_server_db = '0';
    public $proxy_enable = '0';
    public $proxy_host = '';
    public $proxy_port = '';
    public $proxy_user = '';
    public $proxy_pass = '';
    public $massmailoff = '0';
    public $MetaRights = '';
    public $sitename_pagetitles = '0';
    public $force_ssl = '0';
    public $session_memcache_server_host = 'localhost';
    public $session_memcache_server_port = '11211';
    public $session_memcached_server_host = 'localhost';
    public $session_memcached_server_port = '11211';
    public $frontediting = '1';
    public $feed_email = 'author';
    public $cookie_domain = '';
    public $cookie_path = '';
    public $asset_id = '1';
}

[chabi01]

Re : connexion à la base de données

Petites choses que je vois :
- Pourquoi es-tu en mysql et pas en mysqli ?

- Pour quoi ton hôte est déclaré sur l'ip du serveur ?
En théorie, tu devrais être en "localhost" et pas sur l'ip du serveur : mysql est fermé par défaut dans sa config (sauf si tu as modifié la config de mysql et que tu as modifié ce qu'écoute mysql, la config par défaut est localhost/120.0.0.1).
Change l'adresse ip du host en "localhost" et vois si cela ne va pas mieux...

Cordialement,

[RobertG]

Re : connexion à la base de données

Si c'est le fichier de configuration du sous-domaine, il ne permettra pas de savoir quelle erreur concerne l'accès à la base du nouveau domaine.
Je note seulement que pour "host", en général sur un dédié, c'est "localhost" qui est utilisé et non une IP (mais je peux me tromper). Donc voir de ce côté, si les paramètres user, password et dbprefix sont corrects.

[sultanb]

Re : connexion à la base de données

j'ai changer le host en localhost mais il y a un nouveau message d'erreur:

La page ewtechnologie.com ne fonctionne pas

Impossible de traiter cette demande via ewtechnologie.com à l'heure actuelle.
HTTP ERROR 500,

cordialement;

[sultanb]

Re : connexion à la base de données

j'ai fait la mis à jur de joommla 3.5.0 à 3.5.1 avant le transfert et quand je verifie mon log du serveur voici le message d'erreur:

[Wed Jul 13 02:17:52.780675 2016] [:error] [pid 8959] [client 41.66.53.160:63201] FastCGI: server "/var/www/clients/client2/web20/cgi-bin/php5-fcgi-*-80-ewtechnologie.com" stderr: PHP message: PHP Fatal error: Class 'JBrowser' not found in /var/www/clients/client2/web20/web/libraries/cms/html/html.php on line 315

voici le contenu de mon fichier html.php

<?php
/**
 * @package     Joomla.Libraries
 * @subpackage  HTML
 *
 * @copyright   Copyright (C) 2005 - 2016 Open Source Matters, Inc. All rights reserved.
 * @license     GNU General Public License version 2 or later; see LICENSE
 */

defined('JPATH_PLATFORM') or die;

jimport('joomla.environment.browser');
jimport('joomla.filesystem.file');
jimport('joomla.filesystem.path');
jimport('joomla.utilities.arrayhelper');

/**
 * Utility class for all HTML drawing classes
 *
 * @since  1.5
 */
abstract class JHtml
{
  /**
   * Option values related to the generation of HTML output. Recognized
   * options are:
   *     fmtDepth, integer. The current indent depth.
   *     fmtEol, string. The end of line string, default is linefeed.
   *     fmtIndent, string. The string to use for indentation, default is
   *     tab.
   *
   * @var    array
   * @since  1.5
   */
  public static $formatOptions = array('format.depth' => 0, 'format.eol' => "\n", 'format.indent' => "\t");

  /**
   * An array to hold included paths
   *
   * @var    array
   * @since  1.5
   */
  protected static $includePaths = array();

  /**
   * An array to hold method references
   *
   * @var    array
   * @since  1.6
   */
  protected static $registry = array();

  /**
   * Method to extract a key
   *
   * @param   string  $key  The name of helper method to load, (prefix).(class).function
   *                        prefix and class are optional and can be used to load custom html helpers.
   *
   * @return  array  Contains lowercase key, prefix, file, function.
   *
   * @since   1.6
   */
  protected static function extract($key)
  {
    $key = preg_replace('#[^A-Z0-9_\.]#i', '', $key);

    // Check to see whether we need to load a helper file
    $parts = explode('.', $key);

    $prefix = (count($parts) == 3 ? array_shift($parts) : 'JHtml');
    $file = (count($parts) == 2 ? array_shift($parts) : '');
    $func = array_shift($parts);

    return array(strtolower($prefix . '.' . $file . '.' . $func), $prefix, $file, $func);
  }

  /**
   * Class loader method
   *
   * Additional arguments may be supplied and are passed to the sub-class.
   * Additional include paths are also able to be specified for third-party use
   *
   * @param   string  $key  The name of helper method to load, (prefix).(class).function
   *                        prefix and class are optional and can be used to load custom
   *                        html helpers.
   *
   * @return  mixed  Result of JHtml::call($function, $args)
   *
   * @since   1.5
   * @throws  InvalidArgumentException
   */
  public static function _($key)
  {
    list($key, $prefix, $file, $func) = static::extract($key);

    if (array_key_exists($key, static::$registry))
    {
      $function = static::$registry[$key];
      $args = func_get_args();

      // Remove function name from arguments
      array_shift($args);

      return static::call($function, $args);
    }

    $className = $prefix . ucfirst($file);

    if (!class_exists($className))
    {
      $path = JPath::find(static::$includePaths, strtolower($file) . '.php');

      if ($path)
      {
        require_once $path;

        if (!class_exists($className))
        {
          throw new InvalidArgumentException(sprintf('%s not found.', $className), 500);
        }
      }
      else
      {
        throw new InvalidArgumentException(sprintf('%s %s not found.', $prefix, $file), 500);
      }
    }

    $toCall = array($className, $func);

    if (is_callable($toCall))
    {
      static::register($key, $toCall);
      $args = func_get_args();

      // Remove function name from arguments
      array_shift($args);

      return static::call($toCall, $args);
    }
    else
    {
      throw new InvalidArgumentException(sprintf('%s::%s not found.', $className, $func), 500);
    }
  }

  /**
   * Registers a function to be called with a specific key
   *
   * @param   string  $key       The name of the key
   * @param   string  $function  Function or method
   *
   * @return  boolean  True if the function is callable
   *
   * @since   1.6
   */
  public static function register($key, $function)
  {
    list($key) = static::extract($key);

    if (is_callable($function))
    {
      static::$registry[$key] = $function;

      return true;
    }

    return false;
  }

  /**
   * Removes a key for a method from registry.
   *
   * @param   string  $key  The name of the key
   *
   * @return  boolean  True if a set key is unset
   *
   * @since   1.6
   */
  public static function unregister($key)
  {
    list($key) = static::extract($key);

    if (isset(static::$registry[$key]))
    {
      unset(static::$registry[$key]);

      return true;
    }

    return false;
  }

  /**
   * Test if the key is registered.
   *
   * @param   string  $key  The name of the key
   *
   * @return  boolean  True if the key is registered.
   *
   * @since   1.6
   */
  public static function isRegistered($key)
  {
    list($key) = static::extract($key);

    return isset(static::$registry[$key]);
  }

  /**
   * Function caller method
   *
   * @param   callable  $function  Function or method to call
   * @param   array     $args      Arguments to be passed to function
   *
   * @return  mixed   Function result or false on error.
   *
   * @see     http://php.net/manual/en/function.call-user-func-array.php
   * @since   1.6
   * @throws  InvalidArgumentException
   */
  protected static function call($function, $args)
  {
    if (!is_callable($function))
    {
      throw new InvalidArgumentException('Function not supported', 500);
    }

    // PHP 5.3 workaround
    $temp = array();

    foreach ($args as &$arg)
    {
      $temp[] = &$arg;
    }

    return call_user_func_array($function, $temp);
  }

  /**
   * Write a `<a>` element
   *
   * @param   string  $url      The relative URL to use for the href attribute
   * @param   string  $text     The target attribute to use
   * @param   array   $attribs  An associative array of attributes to add
   *
   * @return  string
   *
   * @since   1.5
   */
  public static function link($url, $text, $attribs = null)
  {
    if (is_array($attribs))
    {
      $attribs = JArrayHelper::toString($attribs);
    }

    return '<a href="' . $url . '" ' . $attribs . '>' . $text . '</a>';
  }

  /**
   * Write a `<iframe>` element
   *
   * @param   string  $url       The relative URL to use for the src attribute.
   * @param   string  $name      The target attribute to use.
   * @param   array   $attribs   An associative array of attributes to add.
   * @param   string  $noFrames  The message to display if the iframe tag is not supported.
   *
   * @return  string
   *
   * @since   1.5
   */
  public static function iframe($url, $name, $attribs = null, $noFrames = '')
  {
    if (is_array($attribs))
    {
      $attribs = JArrayHelper::toString($attribs);
    }

    return '<iframe src="' . $url . '" ' . $attribs . ' name="' . $name . '">' . $noFrames . '</iframe>';
  }

  /**
   * Com**** the files to be included
   *
   * @param   string   $folder          folder name to search into (images, css, js, ...).
   * @param   string   $file            path to file.
   * @param   boolean  $relative        path to file is relative to /media folder  (and searches in template).
   * @param   boolean  $detect_browser  detect browser to include specific browser files.
   * @param   boolean  $detect_debug    detect debug to include compressed files if debug is on.
   *
   * @return  array    files to be included.
   *
   * @see     JBrowser
   * @since   1.6
   */
  protected static function includeRelativeFiles($folder, $file, $relative, $detect_browser, $detect_debug)
  {
    // If http is present in filename
    if (strpos($file, 'http') === 0 || strpos($file, '//') === 0)
    {
      $includes = array($file);
    }
    else
    {
      // Extract extension and strip the file
      $strip = JFile::stripExt($file);
      $ext   = JFile::getExt($file);

      // Prepare array of files
      $includes = array();

      // Detect browser and com**** potential files
      if ($detect_browser)
      {
        $browser = JBrowser::getInstance();
        $browser = $navigator->getBrowser();
        $major = $navigator->getMajor();
        $minor = $navigator->getMinor();

        // Try to include files named filename.ext, filename_browser.ext, filename_browser_major.ext, filename_browser_major_minor.ext
        // where major and minor are the browser version names
        $potential = array($strip, $strip . '_' . $browser,  $strip . '_' . $browser . '_' . $major,
          $strip . '_' . $browser . '_' . $major . '_' . $minor);
      }
      else
      {
        $potential = array($strip);
      }

      // If relative search in template directory or media directory
      if ($relative)
      {
        // Get the template
        $template = JFactory::getApplication()->getTemplate();

        // For each potential files
        foreach ($potential as $strip)
        {
          $files = array();

          // Detect debug mode
          if ($detect_debug && JFactory::getConfig()->get('debug'))
          {
            /*
             * Detect if we received a file in the format name.min.ext
             * If so, strip the .min part out, otherwise append -uncompressed
             */
            if (strrpos($strip, '.min', '-4'))
            {
              $position = strrpos($strip, '.min', '-4');
              $filename = str_replace('.min', '.', $strip, $position);
              $files[]  = $filename . $ext;
            }
            else
            {
              $files[] = $strip . '-uncompressed.' . $ext;
            }
          }

          $files[] = $strip . '.' . $ext;

          /*
           * Loop on 1 or 2 files and break on first found.
           * Add the content of the MD5SUM file located in the same folder to url to ensure cache browser refresh
           * This MD5SUM file must represent the signature of the folder content
           */
          foreach ($files as $file)
          {
            // If the file is in the template folder
            $path = JPATH_THEMES . "/$template/$folder/$file";

            if (file_exists($path))
            {
              $md5 = dirname($path) . '/MD5SUM';
              $includes[] = JUri::base(true) . "/templates/$template/$folder/$file" .
                (file_exists($md5) ? ('?' . file_get_contents($md5)) : '');

              break;
            }
            else
            {
              // If the file contains any /: it can be in an media extension subfolder
              if (strpos($file, '/'))
              {
                // Divide the file extracting the extension as the first part before /
                list($extension, $file) = explode('/', $file, 2);

                // If the file yet contains any /: it can be a plugin
                if (strpos($file, '/'))
                {
                  // Divide the file extracting the element as the first part before /
                  list($element, $file) = explode('/', $file, 2);

                  // Try to deal with plugins group in the media folder
                  $path = JPATH_ROOT . "/media/$extension/$element/$folder/$file";

                  if (file_exists($path))
                  {
                    $md5 = dirname($path) . '/MD5SUM';
                    $includes[] = JUri::root(true) . "/media/$extension/$element/$folder/$file" .
                      (file_exists($md5) ? ('?' . file_get_contents($md5)) : '');

                    break;
                  }

                  // Try to deal with classical file in a a media subfolder called element
                  $path = JPATH_ROOT . "/media/$extension/$folder/$element/$file";

                  if (file_exists($path))
                  {
                    $md5 = dirname($path) . '/MD5SUM';
                    $includes[] = JUri::root(true) . "/media/$extension/$folder/$element/$file" .
                      (file_exists($md5) ? ('?' . file_get_contents($md5)) : '');

                    break;
                  }

                  // Try to deal with system files in the template folder
                  $path = JPATH_THEMES . "/$template/$folder/system/$element/$file";

                  if (file_exists($path))
                  {
                    $md5 = dirname($path) . '/MD5SUM';
                    $includes[] = JUri::root(true) . "/templates/$template/$folder/system/$element/$file" .
                      (file_exists($md5) ? ('?' . file_get_contents($md5)) : '');

                    break;
                  }

                  // Try to deal with system files in the media folder
                  $path = JPATH_ROOT . "/media/system/$folder/$element/$file";

                  if (file_exists($path))
                  {
                    $md5 = dirname($path) . '/MD5SUM';
                    $includes[] = JUri::root(true) . "/media/system/$folder/$element/$file" .
                      (file_exists($md5) ? ('?' . file_get_contents($md5)) : '');

                    break;
                  }
                }
                else
                {
                  // Try to deals in the extension media folder
                  $path = JPATH_ROOT . "/media/$extension/$folder/$file";

                  if (file_exists($path))
                  {
                    $md5 = dirname($path) . '/MD5SUM';
                    $includes[] = JUri::root(true) . "/media/$extension/$folder/$file" .
                      (file_exists($md5) ? ('?' . file_get_contents($md5)) : '');

                    break;
                  }

                  // Try to deal with system files in the template folder
                  $path = JPATH_THEMES . "/$template/$folder/system/$file";

                  if (file_exists($path))
                  {
                    $md5 = dirname($path) . '/MD5SUM';
                    $includes[] = JUri::root(true) . "/templates/$template/$folder/system/$file" .
                      (file_exists($md5) ? ('?' . file_get_contents($md5)) : '');

                    break;
                  }

                  // Try to deal with system files in the media folder
                  $path = JPATH_ROOT . "/media/system/$folder/$file";

                  if (file_exists($path))
                  {
                    $md5 = dirname($path) . '/MD5SUM';
                    $includes[] = JUri::root(true) . "/media/system/$folder/$file" .
                      (file_exists($md5) ? ('?' . file_get_contents($md5)) : '');

                    break;
                  }
                }
              }
              // Try to deal with system files in the media folder
              else
              {
                $path = JPATH_ROOT . "/media/system/$folder/$file";

                if (file_exists($path))
                {
                  $md5 = dirname($path) . '/MD5SUM';
                  $includes[] = JUri::root(true) . "/media/system/$folder/$file" .
                      (file_exists($md5) ? ('?' . file_get_contents($md5)) : '');

                  break;
                }
              }
            }
          }
        }
      }
      // If not relative and http is not present in filename
      else
      {
        foreach ($potential as $strip)
        {
          $files = array();

          // Detect debug mode
          if ($detect_debug && JFactory::getConfig()->get('debug'))
          {
            /*
             * Detect if we received a file in the format name.min.ext
             * If so, strip the .min part out, otherwise append -uncompressed
             */
            if (strrpos($strip, '.min', '-4'))
            {
              $position = strrpos($strip, '.min', '-4');
              $filename = str_replace('.min', '.', $strip, $position);
              $files[]  = $filename . $ext;
            }
            else
            {
              $files[] = $strip . '-uncompressed.' . $ext;
            }
          }

          $files[] = $strip . '.' . $ext;

          /*
           * Loop on 1 or 2 files and break on first found.
           * Add the content of the MD5SUM file located in the same folder to url to ensure cache browser refresh
           * This MD5SUM file must represent the signature of the folder content
           */
          foreach ($files as $file)
          {
            $path = JPATH_ROOT . "/$file";

            if (file_exists($path))
            {
              $md5 = dirname($path) . '/MD5SUM';
              $includes[] = JUri::root(true) . "/$file" .
                (file_exists($md5) ? ('?' . file_get_contents($md5)) : '');

              break;
            }
          }
        }
      }
    }

    return $includes;
  }

  /**
   * Write a `<img>` element
   *
   * @param   string   $file      The relative or absolute URL to use for the src attribute.
   * @param   string   $alt       The alt text.
   * @param   mixed    $attribs   String or associative array of attribute(s) to use.
   * @param   boolean  $relative  Path to file is relative to /media folder (and searches in template).
   * @param   mixed    $path_rel  Return html tag without (-1) or with file computing(false). Return com****d path only (true).
   *
   * @return  string
   *
   * @since   1.5
   */
  public static function image($file, $alt, $attribs = null, $relative = false, $path_rel = false)
  {
    if ($path_rel !== -1)
    {
      $includes = static::includeRelativeFiles('images', $file, $relative, false, false);
      $file = count($includes) ? $includes[0] : null;
    }

    // If only path is required
    if ($path_rel)
    {
      return $file;
    }
    else
    {
      return '<img src="' . $file . '" alt="' . $alt . '" '
      . trim((is_array($attribs) ? JArrayHelper::toString($attribs) : $attribs) . ' /')
      . '>';
    }
  }

  /**
   * Write a `<link>` element to load a CSS file
   *
   * @param   string   $file            path to file
   * @param   array    $attribs         attributes to be added to the stylesheet
   * @param   boolean  $relative        path to file is relative to /media folder
   * @param   boolean  $path_only       return the path to the file only
   * @param   boolean  $detect_browser  detect browser to include specific browser css files
   *                                    will try to include file, `file_*browser*`, `file_*browser*_*major*`, `file_*browser*_*major*_*minor*`
   *                                    <table>
   *                                       <tr><th>Navigator</th>                  <th>browser</th>  <th>major.minor</th></tr>
   *
   *                                       <tr><td>Safari 3.0.x</td>               <td>konqueror</td>  <td>522.x</td></tr>
   *                                       <tr><td>Safari 3.1.x and 3.2.x</td>     <td>konqueror</td>  <td>525.x</td></tr>
   *                                       <tr><td>Safari 4.0 to 4.0.2</td>        <td>konqueror</td>  <td>530.x</td></tr>
   *                                       <tr><td>Safari 4.0.3 to 4.0.4</td>      <td>konqueror</td>  <td>531.x</td></tr>
   *                                       <tr><td>iOS 4.0 Safari</td>             <td>konqueror</td>  <td>532.x</td></tr>
   *                                       <tr><td>Safari 5.0</td>                 <td>konqueror</td>  <td>533.x</td></tr>
   *
   *                                       <tr><td>Google Chrome 1.0</td>          <td>konqueror</td>  <td>528.x</td></tr>
   *                                       <tr><td>Google Chrome 2.0</td>          <td>konqueror</td>  <td>530.x</td></tr>
   *                                       <tr><td>Google Chrome 3.0 and 4.x</td>  <td>konqueror</td>  <td>532.x</td></tr>
   *                                       <tr><td>Google Chrome 5.0</td>          <td>konqueror</td>  <td>533.x</td></tr>
   *
   *                                       <tr><td>Internet Explorer 5.5</td>      <td>msie</td>    <td>5.5</td></tr>
   *                                       <tr><td>Internet Explorer 6.x</td>      <td>msie</td>    <td>6.x</td></tr>
   *                                       <tr><td>Internet Explorer 7.x</td>      <td>msie</td>    <td>7.x</td></tr>
   *                                       <tr><td>Internet Explorer 8.x</td>      <td>msie</td>    <td>8.x</td></tr>
   *
   *                                       <tr><td>Firefox</td>                    <td>mozilla</td>  <td>5.0</td></tr>
   *                                    </table>
   * @param   boolean  $detect_debug    detect debug to search for compressed files if debug is on
   *
   * @return  mixed  nothing if $path_only is false, null, path or array of path if specific css browser files were detected
   *
   * @see     JBrowser
   * @since   1.5
   */
  public static function stylesheet($file, $attribs = array(), $relative = false, $path_only = false, $detect_browser = true, $detect_debug = true)
  {
    $includes = static::includeRelativeFiles('css', $file, $relative, $detect_browser, $detect_debug);

    // If only path is required
    if ($path_only)
    {
      if (count($includes) == 0)
      {
        return null;
      }
      elseif (count($includes) == 1)
      {
        return $includes[0];
      }
      else
      {
        return $includes;
      }
    }
    // If inclusion is required
    else
    {
      $document = JFactory::getDocument();

      foreach ($includes as $include)
      {
        $document->addStylesheet($include, 'text/css', null, $attribs);
      }
    }
  }

  /**
   * Write a `<script>` element to load a JavaScript file
   *
   * @param   string   $file            path to file.
   * @param   boolean  $framework       load the JS framework.
   * @param   boolean  $relative        path to file is relative to /media folder.
   * @param   boolean  $path_only       return the path to the file only.
   * @param   boolean  $detect_browser  detect browser to include specific browser js files.
   * @param   boolean  $detect_debug    detect debug to search for compressed files if debug is on.
   *
   * @return  mixed  nothing if $path_only is false, null, path or array of path if specific js browser files were detected.
   *
   * @see     JHtml::stylesheet()
   * @since   1.5
   */
  public static function script($file, $framework = false, $relative = false, $path_only = false, $detect_browser = true, $detect_debug = true)
  {
    // Include MooTools framework
    if ($framework)
    {
      static::_('behavior.framework');
    }

    $includes = static::includeRelativeFiles('js', $file, $relative, $detect_browser, $detect_debug);

    // If only path is required
    if ($path_only)
    {
      if (count($includes) == 0)
      {
        return null;
      }
      elseif (count($includes) == 1)
      {
        return $includes[0];
      }
      else
      {
        return $includes;
      }
    }
    // If inclusion is required
    else
    {
      $document = JFactory::getDocument();

      foreach ($includes as $include)
      {
        $document->addScript($include);
      }
    }
  }

  /**
   * Set format related options.
   *
   * Updates the formatOptions array with all valid values in the passed array.
   *
   * @param   array  $options  Option key/value pairs.
   *
   * @return  void
   *
   * @see     JHtml::$formatOptions
   * @since   1.5
   */
  public static function setFormatOptions($options)
  {
    foreach ($options as $key => $val)
    {
      if (isset(static::$formatOptions[$key]))
      {
        static::$formatOptions[$key] = $val;
      }
    }
  }

  /**
   * Returns formated date according to a given format and time zone.
   *
   * @param   string   $input      String in a format accepted by date(), defaults to "now".
   * @param   string   $format     The date format specification string (see {@link PHP_MANUAL#date}).
   * @param   mixed    $tz         Time zone to be used for the date.  Special cases: boolean true for user
   *                               setting, boolean false for server setting.
   * @param   boolean  $gregorian  True to use Gregorian calendar.
   *
   * @return  string    A date translated by the given format and time zone.
   *
   * @see     strftime
   * @since   1.5
   */
  public static function date($input = 'now', $format = null, $tz = true, $gregorian = false)
  {
    // Get some system objects.
    $config = JFactory::getConfig();
    $user = JFactory::getUser();

    // UTC date converted to user time zone.
    if ($tz === true)
    {
      // Get a date object based on UTC.
      $date = JFactory::getDate($input, 'UTC');

      // Set the correct time zone based on the user configuration.
      $date->setTimeZone(new DateTimeZone($user->getParam('timezone', $config->get('offset'))));
    }
    // UTC date converted to server time zone.
    elseif ($tz === false)
    {
      // Get a date object based on UTC.
      $date = JFactory::getDate($input, 'UTC');

      // Set the correct time zone based on the server configuration.
      $date->setTimeZone(new DateTimeZone($config->get('offset')));
    }
    // No date conversion.
    elseif ($tz === null)
    {
      $date = JFactory::getDate($input);
    }
    // UTC date converted to given time zone.
    else
    {
      // Get a date object based on UTC.
      $date = JFactory::getDate($input, 'UTC');

      // Set the correct time zone based on the server configuration.
      $date->setTimeZone(new DateTimeZone($tz));
    }

    // If no format is given use the default locale based format.
    if (!$format)
    {
      $format = JText::_('DATE_FORMAT_LC1');
    }
    // $format is an existing language key
    elseif (JFactory::getLanguage()->hasKey($format))
    {
      $format = JText::_($format);
    }

    if ($gregorian)
    {
      return $date->format($format, true);
    }
    else
    {
      return $date->calendar($format, true);
    }
  }

  /**
   * Creates a tooltip with an image as button
   *
   * @param   string  $tooltip  The tip string.
   * @param   mixed   $title    The title of the tooltip or an associative array with keys contained in
   *                            {'title','image','text','href','alt'} and values corresponding to parameters of the same name.
   * @param   string  $image    The image for the tip, if no text is provided.
   * @param   string  $text     The text for the tip.
   * @param   string  $href     An URL that will be used to create the link.
   * @param   string  $alt      The alt attribute for img tag.
   * @param   string  $class    CSS class for the tool tip.
   *
   * @return  string
   *
   * @since   1.5
   */
  public static function tooltip($tooltip, $title = '', $image = 'tooltip.png', $text = '', $href = '', $alt = 'Tooltip', $class = 'hasTooltip')
  {
    if (is_array($title))
    {
      foreach (array('image', 'text', 'href', 'alt', 'class') as $param)
      {
        if (isset($title[$param]))
        {
          $$param = $title[$param];
        }
      }

      if (isset($title['title']))
      {
        $title = $title['title'];
      }
      else
      {
        $title = '';
      }
    }

    if (!$text)
    {
      $alt = htmlspecialchars($alt, ENT_COMPAT, 'UTF-8');
      $text = static::image($image, $alt, null, true);
    }

    if ($href)
    {
      $tip = '<a href="' . $href . '">' . $text . '</a>';
    }
    else
    {
      $tip = $text;
    }

    if ($class == 'hasTip')
    {
      // Still using MooTools tooltips!
      $tooltip = htmlspecialchars($tooltip, ENT_COMPAT, 'UTF-8');

      if ($title)
      {
        $title = htmlspecialchars($title, ENT_COMPAT, 'UTF-8');
        $tooltip = $title . '::' . $tooltip;
      }
    }
    else
    {
      $tooltip = self::tooltipText($title, $tooltip, 0);
    }

    return '<span class="' . $class . '" title="' . $tooltip . '">' . $tip . '</span>';
  }

  /**
   * Converts a double colon seperated string or 2 separate strings to a string ready for bootstrap tooltips
   *
   * @param   string  $title      The title of the tooltip (or combined '::' separated string).
   * @param   string  $content    The content to tooltip.
   * @param   int     $translate  If true will pass texts through JText.
   * @param   int     $escape     If true will pass texts through htmlspecialchars.
   *
   * @return  string  The tooltip string
   *
   * @since   3.1.2
   */
  public static function tooltipText($title = '', $content = '', $translate = 1, $escape = 1)
  {
    // Initialise return value.
    $result = '';

    // Don't process empty strings
    if ($content != '' || $title != '')
    {
      // Split title into title and content if the title contains '::' (old Mootools format).
      if ($content == '' && !(strpos($title, '::') === false))
      {
        list($title, $content) = explode('::', $title, 2);
      }

      // Pass texts through JText if required.
      if ($translate)
      {
        $title = JText::_($title);
        $content = JText::_($content);
      }

      // Use only the content if no title is given.
      if ($title == '')
      {
        $result = $content;
      }
      // Use only the title, if title and text are the same.
      elseif ($title == $content)
      {
        $result = '<strong>' . $title . '</strong>';
      }
      // Use a formatted string combining the title and content.
      elseif ($content != '')
      {
        $result = '<strong>' . $title . '</strong><br />' . $content;
      }
      else
      {
        $result = $title;
      }

      // Escape everything, if required.
      if ($escape)
      {
        $result = htmlspecialchars($result);
      }
    }

    return $result;
  }

  /**
   * Displays a calendar control field
   *
   * @param   string  $value    The date value
   * @param   string  $name     The name of the text field
   * @param   string  $id       The id of the text field
   * @param   string  $format   The date format
   * @param   mixed   $attribs  Additional HTML attributes
   *
   * @return  string  HTML markup for a calendar field
   *
   * @since   1.5
   */
  public static function calendar($value, $name, $id, $format = '%Y-%m-%d', $attribs = null)
  {
    static $done;

    if ($done === null)
    {
      $done = array();
    }

    $readonly = isset($attribs['readonly']) && $attribs['readonly'] == 'readonly';
    $disabled = isset($attribs['disabled']) && $attribs['disabled'] == 'disabled';

    if (is_array($attribs))
    {
      $attribs['class'] = isset($attribs['class']) ? $attribs['class'] : 'input-medium';
      $attribs['class'] = trim($attribs['class'] . ' hasTooltip');

      $attribs = JArrayHelper::toString($attribs);
    }

    static::_('bootstrap.tooltip');

    // Format value when not nulldate ('0000-00-00 00:00:00'), otherwise blank it as it would result in 1970-01-01.
    if ($value && $value != JFactory::getDbo()->getNullDate() && strtotime($value) !== false)
    {
      $tz = date_default_timezone_get();
      date_default_timezone_set('UTC');
      $inputvalue = strftime($format, strtotime($value));
      date_default_timezone_set($tz);
    }
    else
    {
      $inputvalue = '';
    }

    // Load the calendar behavior
    static::_('behavior.calendar');

    // Only display the triggers once for each control.
    if (!in_array($id, $done))
    {
      $document = JFactory::getDocument();
      $document
        ->addScriptDeclaration(
        'jQuery(document).ready(function($) {Calendar.setup({
      // Id of the input field
      inputField: "' . $id . '",
      // Format of the input field
      ifFormat: "' . $format . '",
      // Trigger for the calendar (button ID)
      button: "' . $id . '_img",
      // Alignment (defaults to "Bl")
      align: "Tl",
      singleClick: true,
      firstDay: ' . JFactory::getLanguage()->getFirstDay() . '
      });});'
      );
      $done[] = $id;
    }

    // Hide button using inline styles for readonly/disabled fields
    $btn_style = ($readonly || $disabled) ? ' style="display:none;"' : '';
    $div_class = (!$readonly && !$disabled) ? ' class="input-append"' : '';

    return '<div' . $div_class . '>'
        . '<input type="text" title="' . ($inputvalue ? static::_('date', $value, null, null) : '')
        . '" name="' . $name . '" id="' . $id . '" value="' . htmlspecialchars($inputvalue, ENT_COMPAT, 'UTF-8') . '" ' . $attribs . ' />'
        . '<button type="button" class="btn" id="' . $id . '_img"' . $btn_style . '><span class="icon-calendar"></span></button>'
      . '</div>';
  }

  /**
   * Add a directory where JHtml should search for helpers. You may
   * either pass a string or an array of directories.
   *
   * @param   string  $path  A path to search.
   *
   * @return  array  An array with directory elements
   *
   * @since   1.5
   */
  public static function addIncludePath($path = '')
  {
    // Force path to array
    settype($path, 'array');

    // Loop through the path directories
    foreach ($path as $dir)
    {
      if (!empty($dir) && !in_array($dir, static::$includePaths))
      {
        array_unshift(static::$includePaths, JPath::clean($dir));
      }
    }

    return static::$includePaths;
  }

  /**
   * Internal method to get a JavaScript object notation string from an array
   *
   * @param   array  $array  The array to convert to JavaScript object notation
   *
   * @return  string  JavaScript object notation representation of the array
   *
   * @deprecated 4.0 use json_encode or JRegistry::toString('json')
   *
   * @since   3.0
   */
  public static function getJSObject(array $array = array())
  {
    JLog::add(__METHOD__ . ' is deprecated. Use json_encode instead.', JLog::WARNING, 'deprecated');

    $elements = array();

    foreach ($array as $k => $v)
    {
      // Don't encode either of these types
      if (is_null($v) || is_resource($v))
      {
        continue;
      }

      // Safely encode as a Javascript string
      $key = json_encode((string) $k);

      if (is_bool($v))
      {
        $elements[] = $key . ': ' . ($v ? 'true' : 'false');
      }
      elseif (is_numeric($v))
      {
        $elements[] = $key . ': ' . ($v + 0);
      }
      elseif (is_string($v))
      {
        if (strpos($v, '\\') === 0)
        {
          // Items such as functions and JSON objects are prefixed with \, strip the prefix and don't encode them
          $elements[] = $key . ': ' . substr($v, 1);
        }
        else
        {
          // The safest way to insert a string
          $elements[] = $key . ': ' . json_encode((string) $v);
        }
      }
      else
      {
        $elements[] = $key . ': ' . static::getJSObject(is_object($v) ? get_object_vars($v) : $v);
      }
    }

    return '{' . implode(',', $elements) . '}';
  }
}

aidez moi svp

[chabi01]

Re : connexion à la base de données

Bonjour,
Cela semble correspondre à ce souci : https://docs.joomla.org/J3.x:Missing...fter_upgrading
A vérifier.

Cordialement,

[sultanb]

Re : connexion à la base de données

Bonjour chabi01 j'ai fait tout ce qu'il on dit mais l'erreur persiste.
Je cherche toujours
cordialement,

[chabi01]

Re : connexion à la base de données

Bon. Il va falloir évacuer les problèmes au fur et à mesure.

Tu vas créer un sous domaine sur ton dédié. Installe un Joomla vierge. Est-ce que tu arrives au bout avec un Joomla opérationnel ?
Objectif : vérifier que tu sais bien installer un site, créer une base de données, un domaine/sous domaine sur un dédié, vérifier que le serveur est opérationnel.

Même si tu réponds sans tester "bien sur que je sais faire ça !", fais le quand même pour vérifier que par rapport à ce que tu fais habituellement, le fonctionnement sur le serveur est normal.

Si cela marche correctement, alors le problème vient du site.
Si non, alors c'est ton dédié qui a un souci ou toi qui te plantes sur un paramètre dans ton site pour l'utiliser.

Cordialement,

[lefabdu51]

Re : connexion à la base de données

bonjour, pour ce qui est de localhost ou une adresse ip pour le serveur mysql, tout dépend si la bdd est sur le meme serveur que le site ou non.

Si on met une adresse ip, c est que c est une base distante qui est située sur un autre serveur que le serveur ou est le site.

Pour ce qui est du type de serveur, il y encore du temps avant de voir disparaitre mysql, vu que ce type de base de donnée est encore très très utilisé.
La d'apres tes fichiers de config, tu as une base de données sur une ip, la base de ton second site sur une seconde ip et ton site sur une troisième ip.

Pour ton erreur 500, peut tu modifier le fichier php.ini afin d'avoir touts les messages d'erreur ?

si tu ne peut ou ne sait pas, que disent les rapports de logs du serveur ?

[sultanb]

Re : connexion à la base de données

Bonjour lefabdu51,
je vais suivre ton conseil et je te revient merci d'avance.

cordialement,