It is your http url. So it would be your domain name that points to your
server, followed by /citrus
Something like: Http://example.com/citrus
Paul
On Sunday, July 3, 2016, Bogi Maramski wrote:
> hi all
> I'm truing to configure citrusdb to use conf.d in apache2
> My question is what to put i
Is SELinux enabled?
On Sat, Dec 20, 2014 at 12:10 PM, Clinton Strouth
wrote:
> I set permissions to 777 on /var/www/html/invoices
>
> Sent from my iPhone
>
> On Dec 20, 2014, at 12:01 PM, Paul Yasi wrote:
>
> Does your web server have permission to write to that folde
> *Sent:* Friday, December 19, 2014 11:37 AM
> *To:* For users of CitrusDB discussion
> *Subject:* Re: [Citrusdb-users] Problem printing new invoices with
> current date on iis
>
> Same problem keeps placing a /
>
> Sent from my iPhone
>
> On Dec 18, 2014, at 6:13 PM,
It may be the encoded characters instead of slashes that got in there
somehow. Can you try just /billing
Paul
On Wednesday, December 17, 2014, Clinton Strouth
wrote:
> When trying to print new invoices we are getting the following error
>
> this is being done from the tool's page and then und
If you set both the $url_prefix and the $ssl_url_prefix in the config file
to both have the https URL then it will always use it.
Paul
On Saturday, April 19, 2014, Michael Grant wrote:
> I just installed CitrusDB. When I log in to https://mydomain it
> redirects me to the non-https site. Is t
There is a usage multiple that you can use to charge anything you want. If
you make the service price 1 dollar, them whatever amount you put in the
usage multiple is the total for that service.
You can also label the usage multiple to name it something else like hours,
square feet, gallons, whate
12-12-25 16:11, bryan wrote:
>> Paul,
>>
>> Looks like I erased the credit and prorated "services".
>> Added them back in as per the original citrus.sql.
>>
>> Now how do I insert the credit manually?
>>
>> Bryan
>>
>>
>>
>&g
This means that E_STRICT is probably enabled in your error reporting
setting. You'll want to turn that off in your php.ini settings so it
does not show these notices. Once it does not show the notices it
should allow the setting of session cookies correctly since it won't
have output any headers
I cannot duplicate the link failing, it is loading the
tools/addcredit.php script. The whole payment is recorded, however if
the credit is not entered with that link on that account then it must
be entered manually. Sometimes a customer may pay for two accounts or
multiple invoices with one payme
Do you mean the date shown in Payment history? When citrus inserts a
payment using the payment tool (tools/payments.php) on the insert
statement around line 95 or so it makes the new payment_history entry
and inserts the CURRENT_DATE into the payment_history creation date.
One would need to instea
I'm guessing you may not have the default database from the citrus.sql
file - this needs to be imported into your empty citrus database, you
can do that with phpmyadmin or on the mysql cmd line.
Paul
On Tue, Sep 11, 2012 at 12:22 PM, Rakesh Kotha wrote:
> Am installing CitrusDB on Windows XP wit
I wrote a custom importer for my data back when I moved it out of my
previous system, being CUSTOM though, I don't know if it makes any
sense to release it since it was very specific to the format that my
data was coming from.
Unless there are popular customer databases that people are importing
a
The variable should go into the config.inc.php and you are right that
kind of function can go into citrus_base.php
Paul
On Thu, Aug 23, 2012 at 5:04 AM, bryan wrote:
> Paul,
>
> You have probably been asked this before...
> To introduce a function where would I put it?
>include/citrus_base.p
Using Print New Invoices under Tools you can create a batch of
invoices using the billing date. When a new account is imported the
billing date will be set to the next available billing date, usually
that will be today's date if you are importing before your billing
date rollover time.
Paul
On W
try just the service line(s) without quotes.
>> Got crazy with the quotes because of commas in the addresses.
>>
>>
>> On 2012-08-11 22:56, Paul Yasi wrote:
>>> I think the quotes around the service attributes may be screwing it
>>> up, can you try i
I think the quotes around the service attributes may be screwing it
up, can you try it without quotes, just comma separated.
Paul
On Thu, Aug 9, 2012 at 2:58 AM, bryan wrote:
> Paul,
>
> I have been unsuccessful in moving from our old invoicing system to
> citrusdb.
> All the data for the import
Billing the same customer every day would not be possible, it uses month
intervals. 1 month or multiple months.
On Jul 9, 2012 10:12 PM, "Nathan Kirk" wrote:
>
> What would I need to do for daily billing? Is that possible in this code?
>
> Nathan Kirk
>
> On Jul 9,
The next billing dates are all based on the from date. Also if today
was january 1st and you are creating a bill now you should set the
next billing date to today's date, eg for a january invoice use
2012-01-01 as your next billing date for that first invoices. After
the monthly invoices is creat
Using the create invoice link under billing it created an invoice
(maybe you created a few) and you can see it in the invoice
maintenance and print it from there. (maybe it should redirect one to
that screen after clicking create invoice?)
You can also batch create invoices. If you go into tools
In preparing for CitrusDB version 3 i'd like to make it easier to
install the software, and to understand better how you are using the
software. If you could take two minutes and answer this short 5
question survey it would help me determine how best to proceed. Thank
you for your time.
Please vis
If you look in the includes folder that comes with 2.x you'll see
there are files that have functions for billing, services, and support
that have much of these function in them. Including the config and
database files will get your settings and database connection too.
eg:
include('./include/co
It is a simple billing model, but it works for many uses. I would be
glad to look at a patch that implements this. If you expect the
software to do this out of the box, then maybe citrus isn't for you.
Paul
On Wed, May 30, 2012 at 4:38 AM, wrote:
> Hi Paul/whoever,
>
> We expect our database
The currency symbol is printed almost nowhere, maybe it should just be
removed. For multiple currencies would one need multiple prices for
everything? That sounds like a total mess. Why would you want to do
that to yourself?
A volume discount could be done during your import script by assigning
The database can be named anything you want as long as it matches what
you set in the $sys_dbname variable in the config.inc.php file.
eg:
$sys_dbname = 'citrus2';
I would ask you to consider if shared hosting keeps your customer data
adequately safe and meets your local PII laws and regulations
This 2.4.2 release fixes a file include vulnerability that allowed
users who are logged into citrus to load other php files from the
server. It also adds some minor features.
- fixes file include vulnerablity
- adds a tool to show the pending creditcard refunds
- adds script that can email custom
There is a vulnerability in citrus that can be patched by adding a
preg filter around line 99 of the index.php file that will prevent the
php file inclusion vulnerability. This vulnerability is only
exploitable to users already logged into citrus.
http://bazaar.launchpad.net/~paul-citrusdb/citrus
The email functions that send invoices and notices use a mailserver,
usually one running on the same server as the database software. So
for a linux server you would need to be running an mta like postfix or
exim to send outgoing mail from the server. On windows there is a
setting in the php.ini
I don't think you have to modify anything, just turn off the
deprecated warnings.
Paul
2012/3/13 James Paul :
> Thanks for the community support, I would rather not have to start
> modifying code.
>
> I am running a linux lampp framework, current version,
> php 5.3.8, FPDF 1.6.
>
> I can backtra
I think it worked but is showing a deprecated error since not all the
split calls have been updated to use preg's for php 5.3
You can turn off this message by turning off the deprecated warning in
your php.ini
error_reporting = E_ALL & ~E_DEPRECATED
In production you probably also want to turn
I don't use google apps myself, but i'm intersted in this module. Do
you go through google directly or through their ikano partner editon?
Paul
2012/2/21 John Hurst :
> Hey Guys,
> I've been working on a module for citrusdb that will use Google
> provisioning API to provision Google Apps acc
The URL prefix needs to be the beginning of the URL to your citrus
site that will work in a browser, eg: http://www.example.com/citrusdb
and https://www.example.com/citrusdb
Paul
2012/2/20 AC Perdon :
> Hi,
>
>
> I have encounter this before and fix it by just editing the below variable,
> but no
Is this when searching for customers? On a search that does not
return results you should get "Sorry No Records Found" and a link to
"Click here to try again". If you are getting a query failed
something may be wrong.
Paul
On Tue, Feb 7, 2012 at 7:54 PM, Bill Harris wrote:
>
> One thing that w
ES | | NULL |
> |
> | cancel_reason | int(11) | YES | | NULL |
> |
> | notes | text | YES | | NULL |
> |
> +--+--+--+---
I don't think it would break anything.
Paul
On Mon, Jan 23, 2012 at 8:29 AM, Bill Harris wrote:
> Paul,
>
> Our current "homegrown" Access-based system stores the account
> name as the account number (legacy from dial-up days)..
>
> I want to import the customers today, but wondered if I could a
It should work, but I have not done it myself. Citrus is dependent on
the php interpreter and not the web server underneath. Microsoft has
made some commitment to making php work with windows.
http://www.microsoft.com/web/platform/phponwindows.aspx
I could try it on my Windows 7 partition someti
There is a stable/maintenance version and an active development
version. The version on citrusdb.org is 2.4.x that is the
stable/maintenance version and there is a development version 3.0 that
is not yet deemed ready for production. It has been refactored into
an MVC framework and is under active
It will not login and look as if it's doing nothing if you have the
wrong password or there may be some errors you can look at in the
apache error_log or wherever php may be writing errors.
I currently use ubuntu linux but citrus can run anywhere php/mysql can
run. Whatever OS you are comfortable
There isn't a paypal import feature included, but you could probably
modify the importcc.php file in tools to import this file of payment
information.
Has anyone on the mailing list already done something with paypal
files? I would imagine many people download the same paypal file
format.
Before
I don't know much about running php/mysql under OpenBSD but I found a
tutorial that recommends making a new hard link to the place where
apache can see the file.
http://freeyourbox.org/tutorials/bsd/obsd3.8_apache_php_mysql.html#Setting
that says:
On OpenBSD, apache comes chrooted in the /var/www
Announcing version 2.4.1 of citrusdb with bug fixes and minor feature
updates including
- making it easier to choose items to rerun on specific invoices
- adding a date range to the invoice printing tool to print multiple
invoices days at once
- improving the revenue report to show all organizatio
Maybe the SSL module is not loaded, I can reproduce the same error if
I turn off the SSL module in apache.
https://help.ubuntu.com/11.04/serverguide/C/httpd.html#https-configuration
Paul
On Mon, Aug 29, 2011 at 5:41 PM, Brien wrote:
> Also I have checked to see if apache is running and restarte
Do you get any response like the default apache "It Works!" page when
you go to https://locahost/
I've followed these instructions to enable ssl on ubuntu successfully before:
http://www.tc.umn.edu/~brams006/selfsign_ubuntu.html
If you are just trying this out on localhost and not across a networ
Edit billing tries to use the SSL url since it may have card data in
it. This is probably because you don't have the $ssl_url_prefix
configured correctly. If you are storing credit cards you'll want to
enable SSL on your server and configure that ssl_url_prefix to use
the https address. If you
You should certainly have had the Example Service and credit entries,
not sure why those would not be there. That sounds like the initial
installation of the citrus.sql file did not complete correctly.
Regarding the credits, they are added to the customer's services
listing, and are applied when
Citrusdb is not content management system for a customer facing
website all by itself, though it does have a small component you can
use that provides customers a view of their account. Most of citrusdb
is for internal usage by customer service representatives and billing
to manage customers and t
Welcome to citrusdb, this list is still active, though often quiet.
There is a new project i'm working on to refactor citrusdb into
codeigniter if anyone is interested. This is totally unusable right
now, and i'm not sure how far i'll get. It is hosted at github,
https://github.com/paulyasi/citr
The customer you are viewing is stored as a session variable, so if
that isn't working then you cannot view anything but the first
customer number.
It sounds like you do not have a session storage location properly
setup in your php configuration.
Paul
2011/5/7 "Ing. Oscar Hernández C." :
> Hell
CitrusDB 2.4 is now available. This release now requires SSL for
login and uses the phpass framework to support stronger bcrypt
password hashes. A new service churn report has been added. Message
tabs now have separate pages for each usergroup and give a green
notification upon new messages, and
Due to customer privacy laws and payment card industry standards that
recommend a separation of duties between development and production
work I am restricted from taking on work myself for installation and
integration of citrusdb onto production systems at customer sites.
I am looking to make a l
I'm not sure this would be something that would be useful in the release
version, maybe an option to add at some point. You could hack it in to the
customer view by adding some code to the modules/customer/index.php file
around line 203 replace it with something like:
"".
"".
""
This new feature release adds email invoices with pdf attachments,
credit card reruns now create invoices with pastdue amounts instead of
moving old items to new invoices, and more indexes have been added to
the default sql scheme for faster queries.
This new version requires PHP 5.2 or greater.
I'm happy to announce the release of citrusdb version 2.2. This
release now includes the full documentation, LDAP authentication
support, tabs for each message group, and many other minor features
and bug fixes. Download the latest version from
http://www.citrusdb.org
I am also announcing the av
The \' at the end of your $path_to_citrus path is causing it to escape
the single quote and not close the string. You need to put two
slashes at the end of that line, or you can use forward slashes
unix-like and not need to specify C: on windows, apache/php treats C:
as the root directory, eg:
$p
This is a maintenance release for citrusdb that fixes some bugs and adds
minor features.
- fixes to the credit card import and update function
- added a button to delete a service today
- added a vendor history for auditing later
- fixes to typos and various undefined variables
- customer summary
There is not much style being applied in the html of the online customer
site since I thought one would want to wrap it in their own brand's css
anyway. This question has been asked before though, so maybe that was a
wrong assumption by me and I should apply more styles to the there.
What kind of
dard? Some how use a variable for the path?
>
> If you could knock up a version of the email invoice to be run nightly
> that would be much appreciated. I have a fair amount of web space on
> my server if you ever need any!
>
> db
>
>
> On 19 Jun 2010, at 14:03, Paul Yasi w
If the rate for extra minutes not included with the flat rate is the
same for all rate-centers you could create one service called something
like "additional minutes" that costs the per-minute rate and put the
amount of minutes used in the Measured Usage field. This will multiply
that by the rate
There is a table called login_failures that will record your IP address
each time you fail to enter the correct password. If you fail more than
5 times in a 24 hour period it will not allow you to try logging into
the system again. You'll need to go to the login_failures table and
remove the rows
The statusupdate script requires many of the files in the /include
folder of citrus, so if it cannot find those files in the same place it
is at it cannot run. You can copy the /include folder to the same place
you are running statusupdate from to get it to work or a better idea may
be to use a sh
I'm not sure I understand the issue. Citrus primarily uses the
DATE_ADD function from MySQL which should not have a problem adding to
any calendar date correctly.
You are right that the prev_billing_date column is not used anywhere,
it's a left over field from pre-release days.
Paul
2010/5/29 E
I think your keyring is probably owned by a different user than the
one that the web server is running as. You must change the
permissions of the keyring files to allow read/write access from the
web server account.
I think the permissions below should work, though I haven't tested
them recently.
You can enable the debug function by adding:
$DB->debug = true;
Near the top of the index.php file.
Adding debug will print out all the database queries all over the
page. You will only need to pay attention to the one that shows up
right before the query failed message.
You should look throug
I've fixed the nummessages typo and found a whole bunch of undefined
vaiables to fix when I turned on notices. I know i've turned on E_ALL
notices to find these before, but it seems that is was undone during
some upgrade or something. Thanks for reminding me. I've found still
more undefined vari
Regarding the option for inputting new fields for IP addresses and
fields for DHCP etc. There is some info in the help document about
setting up new services with custom attributes here:
http://citrusdb.org/help.html#sec-3.8.1 However maybe it is unclear
what all that implies.
Instead of editing
I know there are many service providers using citrus and wanted to
discuss the possible third way of internet regulation proposed by the
FCC in the US.
http://www.engadget.com/2010/05/06/fcc-outlines-new-third-way-internet-regulatory-plan-will-spli/
According to the news about the new 'third way'
There is no built in option that connects to paypal. At one time I
thought that paypal's virtual terminal had a batch file upload
feature, but I cannot find documentation on that now.
It may be possible to use Paypal's Website Payments Pro Payflow
Edition API.
https://cms.paypal.com/us/cgi-bin/
I think you need to update the url_prefix variables in config.inc.php
to match your own URL for your installation of citrus.
Paul
On Wed, May 5, 2010 at 6:52 PM, Ronnie Mubiru wrote:
> Hello,
> Thanks for the good work out there.
>
> i have tried to install this system and also tried to configur
Ok, Eric you are in there!
Paul
2010/4/26 Eric Cho :
> Oh. Thanks.
>
> This is my address for twitter. I hope you add this there.
>
> http://twitter.com/myfoxfree
>
> Appreciate!
>
> -Eric
>
>
> ____
> From: Paul Yasi
> To
gt;
>
> #2,
>
> When I tried refund I couldn't find a message such "You must manually
> process ... that you said.
>
> Anyway, I added exception code for cancel refunding before executing refund
> button in tools menu.
>
> (Since I will use it in a batch proc
Oops. I've committed a fix for the next release:
http://bazaar.launchpad.net/~paul-citrusdb/citrusdb/gpg/revision/241
Paul
2010/4/26 Eric Cho :
> Hello!
>
> I found one little error in the "tools/modules/billling/importccupdate.php"
>
> 85 line
> I believe that
> $armordate .= "$line[0]
Item 1: Refunds do not currently work for prepaycc billing types,
only normal monthly creditcard bills. When you went into the refund
report to indicate the amount of the refund it would have came back
with a message: "You must manually process a refund for this billing
method" Prepaycc had sor
What browser are you using? Could you try it in a different or newer browser?
Paul
2010/4/23 Eric Cho :
> Hello.
>
> I'm using CitrusDB on localhost.
>
> I found one error when I try to open sub window for configuration menu in
> tool as follows.
>
>
>
> Webpage error details
>
> User Agent: Moz
This minor feature release release adds a function to track field
assets being shipped out with a service. Credit card charges are now
applied to the newest invoice first. Adds the to and from date range
for each service on a receipt. Fixes the subject in the email
notifications
Download it now at
You need to edit citrus to use a new path to save the data to. That
is done by going to Tools and Opening the Settings tool. Here you'll
see a Path to Credit Card File field. You need to change that to your
own file path where the invoice can be stored. It is also where card
data would be expor
>
> M
>
> On Wed, Mar 17, 2010 at 10:32 PM, Paul Yasi wrote:
>>
>> The name for the base modules are assigned in modules.php around line
>> 55. It is using a variable from the language file stored in
>> /include/local/. It would probably be easiest to chang
The name for the base modules are assigned in modules.php around line
55. It is using a variable from the language file stored in
/include/local/. It would probably be easiest to change the name in
the language file or make a new language variable file with your own
wording.
Paul
2010/3/17 Ick
Those notices are not going to cause it to not function, they just
reflect your error level in PHP showing you everything. The thing
that will cause it not to function is the PHP Warnings
at the bottom. CitrusDB is trying to save the accounts files that
statusupdate creates. It puts it in to the
This release changes credit items to be used to credit new charges,
and does not use them to pay off past invoices which was causing
confusion. It also shows the subtotal of unused credit on the invoice.
Also adds a notification feature that can email or send jabber/xmpp
notifications of new suppor
When you said mailing them with a cron job, do you mean attaching them
to an email? There is an e-invoice type for emailed invoices, however
it sends a text invoice right now. At some point i'd like to add an
option that makes that attach pdf files to invoices too that would
need to generate eac
You'll need to take the code from printpreivous and edit it a bit and
run it outside of citrusdb with the php command line program. If use
use SELECT DISTINCT billing_details.invoice_number I don't think
you'll need to do that thing that removes duplicate results either.
Include the functions at
If you are running gpg inside a user that is not the same as the web
server's user then you'll need to suppress those permission warnings
by adding --no-permission-warning to your gpg command.
More info about this option and other options are available here:
http://www.gnupg.org/documentation/manu
There are two functions you can call in a loop while you read your
data that will pretty much do this for you. The create_service and
service_message function. These are from the include/services.inc.php
and include/support.inc.php. You'll also probably want to have the
bunch of included files t
The latest bug fix for citrusdb 2.0 is now available. This release
now adds a gpg_sign variable to the configuration that is used to
specify a priate key signature command that is used to verify the
passphrase entered in the export cards tool before any other batch
processing is begun. This is no
You need to update the url_prefix and ssl_url_prefix variables to the
correct ones in config.inc.php
These are new in 2.0
Paul
2010/2/5 AC Perdon
> Hi,
>
> I have installed citrusdb 3 times and my first time to encounter this
> problem which I cant figure it out, can any one help details below
The newest release of citrusdb is now available! Version 2.0 now
supports industry standard OpenPGP encryption of stored credit card
data, sub-notes added to customer tickets, a history of the customers
you have recently viewed, and logging of citrusdb activity.
Visit http://www.citrusdb.org to g
Sounds like you probably need to install the mysql module for php.
Most linux distro's will have a package you can install that will
include this for you. If you are running ubuntu/debian you can run:
apt-get install php5-mysql
If you compiled php yourself you would have to put --with-mysql in
y
ierr...@poseidon-networks.com*
> *web: www.poseidon-networks.com*
>
> On Thu, 2010-01-07 at 09:45 -0500, Paul Yasi wrote:
>
> I'm not too familiar with ldap. Are you trying to use ldap to initiate the
> connection from the webserver to the mysql server, or to hold the
I'm not too familiar with ldap. Are you trying to use ldap to initiate the
connection from the webserver to the mysql server, or to hold the citrusdb
users themselves?
Paul
2010/1/7 Pierrick Merle
> Hello,
>
> I'm looking for an ldap connector in citrusdb.
> As far as i can see, it seems that
I think the majority of citrusdb users are firefox users, and I've
never seen this myself or heard about it before. A quick search about
firefox turns up a feature in firefox called pipelining that may make
multiple requests for one page,
http://www.ehow.com/how_2033391_enable-pipelining-firefox.h
A public beta version for testing the next major release of citrusdb
is now available!
Version 2.0 adds support for public key encryption of credit card
data, logging of access to customer records, a search dashboard that
shows previous customers you have viewed, and better support tickets
with ti
Those variables are used by the notice class when creating notices,
they are currently undefined until they are in use, so that notice is
actually correct. You can safely turn off notices like this in your
php.ini file with a setting like:
error_reporting = E_ALL & ~E_NOTICE
Paul
2009/12/13 G
Adding a new module that would upload files and associate those files
to an account number should not be too difficult, especially if the
filename can contain the account number. The part that then links
them with their online account manager would need to be a custom added
case, since the online
CitrusDB 1.3.2 has been released. This release fixes numerous minor
issues as well as a hand full of larger ones:
- Fixed decimal precision for money amounts in tables
- Faster exporting of large batches
- Added billing record tools to manually set status and send or print notices
- Added an orga
I'm not sure what file you are referring to? Are you sure it's
/admins/modify_client.php ?
One could make the PDF be sent as an email attachment, to do this the
you would have to mime encode the PDF output and attach it to the
email message with appropriate headers.
Paul
On Mon, Jul 20, 2009 at
The billing tab allows you alter that customer's billing record. Most
customers would only have one billing record, the default one is show
there, and the alternate ones are shown below it in a list. Sometimes
you may add alternate billing records when a customer has a service
that is not billed
There may be a compatibility mode you can try turning on that may
make it work. I think 6.0 is a preview version and not really for
production use. I would recommend sticking to the regular general
release version, which is 5.1 right now.
Paul
On Fri, Jul 10, 2009 at 1:21 PM, Clinton Strouth w
Sorry, citrusdb does not do payroll.
Paul
2009/6/29 Jeremy Winton :
> Does CitrusDB have payroll and if so does it get payroll tax updates?
>
> Thanks in advance
> Jeremy
> --
>
> _
CitrusDB 1.3.1 has been released. This is release adds the ability to
choose which items to rerun on a credit card payment, it can associate
a ticket to a service,
and allows fixed amount taxes or fees. Please note that the update
script will reset any rerun dates in the database to be NULL becau
The new CitrusDB 1.3 Manual is now available! It provides up to date
information for using version 1.3 and I believe it a better organized
pdf file with a nicer chapter list thanks to producing the manual
using emacs org-mode (thanks org-mode!). You can get the manual from
lulu at http://www.lulu
Oh, and that mysql user will need access to the default citrus
database you created with the citrus.sql file too of course!
On Wed, Mar 25, 2009 at 10:07 PM, Paul Yasi wrote:
> You'll need to make sure the mysql server has a user with a name and
> password matching the one you have in
1 - 100 of 247 matches
Mail list logo