X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=TODO;h=aaa90d4524266317dead8500f47d2255d4fe1e4c;hp=6702016025c689640549cf5049e2f6fe6af424a5;hb=387f0b6a7ab855203fa88c08d1cb85ccb976e526;hpb=53437ddeba0439876f496eae235700d46ea7645f diff --git a/TODO b/TODO index 670201602..aaa90d452 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.36 1999-07-29 19:13:06 ivan Exp $ +$Id: TODO,v 1.44 2000-06-15 14:45:38 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,253 @@ duplication of effort. --- +update the cybercash links in config.html and in the homepage. add more explicit support for other payment types. etc. + +From "Tim Jung" +. +Automatic CC Decline Notices via email +Block Time billing for prepaid internet cards (400 hours or whatever block +time of hours) +Trouble Ticket System with simple search function for Knowledge Base feature +Employee Timecards +Credit Card System support for Red Hat's CCVS, and other Linux credit card +programs +Contact Manager/Lead Tracking +Pre-Sale Quotes +Cisco NetFlow Account for IP traffic billing +VoIP and FoIP billing +Roaming per minute billing based on Radius Proxy support or number they +dialed into from Radius logs (800# etc) +Support for OpenSRS Domain Registration +Support for TUCOWS signup CDs + + +dbdef-create for postgres + +pro-rating, fiddling dates + +It looks like svc_acct.import doesn't deal well with comments and +multi-attribute lines. + +ivan@rootwood:~/freeside_current$ rgrep -r domuid * | cut -d: -f1 | sort | +uniq +CVS/Base/TODO +TODO +bin/fs-setup +bin/svc_acct_sm.export +bin/svc_acct_sm.import +htdocs/docs/man/svc_acct_sm.txt +htdocs/docs/schema.html +htdocs/edit/CVS/Base/part_svc.cgi +htdocs/edit/part_svc.cgi +htdocs/edit/process/svc_acct_sm.cgi +htdocs/edit/svc_acct_sm.cgi +htdocs/search/svc_acct_sm.cgi +htdocs/view/svc_acct_sm.cgi +site_perl/svc_acct_sm.pm + +rootwood:COMPLETEHOST/TODO + +Currently, you set a value in the %FS::UID::callback hash with a coderef +of the code you want to execute, but this was bad design and will shortly +be changed to a subroutine to which you pass your coderef to register it. + +This is not a bug, it is how the system is currently designed. After +defining a new package, you need to specifically allow agent types to +purchase packages. You can do this from the edit screen of the new agent +type. +. +It wouldn't be a bad idea to add a configuration value that makes new +packages available for all currently existing agent types automatically. +. +On Fri, Apr 07, 2000 at 10:50:35AM -0500, David Morton wrote: +> For some reason, the type_pkgs table didn't get updated when I tried to +> create a domain service and package... insert into type_pkgs values +> (4,1); fixed it up so that I could actually order the package. + + +From: Chuck Cochems +. +1) automated generating of late notices. So far the only way I know to +generate one is to re-invoice manually. +. +2) smart credit card rejection handling. It should e-mail a note at +least, explainig that it did't go through, and why. +. +3)coment field in the main customer record. +. +4) streamlined payment entry feature. the current scheme has it fairly +buried. +. +5) queries to show al customers who owe money,and such stuff as that. + + +credits aren't counted against past invoices? hmm. something needs to be +done to "apply payment" genericly. and zero out invoices etc. + +more email which should make it into a more organized TODO list: +. +I would also love to see Freeside support bandwidth billing by reading the +Cisco NetFlow Accounting data so we and other ISP's could automatically bill +co-located servers and even potentially other virtually hosted sites like +MUD, Palace Chat, IRC Chat, etc based on the bandwidth they use or average +sustained rates or whatever. I'm not much of a programmer so I don't know +what all this entails but I did download a NetFlow client agent/whatever for +Linux though. + . +It would also be nice to see Freeside be able to read Apache log files and +bill customers for web traffic that way as an option also. Plus an option to +bill for excessive disk usage without having to use quotas if you didn't +want to, would be a nice feature as well. So you could monitor with a script +or something to see how much disk space a user was using then get some +average and charge a certain amount for anything above some preset limit for +that account type. I might be able to hack something like this up, but I'm +not 100% sure where to start or if there is something out there that could +be modified or not. +. +Do you think that you will ever support the HKS CCVS (Hell's Kitchen +Software Credit Card Verification Software) since Red Hat bought them out +and is going to be including that for credit card processing when you buy +the professional version? What about possibly supporting the OpenCCVS which +is a GNU/GPL version of a credit card program? I haven't had time to comb +through the Freeside code to see how hard it would be to add support for +these as externally called programs. +. +Also any thoughts on help desk, and knowledge base stuff? Any thoughts on +this stuff, and how possible and what kinds of work or time frame would be +involved? +. +Tim Jung +System Admin +Internet Gateway Inc. +tjung@igateway.net + + + + CVS via SSH (Score:1) + by platinum (jedgar at fxp dot org) on Thursday September 30, @07:13PM EDT (#4) + (User Info) http://www.fxp.org/~jedgar + The links above are your best bet for basic cvs server configuration. Once you have a pserver set up, you + may consider using cvs via ssh. All you need to do is the following: + + 1) Have ssh and sshd set up on the client and server machines + 2) Set CVSROOT="joe@example.com:/home/ncvs" + 3) Set CVS_RSH="/usr/local/bin/ssh" + 4) Use cvs normally + (Obviously, insert the proper host/paths above) + + You can also set up cvs/ssh to not need a password every time (similiar to an initial 'cvs login'): + + 1) run ssh-keygen on client machine using no passphrase. + 2) copy/add ~/.ssh/identity.pub on the client to ~/.ssh/authorized_keys on the server + (man ssh for more details) + + The main reason I mentio + CVS via SSH (Score:1) + by platinum (jedgar at fxp dot org) on Thursday September 30, @07:13PM EDT (#4) + (User Info) http://www.fxp.org/~jedgar + + +There's no way to do this currently, though it would be pretty +straightforward to modify the source - specifically, the _collect_ +subroutine in FS::cust_main. +> +On Mon, Dec 13, 1999 at 04:05:32PM -0700, Jeff Garner wrote: +> Freeside will e-mail my users when they are billed if they are setup as +> billing. +> +> When setup by credit card it does not e-mail them. Is there a way to +> turn on e-mail invoices for those who are billed via credit card? Kind +> of like a recipt of billing.... + + +doc: http://www.softagency.co.jp/mysql/qmail.en.html + +sql1992.txt standard is 18 character column names. shoot for that, not just +32 (postgresql default) + +Also note that (AFAIK) Freeside won't display any package that has more +than one service on the "Add Customer" page. The reason for this is +because there's no way to dynamically alter the displayed html form +based on which package is selected. One possible solution would be to +make an additional page that's used in the signup process that would +display the form for each package, like a MS-style "Wizard". The first +page lets you select the package, then the second page has the custom +form with fields for each service in that package and a save button. Of +course, that would require a little perl work. +. +Later, +Scott Cruzen + + +Your suggested script with back up /usr/local/etc/freeside, but will miss +any database not named `freeside'. Both of our scripts are specific to +MySQL. If you're interested in contributing to Freeside, maybe you could +work on a script which: reads the mapsecrets configuration file and then +each secrets file to find out what specific database engine(s) (MySQL, +PostgreSQL, etc.) and database(s) need to be backed up, then does so, +serializing backups of the same engine, i.e. stop mysql, do all the mysql +backups, start mysql, stop postgresql, do all the postgresql backups, +start postgresql, etc. +> #!/bin/sh +> apachectl stop +> mysqldump -t freeside > fs-backup.sql +> apachectl start +> tar -Pzcvf fs-backup-`date +%y%m%d%H%M%S`.tgz fs-backup.sql /usr/local/etc/freeside/ +> rm fs-backup.sql + +I chose to use counters in the filesystem because there is no standard way +to get the value of an auto-incrementing keyfield which is common across +all databases (as seen through DBI/DBD). +. +It certainly wouldn't be a bad idea to use the database-specific methods, +when available. + +htdocs/edit/svc_acct.cgi: +(Does the `*HIDDEN*' show up when you are adding a new account, and +specify the password, then receive an error and are returned to the form?) + +more DOC: +Thought some of you might be interested in this: + + has CyberCash compatibility modules for +Paymentnet and Authorizenet + which should allow you process transactions +using those services as well as CyberCash. + +The files are named CCLib.pm.paymentnet and CCLib.pm_authorizenet, +respectively, and are installed by renaming to CCLib.pm and moving to your +site_perl directory. Otherwise, follow the directions for Cybercash v2 in +htdocs/docs/config.html + +DOC: +fs_passwd/ is a client-server replacement for the `passwd', `chfn' and +`chsh' commands that updates the Freeside database. (so for that to be +useful, you'd have to be exporting that data periodically) + +fs_radlog/ is a client-server RADIUS log parser that stuffs the data into +SQL. It isn't finished, and probably won't be unless someone who I can't +convince to use one of the RADIUS daemons that logs to SQL directly pays +me money or something. + +fs_signup/ is a client-server signup server. i'm just finishing it up +now; probably isn't on your machine yet. + + +http://www.sisd.com/freeside/list-archive/msg00812.html + +package definitions should be implicit allow wrt agent types, not implicit deny +(with the old behavior possible via a config file) + +> So is there anyway it could be setup to allow you to select a "primary +> service" from each package? This service would be the one you were prompted +> for. Could the signup server then be expanded to allow users to go into +> their package and "turn-on" the remaining non-primary services(using the +> primary account.) + +take the GPL'ed whois proxy stuff at www.geektools.com and turn it into +intelligence for Net::Whois. + A web version of the fs_passwd stuff would be nifty. If you have Cistron authenticating directly from MySQL, you can replicate @@ -13,10 +260,9 @@ in real-time instead of exporting periodically. See . these go in docs: -, and - + (was 546), and -and http://www.sisd.com/freeside/list-archive/msg00423.html +and http://www.sisd.com/freeside/list-archive/msg00421.html (was 423) > > 5: Is there anyway to get freeside to send a sysadmin a warning when a > > credit card has expired? @@ -69,7 +315,7 @@ table should go away, along with the concept of a "default" domain. default setting for new packages should allow all agents to purchase them... with a config file for the old behaviour -replace Term::Query with Quiz::Question? +fix or replace Term::Query (Quiz::Question doesn't do what i need) Check config file reading stuff from CPAN @@ -191,20 +437,7 @@ that error because it didn't exist yet. Sounds like a buglet to me. I'll try to fix that soon; in the meantime you can add the invoicing email address afterwords. -Postgres `money' time sucks rocks anyway. I'll probably just require 6.5 -and use the numeric types, which *finally* work right. -On Sat, Apr 24, 1999 at 12:52:00PM -0700, Mr. Poet wrote: -> Software error: -> Error creating cust_bill record: ERROR: parser: -> attribute 'charged' is of type 'money' but expression -> is of type 'float8' You will need to rewrite or cast -> the expression ! Check updated but unbilled packages -> for customer1 -. -Postgres `money' time sucks rocks anyway. I'll probably just require 6.5 -and use the numeric types, which *finally* work right (well, according to -the web site, anyway). -. +(workaround for postgres before 6.5) (unlikely to ever be implemented) In the mean-time, this could probably be fixed with the reverse of the kludge in FS::Record::new. This removes `$' and `,' from money fields coming out of the database. Something which fixed up the data so Postgres