On Saturday 25 August 2007 04:35, Iain Mac Donald wrote: > Hello Folks, > > came across Dabo yesterday and decided to have a look around. Did an > svn co > > svn checkout http://svn.dabodev.com/dabo/trunk dabo > svn checkout http://svn.dabodev.com/dabodemo/trunk dabodemo > svn checkout http://svn.dabodev.com/daboide/trunk daboide > > Installed the reqs: python-reportlab python-wxgtk2.6 python-psycopg2 > sqlite3 python-pysqlite2. Setup Dabo and checked I could import dabo. > > Created simple database with single table: > CREATE TABLE card (id SERIAL, title CHAR(5), forename CHAR(35), surname > CHAR(35), country CHAR(35), email CHAR(35)); > > Changed directory to AppWizard and ran the application. Tried to use my > simple database using 127.0.0.1/localhost/domain name/192.168.0.45 > (this is my notebook) but received this output > > "Could not connect to the database server. Please check your parameters > and try again." > > and > > Traceback (most recent call last): > File "AppWizard.py", line 305, in onLeavePage > tables = cursor.getTables() > File > "/usr/lib/python2.4/site-packages/Dabo-0.9a-py2.4.egg/dabo/db/dCursorMixin. >py", line 1657, in getTables return > self.BackendObject.getTables(self.AuxCursor, includeSystemTables) File > "/usr/lib/python2.4/site-packages/Dabo-0.9a-py2.4.egg/dabo/db/dbPostgreSQL. >py", line 76, in getTables tables.append(record[0]) KeyError: 0 > > Set debug5 on in PostgreSQL but I am not seeing anything in the log. > Psql connects to the DB fine. I am using Debian Etch with PostgreSQL > 8.1 and I am not using SSL. > > Pointers anyone?
I guess the first thing to do is confirm that you can make a connection to the DB. To do that run "CxnEditor.py". CxnEditor will allow you to test the connection. Also you need to be aware that all postgres tables require a primary constraint be created. You have already created the ID (serial) field and you could assign it as your primary key. Unfortunately, I am leaving for the weekend so hopefully someone else will lend a hand in getting you started. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
