login problem on a small database driven web application
 

Desktop is Win2K, IE 6.0
Server is Fedora Core 5, PHP 5.1.4, mysql 5.0.22


I had a small database driven web application running on
my Fedora Core 5 system "A" with no problems at all.

I moved the application to another FC 5 system "B"
with the associated MySQL tables.


On the old FC5 system "A", I would login after entering the id and password at:
https://192.168.2.103/testing/

But now after entering the id and password on the new FC5 "B" system,
I get thrown back to the login screen with this URL:
https://192.168.2.103/testing/index.php?ccsForm=Login


On the new FC5 "B" system, I can see all my MySQL data from the mysql command line.
Including the id and password.
I entered the correct id and password.

The /var/log/httpd/ssl_error_log contains just these sort of entries and nothing else:
...........
[Wed Aug 30 01:09:11 2006] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Wed Aug 30 01:09:11 2006] [warn] RSA server certificate CommonName (CN) `localhost.localdomain' does NOT match server name!?
[Wed Aug 30 01:09:15 2006] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Wed Aug 30 01:09:15 2006] [warn] RSA server certificate CommonName (CN) `localhost.localdomain' does NOT match server name!?
...........

And yet I am stuck at the login screen.
What am I doing wrong?



So then I tried a non-existent id and password.

Again, I was back at the login page with the URL
https://192.168.2.103/testing/index.php?ccsForm=Login

I was expecting some invalid id message.
But I did not get any such message.

MySQL is running:
...........
ps aux | grep mysql
root 1813 0.0 0.4 4448 1264 ? S 01:32 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid --log-error=/var/log/mysqld.log
mysql 1849 0.0 7.1 136544 18288 ? Sl 01:32 0:00 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
root 4187 0.0 0.2 3916 652 pts/2 R+ 03:18 0:00 grep mysql
...........



The recent entries in the /var/log/mysql.log are:
...........
060830 01:32:52 mysqld started
060830 1:32:53 InnoDB: Started; log sequence number 0 43685
060830 1:32:54 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
...........



So I migrated a 2nd small database driven web application from my Fedora Core 5 system "A" to
the same FC 5 system "B" with the associated MySQL tables.
This time without any problems.

But I still have the same login problem with the 1st application.

What you seem to be doing wrong is trying to use a cert that was
made for machine A on machine B. According to your log, anyway.

As for the second one: does it make use of SSL, too? If it doesn't
that would explain why it works.


Cheers,
Tink

I understand what you saying about the cert.
I am not using any other cert on machine A.
The cert on machine A was created (by default) when FC5 was installed.
The hostname on machine A is not "localhost.localdomain" so we get this warning.

But this warning is not the issue because the 2nd application seems to work just fine.

The 2nd application also uses SSL.

So the login problem is limited to the 1st application.