Any one the Dev list that can help here....
-----Oprindelig meddelelse-----
Fra: Mikael Syska [mailto:mikael@syska.dk]
Sendt: 31. januar 2004 20:06
Til: 'dbmail@dbmail.org'
Emne: SV: SV: [Dbmail] Easiest way to transfer mails from postgresql 1.x to
mysql 2.x or 1.x does not matter.......
Hi Poul,
The alias is "mikael@syska.dk"
Nope did not help to solve the problem.
I have now tried to get the newest version that includes the
"./migrate_singe_user.py" and it still fails.....
I'm trying to migrate from PostGreSQL to MySQL version 3.23.57.
If there are more information need just ask.....
I want to get the database moved ASAP.
Here are output from the new single user migration script are a down:
LOADING DATABASE DRIVERS
loading MySQL driver
loading MySQL driver
connecting to databases
Name of user to copy data for?mikael@syska.dk finding user in database
1 =nieuwe user
copying aliases table
copied 5 records from aliases table
copying mailboxes, messages and messageblocks table Traceback (most recent
call last):
File "./migrate_singe_user.py", line 141, in ?
cursor_2.execute("""INSERT INTO mailboxes
File
"/usr/ports/databases/py-mysql/w-py-mysql-0.9.2/fake-i386/usr/local/lib/pyth
on2.2/site-packages/MySQLdb/cursors.py", line 95, in execute
return self._execute(query, args)
File
"/usr/ports/databases/py-mysql/w-py-mysql-0.9.2/fake-i386/usr/local/lib/pyth
on2.2/site-packages/MySQLdb/cursors.py", line 114, in _execute
self.errorhandler(self, exc, value)
File
"/usr/ports/databases/py-mysql/w-py-mysql-0.9.2/fake-i386/usr/local/lib/pyth
on2.2/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1136, "Column count doesn't match value
count at row 1") fw#
>-----Oprindelig meddelelse-----
>Fra: dbmail-admin@dbmail.org [mailto:dbmail-admin@dbmail.org] På vegne
>af Paul J Stevens
>Sendt: 31. januar 2004 19:06
>Til: dbmail@dbmail.org
>Emne: Re: SV: [Dbmail] Easiest way to transfer mails from postgresql
>1.x to mysql 2.x or 1.x does not matter.......
>
>What are the exact aliases that make the script barf?
>
>Try:
>
>cursor_2.execute("""INSERT INTO auto_notifications
> (auto_notify_idnr, user_idnr, notify_address)
> VALUES ('%s', '%s', '%s')""", record)
>
>instead around line 113. Notice the single quotes around the values.
>
>Sorry for not making this a proper diff. The missing quotes are a
>generic problem I notice in this code. I'm guessing there may be some
>weird chars in your aliases that drive python's string interpolation
>into recursive mania.
>
>Also, aside from messages and messageblks you should be able to dump
>and load the 1.2 tables straight into the 2.0 db.
>
>
>
>
>
>Mikael Syska wrote:
>
>>Plese there must be someone how can help me with the errors...
>>If, then plese contact me on MSN: mikael@syska.dk or ICQ: 37679058...
>>
>>Or just reply to the list.....
>>
>>
>>
>>>-----Oprindelig meddelelse-----
>>>Fra: dbmail-admin@dbmail.org
>[mailto:dbmail-admin@dbmail.org] På vegne
>>>af Mikael Syska
>>>Sendt: 29. januar 2004 17:57
>>>Til: dbmail@dbmail.org
>>>Emne: [Dbmail] Easiest way to transfer mails from postgresql 1.x to
>>>mysql 2.x or 1.x does not matter.......
>>>
>>>All in the subject, nothing more to say, I have tried the script in
>>>the dbmail 2.0 from 1 to 2, but I can't get it to work.....
>>>
>>>Here are the output from the script....
>>>------------------------------------------------------
>>>LOADING DATABASE DRIVERS
>>>
>>>loading MySQL driver
>>>loading PostgreSQL driver
>>>connecting to databases
>>>copying aliases table
>>>Traceback (most recent call last):
>>> File "./migration_1_x_to_2_0alpha.py", line 97, in ?
>>> cursor_2.execute("""INSERT INTO aliases (alias_idnr, alias, File
>>>"/usr/local/lib/python2.3/site-packages/MySQLdb/cursors.py",
>>>line 95, in execute
>>> return self._execute(query, args)
>>> File
>>>"/usr/local/lib/python2.3/site-packages/MySQLdb/cursors.py",
>>>line 114, in _execute
>>> self.errorhandler(self, exc, value) File
>>>"/usr/local/lib/python2.3/site-packages/MySQLdb/connections.py"
>>>, line 33, in defaulterrorhandler
>>> raise errorclass, errorvalue
>>>RuntimeError: maximum recursion depth exceeded
>>>------------------------------------------------------
>>>
>>>I'm really desperate, any help would be great....
>>>
>>>Is there are IRC channel for dbmail?? If where????
>>>
>>>// ouT
>>>
>>>_______________________________________________
>>>Dbmail mailing list
>>>Dbmail@dbmail.org
>>>https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>
>>>
>>>
>>
>>_______________________________________________
>>Dbmail mailing list
>>Dbmail@dbmail.org
>>https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
>>
>>
>
>--
> ________________________________________________________________
> Paul Stevens mailto:paul@nfg.nl
> NET FACILITIES GROUP PGP: finger paul@nfg.nl
> The Netherlands________________________________http://www.nfg.nl
>
>_______________________________________________
>Dbmail mailing list
>Dbmail@dbmail.org
>https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
-----Oprindelig meddelelse-----
Fra: Mikael Syska [mailto:mikael@syska.dk]
Sendt: 31. januar 2004 20:06
Til: 'dbmail@dbmail.org'
Emne: SV: SV: [Dbmail] Easiest way to transfer mails from postgresql 1.x to
mysql 2.x or 1.x does not matter.......
Hi Poul,
The alias is "mikael@syska.dk"
Nope did not help to solve the problem.
I have now tried to get the newest version that includes the
"./migrate_singe_user.py" and it still fails.....
I'm trying to migrate from PostGreSQL to MySQL version 3.23.57.
If there are more information need just ask.....
I want to get the database moved ASAP.
Here are output from the new single user migration script are a down:
LOADING DATABASE DRIVERS
loading MySQL driver
loading MySQL driver
connecting to databases
Name of user to copy data for?mikael@syska.dk finding user in database
1 =nieuwe user
copying aliases table
copied 5 records from aliases table
copying mailboxes, messages and messageblocks table Traceback (most recent
call last):
File "./migrate_singe_user.py", line 141, in ?
cursor_2.execute("""INSERT INTO mailboxes
File
"/usr/ports/databases/py-mysql/w-py-mysql-0.9.2/fake-i386/usr/local/lib/pyth
on2.2/site-packages/MySQLdb/cursors.py", line 95, in execute
return self._execute(query, args)
File
"/usr/ports/databases/py-mysql/w-py-mysql-0.9.2/fake-i386/usr/local/lib/pyth
on2.2/site-packages/MySQLdb/cursors.py", line 114, in _execute
self.errorhandler(self, exc, value)
File
"/usr/ports/databases/py-mysql/w-py-mysql-0.9.2/fake-i386/usr/local/lib/pyth
on2.2/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1136, "Column count doesn't match value
count at row 1") fw#
>-----Oprindelig meddelelse-----
>Fra: dbmail-admin@dbmail.org [mailto:dbmail-admin@dbmail.org] På vegne
>af Paul J Stevens
>Sendt: 31. januar 2004 19:06
>Til: dbmail@dbmail.org
>Emne: Re: SV: [Dbmail] Easiest way to transfer mails from postgresql
>1.x to mysql 2.x or 1.x does not matter.......
>
>What are the exact aliases that make the script barf?
>
>Try:
>
>cursor_2.execute("""INSERT INTO auto_notifications
> (auto_notify_idnr, user_idnr, notify_address)
> VALUES ('%s', '%s', '%s')""", record)
>
>instead around line 113. Notice the single quotes around the values.
>
>Sorry for not making this a proper diff. The missing quotes are a
>generic problem I notice in this code. I'm guessing there may be some
>weird chars in your aliases that drive python's string interpolation
>into recursive mania.
>
>Also, aside from messages and messageblks you should be able to dump
>and load the 1.2 tables straight into the 2.0 db.
>
>
>
>
>
>Mikael Syska wrote:
>
>>Plese there must be someone how can help me with the errors...
>>If, then plese contact me on MSN: mikael@syska.dk or ICQ: 37679058...
>>
>>Or just reply to the list.....
>>
>>
>>
>>>-----Oprindelig meddelelse-----
>>>Fra: dbmail-admin@dbmail.org
>[mailto:dbmail-admin@dbmail.org] På vegne
>>>af Mikael Syska
>>>Sendt: 29. januar 2004 17:57
>>>Til: dbmail@dbmail.org
>>>Emne: [Dbmail] Easiest way to transfer mails from postgresql 1.x to
>>>mysql 2.x or 1.x does not matter.......
>>>
>>>All in the subject, nothing more to say, I have tried the script in
>>>the dbmail 2.0 from 1 to 2, but I can't get it to work.....
>>>
>>>Here are the output from the script....
>>>------------------------------------------------------
>>>LOADING DATABASE DRIVERS
>>>
>>>loading MySQL driver
>>>loading PostgreSQL driver
>>>connecting to databases
>>>copying aliases table
>>>Traceback (most recent call last):
>>> File "./migration_1_x_to_2_0alpha.py", line 97, in ?
>>> cursor_2.execute("""INSERT INTO aliases (alias_idnr, alias, File
>>>"/usr/local/lib/python2.3/site-packages/MySQLdb/cursors.py",
>>>line 95, in execute
>>> return self._execute(query, args)
>>> File
>>>"/usr/local/lib/python2.3/site-packages/MySQLdb/cursors.py",
>>>line 114, in _execute
>>> self.errorhandler(self, exc, value) File
>>>"/usr/local/lib/python2.3/site-packages/MySQLdb/connections.py"
>>>, line 33, in defaulterrorhandler
>>> raise errorclass, errorvalue
>>>RuntimeError: maximum recursion depth exceeded
>>>------------------------------------------------------
>>>
>>>I'm really desperate, any help would be great....
>>>
>>>Is there are IRC channel for dbmail?? If where????
>>>
>>>// ouT
>>>
>>>_______________________________________________
>>>Dbmail mailing list
>>>Dbmail@dbmail.org
>>>https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>
>>>
>>>
>>
>>_______________________________________________
>>Dbmail mailing list
>>Dbmail@dbmail.org
>>https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
>>
>>
>
>--
> ________________________________________________________________
> Paul Stevens mailto:paul@nfg.nl
> NET FACILITIES GROUP PGP: finger paul@nfg.nl
> The Netherlands________________________________http://www.nfg.nl
>
>_______________________________________________
>Dbmail mailing list
>Dbmail@dbmail.org
>https://mailman.fastxs.nl/mailman/listinfo/dbmail
>