500 Internal Server Error

[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

[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 !?

[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.

[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!

[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?

[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.

[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?

[areski]

As asked before, it will be nice to see the full output of the install script!

[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

[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.