Tuesday, July 17, 2012

While running manage.py syncdb if "settings.DATABASES is improperly configured"

While running manage.py syncdb if "settings.DATABASES is improperly configured" although you are in the directory containing the settings.py file.

try: $ python manage.py syncdb --settings=settings

Monday, July 16, 2012

Set up SquirrelSql for Ubuntu

This is a guide to setting up SquirrelSql on Ubuntu..

1. Download SquirrelSql from : http://sourceforge.net/projects/squirrel-sql/files/1-stable/3.3.0/squirrel-sql-3.3.0-install.jar/download

2. Unzip the tarball by doing $ tar zxf <path-to-tarball>. To install the jar, $ java -jar <path-to-jar-file> . Then follow the on screen instructions (make sure to check MySql among the checkboxes) and you're done.

3. To connect to the database, you need a mysql driver. Download it from : http://dev.mysql.com/downloads/connector/j/

4. Fire up SquirrelSql and choose the "Drivers" on the vertical tab on the left.

5. Scroll to MySql and double click on it. Click on the 'Extra Class path' tab.

6. Click 'Add' and browse to the .jar friver file you downloaded at step3. Then hit 'Ok'.

7. Next, choose 'Aliases' on the vertical tab on the left and hit the '+' sign to add a new Alias.

8. Enter a name of your choice for the alias and in the driver dropdown menu select MySql.

9. For the url, enter the url that points to the database. For my local copy of the database I put. jdbc:mysql://localhost

10. Enter the username and password that you configured for your local db 'efldbadmin' and whatever password you choose. If connecting to staging use the password from dev.py

11. Hit 'Test' and then 'Connect'.  You should get a 'Connection Successful' message.

You're done! ^_^

Popular Posts