Page 1 of 2

500 Internal Server Error

PostPosted: Tue Feb 14, 2012 5:59 pm
by noy_siam
Hi Guys,

I have a problem with the GUI after the installation, "500 Internal Server Error".
The application installed following the "Beginner’s Guide" step by step on a clean Ubuntu 10.04 LTS OS server as recommended.
After the installation the OS I run the apt-get update and apt-get upgrade and reboot the server.
When I finished to install the install-all.sh script and reboot the server, I tried to reached the GUI via Chrome, the 500 error showed.
The port 80 working well but the port 8008 not, I check it in Firewall, iptables etc... the port is open, there is no errors in apache2 log service.
In the log file /var/log/newfies/err-apache-newfies.log I find this error:
DatabaseError: (1146, "Table 'newfies.dialer_phonebook' doesn't exist")
I will appreciate your advice and you time.

Thanks,
Noy

Re: 500 Internal Server Error

PostPosted: Tue Feb 14, 2012 8:08 pm
by areski
It seems an error occur when the install script try to create the database, can you relaunch it and copy the content of it !?

Re: 500 Internal Server Error

PostPosted: Wed Feb 15, 2012 9:03 am
by noy_siam
I have find this error during the installation:
Code: Select all
Run backup with mysqldump...
mysqldump: Got error: 1049: Unknown database 'newfies' when selecting the database
Mysql Dump of database newfies added in /tmp/old-newfies-dialer_20120214105851.mysqldump.sql
Press Enter to continue

Under /tmp/ folder there is no "old-newfies-dialer_20120214105851.mysqldump.sql" file.
The Ubuntu OS installed on cloud base.

Re: 500 Internal Server Error

PostPosted: Wed Feb 15, 2012 9:19 am
by areski
This error is normal if you run the installation script on a new server, the script try to do a backup of the previous data just as a security measure!

Re: 500 Internal Server Error

PostPosted: Wed Feb 15, 2012 1:22 pm
by noy_siam
ok, so all those errors not give us a clue about the problem.
where can i look for more clues? there is more log files i can look into?

Re: 500 Internal Server Error

PostPosted: Wed Feb 15, 2012 2:22 pm
by areski
After installation Newfies-Dialer, check if the database is well created, if you don't see the tables created then the install script failed somewhere, but it's not happening where you mentioned it earlier.

Re: 500 Internal Server Error

PostPosted: Wed Feb 15, 2012 3:35 pm
by noy_siam
Yes, you right.
The DB was not created well.
I can see the Newfies DB
Code: Select all
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| newfies            |
+--------------------+

but its empty
Code: Select all
mysql> show tables;
Empty set (0.00 sec)


I tried to reinstall the application but its still empty. There is any way to install the db only?

Re: 500 Internal Server Error

PostPosted: Wed Feb 15, 2012 4:05 pm
by areski
As asked before, it will be nice to see the full output of the install script!

Re: 500 Internal Server Error

PostPosted: Thu Feb 16, 2012 9:52 am
by noy_siam
Here is the full newfies-django.log file.
http://pastebin.com/GCKyxq4r
And this is the full err-apache-newfies.log file.
http://pastebin.com/3R7n6H3q
All other log files (celery-newfies-node1.log and newfies-django-db.log) are empty.
If its not the content you looking for, please let me know the files path.
Thank you very much for your helping.

Noy

Re: 500 Internal Server Error

PostPosted: Thu Feb 16, 2012 10:10 am
by areski
Hi,

Code: Select all
File "/usr/share/virtualenvs/newfies-dialer/lib/python2.6/site-packages/MySQLdb/connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")


It's very clear that the access information to your MySQL database are not correct.