Reading the Zope book about relational databases, (I need to do the same thing you are doing) I see that I must install MySQL DA. The Chapter about relational data bases has examples of some connection strings for PostGres. Here is a URlL for ZmyslqDa http://www.zope.org/Members/mordred/ZMySQLDA Here is a somewhat dated howto install the Mysql DA on SUSE 6.5 Linux http://lists.suse.com/archives/suse-linux-e/2000-Aug/0156.html I have SUSE 7.1 with the mysql and zope that came with the package. Hope this helps. Jens Benecke wrote:
Hi,
I've played a bit with Zope, read a load of HOWTOs and intros etc. and like it so far, but I haven't found a documentation source where to look up the "simple" things, like how to connect to a MySQL database. e.g. the ZMYSQL connector wants a "connection string" - what is that (authentication?) how is it formatted etc?
Is there a tutorial how to set up a simple (external) database-driven webpage (something like a guestbook or table editor)? That might help me get going.
Thanks!
-- " ...screams erupted at a Seattle hotel where Microsoft founder Bill Gates was addressing an education and technology conference. (...)" -- cnn.com, Reportage über das Erdbeben in Seattle · http://www.hitchhikers.de/ - Die kostenlose Mitfahrzentrale für ganz Europa
hi jens, if you've gotten this far, you've made a lot of progress indeed. the connection string what you use to open a mysql client connection. if you were running from a shell prompt, you could enter something like: $ mysql -u root dbase_name -p mysql would prompt you for the root password. the connection string for a zmysql database connection is something like: dbase_name user password note they are not separated by commas. if you could not set this when you added the method, you can go to the properties of the connection method and set them there. also, please note, i have also seen the connection string to be simply the database name and the root users password, though 2.3 (which i have on my home machine) does not allow that. hth. ciao! greg. Gregory Haley DBA/Web Programmer Venaca, LLC.
I've played a bit with Zope, read a load of HOWTOs and intros etc. and > like > it so far, but I haven't found a documentation source where to look up > the > "simple" things, like how to connect to a MySQL database. e.g. the > ZMYSQL > connector wants a "connection string" - what is that (authentication?) > how > is it formatted etc?
Is there a tutorial how to set up a simple (external) database-driven > webpage (something like a guestbook or table editor)? That might help me > get going. > > Thanks! >
participants (2)
-
ghaley@mail.venaca.com -
kentj