zForum - Zope Based Message Boards

Home / MySQL zForum / Installing zForum in Plone 2.1.2 [Viewed 2979 Times]

Back

Installing zForum in Plone 2.1.2
By: mcdonald Rank: Starfleet Ensign Postings: 2 From:	Posted: Sun Mar 26, 2006 - 01:24 PM Hello I have tried installing zForum in plone 2.12 a couple of times without success. At first I thought it might be due to some of my own customizations, so I went back and installed zForum in a completely clean install of plone 2.1.2 I believe I have followed the plone_integration instructions accurately. The following is my error when attempting to access the zforum url, I am using MySQL mysql-4.1.12-3 on a RHEL4 system Site error This site encountered an error trying to fulfill your request. The errors were: Error Type ProgrammingError Error Value (1146, "Table 'zope.zf_system_properties' doesn't exist") Request made at 2006/03/26 11:12:35.631 US/Pacific Question 1) Do I need to create a ZMySQLDA object before installing zforum or is this done when zforum is installed. 2) I examined the database I used when I created the zforum instance, there are no tables in the database, is the zforum install process supposed to cretae tables in this database? or am I supposed to populate these tables using the .sql schema in the /doc directory of zforum, I have verified from the zforum instance that I have a connection and can run mysql command Suugestions were to look for my error would be appreciated. Thanks Steve
By: paulus Rank: Starfleet Lieutenant Postings: 17 From:	Posted: Sun Mar 26, 2006 - 02:42 PM Hi Steve, Yes you have to create the database first and then run the schema. And yes the schema is in the doc folder. Probably you know to use mysql. Then when adding the zForum instance inside Zope you give the connection string for the database you just created: <database_name> <mysql_user> <password> Then the database connection is created and you are up and running. I guess it should be noted on the adding screen that you really need to create the database by hand for zForum to work. This is hard to automate since a proper mysql setup is password protected. Usually you need to be the mysql root user to create a database, plus you probably want a specific user for the zForum database. Cheers, paulus
By: mcdonald Rank: Starfleet Ensign Postings: 2 From:	Posted: Sun Mar 26, 2006 - 11:03 PM Hi Paulus Thanks, all is now fine. I agree not having administrator access to the Mysql database does not make it easy to automate this process. But having a few additional lines in the description of the install process, making it clear the the mysql tables must be installed seperately would make it much clearer. Thanks for your help Steve
By: paulus Rank: Starfleet Lieutenant Postings: 17 From:	Posted: Sun Mar 26, 2006 - 11:52 PM Hi Steve, I'm glad it worked out. And yes, I had to look around to to figure out that I had to setup the DB first, after which I realized it was sort of obvious. So speedbird, if you see this, I guess you will pick up the hint. I suggest two places: the readme file and the add form paulus
By: merckx Rank: Starfleet Ensign Postings: 2 From:	Posted: Thu Apr 06, 2006 - 05:02 PM Hey, Another Plone question. I'm working with the following: OS X 10.4.6 Server MySQL 4.1 (ships with OS X) Zope 2.8.6 Plone 2.1.2 (installed with the OS X installer) zForum 1.1.0 RC4 I've installed everything (ZMySQLDA, MySQLdb), loaded tables into mysql, and can add a zforum to my plone site using the quickinstaller, but when I try to establish a database connection, I get the following error: (2002, "Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (13)") Interestingly, if I try to open mysql at the command line, I get the same error, a complaint about mysql.sock. (Using sudo allows me to open mysql successfully, though.) The /var/mysql directory and contents are owned by the user mysql. I've tried to move the default location of mysql.sock to /tmp by setting that location in the mysql_config file, but that doesn't seem to have taken effect after a restart of mysql. I just installed zForum on my G4 powerbook with pretty much the same environment without any problem, so I'm a bit at a loss as to why things aren't working here. It smells to me like a permissions/security issue, but I don't know enough to troubleshoot this effectively. Ideas would be very much appreciated. Thanks!
By: merckx Rank: Starfleet Ensign Postings: 2 From:	Posted: Thu Apr 06, 2006 - 07:30 PM um. nevermind. changing 'localhost' to '127.0.0.1' in the connection string did the trick.
By: morrighu Rank: Starfleet Ensign Postings: 4 From:	Posted: Tue Oct 02, 2007 - 10:44 AM Message has been edited, Click Here to view/hide original message *Original Message - [10/02/2007]* *Original Message - [10/02/2007]* No matter what I try in the MySQL connection string, I get unknown host. I've tried 'localhost', '127.0.0.1', the FQDN host hame, the actual IP address of the box. Nothing seems to be working. I've checked and my /etc/hosts is configured properly so I'm not really sure what the problem is. The machine is also configured to check hosts before DNS when resolving names. I still get "Unknown MySQL server host" followed by whatever I've filled in above. If anyone has any ideas on what to try, I'd appreciate it. We really want to use Zforums. Thanks, M. No matter what I try in the MySQL connection string, I get unknown host. I've tried 'localhost', '127.0.0.1', the FQDN host hame, the actual IP address of the box. Nothing seems to be working. I've checked and my /etc/hosts is configured properly so I'm not really sure what the problem is. The machine is also configured to check hosts before DNS when resolving names. I still get "Unknown MySQL server host" followed by whatever I've filled in above. Oddly enough, it works fine from PHP, so it's something in Zope and/or ZForums that's the issue. If anyone has any ideas on what to try, I'd appreciate it. We really want to use Zforums. Thanks, M. Message has been edited, Click Here to view/hide original message *Original Message - [10/02/2007]* No matter what I try in the MySQL connection string, I get unknown host. I've tried 'localhost', '127.0.0.1', the FQDN host hame, the actual IP address of the box. Nothing seems to be working. I've checked and my /etc/hosts is configured properly so I'm not really sure what the problem is. The machine is also configured to check hosts before DNS when resolving names. I still get "Unknown MySQL server host" followed by whatever I've filled in above. If anyone has any ideas on what to try, I'd appreciate it. We really want to use Zforums. Thanks, M. No matter what I try in the MySQL connection string, I get unknown host. I've tried 'localhost', '127.0.0.1', the FQDN host hame, the actual IP address of the box. Nothing seems to be working. I've checked and my /etc/hosts is configured properly so I'm not really sure what the problem is. The machine is also configured to check hosts before DNS when resolving names. I still get "Unknown MySQL server host" followed by whatever I've filled in above. Oddly enough, it works fine from PHP, so it's something in Zope and/or ZForums that's the issue. If anyone has any ideas on what to try, I'd appreciate it. We really want to use Zforums. Thanks, M.
By: rmansuri Rank: Starfleet Lieutenant Postings: 16 From: UK	Posted: Thu Oct 04, 2007 - 04:10 AM I reckon 1.0.16 ..which works fine.