Problemas em instalar o phpmyadmin ele não quer abrir o localhost

Ghostwar
(usa Debian)

Enviado em 04/12/2017 - 12:41h

Fiz a instalação do phpmyadmin e do apache2 fiz o procedimento de colocar.
Uma segunda e melhor solução
fazer uma alias no arquivo /etc/apache2/apache2.conf basta adicionar as seguintes linhas no final do documento
Alias /phpmyadmin /usr/share/phpmyadmin
<Directory /usr/share/phpmyadmin>
Options Indexes FollowSymLinks
AllowOverride All
Order allow,deny
Allow from all
</Directory>

porem nada feito ele abre porem assim ..

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Main loader script
*
* @package PhpMyAdmin
*/

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

/**
* display Git revision if requested
*/
require_once 'libraries/display_git_revision.lib.php';
require_once 'libraries/Template.class.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)
&& in_array($_REQUEST['target'], $goto_whitelist)
) {
include $_REQUEST['target'];
exit;
}

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

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

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

if ($GLOBALS['PMA_Config']->isGitRevision()) {
if (isset($_REQUEST['git_revision']) && $GLOBALS['is_ajax_request'] == true) {
PMA_printGitRevision();
exit;
}
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 PMA_Util::getMessage($message);
unset($message);
}

$common_url_query = PMA_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';
include 'libraries/StorageEngine.class.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 PMA_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 style="margin: 0.5em 1em 0.5em 1em">';
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="http://demo.phpmyadmin.net/">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" >';
include_once 'libraries/select_server.lib.php';
echo PMA_Util::getImage('s_host.png') . " " . PMA_selectServer(true, true);
echo '</li>';
}

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

// Logout for advanced authentication
if ($cfg['Server']['auth_type'] != 'config') {
if ($cfg['ShowChgPassword']) {
$conditional_class = 'ajax';
PMA_printListItem(
PMA_Util::getImage('s_passwd.png') . "&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 method="post" action="index.php">' . "\n"
. PMA_URL_getHiddenInputs(null, null, 4, 'collation_connection')
. ' <label for="select_collation_connection">' . "\n"
. ' ' . PMA_Util::getImage('s_asci.png') . "&nbsp;"
. __('Server connection collation') . "\n"
// put the doc link in the form so that it appears on the same line
. PMA_Util::showMySQLDocu('Charset-connection')
. ': ' . "\n"
. ' </label>' . "\n"

. PMA_generateCharsetDropdownBox(
PMA_CSDROPDOWN_COLLATION,
'collation_connection',
'select_collation_connection',
$collation_connection,
true,
true
)
. ' </form>' . "\n"
. ' </li>' . "\n";
} // end of if ($server > 0 && !PMA_DRIZZLE)
echo '</ul>';
echo '</div>';
}

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

// Displays language selection combo
if (empty($cfg['Lang']) && count($GLOBALS['available_languages']) > 1) {
echo '<li id="li_select_lang" class="no_bullets">';
include_once 'libraries/display_select_lang.lib.php';
echo PMA_Util::getImage('s_lang.png') . " " . PMA_getLanguageSelectorHtml();
echo '</li>';
}

// ThemeManager if available

if ($GLOBALS['cfg']['ThemeManager']) {
echo '<li id="li_select_theme" class="no_bullets">';
echo PMA_Util::getImage('s_theme.png') . " "
. $_SESSION['PMA_Theme_Manager']->getHtmlSelectBox();
echo '</li>';
}
echo '<li id="li_select_fontsize">';
echo PMA_Config::getFontsizeForm();
echo '</li>';

echo '</ul>';

// User preferences

if ($server > 0) {
echo '<ul>';
PMA_printListItem(
PMA_Util::getImage('b_tblops.png') . "&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";
PMA_printListItem(
__('Server:') . ' ' . $server_info,
'li_server_info'
);
PMA_printListItem(
__('Server type:') . ' ' . PMA_Util::getServerType(),
'li_server_type'
);
PMA_printListItem(
__('Server version:')
. ' '
. PMA_MYSQL_STR_VERSION . ' - ' . PMA_MYSQL_VERSION_COMMENT,
'li_server_version'
);
PMA_printListItem(
__('Protocol version:') . ' ' . $GLOBALS['dbi']->getProtoInfo(),
'li_mysql_proto'
);
PMA_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">';
if (! PMA_DRIZZLE) {
echo ' '
. $mysql_charsets_descriptions[$mysql_charset_map['utf-8']];
}
echo ' (' . $mysql_charset_map['utf-8'] . ')'
. ' </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']) {
PMA_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;
}
PMA_printListItem(
__('Database client version:') . ' ' . $client_version_str,
'li_mysql_client_version'
);

$php_ext_string = __('PHP extension:') . ' ';
if (PMA_DatabaseInterface::checkDbExtension('mysqli')) {
$extension = 'mysqli';
} else {
$extension = 'mysql';
}
$php_ext_string .= $extension . ' '
. PMA_Util::showPHPDocu('book.' . $extension . '.php');

PMA_printListItem(
$php_ext_string,
'li_used_php_extension'
);

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

PMA_printListItem(
$php_version_string,
'li_used_php_version'
);
}
}

if ($cfg['ShowPhpInfo']) {
PMA_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;
// We rely on CSP to allow access to http://www.phpmyadmin.net, but IE lacks
// support here and does not allow request to http once using https.
if ($GLOBALS['cfg']['VersionCheck']
&& (! $GLOBALS['PMA_Config']->get('is_https') || PMA_USR_BROWSER_AGENT != 'IE')
) {
$class = 'jsversioncheck';
}
PMA_printListItem(
__('Version information:') . ' <span class="version">' . PMA_VERSION . '</span>',
'li_pma_version',
null,
null,
null,
null,
$class
);
PMA_printListItem(
__('Documentation'),
'li_pma_docs',
PMA_Util::getDocuLink('index'),
null,
'_blank'
);
PMA_printListItem(
__('Wiki'),
'li_pma_wiki',
PMA_linkURL('http://wiki.phpmyadmin.net/'),
null,
'_blank'
);

// does not work if no target specified, don't know why
PMA_printListItem(
__('Official Homepage'),
'li_pma_homepage',
PMA_linkURL('http://www.phpMyAdmin.net/'),
null,
'_blank'
);
PMA_printListItem(
__('Contribute'),
'li_pma_contribute',
PMA_linkURL('https://www.phpmyadmin.net/contribute/'),
null,
'_blank'
);
PMA_printListItem(
__('Get support'),
'li_pma_support',
PMA_linkURL('https://www.phpmyadmin.net/support/'),
null,
'_blank'
);
PMA_printListItem(
__('List of changes'),
'li_pma_changes',
'changelog.php' . PMA_URL_getCommon(),
null,
'_blank'
);
echo ' </ul>';
echo ' </div>';

echo '</div>';

echo '</div>';

/**
* Warning if using the default MySQL privileged account
*/
if ($server != 0
&& $cfg['Server']['user'] == 'root'
&& $cfg['Server']['password'] == ''
) {
trigger_error(
__(
'You are connected as \'root\' with no password, which'
. ' corresponds to the default MySQL privileged account.'
. ' Your MySQL server is running with this default, is open to'
. ' intrusion, and you really should fix this security hole by'
. ' setting a password for user \'root\'.'
),
E_USER_WARNING
);
}

/**
* As we try to handle charsets by ourself, mbstring overloads just
* break it, see bug 1063821.
*/
if (@extension_loaded('mbstring') && @ini_get('mbstring.func_overload') > 1) {
trigger_error(
__(
'You have enabled mbstring.func_overload in your PHP '
. 'configuration. This option is incompatible with phpMyAdmin '
. 'and might cause some data to be corrupted!'
),
E_USER_WARNING
);
}

/**
* 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
);
}

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@http://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
e segue..... o que pode ser isso.

plimo263
(usa Ubuntu)

Enviado em 04/12/2017 - 18:06h

digite no teu terminal e poste a saída deste comando aqui

php -v

 

ThinKing
(usa Debian)

Enviado em 05/12/2017 - 01:20h

meu amigo, isso daí é versão do seu php está faltando módulos, faça um seguinte...

No terminal dá um whereis php e manda a saída aqui para a gente daí já resolvemos...

Ghostwar
(usa Debian)

Enviado em 05/12/2017 - 10:44h

Retorno do comando...

PHP 7.0.22-0ubuntu0.16.04.1 (cli) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies
with Zend OPcache v7.0.22-0ubuntu0.16.04.1, Copyright (c) 1999-2017, by Zend Technologies

Ghostwar
(usa Debian)

Enviado em 05/12/2017 - 10:45h

enviando o retorno do comando...

php: /usr/bin/php7.0 /usr/bin/php /usr/lib/php /etc/php /usr/share/php7.0-readline /usr/share/php7.0-mysql /usr/share/php7.0-json /usr/share/php7.0-mbstring /usr/share/php7.0-xml /usr/share/php7.0-opcache /usr/share/php /usr/share/php7.0-common /usr/share/man/man1/php.1.gz

plimo263
(usa Ubuntu)

Enviado em 05/12/2017 - 11:09h

O módulo PHP esta ativo no Apache ?

$ sudo a2enmod php7.0 

# Agora vai depender se usa sys-V ou systemd

# sysV

$ sudo service apache2 restart

# systemd

$ sudo systemctl restart apache2

 

Ghostwar
(usa Debian)

Enviado em 05/12/2017 - 11:55h

Os Comandos solicitados.

gomes@MitLinux ~ $ sudo a2enmod php7.0
Considering conflict php5 for php7.0:
Enabling module php7.0.
To activate the new configuration, you need to run:
service apache2 restart

gomes@MitLinux ~ $ sudo service apache2 restart
Job for apache2.service failed because the control process exited with error code. See "systemctl status apache2.service" and "journalctl -xe" for details.

gomes@MitLinux ~ $ sudo systemctl restart apache2
Job for apache2.service failed because the control process exited with error code. See "systemctl status apache2.service" and "journalctl -xe" for details

plimo263
(usa Ubuntu)

Enviado em 05/12/2017 - 11:59h

Esta usando qual distro ? Reinicie o serviço do apache2 então desta forma

$ sudo /etc/init.d/apache2 restart 

# ou 

$ sudo systemctl restart httpd

# ou

$ sudo /etc/init.d/httpd restart



 

Se souber qual a distro ajuda nesta questão de reinicio de serviço.

Ghostwar
(usa Debian)

Enviado em 07/12/2017 - 14:47h

Segue


gomes@MitLinux ~ $ sudo /etc/init.d/apache2 restart
[sudo] senha para gomes:
[....] Restarting apache2 (via systemctl): apache2.serviceJob for apache2.service failed because the control process exited with error code. See "systemctl status apache2.service" and "journalctl -xe" for details.
failed!
gomes@MitLinux ~ $ sudo systemctl restart httpd
Failed to restart httpd.service: Unit httpd.service not found.
gomes@MitLinux ~ $ sudo /etc/init.d/httpd restart
sudo: /etc/init.d/httpd: comando não encontrado
gomes@MitLinux ~ $ uname -r
4.10.0-40-generic
gomes@MitLinux ~ $ cat /etc/[A-Za-z]*[_-][rv]e[lr]*
stretch/sid
DISTRIB_ID=LinuxMint
DISTRIB_RELEASE=18.3
DISTRIB_CODENAME=sylvia

plimo263
(usa Ubuntu)

Enviado em 07/12/2017 - 16:14h

sudo /etc/init.d/apache2 restart
[sudo] senha para gomes:
[....] Restarting apache2 (via systemctl): apache2.serviceJob for apache2.service failed because the control process exited with error code. See "systemctl status apache2.service" and "journalctl -xe" for details.
failed!

Já no primeiro comando ele tentaria reiniciar o apache, mas encontrou um erro ao subir o serviço, solicitou que você verifique usando

$ systemctl status apache2

E

$ journalctl -xe

Executa o comando novamente, e depois você executa os dois acima e posta a saída para verificarmos.

$ sudo /etc/&#297;nit.d/apache2 restart

Ghostwar
(usa Debian)

Enviado em 07/12/2017 - 16:44h

&#9679; apache2.service - LSB: Apache2 web server
Loaded: loaded (/etc/init.d/apache2; bad; vendor preset: enabled)
Drop-In: /lib/systemd/system/apache2.service.d
&#9492;&#9472;apache2-systemd.conf
Active: failed (Result: exit-code) since Qui 2017-12-07 13:45:56 -03; 1h 57mi
Docs: man:systemd-sysv-generator(8)
Process: 13935 ExecStart=/etc/init.d/apache2 start (code=exited, status=1/FAIL

Dez 07 13:45:56 MitLinux apache2[13935]: * The apache2 configtest failed.
Dez 07 13:45:56 MitLinux apache2[13935]: Output of config test was:
Dez 07 13:45:56 MitLinux apache2[13935]: [Thu Dec 07 13:45:56.300976 2017] [:cri
Dez 07 13:45:56 MitLinux apache2[13935]: AH00013: Pre-configuration failed
Dez 07 13:45:56 MitLinux apache2[13935]: Action 'configtest' failed.
Dez 07 13:45:56 MitLinux apache2[13935]: The Apache error log may have more info
Dez 07 13:45:56 MitLinux systemd[1]: apache2.service: Control process exited, co
Dez 07 13:45:56 MitLinux systemd[1]: Failed to start LSB: Apache2 web server.
Dez 07 13:45:56 MitLinux systemd[1]: apache2.service: Unit entered failed state.
Dez 07 13:45:56 MitLinux systemd[1]: apache2.service: Failed with result 'exit-c
lines 1-18/18 (END)
gomes@MitLinux ~ $ journalctl -xe
-- A unidade NetworkManager-dispatcher.service está sendo iniciada.
Dez 07 15:35:31 MitLinux dhclient[1095]: bound to 172.16.119.89 -- renewal in 17
Dez 07 15:35:31 MitLinux dbus[779]: [system] Successfully activated service 'org
Dez 07 15:35:31 MitLinux systemd[1]: Started Network Manager Script Dispatcher S
-- Subject: Unidade NetworkManager-dispatcher.service concluiu a inicialização
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade NetworkManager-dispatcher.service concluiu a inicialização.
--
-- The start-up result is done.
Dez 07 15:35:31 MitLinux nm-dispatcher[17737]: req:1 'dhcp4-change' [enp1s0]: ne
Dez 07 15:35:31 MitLinux nm-dispatcher[17737]: req:1 'dhcp4-change' [enp1s0]: st
Dez 07 15:35:33 MitLinux smbd[17730]: pam_unix(samba:session): session closed fo
Dez 07 15:38:48 MitLinux kernel: perf: interrupt took too long (7910 > 7876), lo
Dez 07 15:39:01 MitLinux CRON[17827]: pam_unix(cron:session): session opened for
Dez 07 15:39:01 MitLinux CRON[17828]: (root) CMD ( [ -x /usr/lib/php/sessioncle
Dez 07 15:39:01 MitLinux CRON[17827]: pam_unix(cron:session): session closed for
Dez 07 15:40:05 MitLinux dbus[779]: [system] Activating via systemd: service nam
Dez 07 15:40:30 MitLinux dbus[779]: [system] Failed to activate service 'org.blu
Dez 07 15:41:44 MitLinux sudo[18051]: gomes : TTY=pts/4 ; PWD=/home/gomes ; U
Dez 07 15:41:44 MitLinux sudo[18051]: pam_unix(sudo:session): session opened for
Dez 07 15:41:56 MitLinux sudo[18051]: pam_unix(sudo:session): session closed for

gomes@MitLinux ~ $ sudo /etc/&#297;nit.d/apache2 restart
[1] 18130
gomes@MitLinux ~ $ sudo: /etc/: comando não encontrado

plimo263
(usa Ubuntu)

Enviado em 07/12/2017 - 16:55h

Lê o arquivo de log amigo

sudo tail /var/log/apache2/error.log