To anyone interested..
I have successfully gotten the Calander plugin to use a MySQL database to store events..
It's a kludge, because I was in a hurry and didn't know my way around SQmail's data abstraction systems, but it does work.
If anyone is interested, let me know and I'll put the replacement calander_data.php file.
(I set a variable called $is_mysql and if its yes, the mysql code is used, if its anything else, the normal flat file is used.)
Like I said, its fast and nasty, but its been used by several users now, and nobody found any bugs.
Paul has stated that he will be releasing a new calander plugin sometime, so your probably better waiting for that, but if you can't wait.. then drop me a line and I'll put it up.
Rgds
Franki.
PS, If someone wants to give me a quick rundown on using SQmails mysql backend, I'll swap it around to match the rest of sqmail's data abstraction methods.
p dont think wrote:
*Warning*: fopen(/usr/virtual/***VIRTUAL_DOMAIN***/***USERNAME***/[EMAIL PROTECTED]): failed to open stream: No such file or directory in */var/www/html/secure/mail/plugins/calendar/calendar_data.php* on line *60
Ah, looks like vlogin is "the virtual domain plugin". Huh. I guess vlogin is not getting called in calendar_data.php. I don't have the energy to look at that code, but try these things:
- make sure vlogin comes BEFORE calendar in plugin list
- try using $useSessionBased in vlogin configuration
- or insert a call to vlogin's overrideSmConfig() function at the beginning of the offending file
BTW, why do you have data directories on a per-user basis? Seems rather useless to me.
Thats the odd thing, in the sqmail settings, I have data-dir and attachments set to /var/local/webmail/data-dir and /var/local/webmail/attachements respectivly, so I don't know why it is trying to save to individual user accounts.
Then there's your problem. That data directory comes from vlogin. You might have a default setting enabled by accident.
Bummer, I didn't know you were working on it, so I setup a table in mysql and have so far added code so that events are inserted into the mysql table in the same format that it normally stores in the txt file.I was wondering if anyone has converted the calander to mysql backend as well? I am already using mysql for the user prefs and address book, so it seems logical to add a table to that db and put the calander info in there.
Note that there is a new calendar plugin on the way; it's tentatively alpha right now, but I simply do not have time to send it out ATM. It has the ability to use a SQL backend, but only a file backend is coded presently.
(minus the pipes of course.)
But my experiance with squirellmail is extrememly limited from a developer perspective, so I'm not familar with the data abstraction method in place, therefore I just inserted the SQL statements into the relevant files and will change it to the proper methods once I work out what they are.
It looks like its going to work fine though.
Sure. No reason why that won't work for you. The new calendar is just more feature rich.
Interestingly, I had an install of sqmail from before I installed the new mail server, and the old one was conventional and didn't use vlogin. when I used the calander, it would save a single file with the event data in it, but if I added a second event, the first one was overwritten and disappeared.
I'm assuming that was from an earlier version.
That's all over the mailing list archives -- known bug, use any other calendar version or the shared calendar plugin.
BTW, are their any developer docs for sqmail? I'd like to get more familiar with the code layout (like the db abstraction code) and stuff, but don't want to read the whole lot to learn my way around..
The code isn't as bad as oscommerce from a learning perspective, but it's still not obvious to a developer that is not familiar with its constructs.
Fragmented. Look in the doc directory, otherwise your best bet is to run phpDocumentor on the codebase.
Cheers,
paul
------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl -- squirrelmail-users mailing list Posting Guidelines: http://squirrelmail.org/wiki/wiki.php?MailingListPostingGuidelines List Address: [EMAIL PROTECTED] List Archives: http://news.gmane.org/thread.php?group=gmane.mail.squirrelmail.user List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
