Authenticate users using a already defined Mysql-Database
Hi, wanna migrate my web-project from an proprietary sql-based solution to a zope-project, because I see many benefits and pro's from zope. But I've the problem that I have to migrate about 200 users from my SQL-Database into Zope. I've seen projects like mysqlUserFolders but these have another table-structure. So my question: Is there an easy way to authenticate via Zope using my own database/tables ? table users; | uid | username | password | surname | firstname | This means, that Zope gets the username from that table and authenticates it using the password in this table. It's a bad idea to change the current database-structure, because there exist many foreign-keys that refers to 'uid' etc. Any ideas ? ________________________________________________________________ Viren? Wir wissen nicht was Ihr Arzt empfiehlt. Wir empfehlen den Virencheck für Dateianhänge! http://freemail.web.de/features/?mc=021159
I do that with LoginManager. There is an example somewhere on zope.org. However it seems as if LoginManager has fallen out of favour, so you might consider other alternatives. Hedley -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of andy toenz Sent: 13 November 2002 11:10 To: zope@zope.org Subject: [Zope] Authenticate users using a already defined Mysql-Database Hi, wanna migrate my web-project from an proprietary sql-based solution to a zope-project, because I see many benefits and pro's from zope. But I've the problem that I have to migrate about 200 users from my SQL-Database into Zope. I've seen projects like mysqlUserFolders but these have another table-structure. So my question: Is there an easy way to authenticate via Zope using my own database/tables ? table users; | uid | username | password | surname | firstname | This means, that Zope gets the username from that table and authenticates it using the password in this table. It's a bad idea to change the current database-structure, because there exist many foreign-keys that refers to 'uid' etc. Any ideas ? ________________________________________________________________ Viren? Wir wissen nicht was Ihr Arzt empfiehlt. Wir empfehlen den Virencheck für Dateianhänge! http://freemail.web.de/features/?mc=021159 _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Hello Andy Use exUserFolder (http://www.zope.org/Members/TheJester/exUserFolder). There you can exactly do what you like to do, using your existing table structure. Regards Dieter
-----Ursprüngliche Nachricht----- Von: zope-admin@zope.org [mailto:zope-admin@zope.org]Im Auftrag von andy toenz Gesendet am: Mittwoch, 13. November 2002 10:10 An: zope@zope.org Betreff: [Zope] Authenticate users using a already defined Mysql-Database
Hi,
wanna migrate my web-project from an proprietary sql-based solution to a zope-project, because I see many benefits and pro's from zope.
But I've the problem that I have to migrate about 200 users from my SQL-Database into Zope. I've seen projects like mysqlUserFolders but these have another table-structure.
So my question: Is there an easy way to authenticate via Zope using my own database/tables ?
table users; | uid | username | password | surname | firstname |
This means, that Zope gets the username from that table and authenticates it using the password in this table. It's a bad idea to change the current database-structure, because there exist many foreign-keys that refers to 'uid' etc.
Any ideas ? ________________________________________________________________ Viren? Wir wissen nicht was Ihr Arzt empfiehlt. Wir empfehlen den Virencheck für Dateianhänge! http://freemail.web.de/features/?mc=021159
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
andy toenz wrote:
table users; | uid | username | password | surname | firstname |
This means, that Zope gets the username from that table and authenticates it using the password in this table. It's a bad idea to change the current database-structure, because there exist many foreign-keys that refers to 'uid' etc.
Any ideas ?
You want SimpleUserFolder ;-) http://www.zope.org/Members/NIP/SimpleUserFolder/ You should be able to get exactly what you want by writing one or two ZSQL methods. I know, I've done it! If you get any problems, mail the list and I'll answer 'em :-) Chris
participants (4)
-
andy toenz -
Chris Withers -
Dieter Fischer -
Hedley Roos