http://permalink.gmane.org/gmane.comp.crm.citrusdb.user hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/574 <pre>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 it to different services depending on what the amount was, say under 100 gets one service id and over 100 gets a different service id. Each rate you offer would usually be a different service at a different price. You do end up with a huge number of services. At least that's how it's meant to be. Paul On Wed, May 23, 2012 at 6:40 AM, &lt;nabl-yx4YqRIVDag&lt; at &gt;public.gmane.org&gt; wrote: </pre> Paul Yasi 2012-05-25T19:29:32 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/573 <pre>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. Particularly things like access control and comprehensive log review may be difficult on a shared host. A virtual private server may be more appropriate. Paul On Wed, May 23, 2012 at 4:48 PM, Kiersten Williams &lt;kiersteny-/E1597aS9LQAvxtiuMwx3w&lt; at &gt;public.gmane.org&gt; wrote: </pre> Paul Yasi 2012-05-24T01:12:38 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/572 <pre>I am a new user with some php &amp; mysql experience.  I'd like to run Citrus DB on a shared server with GoDaddy.  I am unable to name the mysql database "citrus" as that name is already in use.  If I name the database something different, which files will I need to modify with the new name in order to get things installed properly? Thanks in advance for any help! Kiersten ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________ Citrusdb-users mailing list Citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> Kiersten Williams 2012-05-23T20:48:39 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/571 <pre>I'm evaluating CitrusDB for a telecoms-like application, having abandoned an evaluation of jBilling. CitrusDB seems more limited, but at least I got it working quickly with a simple initial demo setup of my own - which is more than I can say for jBilling, after spending around a week on it. These are the points I'd like to share. Thanks to anyone who can confirm or correct or make suggestions. Limitation to a single currency: as I'm not evaluating on my own behalf, I'm not sure yet if this is a showstopper. There doesn't seem to be an obvious workaround, though I noticed that no currency unit appeared on the sample invoice I generated. Perhaps the simplest way would be to run a separate installation of CitrusDB for each currency (which might be acceptable if they could be limited to, say, three, but which is obviously not an appealing solution)? Volume discounts, discount for advance payment, etc. I didn't see a section dealing with this subject in the manual. My understanding is that this would hav</pre> nabl-yx4YqRIVDag< at >public.gmane.org 2012-05-23T10:40:27 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/569 <pre>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/citrusdb/gpg/revision/417/index.php The SQL injection vulnerability is not exploitable because the injected code is filtered out before it gets to that database query. The preg filter will be included in the next release of citrus, which I hope to get online soon. http://seclists.org/bugtraq/2012/Apr/53 Paul </pre> Paul Yasi 2012-05-22T13:33:42 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/568 <pre>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 that specifies the mail server I believe. Paul On Sat, May 5, 2012 at 5:10 AM, nam vo &lt;congthanhgiong-/E1597aS9LQAvxtiuMwx3w&lt; at &gt;public.gmane.org&gt; wrote: </pre> Paul Yasi 2012-05-15T13:17:27 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/567 <pre>Hi all,   I cannot find out how to configure citrusdb to work with my current gmail to send invoice ... really weird system to me.   I'm totally new to citrusdb. please help.   Nam Vo------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________ Citrusdb-users mailing list Citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> nam vo 2012-05-05T09:10:02 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/566 <pre>I don't think you have to modify anything, just turn off the deprecated warnings. Paul 2012/3/13 James Paul &lt;datacatch336699-PkbjNfxxIARBDgjK7y7TUQ&lt; at &gt;public.gmane.org&gt;: </pre> Paul Yasi 2012-03-13T18:24:11 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/565 <pre> 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 backtrack to lampp v1.7, PHP 5.2.8, FPDF 1.6. Will have to dig though errata to find when split and magic were deprecated. Anyone know ? ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d_______________________________________________ Citrusdb-users mailing list Citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> James Paul 2012-03-13T18:15:44 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/564 <pre>As of PHP 6, these functions are removed. You can install a PHP version less than 6.0, or you can modify the code. For split() I believe they recommend replacing with explode(). For set_magic_quotes_runtime(), the code to check for it for earlier versions of PHP is at http://us2.php.net/get_magic_quotes_runtime/ |&lt;?php // Check if magic_quotes_runtime is active if(get_magic_quotes_runtime()) { // Deactivate set_magic_quotes_runtime(false); } ?&gt; | Send Citrusdb-users mailing list submissions to citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/citrusdb-users or, via email, send a message with subject or body 'help' to citrusdb-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org You can reach the person managing the list at citrusdb-users-owner-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org When replying, please edit your Subject line so it is more specific than "R</pre> Rich Cloutier 2012-03-13T15:52:24 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/563 <pre> Updated the presets as advised, setup services, added services, created invoice, view invoice maintenance, clicked on [pdf] and this is the result. Wondering whether I have not quite got the settings setup quite right yet, or, is this something else ? Thanks. JP Deprecated: Function split() is deprecated in /opt/lampp/htdocs/citrus-2.4.1/include/billing.inc.php on line 1777 Deprecated: Function split() is deprecated in /opt/lampp/htdocs/citrus-2.4.1/include/billing.inc.php on line 1777 Deprecated: Function split() is deprecated in /opt/lampp/htdocs/citrus-2.4.1/include/billing.inc.php on line 1777 Deprecated: Function split() is deprecated in /opt/lampp/htdocs/citrus-2.4.1/include/billing.inc.php on line 1777 Deprecated: Function set_magic_quotes_runtime() is deprecated in /opt/lampp/htdocs/citrus-2.4.1/include/fpdf.php on line 1165 Deprecated: Function set_magic_quotes_runtime() is deprecated in /opt/lampp/htdocs/citrus-2.4.1/include/fpdf.php on line 1203 FPDF error: Some data ha</pre> James Paul 2012-03-13T03:54:04 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/562 <pre>Paul, I have a question about what happens when you click the Cancel Customer button on the Customer Module. Will it notify each module that this is happening? My goal is to have my module delete each email account when the customers account is canceled. - John H On Tue, Feb 21, 2012 at 3:15 PM, John Hurst &lt;hursjohn-UP35GtZhEQQybS5Ee8rs3A&lt; at &gt;public.gmane.org&gt; wrote: ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d_______________________________________________ Citrusdb-users mailing list Citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> John Hurst 2012-03-06T23:50:44 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/561 <pre> PHP v5.2.15 (cli) (built: May 5 2011) Zend engine v2.2.0 ------------------------------------------------------------------------------ Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2_______________________________________________ Citrusdb-users mailing list Citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> James Paul 2012-03-05T15:38:27 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/560 <pre>are you using PHP v5.2 or newer? On Mar 4, 2012 8:43 AM, "James Paul" &lt;datacatch336699-PkbjNfxxIARBDgjK7y7TUQ&lt; at &gt;public.gmane.org&gt; wrote: ------------------------------------------------------------------------------ Virtualization &amp; Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/_______________________________________________ Citrusdb-users mailing list Citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> John Hurst 2012-03-04T18:55:25 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/559 <pre>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 &amp; ~E_DEPRECATED In production you probably also want to turn off display_errors and turn on log_errors: display_errors = Off log_errors = On Paul 2012/3/4 James Paul &lt;datacatch336699-PkbjNfxxIARBDgjK7y7TUQ&lt; at &gt;public.gmane.org&gt;: </pre> Paul Yasi 2012-03-04T16:24:02 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/558 <pre> Hello Citrus, I am looking forward to becoming adept at this software :)))) I added a customer/client, set up a few new services, and went to add a service line item to the main customer page and got this notice: Deprecated: Function split() is deprecated in /opt/lampp/htdocs/citrus-2.4.1/include/billing.inc.php on line 1777 Edit: 45 Attendance Hourly (New Client Name) Created On: Mar 04, 2012, ActiveAny idea where I missed a pre-config or ??? as the nature of this notice ? Kindly, JP. ------------------------------------------------------------------------------ Virtualization &amp; Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/_______________________________________________ Citrusdb-users mailing list Citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrus</pre> James Paul 2012-03-04T15:43:42 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/557 <pre>We're going through iKano. We have the ISP paid version. Like I said before, I don't have it working entirely yet. But I am able to suspend, unsuspend, add, and delete email accounts. Changeing passwords, and names I'm still working on. I'm using the Zend PHP Framework to do all the provisioning. You can get a copy of my current code at hursjohn.com/citrusdb/email.zip - John On Tue, Feb 21, 2012 at 2:19 PM, Paul Yasi &lt;paul-5xkpsxcFBZtg9hUCZPvPmw&lt; at &gt;public.gmane.org&gt; wrote: ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d_______________________________________________ Citrusdb-users mailing list Citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.s</pre> John Hurst 2012-02-21T22:15:46 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/556 <pre>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 &lt;hursjohn-UP35GtZhEQQybS5Ee8rs3A&lt; at &gt;public.gmane.org&gt;: </pre> Paul Yasi 2012-02-21T21:19:19 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/555 <pre>Hey Guys, I've been working on a module for citrusdb that will use Google provisioning API to provision Google Apps accounts. I'm making this because we recently switched our customer base over to Google. Is there anyone else out there who is using Google Apps and would be interested in this module? I have it working now, however still working on getting it to update user's names, and passwords. - John ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d_______________________________________________ Citrusdb-users mailing list Citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> John Hurst 2012-02-21T20:21:45 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/554 <pre>Hi, I solved the problem by using below config. Got the idea as I read some of the issue posted here. $url_prefix = "http://localhost/citrusdb"; $ssl_url_prefix = "http://localhost/citrusdb"; Thanks for the help AC On Mon, Feb 20, 2012 at 1:00 PM, AC Perdon &lt;acp.tcn-Re5JQEeQqe8AvxtiuMwx3w&lt; at &gt;public.gmane.org&gt; wrote: ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d_______________________________________________ Citrusdb-users mailing list Citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> AC Perdon 2012-02-21T17:50:53 http://permalink.gmane.org/gmane.comp.crm.citrusdb.user/553 <pre>Still get same error = ( $path_to_citrus='/var/www/html/citrusdb'; $hidden_hash_var='thequickbrownfoxjumpoverthelayzdod'; $lang = './include/local/us-english.inc.php'; $url_prefix = "/var/www/html/citrusdb"; $ssl_url_prefix = "/var/www/html/citrusdb"; On Tue, Feb 21, 2012 at 1:29 AM, Rich Cloutier &lt;richc-3SjB2UHLC3Hby3iVrkZq2A&lt; at &gt;public.gmane.org&gt; wrote: ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d_______________________________________________ Citrusdb-users mailing list Citrusdb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/citrusdb-users </pre> AC Perdon 2012-02-21T17:39:06 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.crm.citrusdb.user