Developing a mailman module

[jogr]

As mentioned bevor I am interested in a mailman module for froxlor. So I started to adapt the old syscp mailman module for froxlor (0.9.12).

The base of operations is as followed:

- installing a fresh froxlor version

- downloading the module from the syscp forum (version mailman-0.1.3.tar.gz)

- copying the files to the froxlor folder

 

I have run the following sql command

CREATE TABLE modules_mailman (
 id int(11) unsigned NOT NULL auto_increment,
 `type` enum('list','update','new','delete','system','del_archive') NOT NULL default 'list',
 customerid int(11) unsigned NOT NULL default '0',
 domainid int(11) unsigned NOT NULL default '0',
 listid int(11) unsigned NOT NULL default '0',
 list_name tinytext NOT NULL,
 list_webhost tinytext NOT NULL,
 list_owner tinytext NOT NULL,
 list_mailhost tinytext NOT NULL,
 transport tinytext NOT NULL,
 list_password tinytext NOT NULL,
 PRIMARY KEY  (id)
) ENGINE=MyISAM;

 

to guarantee that the database is up to date (no missing tables).

 

 

I have created a file 99.mailman.php in lib/navigation

<?php
return array (
   	'admin' => array (
           	'mailman' => array (
                   	'label' => $lng['admin']['mailman'],
                   	'show_element' => true,
                   	'elements' => array (
                           	array (
                                   	'url' => 'modules_admin_mailman.php?page=lists',
                                   	'label' => $lng['menue']['mailinglists']['mailinglists'],
                           	),
                   	),
           	),
   	),
);
?>

 

After that I added the content of lng/modules/mailman/german.lng.php to lng/german.lng.php

 

Doing so I got my entry in main navigation and a link to the old admin mailinglist menu.

 

I've tryed to use that link, but I got a "blank" page, which means that there are no system and froxlor mailinglists (which is correct, there are none defined on my system yet) but I am not able to adept the pathes for mailman. phpmyadmin shows, that there were mailman entrys in panel_settings, but it seems but they are not displayed. Can you give me a hint which file / entrys I have to change?

[jogr]

Ok, froxlor version is now 0.9.13.1. As I have used the "old" databese I wouldn't have done step 1 of the howto. I have done all the other steps, but changed the beginning of mailmanscript.php to beginning I have changed (and posted) 4 posts earlier.

The new .patch file is uploaded to the link, I've send you via pm.

 

The output of the mastercron is

Warning: fwrite(): 6 is not a valid stream resource in /var/www/localhost/htdocs/meinaccount/scripts/froxlor_master_cronjob.php on line 27

Warning: mysql_query(): 200 is not a valid MySQL-Link resource in /var/www/localhost/htdocs/meinaccount/lib/classes/database/class.db.php on line 190

Warning: mysql_error(): 200 is not a valid MySQL-Link resource in /var/www/localhost/htdocs/meinaccount/lib/classes/database/class.db.php on line 300

Warning: mysql_errno(): 200 is not a valid MySQL-Link resource in /var/www/localhost/htdocs/meinaccount/lib/classes/database/class.db.php on line 301
Invalid SQL: SELECT MAX(`guid`) as `fguid` FROM `panel_customers`<br />
mysql error number: <br />
mysql error desc: <br />
Time/date: 07/10/2010 02:30 PM<br />
Script: <br />
Referer: <br />

 

If I set the new mailman cronjob inactive, I will not recieve this errormessage.

[d00p]

Please nopaste the complete mailmanscript.php file - I'll try to reproduce the error

[jogr]

Here the link

http://www.nopaste.froxlor-handbuch.de/?44

[d00p]

remove include ($pathtophpfiles . '/lib/cron_shutdown.php'); (last line), i told you to check against existing cron-files, the shutdown is called by the master-cronjob

[jogr]

After deleting the last line, the cronjob works well

[atari]

Hi

 

I'll set up the new server in the next couple of days (at least i hope so). I will update the mailman module and publish it in the forum as soon as possible...

 

cheers

atari