My "regexfu" is pretty bad, but I'll try.
On Tue, Jun 23, 2009 at 9:38 AM, mdipierro<mdipie...@cs.depaul.edu> wrote:
>
> Can you help me debug why? Perhaps there is a typo in the regex?
>
> Massimo
>
> On Jun 22, 8:23 pm, Alexei Vinidiktov <alexei.vinidik...@gmail.com>
> wrote:
>> Thanks, Massimo!
>>
>> The auth.settings.password_field='password2' thing did the trick!
>>
>> I'm afraid the '?set_encoding=None' thing doesn't work.
>>
>> As I said earlier I tried using the string that you suggested:
>>
>> db = SQLDB('firebird://sysdba:passw...@localhost/employee.fdb?
>> set_encoding=None')
>>
>> but I got this error:
>>
>> "'isc_attach_database: I/O error for file "employee.fdb?set_encoding=None"
>> Error while trying to open file. No such file or directory'"
>>
>>
>>
>> On Tue, Jun 23, 2009 at 4:46 AM, mdipierro<mdipie...@cs.depaul.edu> wrote:
>>
>> > ?set_encoding=None
>>
>> > should have the effect of not running "SET NAMES"
>>
>> > The other problem you have is that "password' cannot be used a field
>> > name by auth because it is a reserved in firebird.
>>
>> > auth.settings.password_field='password2'
>>
>> > before auth.define_tables()
>>
>> > Massimo
>>
>> > On Jun 22, 9:42 am, Alexei Vinidiktov <alexei.vinidik...@gmail.com>
>> > wrote:
>> >> Thanks for your input, Jose.
>>
>> >> As I said earlier, I had tried commenting the lines that add SET NAMES
>> >> in sql.py, and I got a different error message that I quoted in a
>> >> previous email. Part of the traceback was:
>>
>> >> self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
>> >> ProgrammingError: (-104, \'isc_dsql_prepare: Dynamic SQL Error SQL
>> >> error code = -104
>> >> Token unknown - line 6, column 2 password\')'
>>
>> >> And the solution Massimo suggested didn't work either which I also
>> >> reported in a previous email.
>>
>> >> On Mon, Jun 22, 2009 at 10:36 PM, Jose<jjac...@gmail.com> wrote:
>>
>> >> > On 22 jun, 02:54, Alexei Vinidiktov <alexei.vinidik...@gmail.com>
>> >> > wrote:
>> >> >> Hello,
>>
>> >> >> I'm trying to make a connection to a Firebird db file, but I keep
>> >> >> getting this error:
>>
>> >> >> Traceback (most recent call last):
>> >> >> File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/restricted.py",
>> >> >> line 98, in restricted
>> >> >> exec ccode in environment
>> >> >> File
>> >> >> "/var/www/alvinru/data/www/bilingsoft.ru/applications/notebook/models/db.py",
>> >> >> line 12, in <module>
>> >> >> db = SQLDB(\'firebird://sysdba:passw...@localhost/employee.fdb\')
>> >> >> File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/sql.py", line
>> >> >> 837, in __init__
>> >> >> self._execute(\'SET NAMES %s;\' % charset)
>> >> >> File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/sql.py", line
>> >> >> 835, in <lambda>
>> >> >> self._execute = lambda *a, **b: self._cursor.execute(*a,**b)
>> >> >> ProgrammingError: (-104, \'isc_dsql_prepare: Dynamic SQL Error SQL
>> >> >> error code = -104
>> >> >> Token unknown - line 1, column 5 NAMES\')'
>>
>> >> >> My connection string in db.py is like this:
>>
>> >> >> db = SQLDB('firebird://sysdba:passw...@localhost/employee.fdb')
>>
>> >> >> I can successfully connect to the same database from the command line:
>>
>> >> >> import kinterbasedb
>> >> >> con = kinterbasdb.connect(
>> >> >> host='localhost', database='employee.fdb',
>> >> >> user='sysdba', password='password'
>> >> >> )
>>
>> >> >> I'm using CentOS 5.2 with Python 2.5.4, Firebird 2.1.2 Super Server
>> >> >> and the latest version of web2py.
>>
>> >> >> I'd be grateful for any clues as to what might be happening.
>>
>> >> >> --
>> >> >> Alexei Vinidiktov
>>
>> >> > This had commented on it to Massimo, the instruction :
>> >> > SET NAMES
>> >> > It is not valid in firebird.
>>
>> >> > Jose
>>
>> >> --
>> >> Alexei Vinidiktov
>>
>> --
>> Alexei Vinidiktov
> >
>
--
Alexei Vinidiktov
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
