Re: [Citrusdb-users] New Install

2012-09-12 Thread Rakesh Kotha
Hi Paul, You made my day!! Am not getting that error after importing the citrus.sql file. Surprisingly i don't see that step in the installation document. I have this in my config file: $url_prefix = "http://localhost/citrus";; $ssl_url_prefix = "https://localhost/citrus";; after giving user "a

Re: [Citrusdb-users] New Install

2012-09-12 Thread Paul Yasi
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

Re: [Citrusdb-users] New Install

2012-09-12 Thread Rakesh Kotha
Hi Bryan, I have all of them in place: Below is copy from phpmyadmin Users having access to "citrus" User Host Type Privileges Grant Action citrus localhostdatabase-specific ALL PRIVILEGES No Edit Privileges Below is

Re: [Citrusdb-users] Create invoices for all imported

2012-09-12 Thread bryan
Paul, Sorry. This may be related to a frequency error: Service screen: Fix Billing Frequency Error But the master_services.frequency isn't greater than the billing_types.frequency . They are the same... The default billing type is Bank which has a frequency of 1. Isn't the billing type set d

Re: [Citrusdb-users] New Install

2012-09-12 Thread bryan
Rakesh Kotha, By default PhpMyAdmin doesn't ask for the username or password to log into it. Since it is localhost that doesn't really matter. Click on the citrus DB listed on the left in the DB list column. To make sure you are using the citrus one and not mysql. Then check the Privileges tab

Re: [Citrusdb-users] New Install

2012-09-12 Thread Rakesh
Thank you Bryan for quick reply. I do setup the id and pass from phpmyadmin and mentioned it config file. I tested the connectivity to db using those id and pass from command prompt and it worked well. For some reason while i access phpmyadmin, it is not asking me any id or pass to logon. Not s

Re: [Citrusdb-users] New Install

2012-09-12 Thread bryan
Rakesh Kotha, Could you clarify if you setup the Privileges for the citrus DB in PhpMyAdmin? Its the tab at the top. Once there check for the citrus DB user. If it isn't there click on the "Add a new User" below the table. That username and password need to be set in the citrus configuration

Re: [Citrusdb-users] Create invoices for all imported

2012-09-12 Thread bryan
Paul, I have been trying the Print New Invoices but it didn't create invoices for the new customers. But then the resulting PDF was blank too. Print New Invoices Billed By Organization What date would you like to run: 2012-09-12 Customer's Billing section: -- Next Billing Date