ispworks-users — Generic User Discussion List

[Ispworks-users] ispworks

[Chris C. <ch...@nm...>]

Hey
This mailing list has been dead for...2 years...and the project hasn't been
active for a year....We have various modifications to Ispworks and have been
considering re-releasing it if nobody else is going to work on it....The
modifications include some level of Maia Mailguard integration, fixes for
PHP 5, and auto-responder functionality....and we are interested in actually
rewriting parts of it and what not...There are other systems that we could
switch to, but nobody handles DNS and email with the pure simplicity that
you get here...Are other folks still using Ispworks?  Do you have modifications
that you want to share?

-- 
Theatre is life
Film is art
Television is furniture

[Ispworks-users] SlackBuilds slackware build scripts.

[Mick P. <mi...@lu...>]

Hi all. I have made available the SlackBuild's I used to build my server
and to keep it up to date.
These are for Slackware 9.1 and are scripts to compile the necessary
packages for ISPWORKS to run. They are not binary packages. They build
binary packages. For now they are only available via my home server but
soon will be available via cvs aswell.

http://home.lunix.au.com/ispworks

Feel free to make suggestions or comments. 

Happy compiling.

-- 
Regards
Mick Pollard ( lunix )
------------------------------------------------
BOFH Excuse of the day:
Asynchronous Programming Unavailability

[Ispworks-users] SlackBuilds slackware build scripts.

[Mick P. <mi...@lu...>]

Hi all. I have made available the SlackBuild's I used to build my server
and to keep it up to date.
These are for Slackware 9.1 and are scripts to compile the necessary
packages for ISPWORKS to run. They are not binary packages. They build
binary packages. For now they are only available via my home server but
soon will be available via cvs aswell.

Feel free to make suggestions or comments. 

Happy compiling.

-- 
Regards
Mick Pollard ( lunix )
------------------------------------------------
BOFH Excuse of the day:
Asynchronous Programming Unavailability

Re: [Ispworks-users] web redirects

[Mick P. <mi...@lu...>]

> When you add the product, you specify a hostname in the third field
> (e.g. "redirects.lunix.au.com"), which is the hostname, that points
> to the ip address were you installed the "index.php" page.
> 
> Every cname entry that you enter in the dns module, which points to
> "redirects.lunix.au.com" then will show up in the dropdown box under
> web redirects.


Great stuff. Thanx for your help.



-- 
Regards
Mick Pollard ( lunix )
------------------------------------------------
BOFH Excuse of the day:
Insufficient Array Failure

Re: [Ispworks-users] web redirects

[Martin List-P. <ma...@li...>]

On Wed, 2004-06-02 at 15:49, Mick Pollard wrote:
> Hi all. I have sort of worked out web redirects but not quite.
> How do I actually get it to work. I understand how the index.php ( for
> redirects) works.
> When I add a product od "web redirect" to a domain I want redirected to
> another domain it adds it as a product but the from and to domain fields
> are blank and there is no "ADD" button.
> Currently I add them directly into sql myself ?? I am using 0.7 stable
> not the cvs version. I have checked out the cvs version tonight to a
> devl server and will have a look tomorow.

When you add the product, you specify a hostname in the third field
(e.g. "redirects.lunix.au.com"), which is the hostname, that points
to the ip address were you installed the "index.php" page.

Every cname entry that you enter in the dns module, which points to
"redirects.lunix.au.com" then will show up in the dropdown box under
web redirects.

Kind regards,
Martin List-Petersen

[Ispworks-users] web redirects

[Mick P. <mi...@lu...>]

Hi all. I have sort of worked out web redirects but not quite.
How do I actually get it to work. I understand how the index.php ( for
redirects) works.
When I add a product od "web redirect" to a domain I want redirected to
another domain it adds it as a product but the from and to domain fields
are blank and there is no "ADD" button.
Currently I add them directly into sql myself ?? I am using 0.7 stable
not the cvs version. I have checked out the cvs version tonight to a
devl server and will have a look tomorow.

-- 
Regards
Mick Pollard ( lunix )
------------------------------------------------
BOFH Excuse of the day:
Illegal Software Desynchronisation

[Ispworks-users] web redirects.

[Mick P. <mi...@lu...>]

Hi all. I have sort of worked out web redirects but not quite.
How do I actually get it to work. I understand how the index.php ( for
redirects) works.
When I add a product od "web redirect" to a domain I want redirected to
another domain it adds it as a product but the from and to domain fields
are blank and there is no "ADD" button.
Currently I add them directly into sql myself ?? I am using 0.7 stable
not the cvs version. I have checked out the cvs version tonight to a
devl server and will have a look tomorow.

-- 
Regards
Mick Pollard ( lunix )
------------------------------------------------
BOFH Excuse of the day:
Replicated Decryption NMI Error

[Ispworks-users] Virtual now also being counted

[Philon <ph...@ph...>]

Hello,

now that I found my way through the PHP code, I have my first patch 
done.

It's for the virtual module and allows virtual aliases to also be 
counted. If one still wants ulimited aliases, one could enter 0 in 
amount. It's more or less an adaption the functions of accounts and web 
where the same check is being done.

I also changed the colspan of the tables header to fix the td's width 
to integrate with the whole table.

Perhaps you can make use of this, although I don't think the code is 
perfect.


regards,
Philon

Index: virtual.module
===================================================================
RCS file: /cvsroot/ispworks/ispworks/module/virtual.module,v
retrieving revision 1.8
diff -r1.8 virtual.module
326c326
< 										print "<tr><td colspan=\"4\" 
id=\"tdcbright\">".lang("Virtual aliases")."</td></tr>";
---
 > 										print "<tr><td colspan=\"3\" 
id=\"tdcbright\">".lang("Virtual aliases")."</td></tr>";
344a345,347
 > 										// I want that virtuals be counted
 > 										$count = 0;
 > 										
377a381
 > 												$count++;
455c459,477
<     print "<td colspan=\"2\" id=\"tdcbright\">&nbsp;</td>";
---
 > 	
 > 	// oh, get the limit from the database quick
 > 	$query  = "SELECT * FROM admin_product WHERE domain='".$domainid."' 
AND product='virtual'";
 > 	$result = $db->query($query);
 > 	if(DB::isError($result)) db_error_handling($result, $query);
 > 	if($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
 > 		{
 > 			$accountlimit = $row["amount"];
 > 			if ($accountlimit == 0) $accountlimit = "unlimited";
 > 		}
 > 	else
 > 		unset($accountlimit);
 > 	
 >     print "<td colspan=\"2\" id=\"tdcbright\"><font size=\"1\">";
 > 	if (isset($accountlimit) AND $accountlimit != "unlimited")
 > 	{
 > 		print $count." ".lang("of")." ".$accountlimit." ".lang("aliases");
 > 	}
 > 	print "</font></td>";
457a480,482
 > 	// add should only be visible if aliases can be added
 > 	if (isset($accountlimit) AND ($accountlimit > $count) OR 
($accountlimit == "unlimited"))
 > 	{
467a493
 > 	}

Re: [Ispworks-users] ISP-Works Developement

[Martin List-P. <ma...@li...>]

Citat Philon <ph...@ph...>:

> >> Most of interest for me are the quotas for eMail-accounts
> > Won't work without maildrop, which i'm doing the backend for currently.
> 
> What about the VDA softquota patch at http://web.onda.com.br/nadal/? I 
> didn't get Maildrop to run with MySQL and found this solution of 
> Postfix doing the work itself. It's not standard Postfix, but it works. 
> Also, users not willing to have mail sorted, can get mail directly 
> without maildrop.

VDA Softquota would be up to the system administrator itself, if he want's to
use it. I haven't looked much into it, since i actually use the mail filtering.

Also the pr. user based antispam features will require something like maildrop
to work, so it is essential.
 
>>> and the web/ftp-logins. The fields in MySQL are already there, there 
>>> just needs=20= do be some sort of interface in the admin.
> >
> > It's in CVS. One of the fields in the products module decides the 
> > quota size.
> > Look in the README for that.
> 
> I tried around a bit. The admin_products is being updated with the 
> quota, the ftp_users is not. Ah, I got it. The web-user has to be 
> deleted and reinserted to write the quota into ftp_users. Would be 
> nasty to do when changing admin_products web-quota.

It is, but currently the only way to do it. There will be done a update of
ftp_users as soon as the products module is on the new scheme.
 
> > This is changing in the future though, so that you don't have to look 
> > in the README for that :)
> 
> These Host-fields realy need some descriptive information. What about 
> when the Hosts field in the Products listing are deleted altogether, 
> having them displayed at the individiual menus (like POP3/SMTP for 
> eMail already shows). The Amount could be then rewritten to show 
> something like: # of # accounts used, t's a cosmetic thing.
> 
> Ok, I can talk much longer on this one. I'll try to change some aspects 
> of the thingy now.

When i'm done with it, the fields will not exist in it's current look, but there
will be a variable amount of fields with descriptions, selects, radiobuttons
etc.

/Martin
-- 
Tomorrow will be cancelled due to lack of interest.

Re: [Ispworks-users] ISP-Works Developement

[Philon <ph...@ph...>]

>> I checked with cvs. Documentation should be easy for the start, 
>> without=20=
>> proper knowledge in PHP. Do you already have some organized way in=20
>> maintaining the docu? Something like XML with HTML-output. I saw=20
>> several projects of this type, but didn't set one up myself.
>
> The documentation is what i've done in the README and on my private 
> website so
> far in TXT and HTML. I'm going to transfer these bits and pieces into 
> DocBook
> and submit that to the CVS. This way it should be easy to generate any 
> type of
> format, that is wanted (PDF, HTML etc.)

I will look into DocBook

>> Most of interest for me are the quotas for eMail-accounts
>
> Won't work without maildrop, which i'm doing the backend for currently.

What about the VDA softquota patch at http://web.onda.com.br/nadal/? I 
didn't get Maildrop to run with MySQL and found this solution of 
Postfix doing the work itself. It's not standard Postfix, but it works. 
Also, users not willing to have mail sorted, can get mail directly 
without maildrop.

>> and the web/ftp-logins. The fields in MySQL are already there, there 
>> just
>> needs=20= do be some sort of interface in the admin.
>
> It's in CVS. One of the fields in the products module decides the 
> quota size.
> Look in the README for that.

I tried around a bit. The admin_products is being updated with the 
quota, the ftp_users is not. Ah, I got it. The web-user has to be 
deleted and reinserted to write the quota into ftp_users. Would be 
nasty to do when changing admin_products web-quota.

> This is changing in the future though, so that you don't have to look 
> in the
> README for that :)

These Host-fields realy need some descriptive information. What about 
when the Hosts field in the Products listing are deleted altogether, 
having them displayed at the individiual menus (like POP3/SMTP for 
eMail already shows). The Amount could be then rewritten to show 
something like: # of # accounts used, t's a cosmetic thing.

Ok, I can talk much longer on this one. I'll try to change some aspects 
of the thingy now.


Philon

Re: [Ispworks-users] ISP-Works Developement

[Martin List-P. <ma...@li...>]

Citat Philon <ph...@ph...>:

> I checked with cvs. Documentation should be easy for the start, without=20=
> proper knowledge in PHP. Do you already have some organized way in=20
> maintaining the docu? Something like XML with HTML-output. I saw=20
> several projects of this type, but didn't set one up myself.

The documentation is what i've done in the README and on my private website so
far in TXT and HTML. I'm going to transfer these bits and pieces into DocBook
and submit that to the CVS. This way it should be easy to generate any type of
format, that is wanted (PDF, HTML etc.)

> Most of interest for me are the quotas for eMail-accounts

Won't work without maildrop, which i'm doing the backend for currently.

> and the web/ftp-logins. The fields in MySQL are already there, there just
> needs=20= do be some sort of interface in the admin.

It's in CVS. One of the fields in the products module decides the quota size.
Look in the README for that.

This is changing in the future though, so that you don't have to look in the
README for that :)

/Martin

Re: [Ispworks-users] ISP-Works Developement

[Philon <ph...@ph...>]

> You are welcome to participate. Currently i would only accept=20
> additions to the
> system in the form of patches to current cvs, which i will look=20
> through and if
> acceptable will add. Mail me what you could be interested in looking=20=

> at and
> i'll
> find out how we organise things. Documentation is also a very=20
> necessary thing
> and is most welcome.

I checked with cvs. Documentation should be easy for the start, without=20=

proper knowledge in PHP. Do you already have some organized way in=20
maintaining the docu? Something like XML with HTML-output. I saw=20
several projects of this type, but didn't set one up myself.

> I know that the system is being used on Linux and FreeBSD. It is=20
> developed this
> way exactly because you should be able to manage multiple servers,=20
> regardless
> of
> platform and even in a mixed environment. I even have seen people=20
> running the
> webinterface part on windows based apache+php.

that=91s where I see why there is a server field. If this is used in the=20=

lookups by the different server, a multi-server setup can be achieved.=20=

Go docu go!

> Getting into other peoples code is never that easy. http://www.php.net=20=

> is the
> best documentation you can get. Need the description of a function ?=20=

> ex.
> fopen()
> would just be http://www.php.net/fopen and there you go.
>
> Documentation on my code is mostly in the form of comments, sometimes=20=

> less
> sometimes more. The alias table can't really be used as a comparison,=20=

> since it's
> not managed at all by the ISPWorks interface.

Most of interest for me are the quotas for eMail-accounts and the=20
web/ftp-logins. The fields in MySQL are already there, there just needs=20=

do be some sort of interface in the admin.

> Keep in mind: The ISPWorks interface is an aid to every system=20
> administrator,
> taking trivial work of his hands by giving his customers the ability=20=

> to manage
> parts of the system themselves. It is however not a tool that covers=20=

> every
> aspect of the database and services provided. It is just an additional=20=

> tool to
> ease trivial system administration at this point: a customer=20
> management system
> would be the better description, but not yet fullfilling that 100%=20
> (probably
> never will be, because demands change).

 =46rom my view ISPWorks replaces many manual tasks, with the job being=20=

done by the simple minded computer. I hate adding users manually with=20
many shell-commands, as the human is a very good source for creating=20
creative errors :).



regards,
Philon=

Re: [Ispworks-users] ISP-Works Developement

[Martin List-P. <ma...@li...>]

Citat Philon <ph...@ph...>:

> I was wondering where I could spend my free time. Being workless isn't 
> that nice. As I wasn't playing around with ISPworks I started to look 
> through the code. As I'm pretty new to PHP, it is some work to get 
> through the way things are done. Anyhow I would love to help where I 
> can.

You are welcome to participate. Currently i would only accept additions to the
system in the form of patches to current cvs, which i will look through and if
acceptable will add. Mail me what you could be interested in looking at and
i'll
find out how we organise things. Documentation is also a very necessary thing
and is most welcome.

>> Currently the main platform that ISPWorks is being developed against 
>> is Debian Woody and that is postfix 1.x. I might include support for other
>> ways of doing things together with postfix 2.x at some point, but that is
not
>> the primary issue right now, since there are lots of other things that i'm
>> working on(spam-filter, full maildrop filter editor, auto create of maildirs
>> for maildrop, a more secure web module with support for round robin uid's 
>> etc., a rework of the way products are handled, mysql module and most 
>> important the complete documentation, etc.)
> 
> With a MySQL backend and the services being aviable for nearly every 
> kind of unix, ISPworks already is pretty portable. I suggest, the best 
> thing with options would be staying most compatible.

I know that the system is being used on Linux and FreeBSD. It is developed this
way exactly because you should be able to manage multiple servers, regardless
of
platform and even in a mixed environment. I even have seen people running the
webinterface part on windows based apache+php.
 
>> You are however welcome to send me (or on this mailinglist) suggestions, how
>> you setup/resolved things or intend to resolve things. I'm open to look 
>> into that and see what we can do about it. I've had great discussions with 
>> some of the people using ISPWorks on how to do things better and more secure

>> (especially Chris and Rene to mention there).
> 
> In the moment I'm for interface changes. But as I said, I'm new to PHP 
> and without an existing docu it's not that easy to find out what 
> function does what. Some thing for example would be that aliases don't 
> have a counter in the lower left, like email or dns.

Getting into other peoples code is never that easy. http://www.php.net is the
best documentation you can get. Need the description of a function ? ex.
fopen()
would just be http://www.php.net/fopen and there you go.

Documentation on my code is mostly in the form of comments, sometimes less
sometimes more. The alias table can't really be used as a comparison, since it's
not managed at all by the ISPWorks interface.

Keep in mind: The ISPWorks interface is an aid to every system administrator,
taking trivial work of his hands by giving his customers the ability to manage
parts of the system themselves. It is however not a tool that covers every
aspect of the database and services provided. It is just an additional tool to
ease trivial system administration at this point: a customer management system
would be the better description, but not yet fullfilling that 100% (probably
never will be, because demands change).

/Martin
-- 
Q:	Know what the difference between your latest project
	and putting wings on an elephant is?
A:	Who knows?  The elephant *might* fly, heh, heh...

Re: [Ispworks-users] ISP-Works Developement

[Philon <ph...@ph...>]

Hallo Martin!

> There is only this list and the only developer on this is me. ISPWorks 
> was
> originally a project, that i created for my own needs. After having 
> used it for
> a couple of years with constantly development on and off and people 
> asking, I
> devided to release it under the GPL. I'm allways open for 
> feature-requests, but
> if you look at the TODO, it is loaded with stuff, that i'm working on 
> at the
> moment. Beyond me, a friend of mine is developing a API for a complete 
> new, more
> customizable look of the whole thing, since webdesign not is my thing.

I was wondering where I could spend my free time. Being workless isn't 
that nice. As I wasn't playing around with ISPworks I started to look 
through the code. As I'm pretty new to PHP, it is some work to get 
through the way things are done. Anyhow I would love to help where I 
can.

> Currently the main platform that ISPWorks is being developed against 
> is Debian
> Woody and that is postfix 1.x. I might include support for other ways 
> of doing
> things together with postfix 2.x at some point, but that is not the 
> primary
> issue right now, since there are lots of other things that i'm working 
> on
> (spam-filter, full maildrop filter editor, auto create of maildirs for 
> maildrop,
> a more secure web module with support for round robin uid's etc., a 
> rework of
> the way products are handled, mysql module and most important the 
> complete
> documentation, etc.)

With a MySQL backend and the services being aviable for nearly every 
kind of unix, ISPworks already is pretty portable. I suggest, the best 
thing with options would be staying most compatible.

> You are however welcome to send me (or on this mailinglist) 
> suggestions, how you
> setup/resolved things or intend to resolve things. I'm open to look 
> into that
> and see what we can do about it. I've had great discussions with some 
> of the
> people using ISPWorks on how to do things better and more secure 
> (especially
> Chris and Rene to mention there).

In the moment I'm for interface changes. But as I said, I'm new to PHP 
and without an existing docu it's not that easy to find out what 
function does what. Some thing for example would be that aliases don't 
have a counter in the lower left, like email or dns.


so far...
Philon

Re: [Ispworks-users] ISP-Works Developement

[Martin List-P. <ma...@li...>]

Citat Philon <ph...@ph...>:

> I was just looking into the developement of ISPworks. My installation 
> is running fine so far, but there are many things left to do.
> 
> What about public feature discussions? Here on the list? Or does it 
> have a devel-list?

There is only this list and the only developer on this is me. ISPWorks was
originally a project, that i created for my own needs. After having used it for
a couple of years with constantly development on and off and people asking, I
devided to release it under the GPL. I'm allways open for feature-requests, but
if you look at the TODO, it is loaded with stuff, that i'm working on at the
moment. Beyond me, a friend of mine is developing a API for a complete new, more
customizable look of the whole thing, since webdesign not is my thing.
 
> I yesterday just came across some problems with having all 
> postfix-domains in transport_maps, while virtual_mailbox_domains seems 
> much better with installations running 2.x. The old way, it was 
> impossible to set an alternative transport for secondary MXes as they 
> should be part of mydomains, which is set to transport_maps.

Currently the main platform that ISPWorks is being developed against is Debian
Woody and that is postfix 1.x. I might include support for other ways of doing
things together with postfix 2.x at some point, but that is not the primary
issue right now, since there are lots of other things that i'm working on
(spam-filter, full maildrop filter editor, auto create of maildirs for maildrop,
a more secure web module with support for round robin uid's etc., a rework of
the way products are handled, mysql module and most important the complete
documentation, etc.)

You are however welcome to send me (or on this mailinglist) suggestions, how you
setup/resolved things or intend to resolve things. I'm open to look into that
and see what we can do about it. I've had great discussions with some of the
people using ISPWorks on how to do things better and more secure (especially
Chris and Rene to mention there).

Kind regards,
Martin List-Petersen
-- 
BOFH excuse #438:
sticky bit has come loose

[Ispworks-users] ISP-Works Developement

[Philon <ph...@ph...>]

Hi everybody,

I was just looking into the developement of ISPworks. My installation 
is running fine so far, but there are many things left to do.

What about public feature discussions? Here on the list? Or does it 
have a devel-list?

I yesterday just came across some problems with having all 
postfix-domains in transport_maps, while virtual_mailbox_domains seems 
much better with installations running 2.x. The old way, it was 
impossible to set an alternative transport for secondary MXes as they 
should be part of mydomains, which is set to transport_maps.

regards,
Philon

Re: [Ispworks-users] update_ns_stats.php & aussie domains

[Martin List-P. <ma...@li...>]

Actually the script doesn't check for many other extensions than what i've
primary been used to (.se, .dk).

I'm currently extending it to altså accept and handle things like co.uk, .com.au
etc. The cvs version is a bit more up to date (checks .com, .net etc. also, by
querying whois), but does not yet handle the .com.au domains.

Could you raise a feature request bug on Sourceforge, so that i don't forget it
? Thanks.

/Martin

I'm currently improving the script 

Citat Mick Pollard <lu...@lu...>:

> Hi list.
> I am in Australia therefore most of my domains are 2LD's ie .com.au,
> .net.au
> 
> The function below treats these as "sub-domains"
> 
> > // is this a subdomain ?
> >                 if(strpos($domain, ".") < (strlen($domain)-5))
> >                 {
> >                         return "-";
> >                         break;
> >                 }
> Any idea how to get update_ns_stats.php working for Aussie domains ??
> I have the latest cvs of update_ns_stats.php and It works fine on non-AU
> domains.
> I have added a section in the case statement for .au and used the server of
> ns1.ausregistry.net.
> I am now lost. I believ it lies with the above funstion that stops this
> working for me !!
> 
> Regards
> Mick Pollard ( lunix )
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> ispworks-users mailing list
> isp...@li...
> https://lists.sourceforge.net/lists/listinfo/ispworks-users
> 


-- 
BOFH excuse #185:

system consumed all the paper for paging

[Ispworks-users] update_ns_stats.php & aussie domains

[Mick P. <lu...@lu...>]

Hi list.
I am in Australia therefore most of my domains are 2LD's ie .com.au, .net.au

The function below treats these as "sub-domains"

> // is this a subdomain ?
>                 if(strpos($domain, ".") < (strlen($domain)-5))
>                 {
>                         return "-";
>                         break;
>                 }
Any idea how to get update_ns_stats.php working for Aussie domains ??
I have the latest cvs of update_ns_stats.php and It works fine on non-AU domains.
I have added a section in the case statement for .au and used the server of ns1.ausregistry.net.
I am now lost. I believ it lies with the above funstion that stops this working for me !!

Regards
Mick Pollard ( lunix )

Re: [Ispworks-users] Configuring DNS

[Martin List-P. <ma...@li...>]

Citat "Robert J. Spencer" <rj...@iz...>:

> Hi again Martin,
> 
> I'm slowly working out everything but I have another newbie question for 
> you.  The ispworks website suggests running bind as slaves and pdns on 
> the master, which makes sense so that if there is a problem with the 
> database, the secondary DNS still works. 

In fact is suggest powerdns w/bind backend (bind compatible configuration), but
there is no problem to use bind 8 or 9.

> However, the script that is included seems to expect pdns to be installed -- 
> and the comments inside  are confusing me.  Am I correct in assuming that 
> /usr/share/ispworks/scripts/dns_fetch.sh is supposed to be run on the 
> slave to get the info from the master?  Could you give me some pointers 
> on how to configure it for bind9 under a clean woody install?

Simply insert a line stating:
include "/etc/bind/slave_zones.cf"
in your named.conf (or whereever you want to store the file, that the script
pulls own) and replace "sudo /etc/init.d/powerdns force-reload" with "sudo
/usr/sbin/rndc reload" in the script.

/Martin
-- 
October.

This is one of the peculiarly dangerous months to speculate in stocks in.

The others are July, January, September, April, November, May, March, June,
December, August, and February.

		-- Mark Twain, "Pudd'nhead Wilson's Calendar"

Re: [Ispworks-users] Configuring DNS

[Robert J. S. <rj...@iz...>]

Hi again Martin,

I'm slowly working out everything but I have another newbie question for 
you.  The ispworks website suggests running bind as slaves and pdns on 
the master, which makes sense so that if there is a problem with the 
database, the secondary DNS still works.  However, the script that is 
included seems to expect pdns to be installed -- and the comments inside 
are confusing me.  Am I correct in assuming that 
/usr/share/ispworks/scripts/dns_fetch.sh is supposed to be run on the 
slave to get the info from the master?  Could you give me some pointers 
on how to configure it for bind9 under a clean woody install?

Regards,

Robert.

Re: [Ispworks-users] undefined function: query ???

[Martin List-P. <ma...@li...>]

Sounds like the database connect was not done correctly.

Please check that the connect values in include/config.inc.php are set correctly
and you have access to the database.

Kind regards,
Martin List-Petersen
-- 
BOFH excuse #325:
Your processor does not develop enough heat.

Citat Markus <ma...@ma...>:

> Hi list :)*
> *
> i have a big problem... i have installed RedHat 9.0, newest apache, 
> newest php, ispworks 0.7
> 
> all looks good but when i go to http://ipfromserver/isp then i get an 
> error:*
> 
> Fatal error*: Call to undefined function: query() in 
> */var/www/html/isp/include/realm-auth.inc.php* on line *77
> *
> please help me !!!!
> 
> Thanks
> markus
> 

[Ispworks-users] undefined function: query ???

[Markus <ma...@ma...>]

Hi list :)*
*
i have a big problem... i have installed RedHat 9.0, newest apache, 
newest php, ispworks 0.7

all looks good but when i go to http://ipfromserver/isp then i get an 
error:*

Fatal error*: Call to undefined function: query() in 
*/var/www/html/isp/include/realm-auth.inc.php* on line *77
*
please help me !!!!

Thanks
markus

Re: [Ispworks-users] Configuring DNS

[Martin List-P. <ma...@li...>]

Citat "Robert J. Spencer" <rj...@iz...>:

> Martin List-Petersen wrote:
> 
> >Look also at the templates, which for now have to be created manually in
> the
> >database but then can populate the new record with the default records, that
> you
> >wish.
> >  
> >
> Sorry Martin, where do I find the format for the templates?
 
It's the same format as for the regular dns tables, just without the
domain-names. 

Here a sample for your reference:
INSERT INTO admin_template_records VALUES (1, 1, '', 'SOA',
'spirillen.ispworks.org. hostmaster.ispworks.org. !ID! 10800 1800 3600000
10800', 10800, NULL);
INSERT INTO admin_template_records VALUES (2, 1, '', 'NS',
'spirillen.ispworks.org', 10800, NULL);
INSERT INTO admin_template_records VALUES (3, 1, '', 'NS', 'spip.ispworks.org',
10800, NULL);
INSERT INTO admin_template_records VALUES (6, 1, '', 'MX',
'coyote.ispworks.org', 10800, 10);
INSERT INTO admin_template_records VALUES (7, 1, 'www', 'CNAME',
'roadrunner.ispworks.org', 10800, NULL);

The templates are also described in the README.

/Martin
-- 
BOFH excuse #346:

Your/our computer(s) had suffered a memory leak, and we are waiting for them to
be topped up.

[Ispworks-users] Re: Postfix Install Guide

[Martin List-P. <ma...@li...>]

Citat "Robert J. Spencer" <rj...@iz...>:

> Martin List-Petersen wrote:
> 
> > [DB Access Error Routine]
> >
> >I've got some stuff from another guy on this also. It might be a problem in
> my
> >code. Check the mailinglist archive for ISPWorks.
>
>http://sourceforge.net/mailarchive/forum.php?thread_id=3784417&forum_id=37424
> >
> >It might fix your problem. Please let me know the results of that.
> >  
> >
> Hi Martin,
> 
> Sorry I didn't get back to you, I've just moved from the West to East 
> coast of Australia and am now adminning my systems remotely.  It looks 
> like you might have already fixed the db error routing but just in case, 
> it is definately a problem in your code.
> 
> I'll reply to everything else in the mailing list, so it's archived.
> 

Indeed it is my problem. Actually php in Debian seems to ignore it simply, the
way php is configured in RedHat and some others let's it fail. It is fixed in
CVS and i will do the next release within some weeks.

Regards,
Martin List-Petersen
martin at list-petersen dot net
--
You are the only person to ever get this message.

[Ispworks-users] Configuring DNS

[Robert J. S. <rj...@iz...>]

Martin List-Petersen wrote:

>Look also at the templates, which for now have to be created manually in the
>database but then can populate the new record with the default records, that you
>wish.
>  
>
Sorry Martin, where do I find the format for the templates?

Regards,

Robert Spencer.