LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 08-30-2006, 03:42 PM   #1
lothario
Member
 
Registered: Apr 2004
Posts: 340

Rep: Reputation: 30
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.
 
Old 08-30-2006, 04:32 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,972
Blog Entries: 11

Rep: Reputation: 876Reputation: 876Reputation: 876Reputation: 876Reputation: 876Reputation: 876Reputation: 876
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
 
Old 08-30-2006, 04:51 PM   #3
lothario
Member
 
Registered: Apr 2004
Posts: 340

Original Poster
Rep: Reputation: 30
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Small database program? PatrickMay16 General 1 06-14-2006 11:32 PM
Linux based Interrupt driven application lucky6969b Programming 5 03-24-2006 11:27 PM
Web Application to grab large files from web addresses farmerjoe Programming 3 10-16-2005 08:49 AM
database driven site (egrade) rksprst General 3 06-27-2005 04:51 PM
looking for a small simple database?? Teckno Linux - Software 1 06-03-2004 02:06 PM


All times are GMT -5. The time now is 05:47 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration