http://blog.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://comments.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://comments.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://comments.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://comments.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://comments.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://comments.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://comments.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://comments.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://comments.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://comments.gmane.org/gmane.comp.crm.citrusdb.user/550 <pre>Hi, I have encounter this before and fix it by just editing the below variable, but now using latest version of citrusdb 2.4.1 I get that same error. $url_prefix="/var/www/html/citrusb"; $ssl_url_prefix="/var/www/html/citrusdb"; Not Found The requested URL /var/www/html/citrusdb/index.php was not found on this server. Here is my config. $path_to_citrus='/var/www/html/citrusdb/'; $hidden_hash_var='thequickbrownfoxjumpoverthelayzdod'; $lang = './include/local/us-english.inc.php'; $url_prefix="/var/www/html/citrusb"; $ssl_url_prefix="/var/www/html/citrusdb"; location of the file [root&lt; at &gt;student citrusdb]# pwd /var/www/html/citrusdb [root&lt; at &gt;student citrusdb]# ls -l index.php -rw-r--r-- 1 root root 13830 Dec 8 23:55 index.php [root&lt; at &gt;student citrusdb]# OS: Centos 6.0 SElinux is disable and firewall is flash Is there something I miss? Thanks in advance, AC ------------------------------------------------------------------------------ Try before you buy = See our experts in action! The most compreh</pre> AC Perdon 2012-02-20T05:00:52 http://comments.gmane.org/gmane.comp.crm.citrusdb.user/548 <pre> One thing that would be useful, ( unless I have a configuration issue) is a navigation options after doing a query, failed or successful.. It appears I need to actually view a record on successful, to get my sidebar back. On failure, I just get the "Query failed" message.. Bill </pre> Bill Harris 2012-02-08T00:54:20 http://comments.gmane.org/gmane.comp.crm.citrusdb.user/547 <pre>I found a possible solution to the problem many have had where they try to login after installation but are returned to the login page. The help page at http://www.citrusdb.org/documentation.html#sec-2 says: "Set the regular url and ssl url prefixes for your site. You should use the same name for both the regular url and ssl url with the only difference being http or https for the protocol. This will ensure the session cookie assigned during ssl login is available to the regular http url as well." Once I fixed that, it worked.------------------------------------------------------------------------------ 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+L</pre> JBW 2012-02-08T00:31:07 http://comments.gmane.org/gmane.comp.crm.citrusdb.user/537 <pre>Hi, Any one here is using citrudb for cable TV Operation? I would like to hear your experiences. Thanks, AC ------------------------------------------------------------------------------ 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-01-16T22:29:58 http://comments.gmane.org/gmane.comp.crm.citrusdb.user/534 <pre>I've looked and can't seem to find anywhere that indicates that CitrusDB runs on a Microsoft server running IIS.  Your product looks lovely and I'd love to get it - but don't want to bother if IIS isn't supported.  I do have PHP Ver. 5.2 on my server.  And I also have MySQL - not sure of version at moment but that can be remedied.   Doreen Jones - Owner JDS &amp; Associates and East Texas Programming Database Solutions and Web Site Development Hosting and Domain Name Registration 2121 S. Loop 256 - Suite 3 (Capital One Bank - Next to Office Depot) Palestine, TX 75801 We Make  Custom Software !!! 903.731.3553               Web and associated languages we can offer support for are - ASP/.Net, C/C++, COBOL, FOCUS, FORTRAN, PHP, REXX, Visual Basic/.Net.       We have expertise in the following databases:   MS Access, ORACLE, and MS SQL.       Other expertise:  JCL, MSA, EXEC2, SCADA.  Feel free to ask - we don't list everything.----------------------------------------------</pre> Doreen Jones 2012-01-14T22:40:35 http://comments.gmane.org/gmane.comp.crm.citrusdb.user/533 <pre>Paul, Just curious is CitrusDB under active development? Or is the project mostly in maintenance mode..? Bill </pre> Bill Harris 2012-01-14T16:10:18 http://comments.gmane.org/gmane.comp.crm.citrusdb.user/531 <pre>Paul What's the suggested OS for running Citrus? What do you run? Cheers Brad ------------------------------------------------------------------------------ RSA(R) Conference 2012 Mar 27 - Feb 2 Save $400 by Jan. 27 Register now! http://p.sf.net/sfu/rsa-sfdev2dev2 </pre> Brad Morton 2012-01-12T15:05:10 http://comments.gmane.org/gmane.comp.crm.citrusdb.user/530 <pre>I linked the mysql.sock and it seemed to get of the problem unitl I rebooted. After a reboot the error comes back and I have to relink it. Ideas? Also once the error is gone and I try to login with the default username and password it goes no where. This is the URL that shows up in my adddress bar after the login attempt: https://10.0.0.11/citrus-2.4.1//index.php ---- Brad Morton Field Service Manager Reztel Broadband 780 Midpark Dr. Suite 103 Kingston, ON K7M 7P6 Office:(613) 384-2101 Toll-Free: 888-546-8888 Cell: (613) 888-2161 www.reztel.net Legal Notice: Please consider the environment before printing this email. --------------------------------------------------------------------------------------------------------- This e-mail message is intended only for the named recipient(s) above and may contain information that is privileged and/or confidential. If you have received this message in error, or are not the intended recipient(s), please immediately notify the sender and permanently delete th</pre> Brad Morton 2012-01-12T14:50:25 http://comments.gmane.org/gmane.comp.crm.citrusdb.user/526 <pre> I am looking seriously at CitrusDB to replace an ancient homegrown billing system based on Access. It currently uses a Paypal interface to download a payment file where customer submit online payments.. It appears that CitrusDB can handle these type of payment gateways. Any suggestions going forward. Bill ------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox </pre> Bill Harris 2012-01-11T18:12:09 http://comments.gmane.org/gmane.comp.crm.citrusdb.user/525 <pre>Been working on setting up the new and improved Citrusdb on spare box we have here. OS: OpenBSD 5.0 Mysql-5.1.54 PHP-5.3 I'm getting close, the login page comes up but at the top it says the following: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) Not sure where to go with this. Not really a guru with this stuff. Any help would be great, Cheers Brad ------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox </pre> Brad Morton 2012-01-11T16:23:15 http://comments.gmane.org/gmane.comp.crm.citrusdb.user/515 <pre>I just got a fresh install of Citrusdb on my computer. The install went great, I have no errors. I created a service, and a customer record, then added that service to that customer's record. Then I click to edit default billing. When I click that I get Unable to connect Firefox can't establish a connection to the server at localhost The site could be temporarily unavailable or too busy. Try again in a few moments. If you are unable to load any pages, check your computer's network connection. If your computer or network is protected by a firewall or proxy, make sure that Firefox is permitted to access the Web. Also, the same thing happens when I click the account manager password link. I Tried everything I can think of and can't get it to work. I searched all over to find a answer but haven't been able to come up with anything. I could really use some help on this thanks, ------------------------------------------------------------------------------</pre> Brien 2011-08-28T07:46:23 http://comments.gmane.org/gmane.comp.crm.citrusdb.user/511 <pre>I am testing the system. When I say that an account has received a over payment, I want to credit the account. It seems to fail because it cannot get a master_service_id. $query = "SELECT id,options_table FROM master_services ". "WHERE category = 'credit' ". "AND organization_id = '$organization_id' LIMIT 1"; This returns nothing. Should I create a service that has a category of type "credit"? What other attributes/values, should it have? Also, how can I tell how much is currently owing on an account? Thanks. </pre> Victor Ientilucci 2011-07-27T16:44:28 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.crm.citrusdb.user