Hello,
I tried to use the connection editor under Windows 7 and after a successful
test, when I went to use the connection, I received an error. Taking a look
at the file, it had a zero length. I deleted the file and tried again in
Windows and I saved a screen shot of the console output here
http://theprioryinn.co.uk/dabo/cxneditor.png.
Help about says:
Platform: Win
Python Version: 2.7.3 on win32
Dabo Version: Version 0.9.4; Revision ~7201
UI Version: 2.8.12.1 on wxMSW
I then gave it a try under Linux Mint 13 and had the same problems.
Help about on Mint says:
Platform: GTK
Python Version: 2.7.3 on linux2
Dabo Version: Version 0.9.4; Revision 7207
UI Version: 2.8.12.1 on wxGTK (gtk2)
Strangely it works on my Mint 12 install which is:
Platform: GTK
Python Version: 2.7.2+ on linux2
Dabo Version: Version 0.9.4; Revision 7173
UI Version: 2.8.11.0 on wxGTK (gtk2)
Does anybody have any ideas?
Dave Kelly
The Priory Inn
01666 502 251
<http://www.theprioryinn.co.uk/> www.theprioryinn.co.uk
"Dining in a 30 Mile Food Zone"
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/003701cd6755$5712bfa0$05383ee0$@theprioryinn.co.uk
Author: Sibylle Koczian
Posted: 2012-07-21 12:08:52 Link
Am 21.07.2012 17:27, schrieb Dave Kelly:
> Hello,
>
>
>
> I tried to use the connection editor under Windows 7 and after a successful
> test, when I went to use the connection, I received an error. Taking a look
> at the file, it had a zero length. I deleted the file and tried again in
> Windows and I saved a screen shot of the console output here
> http://theprioryinn.co.uk/dabo/cxneditor.png.
>
Looks very similar to the problem I had some weeks ago. In my case I had
two different .cnxml files for connecting to different databases in the
same project. After deleting one of them, I could save and use the other.
HTH
Sibylle
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/500AE224.4060603@t-online.de
Author: Ed Leafe
Posted: 2012-07-21 12:25:06 Link
On Jul 21, 2012, at 10:27 AM, Dave Kelly wrote:
> I tried to use the connection editor under Windows 7 and after a successful
> test, when I went to use the connection, I received an error. Taking a look
> at the file, it had a zero length. I deleted the file and tried again in
> Windows and I saved a screen shot of the console output here
> http://theprioryinn.co.uk/dabo/cxneditor.png.
I'm trying to see how the connection could become defined without the 'dbtype' key. I know I could just wrap that line with a try/except, but I'd really like to figure out how this is happening in the first place.
-- Ed Leafe
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/C0BE4205-48D8-4289-8926-525448F4C3C2@leafe.com
Author: Dave Kelly
Posted: 2012-07-21 12:38:08 Link
I don't see that I have multiple .cnxml files in this project - certainly
not in the /db database. Could it be lurking in another directory?
Dave Kelly
The Priory Inn
01666 502 251
www.theprioryinn.co.uk
"Dining in a 30 Mile Food Zone"
-----Original Message-----
From: dabo-users-bounces@leafe.com [mailto:dabo-users-bounces@leafe.com] On
Behalf Of Sibylle Koczian
Sent: 21 July 2012 18:09
To: Dabo Users list
Subject: Re: [dabo-users] Struggling with connection editor
Am 21.07.2012 17:27, schrieb Dave Kelly:
> Hello,
>
>
>
> I tried to use the connection editor under Windows 7 and after a
> successful test, when I went to use the connection, I received an
> error. Taking a look at the file, it had a zero length. I deleted
> the file and tried again in Windows and I saved a screen shot of the
> console output here http://theprioryinn.co.uk/dabo/cxneditor.png.
>
Looks very similar to the problem I had some weeks ago. In my case I had two
different .cnxml files for connecting to different databases in the same
project. After deleting one of them, I could save and use the other.
HTH
Sibylle
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/500AE224.4060603@t-online.de
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/004201cd6767$97edd110$c7c97330$@theprioryinn.co.uk
Author: Dave Kelly
Posted: 2012-07-21 12:38:33 Link
How can I help?
Dave Kelly
The Priory Inn
01666 502 251
www.theprioryinn.co.uk
"Dining in a 30 Mile Food Zone"
-----Original Message-----
From: dabo-users-bounces@leafe.com [mailto:dabo-users-bounces@leafe.com] On
Behalf Of Ed Leafe
Sent: 21 July 2012 18:25
To: Dabo Users list
Subject: Re: [dabo-users] Struggling with connection editor
On Jul 21, 2012, at 10:27 AM, Dave Kelly wrote:
> I tried to use the connection editor under Windows 7 and after a
> successful test, when I went to use the connection, I received an
> error. Taking a look at the file, it had a zero length. I deleted
> the file and tried again in Windows and I saved a screen shot of the
> console output here http://theprioryinn.co.uk/dabo/cxneditor.png.
I'm trying to see how the connection could become defined without
the 'dbtype' key. I know I could just wrap that line with a try/except, but
I'd really like to figure out how this is happening in the first place.
-- Ed Leafe
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/C0BE4205-48D8-4289-8926-525448F4C3C2@leafe.c
om
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/004301cd6767$a6f13350$f4d399f0$@theprioryinn.co.uk
Author: Dave Kelly
Posted: 2012-07-21 12:42:29 Link
I executed the following command to see if there are multiple cnxml files in
my project:
dave@Mint-Maya ~/timeclock $ find ~/timeclock -name *cnxml
/home/dave/timeclock/db/cxn_priory.cnxml
It returned the only one.
Dave Kelly
The Priory Inn
01666 502 251
www.theprioryinn.co.uk
"Dining in a 30 Mile Food Zone"
-----Original Message-----
From: dabo-users-bounces@leafe.com [mailto:dabo-users-bounces@leafe.com] On
Behalf Of Sibylle Koczian
Sent: 21 July 2012 18:09
To: Dabo Users list
Subject: Re: [dabo-users] Struggling with connection editor
Am 21.07.2012 17:27, schrieb Dave Kelly:
> Hello,
>
>
>
> I tried to use the connection editor under Windows 7 and after a
> successful test, when I went to use the connection, I received an
> error. Taking a look at the file, it had a zero length. I deleted
> the file and tried again in Windows and I saved a screen shot of the
> console output here http://theprioryinn.co.uk/dabo/cxneditor.png.
>
Looks very similar to the problem I had some weeks ago. In my case I had two
different .cnxml files for connecting to different databases in the same
project. After deleting one of them, I could save and use the other.
HTH
Sibylle
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/500AE224.4060603@t-online.de
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/004401cd6768$337c3450$9a749cf0$@theprioryinn.co.uk
Author: Ed Leafe
Posted: 2012-07-22 18:09:11 Link
On Jul 21, 2012, at 12:42 PM, Dave Kelly wrote:
> I executed the following command to see if there are multiple cnxml files in
> my project:
>
> dave@Mint-Maya ~/timeclock $ find ~/timeclock -name *cnxml
> /home/dave/timeclock/db/cxn_priory.cnxml
>
> It returned the only one.
I don't think it's multiple cnxml files that is the problem; I think it's multiple connections in a single file. I was able to reproduce this once I added a second connection.
-- Ed Leafe
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/9880EF14-170B-414B-B5CC-2A48541DE1BB@leafe.com
Author: Ed Leafe
Posted: 2012-07-23 11:18:26 Link
On Jul 21, 2012, at 10:27 AM, Dave Kelly wrote:
> I tried to use the connection editor under Windows 7 and after a successful
> test, when I went to use the connection, I received an error. Taking a look
> at the file, it had a zero length. I deleted the file and tried again in
> Windows and I saved a screen shot of the console output here
> http://theprioryinn.co.uk/dabo/cxneditor.png.
OK, I've re-worked the code in that script, and it should be working correctly now. If you can update from the latest svn and test to confirm, I would appreciate it.
-- Ed Leafe
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/56521B9A-2B80-474C-9B20-16C9338DAB3E@leafe.com
Author: Dave Kelly
Posted: 2012-07-24 02:35:12 Link
Ed,
I checked out the most recent revision with:
dave@Mint-Maya ~ $ svn checkout http://svn.dabodev.com/dabo/trunk dabo
U dabo/ide/CxnEditor.py
Checked out revision 7208.
I deleted the 0 length connection file.
I re-ran the connection editor and received the following error:
dave@Mint-Maya ~/timeclock/db $ dconnect
/usr/lib/python2.7/dist-packages/dabo/lib/SimpleCrypt.py:52: UserWarning:
WARNING: SimpleCrypt is not secure. Please see
http://wiki.dabodev.com/SimpleCrypt for more information
warnings.warn("WARNING: SimpleCrypt is not secure. Please see
http://wiki.dabodev.com/SimpleCrypt for more information")
Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/dabo/ui/uiwx/dControlMixin.py",
line 27, in _onWxHit
self.raiseEvent(dEvents.Hit, evt, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/dabo/ui/uiwx/dPemMixin.py", line
1074, in raiseEvent
super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args,
**kwargs)
File "/usr/lib/python2.7/dist-packages/dabo/lib/eventMixin.py", line 81,
in raiseEvent
bindingFunction(event)
File "/home/dave/dabo/ide/CxnEditor.py", line 278, in onSave
self.saveFile()
File "/home/dave/dabo/ide/CxnEditor.py", line 23, in _wrapped
return fnc(self, *args, **kwargs)
File "/home/dave/dabo/ide/CxnEditor.py", line 437, in saveFile
self.writeChanges()
File "/home/dave/dabo/ide/CxnEditor.py", line 552, in writeChanges
vals = self.relPaths(self.connDict.values())
File "/home/dave/dabo/ide/CxnEditor.py", line 565, in relPaths
if self.isFileBasedBackend(val["dbtype"]):
KeyError: 'dbtype'
Sorry,
Dave Kelly
The Priory Inn
01666 502 251
www.theprioryinn.co.uk
"Dining in a 30 Mile Food Zone"
-----Original Message-----
From: dabo-users-bounces@leafe.com [mailto:dabo-users-bounces@leafe.com] On
Behalf Of Ed Leafe
Sent: 23 July 2012 17:18
To: Dabo Users list
Subject: Re: [dabo-users] Struggling with connection editor
On Jul 21, 2012, at 10:27 AM, Dave Kelly wrote:
> I tried to use the connection editor under Windows 7 and after a
> successful test, when I went to use the connection, I received an
> error. Taking a look at the file, it had a zero length. I deleted
> the file and tried again in Windows and I saved a screen shot of the
> console output here http://theprioryinn.co.uk/dabo/cxneditor.png.
OK, I've re-worked the code in that script, and it should be working
correctly now. If you can update from the latest svn and test to confirm, I
would appreciate it.
-- Ed Leafe
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/56521B9A-2B80-474C-9B20-16C9338DAB3E@leafe.c
om
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/004801cd696e$dcca31d0$965e9570$@theprioryinn.co.uk
Author: Ed Leafe
Posted: 2012-07-24 20:15:01 Link
On Jul 24, 2012, at 2:35 AM, Dave Kelly wrote:
> dave@Mint-Maya ~/timeclock/db $ dconnect
What is 'dconnect'? If it's an alias, what does the alias expand to?
I've been trying to get that error by trying all sorts of permutations of steps, and I'm no longer able to get the traceback. Can you outline the steps you follow to get that?
-- Ed Leafe
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/6B69F734-3208-4FCA-AF35-FA5EE4BD1140@leafe.com