Apache2Triad Help, Support and Development Forum Index Search Profile Log in to check your private messages Log in Register Memberlist Attachments Statistics Crew/Ranks Archive
 Unable to log in to phpmyadmin
Google
Post new topic Reply to topic
Author Message
trawler
 
 


Joined: 04 Aug 2005
Posts: 6

PostPosted: Mon Aug 08, 2005 3:24 pm Reply with quoteBack to top

Hi,
I installed apache2triad a few days ago.

I have no trouble logging into localhost or into any other feature, using "root" as username and my pw.

However, i found out that i couldn't log on to phpmyadmin for some reason... my password is rejected...

At no point in the installation process do i recall inserting any other pw than the one i was already using.

Can someone help me? i'd rather not install the server again...

*Edited*

Ok, i've uninstalled and re-installed.
I could log on to phpmyadmin and left it open for a while (while i was editing some files i needed to re-insert into htdocs).

Then when i tried to click on a link inside "phpmyadmin" pw window pops up and again, it wouldn't accept my login (whereas it accepted my login just a few minutes earlier).

The same problem has happened again - I can't access "phpmyadmin" even after re-installing...

Any ideas anyone?

==================

I noticed i don't have a htaccess file in phpmyadmin folder.
Could that be the problem?
View user's profileSend private message
trawler
 
 


Joined: 04 Aug 2005
Posts: 6

PostPosted: Wed Aug 10, 2005 4:39 pm Reply with quoteBack to top

Well... doesn't seem like entering a blank pw helps.
In any case, here are the MySql error logs:

Code:
D:\apache2triad\mysql\bin\mysqld.exe: ready for connections.
Version: '4.1.11-log'  socket: ''  port: 3306  Official MySQL binary
MySql: ready for connections.
Version: '4.1.11-log'  socket: ''  port: 3306  Official MySQL binary
050808 19:24:16 [Warning] Aborted connection 6 to db: 'mysql' user: 'root' host: `localhost' (Got an error reading communication packets)
050809 10:05:08 [Note] MySql: Normal shutdown

050809 10:05:12 [Note] MySql: Shutdown complete

MySql: ready for connections.
Version: '4.1.11-log'  socket: ''  port: 3306  Official MySQL binary
050810 19:10:31 [Note] MySql: Normal shutdown

050810 19:10:36 [Note] MySql: Shutdown complete

MySql: ready for connections.
Version: '4.1.11-log'  socket: ''  port: 3306  Official MySQL binary
050810 19:20:24 [Note] MySql: Normal shutdown

050810 19:20:29 [Note] MySql: Shutdown complete

MySql: ready for connections.
Version: '4.1.11-log'  socket: ''  port: 3306  Official MySQL binary
050810 19:26:35 [Note] MySql: Normal shutdown

050810 19:26:39 [Note] MySql: Shutdown complete

MySql: ready for connections.
Version: '4.1.11-log'  socket: ''  port: 3306  Official MySQL binary


And the access logs:
Code:
D:\apache2triad\mysql\bin\mysqld.exe, Version: 4.1.11-log. started with:
Tcp port: 3306  Unix socket: MySQL
Time                 Id Command    Argument
050808 18:50:03         1 Connect     root@localhost on
            1 Query       SHOW VARIABLES LIKE 'old_passwords'
            1 Query       set sql_log_off=1
            1 Quit       
MySql, Version: 4.1.11-log. started with:
Tcp port: 3306  Unix socket: MySQL
Time                 Id Command    Argument
050808 18:54:14         1 Connect     root@localhost on
            1 Query       SELECT VERSION() AS version
050808 18:54:15         1 Query       SET NAMES utf8
050808 18:54:16         1 Query       SHOW SESSION VARIABLES LIKE 'collation_connection'
            1 Query       SHOW SESSION VARIABLES LIKE 'character_set_connection'
            1 Query       SHOW CHARACTER SET
            1 Query       SHOW COLLATION
050808 18:54:17         1 Query       SHOW DATABASES
            1 Quit       
050808 18:54:18         2 Connect     root@localhost on
            2 Query       SELECT VERSION() AS version
            2 Query       SET NAMES utf8
            2 Query       SET collation_connection = 'utf8_general_ci'
            2 Query       SHOW SESSION VARIABLES LIKE 'collation_connection'
            2 Query       SHOW SESSION VARIABLES LIKE 'character_set_connection'
            3 Connect     root@localhost on
            3 Query       SELECT VERSION() AS version
            3 Query       SET NAMES utf8
            3 Query       SET collation_connection = 'utf8_general_ci'
            3 Query       SHOW SESSION VARIABLES LIKE 'collation_connection'
            3 Query       SHOW SESSION VARIABLES LIKE 'character_set_connection'
            2 Query       SHOW CHARACTER SET
            2 Query       SHOW COLLATION
            3 Query       SHOW CHARACTER SET
            3 Query       SHOW COLLATION
            2 Query       SHOW DATABASES
            2 Quit       
            3 Query       SHOW DATABASES
            3 Query       SHOW TABLES FROM `mysql`
            3 Query       SHOW TABLE STATUS FROM `mysql`
050808 18:54:19         4 Connect     root@localhost on
            4 Query       SELECT VERSION() AS version
            4 Query       SET NAMES utf8
            4 Query       SET collation_connection = 'utf8_general_ci'
            4 Query       SHOW SESSION VARIABLES LIKE 'collation_connection'
            4 Query       SHOW SESSION VARIABLES LIKE 'character_set_connection'
            4 Query       SHOW CHARACTER SET
            4 Query       SHOW COLLATION
            4 Query       SELECT USER()
            4 Query       SELECT COUNT(*) FROM mysql.user
            4 Query       SHOW GRANTS
            4 Query       SHOW MASTER LOGS
050808 18:54:20         4 Quit       
050808 18:54:21         3 Quit       
050808 19:21:26         5 Connect     test@localhost as anonymous on
            5 Query       show databases
            5 Quit       
050808 19:23:10         6 Connect     root@localhost on
            6 Query       show status
            6 Query       show databases like '%'
            6 Processlist
            6 Query       show variables
050808 19:23:20         6 Query       show status
050808 19:23:30         6 Query       show status
050808 19:23:40         6 Query       show status
050808 19:23:50         6 Query       show status
050808 19:23:57         6 Query       use mysql
            6 Query       show tables like '%'
            6 Query       use mysql
            6 Query       show tables like '%'
050808 19:23:59         6 Query       use mysql
            6 Query       show full columns from columns_priv
            6 Query       show full columns from columns_priv
            6 Query       use mysql
            6 Query       show index from columns_priv
            6 Query       use mysql
            6 Query       show full columns from columns_priv
            6 Query       show full columns from columns_priv
            6 Query       use mysql
            6 Query       show index from columns_priv
050808 19:24:00         6 Query       show status
050808 19:24:02         6 Query       use mysql
            6 Query       show full columns from columns_priv
            6 Query       show full columns from columns_priv
            6 Query       use mysql
            6 Query       show index from columns_priv
050808 19:24:03         6 Query       use mysql
            6 Query       show full columns from db
            6 Query       show full columns from db
            6 Query       use mysql
            6 Query       show index from db
            6 Query       use mysql
            6 Query       show full columns from db
            6 Query       show full columns from db
            6 Query       use mysql
            6 Query       show index from db
            6 Query       use mysql
            6 Query       show full columns from func
            6 Query       show full columns from func
            6 Query       use mysql
            6 Query       show index from func
            6 Query       use mysql
            6 Query       show full columns from func
            6 Query       show full columns from func
            6 Query       use mysql
            6 Query       show index from func
050808 19:24:07         6 Query       use mysql
            6 Query       show full columns from time_zone_transition_type
            6 Query       show full columns from time_zone_transition_type
            6 Query       use mysql
            6 Query       show index from time_zone_transition_type
            6 Query       use mysql
            6 Query       show full columns from time_zone_transition_type
            6 Query       show full columns from time_zone_transition_type
            6 Query       use mysql
            6 Query       show index from time_zone_transition_type
050808 19:24:08         6 Query       use mysql
            6 Query       show full columns from time_zone_transition
            6 Query       show full columns from time_zone_transition
            6 Query       use mysql
            6 Query       show index from time_zone_transition
            6 Query       use mysql
            6 Query       show full columns from time_zone_transition
            6 Query       show full columns from time_zone_transition
            6 Query       use mysql
            6 Query       show index from time_zone_transition
050808 19:24:09         6 Query       use mysql
            6 Query       show full columns from time_zone_name
            6 Query       show full columns from time_zone_name
            6 Query       use mysql
            6 Query       show index from time_zone_name
            6 Query       use mysql
            6 Query       show full columns from time_zone_name
            6 Query       show full columns from time_zone_name
            6 Query       use mysql
            6 Query       show index from time_zone_name
            6 Query       use mysql
            6 Query       show full columns from time_zone_leap_second
            6 Query       show full columns from time_zone_leap_second
            6 Query       use mysql
            6 Query       show index from time_zone_leap_second
            6 Query       use mysql
            6 Query       show full columns from time_zone_leap_second
            6 Query       show full columns from time_zone_leap_second
            6 Query       use mysql
            6 Query       show index from time_zone_leap_second
050808 19:24:10         6 Query       use mysql
            6 Query       show full columns from time_zone
            6 Query       show full columns from time_zone
            6 Query       use mysql
            6 Query       show index from time_zone
            6 Query       show status
            6 Query       use mysql
            6 Query       show full columns from time_zone
            6 Query       show full columns from time_zone
            6 Query       use mysql
            6 Query       show index from time_zone
MySql, Version: 4.1.11-log. started with:
Tcp port: 3306  Unix socket: MySQL
Time                 Id Command    Argument
MySql, Version: 4.1.11-log. started with:
Tcp port: 3306  Unix socket: MySQL
Time                 Id Command    Argument
MySql, Version: 4.1.11-log. started with:
Tcp port: 3306  Unix socket: MySQL
Time                 Id Command    Argument
MySql, Version: 4.1.11-log. started with:
Tcp port: 3306  Unix socket: MySQL
Time                 Id Command    Argument
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Wed Aug 10, 2005 4:56 pm Reply with quoteBack to top

There is no htaccess file because phpmyadmin under the a2t configuration uses a header response that acts the same as a htaccess with Auth would do

Besides that i do not know what to say , it could be anything , if the login works then afterwards not
View user's profileSend private message
meburke
 
 


Joined: 17 Aug 2005
Posts: 7

PostPosted: Tue Aug 23, 2005 11:18 am Reply with quoteBack to top

I would have to enter my name and passsword 3 or 4 times to enter the phpMyAdmin app as root. I also have an app called DBDesigner 4 that wouldn't connect. I had to create a user with all privileges using the OLD_PASSWORD format, and I have no trouble connecting to phpMyAdmin with that user. Maybe that will help narrow the scope of the problem?

Here's where I found the info: http://dev.mysql.com/doc/mysql/en/old-client.html

Mike
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Tue Aug 23, 2005 3:31 pm Reply with quoteBack to top

these issues are specific to mysql 4.1 versions , i suggest you go with the stable apache2triad releases that contain mysql 4.0
View user's profileSend private message
meburke
 
 


Joined: 17 Aug 2005
Posts: 7

PostPosted: Tue Aug 23, 2005 5:03 pm Reply with quoteBack to top

You are correct in that my control panel reports I'm running MySQL 4.1.11. Cute.

Well, Im in a quandry here: I don't really want to uninstall and re-install A2T, but I would like to upgrade my Apache server to 2.0.54 and either one requires that I take a lot of time out of the current project to do some WAMP administration. The phpMyAdmin thing is an annoyance, but I'm not really motivated to undo something that works so well.

I really need to upgrade the Apache server. How about pointing me to a simple set of instructions that will upgrade the A2T installation?

Thanks,

Mike
View user's profileSend private message
sSenseThade
 
 


Joined: 18 May 2005
Posts: 3

PostPosted: Wed Aug 24, 2005 9:56 am Reply with quoteBack to top

If there was a readily available method to upgrade to the lastest features of all the software Apache2Triad uses...
You would already be using Apache2Triad version 30

The point is, the current (stable) release of apache is exactly that.

If you are going to update individual features you will run into the problems everyone else does.
That is why we all use apache2triad because the hassle factor is taken away by the dedicated people updating it.

The only real way to stay fully upto date with all features is to do it yourself in all fairness. I don't think any combined project will ever be good enough to keep up unless it becomes a full-time paid job.

I would suggest, more constructively, you view the respective sites to assist you in the problem as it is not an Apache2Triad problem.
MySQL site, Apache, Php... etc
________
ZX14 VS HAYABUSA


Last edited by sSenseThade on Wed Feb 16, 2011 4:36 pm; edited 1 time in total
View user's profileSend private message
meburke
 
 


Joined: 17 Aug 2005
Posts: 7

PostPosted: Wed Aug 24, 2005 11:50 am Reply with quoteBack to top

Well, the current release of Apache is 2.0.54, so I think I'm justified in thinking that it is OK to install. So I did: I simply did a custom install and installed it to the Apach2Triad directory, where it created a directory called Apache2 with two subdirectories named "conf" and "logs". When the MSI installer came up with domain and hostname references I changed them to "localhost". The A2T CP shows I'm now running 2.0.54 (although the info section still says .53). The only problem I see in the A2T CP is a red triangle warning sign next to the administrator's e-mail address, which I believe is something I'll have to edit in the conf file.

I do not recommend this for everybody, especially if they need their system for stable production. My development laptop is more a "LABtop" and I experiment a lot. I will probably pay for this little experiment later when I find something is broken and I'm under a deadline. However, I backed up all the files in my htdocs and backed up the configuration files, so I can probably restore myself to usability in an emergency.

I do experimental work to produce solid solutions resulting in stable applications, and I can't remain ignorant just because the software changes and I don't like it. I totally agree, however, that having Mr. Mancini and friends do the brainsweat for installing WAMP has saved me hours of time this week.

Thanks,

Mike
View user's profileSend private message
ibby
 
 


Joined: 05 Jun 2007
Posts: 24

PostPosted: Wed Jun 06, 2007 8:10 am Reply with quoteBack to top

I had this problem yesterday on my 2nd install of the newer version of Triad2.

It said that it could not connect to mysql database, and the password had not been chnaged.

Asked me to try to telnet into the localhost and put in portnumber.

However, soon after install, I could login using Root and password as blank.

This worked fine.

I chnaged my password after that.
View user's profileSend private message
Display posts from previous:      
Post new topic Reply to topic


 Jump to:   



View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme
All times are GMT