a problem after updating 1.7.7... :(

Problems with the Linux version of XAMPP, questions, comments, and anything related.

a problem after updating 1.7.7... :(

Postby superichy » 26. September 2011 03:09

the question is that phpmyadmin has stopped:

When I type http://localhost/phpmyadmin and hit Enter, the page stays in "connecting..." "waiting localhost..." it remains there... with the content blank,
However the localhost is working fine...

MySQL database DEACTIVATED
PHP ACTIVATED
Perl ACTIVATED
Common Gateway Interface (CGI) ACTIVATED
Server Side Includes (SSI) ACTIVATED
PHP extension »eAccelerator« DEACTIVATED ver FAQ
PHP extension »OCI8/Oracle« DEACTIVATED

If I type 127.0.0.1/phpmyadmin, it ask me the password... I enter it, and it remains there... with the content blank,

any idea?
Ubuntu 11.04 / XAMPP 1.7.7
superichy
 
Posts: 12
Joined: 09. September 2011 01:28

Re: a problem after updating 1.7.7... :(

Postby Sharley » 26. September 2011 03:16

Just a guess that may help speed up a solution until a Linux guru pops in, find and edit the Linux equivalent of the Windows MySQL configuration file perhaps my.conf (my.ini or my.cnf) and find a similar following line uncomment it.

#bind-address = 127.0.0.1
So it looks like this:
bind-address = 127.0.0.1

Save the file and you may have to restart MySQL.

I don't have a Linux box to test this so please provide feedback if it helps.

This fix was first discovered in the Windows version.

Good luck :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: a problem after updating 1.7.7... :(

Postby superichy » 26. September 2011 03:46

hi! thank you for trying... I found the file my.cnf under /opt/lampp/etc
However...
It does NOT has the line you are saying: (#bind-address="127.0.0.1")

any other idea?

[edit]
In the same folder, I found the file php.ini
However...
It neither has that line of code :(
[edit]
superichy
 
Posts: 12
Joined: 09. September 2011 01:28

Re: a problem after updating 1.7.7... :(

Postby Sharley » 26. September 2011 03:56

Try adding it at the end of the first section like so
Code: Select all
bind-address = 127.0.0.1
#
# * Fine Tuning
#


You have to get MySQL ACTIVATED or phpMyAdmin won't start.

Is MySQL running?
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: a problem after updating 1.7.7... :(

Postby superichy » 26. September 2011 03:59

Done. Xampp restarted, and the same results :(

Yes, it's running... I have access to all my wordpress sites
superichy
 
Posts: 12
Joined: 09. September 2011 01:28

Re: a problem after updating 1.7.7... :(

Postby superichy » 26. September 2011 04:03

my.cnf
# Here follows entries for some specific programs

# The MySQL server
[mysqld]
user = nobody
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
bind-address = 127.0.0.1

# Where do all the plugins live


superichy@ubuntu-pc:~$ sudo /opt/lampp/lampp restart
Stopping XAMPP for Linux 1.7.7...
XAMPP: Stopping Apache with SSL...
XAMPP: Stopping MySQL...
XAMPP: Stopping ProFTPD...
XAMPP stopped.
Starting XAMPP for Linux 1.7.7...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Starting ProFTPD...
XAMPP for Linux started.
superichy@ubuntu-pc:~$
superichy
 
Posts: 12
Joined: 09. September 2011 01:28

Re: a problem after updating 1.7.7... :(

Postby Sharley » 26. September 2011 04:05

So my guess was not the solution but worth a try.

You may have to wait a while for someone who has a Linux box to try and help you.

Good luck. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: a problem after updating 1.7.7... :(

Postby superichy » 26. September 2011 04:08

in FF it remains connecting... waiting localhost...
in Chrome, it asks me my user and password; when I enter them, it asks me again the same and again and again and again...

In the previous XAMPP version, phpmyadmin was working fine...
superichy
 
Posts: 12
Joined: 09. September 2011 01:28

Re: a problem after updating 1.7.7... :(

Postby superichy » 26. September 2011 04:09

ok, thank you anyway...
waiting...
superichy
 
Posts: 12
Joined: 09. September 2011 01:28

Re: a problem after updating 1.7.7... :(

Postby JonB » 26. September 2011 10:35

If you used the 'Security script' -

Then LAMPP is first asking for your LAMPP username -- which BTW is lampp -- and the pw from the Security Page setup, THEN you will get the 'regular' phpMyAdmin root login.

Good Luck, confused me too

:shock:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: a problem after updating 1.7.7... :(

Postby superichy » 26. September 2011 13:46

-hi Jon, with "security script", are you referring (sudo /opt/lampp/lampp security) to?

Yes I used, then I enter to http://localhost with lampp, admin (the password I chose). Finally I don't have access to http://localhost/phpmyadmin...

any other idea?

thank you ;)
superichy
 
Posts: 12
Joined: 09. September 2011 01:28

Re: a problem after updating 1.7.7... :(

Postby Altrea » 26. September 2011 15:03

if you can't use phpmyadmin anymore first try to change the auth type in your phpmyadmin config.inc.php

search for
Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'config';


change to
Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'cookie';


clear your browser cache and try to connect with phpmyadmin again. You should be asked for username and password now.
try to login with root as user and your password choosen in your xampp security script.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: a problem after updating 1.7.7... :(

Postby superichy » 26. September 2011 15:29

done.
In this line,
$cfg['Servers'][$i]['auth_type'] = 'config';
I had 'http';
I changed to 'cookie';

then I followed the steps you said.... and the same results:
I'm not able to login. It asks the login autentication data once and again. I tried all the possible combinations, however... I have to hit "Cancel", and I have:

¡Autentificación requerida!

El servidor no puede certificar que usted este autorizado para acceder al enlace "/phpmyadmin/". Usted pudo suministrar información errónea accidentalmente (ejem. una contraseña inválida) o, el navegador no sabe como suministrar la información requerida.

En caso de que a usted le este permitido el uso del documento requerido, le solicitamos de la manera más atenta que por favor vuelva a intentar la operación suministrando nuevamente su identificador y su contraseña.

Por favor contacte con el webmaster en caso de que usted crea que existe un error en el servidor.
Error 401
localhost
lun 26 sep 2011 11:09:22 ART
Apache/2.2.21 (Unix) DAV/2 mod_ssl/2.2.21 OpenSSL/1.0.0c PHP/5.3.8 mod_apreq2-20090110/2.7.1 mod_perl/2.0.5 Perl/v5.10.1
superichy
 
Posts: 12
Joined: 09. September 2011 01:28

Re: a problem after updating 1.7.7... :(

Postby Altrea » 26. September 2011 15:38

Auth type http is okay too. It should be cookie or http. Both work nearly the same (http uses htaccess authentification, cookie serverscript based).

So, if that don't work and you can't login to your mysql root account anymore first try three things:
- clear your Browsercache
- use a different browser
- restart your computer

if this don't bring any success, you have just the chance to reset your mysql root user.
- if there is a resetroot script in your xampp (con't know in the current linux version) use this one.
- if not, use the way which is Described [urlhttp://www.howtoforge.com/reset-forgotten-mysql-root-password]here[/url]
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: a problem after updating 1.7.7... :(

Postby superichy » 26. September 2011 17:11

Thank you Altrea, solved:

I think the problem was that I'd never restarted mi PC after updating Xampp to 1.7.7 release.
I did it and now I'm able to login and navigate phpmyadmin normally... I saw it has a new interface, very nice,

thanks everybody for your time and dedication,


Richy
superichy
 
Posts: 12
Joined: 09. September 2011 01:28

Next

Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 2 guests