Page 1 of 2
500 Internal Server Error
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
Thu Feb 16, 2012 9:52 am
by noy_siam
Here is the full newfies-django.log file.
http://pastebin.com/GCKyxq4rAnd this is the full err-apache-newfies.log file.
http://pastebin.com/3R7n6H3qAll 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
Posted:
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.