Ubuntu-fr

bobe

Re : Problème PHPMYADMIN

La commande a2enconf se contente de faire un lien de la configuration ciblée du dossier  conf-available/ vers le dossier conf-enabled/. Si tu as un lien phpmyadmin.conf ans le dossier conf-enabled/, ce fichier de configuration sera lu par apache, donc c'est tout bon de ce coté là.

Mais en appelant http://localhost/, ça te dit toujours que la connexion est refusée ? Alors même qu'apache2 est lancé. C'est insolite ça ^^
Refais la commande suivante pour vérifier si apache2 est en écoute sur le port 80 :

sudo netstat -tlp

koaz

Re : Problème PHPMYADMIN

En tapant juste localhost ca fonctionne ! La ou ca ne fonctionne pas c'est le moment ou je veux allez sur phpmyadmin.

Tient :

Connexions Internet actives (seulement serveurs)
Proto Recv-Q Send-Q Adresse locale          Adresse distante        Etat       PID/Program name    
tcp        0      0 localhost:mysql         0.0.0.0:*               LISTEN      978/mysqld          
tcp        0      0 localhost:domain        0.0.0.0:*               LISTEN      659/systemd-resolve 
tcp        0      0 localhost:8118          0.0.0.0:*               LISTEN      863/privoxy         
tcp        0      0 localhost:ipp           0.0.0.0:*               LISTEN      699/cupsd           
tcp        0      0 localhost:33060         0.0.0.0:*               LISTEN      978/mysqld          
tcp6       0      0 [::]:http               [::]:*                  LISTEN      916/apache2         
tcp6       0      0 ip6-localhost:8118      [::]:*                  LISTEN      863/privoxy         
tcp6       0      0 ip6-localhost:ipp       [::]:*                  LISTEN      699/cupsd     

bobe

Re : Problème PHPMYADMIN

Je récapitule :

Si tu tapes http://localhost/
Ça liste le contenu du dossier /var/www

Si tu tapes http://localhost/phpmyadmin/
Ça donne le message :

Ce site est inaccessible localhost n'autorise pas la connexion.
Voici quelques conseils :

Vérifier la connexion
Vérifier le proxy et le pare-feu
ERR_CONNECTION_REFUSED

?

koaz

Re : Problème PHPMYADMIN

Alors le premier oui exact.

Le deuxieme viens de changer cela me donne ca :

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Main loader script
 *
 * @package PhpMyAdmin
 */
use PhpMyAdmin\Charsets;
use PhpMyAdmin\Config;
use PhpMyAdmin\Core;
use PhpMyAdmin\Display\GitRevision;
use PhpMyAdmin\LanguageManager;
use PhpMyAdmin\Message;
use PhpMyAdmin\RecentFavoriteTable;
use PhpMyAdmin\Relation;
use PhpMyAdmin\Response;
use PhpMyAdmin\Sanitize;
use PhpMyAdmin\Server\Select;
use PhpMyAdmin\ThemeManager;
use PhpMyAdmin\Url;
use PhpMyAdmin\Util;
use PhpMyAdmin\UserPreferences;

/**
 * Gets some core libraries and displays a top message if required
 */
require_once 'libraries/common.inc.php';

/**
 * pass variables to child pages
 */
$drops = array(
    'lang',
    'server',
    'collation_connection',
    'db',
    'table'
);
foreach ($drops as $each_drop) {
    if (array_key_exists($each_drop, $_GET)) {
        unset($_GET[$each_drop]);
    }
}
unset($drops, $each_drop);

/*
 * Black list of all scripts to which front-end must submit data.
 * Such scripts must not be loaded on home page.
 *
 */
$target_blacklist = array (
    'import.php', 'export.php'
);

// If we have a valid target, let's load that script instead
if (! empty($_REQUEST['target'])
    && is_string($_REQUEST['target'])
    && ! preg_match('/^index/', $_REQUEST['target'])
    && ! in_array($_REQUEST['target'], $target_blacklist)
    && Core::checkPageValidity($_REQUEST['target'], [], true)
) {
    include $_REQUEST['target'];
    exit;
}

if (isset($_REQUEST['ajax_request']) && ! empty($_REQUEST['access_time'])) {
    exit;
}

// user selected font size
if (isset($_POST['set_fontsize']) && preg_match('/^[0-9.]+(px|em|pt|\%)$/', $_POST['set_fontsize'])) {
    $GLOBALS['PMA_Config']->setUserValue(
        null,
        'FontSize',
        $_POST['set_fontsize'],
        '82%'
    );
    header('Location: index.php' . Url::getCommonRaw());
    exit();
}
// if user selected a theme
if (isset($_POST['set_theme'])) {
    $tmanager = ThemeManager::getInstance();
    $tmanager->setActiveTheme($_POST['set_theme']);
    $tmanager->setThemeCookie();

    $userPreferences = new UserPreferences();
    $prefs = $userPreferences->load();
    $prefs["config_data"]["ThemeDefault"] = $_POST['set_theme'];
    $userPreferences->save($prefs["config_data"]);

    header('Location: index.php' . Url::getCommonRaw());
    exit();
}
// Change collation connection
if (isset($_POST['collation_connection'])) {
    $GLOBALS['PMA_Config']->setUserValue(
        null,
        'DefaultConnectionCollation',
        $_POST['collation_connection'],
        'utf8mb4_unicode_ci'
    );
    header('Location: index.php' . Url::getCommonRaw());
    exit();
}


// See FAQ 1.34
if (! empty($_REQUEST['db'])) {
    $page = null;
    if (! empty($_REQUEST['table'])) {
        $page = Util::getScriptNameForOption(
            $GLOBALS['cfg']['DefaultTabTable'], 'table'
        );
    } else {
        $page = Util::getScriptNameForOption(
            $GLOBALS['cfg']['DefaultTabDatabase'], 'database'
        );
    }
    include $page;
    exit;
}

$response = Response::getInstance();
/**
 * Check if it is an ajax request to reload the recent tables list.
 */
if ($response->isAjax() && ! empty($_REQUEST['recent_table'])) {
    $response->addJSON(
        'list',
        RecentFavoriteTable::getInstance('recent')->getHtmlList()
    );
    exit;
}

if ($GLOBALS['PMA_Config']->isGitRevision()) {
    // If ajax request to get revision
    if (isset($_REQUEST['git_revision']) && $response->isAjax()) {
        GitRevision::display();
        exit;
    }
    // Else show empty html
    echo '<div id="is_git_revision"></div>';
}

// Handles some variables that may have been sent by the calling script
$GLOBALS['db'] = '';
$GLOBALS['table'] = '';
$show_query = '1';

// Any message to display?
if (! empty($message)) {
    echo Util::getMessage($message);
    unset($message);
}
if (isset($_SESSION['partial_logout'])) {
    Message::success(
        __('You were logged out from one server, to logout completely from phpMyAdmin, you need to logout from all servers.')
    )->display();
    unset($_SESSION['partial_logout']);
}

$common_url_query =  Url::getCommon();
$mysql_cur_user_and_host = '';

// when $server > 0, a server has been chosen so we can display
// all MySQL-related information
if ($server > 0) {
    include 'libraries/server_common.inc.php';

    // Use the verbose name of the server instead of the hostname
    // if a value is set
    $server_info = '';
    if (! empty($cfg['Server']['verbose'])) {
        $server_info .= htmlspecialchars($cfg['Server']['verbose']);
        if ($GLOBALS['cfg']['ShowServerInfo']) {
            $server_info .= ' (';
        }
    }
    if ($GLOBALS['cfg']['ShowServerInfo'] || empty($cfg['Server']['verbose'])) {
        $server_info .= $GLOBALS['dbi']->getHostInfo();
    }
    if (! empty($cfg['Server']['verbose']) && $GLOBALS['cfg']['ShowServerInfo']) {
        $server_info .= ')';
    }
    $mysql_cur_user_and_host = $GLOBALS['dbi']->fetchValue('SELECT USER();');

    // should we add the port info here?
    $short_server_info = (!empty($GLOBALS['cfg']['Server']['verbose'])
                ? $GLOBALS['cfg']['Server']['verbose']
                : $GLOBALS['cfg']['Server']['host']);
}

echo '<div id="maincontainer">' , "\n";
// Anchor for favorite tables synchronization.
echo RecentFavoriteTable::getInstance('favorite')->getHtmlSyncFavoriteTables();
echo '<div id="main_pane_left">';
if ($server > 0 || count($cfg['Servers']) > 1
) {
    if ($cfg['DBG']['demo']) {
        echo '<div class="group">';
        echo '<h2>' , __('phpMyAdmin Demo Server') , '</h2>';
        echo '<p class="cfg_dbg_demo">';
        printf(
            __(
                'You are using the demo server. You can do anything here, but '
                . 'please do not change root, debian-sys-maint and pma users. '
                . 'More information is available at %s.'
            ),
            '<a href="url.php?url=https://demo.phpmyadmin.net/" target="_blank" rel="noopener noreferrer">demo.phpmyadmin.net</a>'
        );
        echo '</p>';
        echo '</div>';
    }
    echo '<div class="group">';
    echo '<h2>' , __('General settings') , '</h2>';
    echo '<ul>';

    /**
     * Displays the MySQL servers choice form
     */
    if ($cfg['ServerDefault'] == 0
        || (! $cfg['NavigationDisplayServers']
        && (count($cfg['Servers']) > 1
        || ($server == 0 && count($cfg['Servers']) == 1)))
    ) {
        echo '<li id="li_select_server" class="no_bullets" >';
        echo Util::getImage('s_host') , " "
            , Select::render(true, true);
        echo '</li>';
    }

    /**
     * Displays the mysql server related links
     */
    if ($server > 0) {
        include_once 'libraries/check_user_privileges.inc.php';

        // Logout for advanced authentication
        if ($cfg['Server']['auth_type'] != 'config') {
            if ($cfg['ShowChgPassword']) {
                $conditional_class = 'ajax';
                Core::printListItem(
                    Util::getImage('s_passwd') . "&nbsp;" . __(
                        'Change password'
                    ),
                    'li_change_password',
                    'user_password.php' . $common_url_query,
                    null,
                    null,
                    'change_password_anchor',
                    "no_bullets",
                    $conditional_class
                );
            }
        } // end if
        echo '    <li id="li_select_mysql_collation" class="no_bullets" >';
        echo '        <form class="disableAjax" method="post" action="index.php">' , "\n"
           . Url::getHiddenInputs(null, null, 4, 'collation_connection')
           . '            <label for="select_collation_connection">' . "\n"
           . '                ' . Util::getImage('s_asci')
            . "&nbsp;" . __('Server connection collation') . "\n"
           // put the doc link in the form so that it appears on the same line
           . Util::showMySQLDocu('Charset-connection')
           . ': ' .  "\n"
           . '            </label>' . "\n"

           . Charsets::getCollationDropdownBox(
               $GLOBALS['dbi'],
               $GLOBALS['cfg']['Server']['DisableIS'],
               'collation_connection',
               'select_collation_connection',
               $collation_connection,
               true,
               true
           )
           . '        </form>' . "\n"
           . '    </li>' . "\n";
    } // end of if ($server > 0)
    echo '</ul>';
    echo '</div>';
}

echo '<div class="group">';
echo '<h2>' , __('Appearance settings') , '</h2>';
echo '  <ul>';

// Displays language selection combo
$language_manager = LanguageManager::getInstance();
if (empty($cfg['Lang']) && $language_manager->hasChoice()) {
    echo '<li id="li_select_lang" class="no_bullets">';

    echo Util::getImage('s_lang') , " "
        , $language_manager->getSelectorDisplay();
    echo '</li>';
}

// ThemeManager if available

if ($GLOBALS['cfg']['ThemeManager']) {
    echo '<li id="li_select_theme" class="no_bullets">';
    echo Util::getImage('s_theme') , " "
            ,  ThemeManager::getInstance()->getHtmlSelectBox();
    echo '</li>';
}
echo '<li id="li_select_fontsize">';
echo Config::getFontsizeForm();
echo '</li>';

echo '</ul>';

// User preferences

if ($server > 0) {
    echo '<ul>';
    Core::printListItem(
        Util::getImage('b_tblops') . "&nbsp;" . __(
            'More settings'
        ),
        'li_user_preferences',
        'prefs_manage.php' . $common_url_query,
        null,
        null,
        null,
        "no_bullets"
    );
    echo '</ul>';
}

echo '</div>';


echo '</div>';
echo '<div id="main_pane_right">';


if ($server > 0 && $GLOBALS['cfg']['ShowServerInfo']) {

    echo '<div class="group">';
    echo '<h2>' , __('Database server') , '</h2>';
    echo '<ul>' , "\n";
    Core::printListItem(
        __('Server:') . ' ' . $server_info,
        'li_server_info'
    );
    Core::printListItem(
        __('Server type:') . ' ' . Util::getServerType(),
        'li_server_type'
    );
    Core::printListItem(
        __('Server connection:') . ' ' . Util::getServerSSL(),
        'li_server_type'
    );
    Core::printListItem(
        __('Server version:')
        . ' '
        . $GLOBALS['dbi']->getVersionString() . ' - ' . $GLOBALS['dbi']->getVersionComment(),
        'li_server_version'
    );
    Core::printListItem(
        __('Protocol version:') . ' ' . $GLOBALS['dbi']->getProtoInfo(),
        'li_mysql_proto'
    );
    Core::printListItem(
        __('User:') . ' ' . htmlspecialchars($mysql_cur_user_and_host),
        'li_user_info'
    );

    echo '    <li id="li_select_mysql_charset">';
    echo '        ' , __('Server charset:') , ' '
       . '        <span lang="en" dir="ltr">';

    $charset = Charsets::getServerCharset($GLOBALS['dbi']);
    $charsets = Charsets::getMySQLCharsetsDescriptions(
        $GLOBALS['dbi'],
        $GLOBALS['cfg']['Server']['DisableIS']
    );

    echo '           ' , (isset($charsets[$charset]) ? $charsets[$charset] : '') , ' (' . $charset, ')';
    echo '        </span>'
       . '    </li>'
       . '  </ul>'
       . ' </div>';
}

if ($GLOBALS['cfg']['ShowServerInfo'] || $GLOBALS['cfg']['ShowPhpInfo']) {
    echo '<div class="group">';
    echo '<h2>' , __('Web server') , '</h2>';
    echo '<ul>';
    if ($GLOBALS['cfg']['ShowServerInfo']) {
        Core::printListItem($_SERVER['SERVER_SOFTWARE'], 'li_web_server_software');

        if ($server > 0) {
            $client_version_str = $GLOBALS['dbi']->getClientInfo();
            if (preg_match('#\d+\.\d+\.\d+#', $client_version_str)) {
                $client_version_str = 'libmysql - ' . $client_version_str;
            }
            Core::printListItem(
                __('Database client version:') . ' ' . $client_version_str,
                'li_mysql_client_version'
            );

            $php_ext_string = __('PHP extension:') . ' ';

            $extensions = Util::listPHPExtensions();

            foreach ($extensions as $extension) {
                $php_ext_string  .= '  ' . $extension
                    . Util::showPHPDocu('book.' . $extension . '.php');
            }

            Core::printListItem(
                $php_ext_string,
                'li_used_php_extension'
            );

            $php_version_string = __('PHP version:') . ' ' . phpversion();

            Core::printListItem(
                $php_version_string,
                'li_used_php_version'
            );
        }
    }

    if ($cfg['ShowPhpInfo']) {
        Core::printListItem(
            __('Show PHP information'),
            'li_phpinfo',
            'phpinfo.php' . $common_url_query,
            null,
            '_blank'
        );
    }
    echo '  </ul>';
    echo ' </div>';
}

echo '<div class="group pmagroup">';
echo '<h2>phpMyAdmin</h2>';
echo '<ul>';
$class = null;
if ($GLOBALS['cfg']['VersionCheck']) {
    $class = 'jsversioncheck';
}
Core::printListItem(
    __('Version information:') . ' <span class="version">' . PMA_VERSION . '</span>',
    'li_pma_version',
    null,
    null,
    null,
    null,
    $class
);
Core::printListItem(
    __('Documentation'),
    'li_pma_docs',
    Util::getDocuLink('index'),
    null,
    '_blank'
);

// does not work if no target specified, don't know why
Core::printListItem(
    __('Official Homepage'),
    'li_pma_homepage',
    Core::linkURL('https://www.phpmyadmin.net/'),
    null,
    '_blank'
);
Core::printListItem(
    __('Contribute'),
    'li_pma_contribute',
    Core::linkURL('https://www.phpmyadmin.net/contribute/'),
    null,
    '_blank'
);
Core::printListItem(
    __('Get support'),
    'li_pma_support',
    Core::linkURL('https://www.phpmyadmin.net/support/'),
    null,
    '_blank'
);
Core::printListItem(
    __('List of changes'),
    'li_pma_changes',
    'changelog.php' . Url::getCommon(),
    null,
    '_blank'
);
Core::printListItem(
    __('License'),
    'li_pma_license',
    'license.php' . Url::getCommon(),
    null,
    '_blank'
);
echo '    </ul>';
echo ' </div>';

echo '</div>';

echo '</div>';

/**
 * mbstring is used for handling multibytes inside parser, so it is good
 * to tell user something might be broken without it, see bug #1063149.
 */
if (! extension_loaded('mbstring')) {
    trigger_error(
        __(
            'The mbstring PHP extension was not found and you seem to be using'
            . ' a multibyte charset. Without the mbstring extension phpMyAdmin'
            . ' is unable to split strings correctly and it may result in'
            . ' unexpected results.'
        ),
        E_USER_WARNING
    );
}

/**
 * Missing functionality
 */
if (! extension_loaded('curl') && ! ini_get('allow_url_fopen')) {
    trigger_error(
        __(
            'The curl extension was not found and allow_url_fopen is '
            . 'disabled. Due to this some features such as error reporting '
            . 'or version check are disabled.'
        )
    );
}

if ($cfg['LoginCookieValidityDisableWarning'] == false) {
    /**
     * Check whether session.gc_maxlifetime limits session validity.
     */
    $gc_time = (int)ini_get('session.gc_maxlifetime');
    if ($gc_time < $GLOBALS['cfg']['LoginCookieValidity'] ) {
        trigger_error(
            __(
                'Your PHP parameter [a@https://secure.php.net/manual/en/session.' .
                'configuration.php#ini.session.gc-maxlifetime@_blank]session.' .
                'gc_maxlifetime[/a] is lower than cookie validity configured ' .
                'in phpMyAdmin, because of this, your login might expire sooner ' .
                'than configured in phpMyAdmin.'
            ),
            E_USER_WARNING
        );
    }
}

/**
 * Check whether LoginCookieValidity is limited by LoginCookieStore.
 */
if ($GLOBALS['cfg']['LoginCookieStore'] != 0
    && $GLOBALS['cfg']['LoginCookieStore'] < $GLOBALS['cfg']['LoginCookieValidity']
) {
    trigger_error(
        __(
            'Login cookie store is lower than cookie validity configured in ' .
            'phpMyAdmin, because of this, your login will expire sooner than ' .
            'configured in phpMyAdmin.'
        ),
        E_USER_WARNING
    );
}

/**
 * Check if user does not have defined blowfish secret and it is being used.
 */
if (! empty($_SESSION['encryption_key'])) {
    if (empty($GLOBALS['cfg']['blowfish_secret'])) {
        trigger_error(
            __(
                'The configuration file now needs a secret passphrase (blowfish_secret).'
            ),
            E_USER_WARNING
        );
    } elseif (strlen($GLOBALS['cfg']['blowfish_secret']) < 32) {
        trigger_error(
            __(
                'The secret passphrase in configuration (blowfish_secret) is too short.'
            ),
            E_USER_WARNING
        );
    }
}

/**
 * Check for existence of config directory which should not exist in
 * production environment.
 */
if (@file_exists('config')) {
    trigger_error(
        __(
            'Directory [code]config[/code], which is used by the setup script, ' .
            'still exists in your phpMyAdmin directory. It is strongly ' .
            'recommended to remove it once phpMyAdmin has been configured. ' .
            'Otherwise the security of your server may be compromised by ' .
            'unauthorized people downloading your configuration.'
        ),
        E_USER_WARNING
    );
}

$relation = new Relation();

if ($server > 0) {
    $cfgRelation = $relation->getRelationsParam();
    if (! $cfgRelation['allworks']
        && $cfg['PmaNoRelation_DisableWarning'] == false
    ) {
        $msg_text = __(
            'The phpMyAdmin configuration storage is not completely '
            . 'configured, some extended features have been deactivated. '
            . '%sFind out why%s. '
        );
        if ($cfg['ZeroConf'] == true) {
            $msg_text .= '<br>' .
                __(
                    'Or alternately go to \'Operations\' tab of any database '
                    . 'to set it up there.'
                );
        }
        $msg = Message::notice($msg_text);
        $msg->addParamHtml('<a href="./chk_rel.php" data-post="' . $common_url_query . '">');
        $msg->addParamHtml('</a>');
        /* Show error if user has configured something, notice elsewhere */
        if (!empty($cfg['Servers'][$server]['pmadb'])) {
            $msg->isError(true);
        }
        $msg->display();
    } // end if
}

/**
 * Warning about Suhosin only if its simulation mode is not enabled
 */
if ($cfg['SuhosinDisableWarning'] == false
    && ini_get('suhosin.request.max_value_length')
    && ini_get('suhosin.simulation') == '0'
) {
    trigger_error(
        sprintf(
            __(
                'Server running with Suhosin. Please refer to %sdocumentation%s ' .
                'for possible issues.'
            ),
            '[doc@faq1-38]',
            '[/doc]'
        ),
        E_USER_WARNING
    );
}

/* Missing template cache */
if (is_null($GLOBALS['PMA_Config']->getTempDir('twig'))) {
    trigger_error(
        sprintf(
            __('The $cfg[\'TempDir\'] (%s) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.'),
            $GLOBALS['PMA_Config']->get('TempDir')
        ),
        E_USER_WARNING
    );
}

/**
 * Warning about incomplete translations.
 *
 * The data file is created while creating release by ./scripts/remove-incomplete-mo
 */
if (@file_exists('libraries/language_stats.inc.php')) {
    include 'libraries/language_stats.inc.php';
    /*
     * This message is intentionally not translated, because we're
     * handling incomplete translations here and focus on english
     * speaking users.
     */
    if (isset($GLOBALS['language_stats'][$lang])
        && $GLOBALS['language_stats'][$lang] < $cfg['TranslationWarningThreshold']
    ) {
        trigger_error(
            'You are using an incomplete translation, please help to make it '
            . 'better by [a@https://www.phpmyadmin.net/translate/'
            . '@_blank]contributing[/a].',
            E_USER_NOTICE
        );
    }
}

(Cela viens d'internet je ne savais dans quelle balise le placer

bruno

Re : Problème PHPMYADMIN

cf. le point 4.2 de la doc php

koaz

Re : Problème PHPMYADMIN

Cela me donne une erreur :

koaz@koaz:~$ sudo a2enmod php7.4
Considering dependency mpm_prefork for php7.4:
Considering conflict mpm_event for mpm_prefork:
ERROR: Module mpm_event is enabled - cannot proceed due to conflicts. It needs to be disabled first!
Considering conflict mpm_worker for mpm_prefork:
ERROR: Could not enable dependency mpm_prefork for php7.4, aborting

bobe

Re : Problème PHPMYADMIN

As-tu essayé ensuite de désactiver le module mpm_event avant de retenter d'activer le module php7.4 ?

koaz

Re : Problème PHPMYADMIN

Je ne comprend pas tout à fait ce que tu veux dire..(Je suis nouveau sur Linux j’apprend petit à petit ..)

bobe

Re : Problème PHPMYADMIN

sudo a2dismod mpm_event
sudo a2enmod php7.4
sudo systemctl restart apache2

koaz

Re : Problème PHPMYADMIN

koaz@koaz:~$ sudo a2dismod mpm_event
Module mpm_event already disabled

koaz@koaz:~$ sudo a2enmod php7.4
Considering dependency mpm_prefork for php7.4:
Considering conflict mpm_event for mpm_prefork:
Considering conflict mpm_worker for mpm_prefork:
Module mpm_prefork already enabled
Considering conflict php5 for php7.4:
Module php7.4 already enabled
koaz@koaz:~$ 

krodelabestiole

Re : Problème PHPMYADMIN

tu peux donner le retour de :

apt list \*php\* --installed

---

nouveau forum ubuntu-fr on en parle là : refonte du site / nouveau design
profil - sujets récurrents - sources du site

koaz

Re : Problème PHPMYADMIN

Oui tient :

koaz@koaz:~$ apt list \*php\* --installed
En train de lister... Fait
libapache2-mod-php7.4/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
libapache2-mod-php/focal,focal,now 2:7.4+75 all  [installé]
php-bz2/focal,focal,now 2:7.4+75 all  [installé, automatique]
php-common/focal,focal,now 2:75 all  [installé, automatique]
php-curl/focal,focal,now 2:7.4+75 all  [installé]
php-gd/focal,focal,now 2:7.4+75 all  [installé]
php-google-recaptcha/focal,focal,now 1.2.3-1 all  [installé, automatique]
php-intl/focal,focal,now 2:7.4+75 all  [installé]
php-json/focal,focal,now 2:7.4+75 all  [installé]
php-mbstring/focal,focal,now 2:7.4+75 all  [installé]
php-mysql/focal,focal,now 2:7.4+75 all  [installé]
php-phpmyadmin-motranslator/focal,focal,now 5.0.0-1 all  [installé, automatique]
php-phpmyadmin-shapefile/focal,focal,now 2.1-3 all  [installé, automatique]
php-phpmyadmin-sql-parser/focal,focal,now 4.6.1-2 all  [installé, automatique]
php-phpseclib/focal,focal,now 2.0.23-2 all  [installé, automatique]
php-psr-cache/focal,focal,now 1.0.1-2 all  [installé, automatique]
php-psr-container/focal,focal,now 1.0.0-2 all  [installé, automatique]
php-psr-log/focal,focal,now 1.1.2-1 all  [installé, automatique]
php-symfony-cache-contracts/focal,focal,now 1.1.8-1 all  [installé, automatique]
php-symfony-cache/focal,focal,now 4.3.8+dfsg-1ubuntu1 all  [installé, automatique]
php-symfony-expression-language/focal,focal,now 4.3.8+dfsg-1ubuntu1 all  [installé, automatique]
php-symfony-service-contracts/focal,focal,now 1.1.8-1 all  [installé, automatique]
php-symfony-var-exporter/focal,focal,now 4.3.8+dfsg-1ubuntu1 all  [installé, automatique]
php-tcpdf/focal,focal,now 6.3.5+dfsg1-1 all  [installé, automatique]
php-twig-extensions/focal,focal,now 1.5.4-1 all  [installé, automatique]
php-twig/focal,focal,now 2.12.5-1 all  [installé, automatique]
php-xml/focal,focal,now 2:7.4+75 all  [installé]
php-zip/focal,focal,now 2:7.4+75 all  [installé]
php7.4-bz2/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-cli/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-common/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-curl/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-gd/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-intl/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-json/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-mbstring/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-mysql/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-opcache/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-readline/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-xml/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-zip/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4/focal-updates,focal-updates,focal-security,focal-security,now 7.4.3-4ubuntu2.4 all  [installé, automatique]
php/focal,focal,now 2:7.4+75 all  [installé]
phpmyadmin/focal,focal,now 4:4.9.5+dfsg1-2 all  [installé]

bruno

Re : Problème PHPMYADMIN

Et cela devrait fonctionner maintenant puisque le retour en #60 montre que le module php d'Apache est bien installé et activé.

koaz

Re : Problème PHPMYADMIN

Cela me donne comme au #54

bruno

Re : Problème PHPMYADMIN

As-tu pensé à redémarrer Apache ?

sudo systemctl restart apache2

bobe

Re : Problème PHPMYADMIN

Tu as bien redémarré apache après ton message #60 ?

koaz

Re : Problème PHPMYADMIN

Oui j'avais bien pensé à le faire.

Je relance PHPMYADMIN est la nouvelle erreur :

Fatal error: Uncaught Error: Call to undefined function PhpMyAdmin\mb_strpos() in /usr/share/phpmyadmin/libraries/classes/Url.php:253 Stack trace: #0 /usr/share/phpmyadmin/libraries/classes/Url.php(206): PhpMyAdmin\Url::getArgSeparator() #1 /usr/share/phpmyadmin/libraries/classes/Url.php(169): PhpMyAdmin\Url::getCommonRaw(Array, '?') #2 /usr/share/phpmyadmin/libraries/classes/Core.php(749): PhpMyAdmin\Url::getCommon(Array) #3 /usr/share/phpmyadmin/libraries/classes/Core.php(330): PhpMyAdmin\Core::linkURL('https://secure....') #4 /usr/share/phpmyadmin/libraries/classes/Core.php(353): PhpMyAdmin\Core::getPHPDocLink('book.mbstring.p...') #5 /usr/share/phpmyadmin/libraries/classes/Core.php(973): PhpMyAdmin\Core::warnMissingExtension('mbstring') #6 /usr/share/phpmyadmin/libraries/common.inc.php(106): PhpMyAdmin\Core::checkExtensions() #7 /usr/share/phpmyadmin/index.php(27): require_once('/usr/share/phpm...') #8 {main} thrown in /usr/share/phpmyadmin/libraries/classes/Url.php on line 253

Dernière modification par bruno (Le 29/01/2021, à 17:58)

bobe

Re : Problème PHPMYADMIN

donne nous le résultat des commandes suivantes :

a2query -c

a2query -m

koaz

Re : Problème PHPMYADMIN

koaz@koaz:~$ a2query -c
charset (enabled by maintainer script)
phpmyadmin (enabled by site administrator)
serve-cgi-bin (enabled by maintainer script)
localized-error-pages (enabled by maintainer script)
other-vhosts-access-log (enabled by maintainer script)
security (enabled by maintainer script)

koaz@koaz:~$ a2query -m
mime (enabled by maintainer script)
autoindex (enabled by maintainer script)
authz_host (enabled by maintainer script)
auth_basic (enabled by maintainer script)
status (enabled by maintainer script)
reqtimeout (enabled by maintainer script)
deflate (enabled by maintainer script)
authn_core (enabled by maintainer script)
authn_file (enabled by maintainer script)
authz_user (enabled by maintainer script)
env (enabled by maintainer script)
filter (enabled by maintainer script)
authz_core (enabled by maintainer script)
access_compat (enabled by maintainer script)
php7.4 (enabled by site administrator)
negotiation (enabled by maintainer script)
mpm_prefork (enabled by site administrator)
setenvif (enabled by maintainer script)
alias (enabled by maintainer script)
dir (enabled by maintainer script)

bobe

Re : Problème PHPMYADMIN

Bon bah tout a l'air ok et je comprends pas le délire là ^^'

edit: ah, c'est l'absence de l''extension mbstring qui le fait chouiner on dirait. bizarre qu'il balance un pâté pas très user-friendly.
Installe l'extension mbstring, puis redémarre apache :

sudo apt install php-mbstring
sudo systemctl restart apache2

Dernière modification par bobe (Le 29/01/2021, à 16:55)

koaz

Re : Problème PHPMYADMIN

L'extension étais déjà installé.

Donc toujours la même erreur que dite précédemment...

bobe

Re : Problème PHPMYADMIN

Ajoute un fichier /var/www/info.php avec ça dedans :

<?php phpinfo();

Sauvegarde. Appelle-le dans le navigateur : http://localhost/info.php

Dis ce que ça indique comme version de PHP + la valeur en face de la ligne "Server API" + descend dans la page pour voir si l'extension mbstring est bien présente

koaz

Re : Problème PHPMYADMIN

La version de php : PHP Version 7.4.3

La valeur : Apache 2.0 Handler

Par contre impossible de trouver mbstring

bobe

Re : Problème PHPMYADMIN

Dans ce cas :

sudo phpenmod mbstring
sudo systemctl restart apache2

koaz

Re : Problème PHPMYADMIN

J'ai une erreur :

WARNING: Module mbstring ini file doesn't exist under /etc/php/7.4/mods-available
WARNING: Module mbstring ini file doesn't exist under /etc/php/7.4/mods-available