Re: [Citrusdb-users] (no subject)
Thanks Paul, works perfect now I think. There's a lot I want to do with citrus. If I want users to be able to make payment, what's the easiest way to do this? I've always used paypal previously but I understand this isn't so easy with citrus? Thanks David ___ On 24 May 2010, at 11:12, Paul Yasi p...@coffeebuzz.com wrote: 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. chmod 777 .gnupg cd .gnupg chmod 604 random_seed chmod 644 pubring.gpg chmod 644 secring.gpg chmod 644 trustdb.gpg Paul On Sun, May 23, 2010 at 7:04 PM, da...@badbison.com wrote: I'm having real trouble with the keys when I execute the command it seems to write the key to /root/.gnupg my config files looks like this $gpg_command = /usr/bin/gpg --homedir /root/.gnupg --armor --batch -e -r 'citrusdb'; $gpg_decrypt = /usr/bin/gpg --homedir /root/.gnupg --passphrase-fd 0 --yes --no-tty --skip-verify --decrypt; $gpg_sign = /usr/bin/gpg --homedir /root/.gnupg --passphrase-fd 0 --yes --no-tty --clearsign -u 'citrusdb'; citrusdb was the real name i gave the key gen. but when I try to store a card number i get this error: Credit Card Encryption Error: error: gpg: WARNING: unsafe ownership on homedir `/root/.gnupg' gpg: failed to create temporary file `/root/.gnupg/.#lk0x8117040.badbuntu.badbison.co.uk.6225': Permission denied gpg: keyblock resource `/root/.gnupg/secring.gpg': general error gpg: failed to create temporary file `/root/.gnupg/.#lk0x8117040.badbuntu.badbison.co.uk.6225': Permission denied gpg: keyblock resource `/root/.gnupg/pubring.gpg': general error gpg: citrusdb: skipped: public key not found gpg: [stdin]: encryption failed: public key not found I bought the manual but that didn't make things much clearer. i'd really appreciate some help. thanks dave --- --- --- - ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users -- The CitrusDB Project | http://www.citrusdb.org Open Source Customer Care Billing System --- --- --- - ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users -- ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
Re: [Citrusdb-users] (no subject)
That SQL command would be issued from within a connection to mysql, often it's easiest to use a utility like phpMyAdmin to do that when you have the citrus database open, use the SQL tab to issue that SQL command. You could also do this from the mysql command line, something like: to login enter: mysql -u yourusername -p (this will prompt you for the mysql users password) then tell it to use the citrus database enter: use yourdatabasename then enter that command to alter the table: ALTER TABLE `customer` AUTO_INCREMENT = 1 Paul On 9/24/07, AJ Becker [EMAIL PROTECTED] wrote: Paul, can this be done to a working system with current users? Where the next account would be the new #s? or would it have to be done before use. Also.. Your example context didnt work for me.. What exaclty do I have to type and how on mySQL. Thanks - Original Message - From: Paul Yasi [EMAIL PROTECTED] To: For users of CitrusDB discussion citrusdb-users@lists.sourceforge.net Sent: Monday, September 24, 2007 2:24 PM Subject: Re: [Citrusdb-users] (no subject) You can actually start the customer account numbers at any number you want, maybe this should be a higher number by default. If you want to alter the customer table, you can run this SQL command to start the number at 1 for example: ALTER TABLE `customer` AUTO_INCREMENT = 1 It may also be a better idea to use something like the customer email address as their account manager login instead of their account number... this is something to think about for future versions. Paul On 9/23/07, AJ Becker [EMAIL PROTECTED] wrote: only reason i wanted to do this was for users to be able to log into there accounts. Im not fond of low 2-3 digit account numbers to start.. makes it look like you have no customer base. plus its another number they have to remember to get to there account. - Original Message - From: Paul Yasi [EMAIL PROTECTED] To: For users of CitrusDB discussion citrusdb-users@lists.sourceforge.net Sent: Sunday, September 23, 2007 9:41 AM Subject: Re: [Citrusdb-users] (no subject) It is not possible for citrus to change a customer's account number. Keeping the account number the same all the time is very important since it connects the customer with all their information. I would not use a phone number as their customer number, the customer may move and get a new phone number, or in a super rare case that number may be assigned to someone else. You can still search by their phone number, and upon a match it will take you right to that record. Paul On 9/23/07, AJ Becker [EMAIL PROTECTED] wrote: is it possible to change a customers customer number ? Would like to use there phone number as their customer number. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users -- The CitrusDB Project | http://www.citrusdb.org Open Source Customer Care Billing System - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users -- The CitrusDB Project | http://www.citrusdb.org Open Source Customer Care Billing System - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01
Re: [Citrusdb-users] (no subject)
REMOVE this email from you Spam Listing -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, September 24, 2007 3:38 PM To: citrusdb-users@lists.sourceforge.net Subject: Re: [Citrusdb-users] (no subject) Thanks AJ Paul, This was a question of mine that I had on the side. Concerning the customer authentication for the online portion I would personally stay away from using e-mail address for authentication purposes due some accounts not having them on file until later. The site I am working on now is sending out paper invoicest to customers who's only information we have on hand (initially) is full name and address. The only true constants for accounts are most likely going to be the there name and the arbitrary account number CitrusDB create's for them, and I'd prefer to keep it that manner for the login. I guess what would be the nicest option is for the administrator to be able to configure what is used for the login on the online customer protion of the site. But I have no idea what would go into setting up a function like this. Personally login via account number is the best in my eyes. Quoting Paul Yasi [EMAIL PROTECTED]: You can actually start the customer account numbers at any number you want, maybe this should be a higher number by default. If you want to alter the customer table, you can run this SQL command to start the number at 1 for example: ALTER TABLE `customer` AUTO_INCREMENT = 1 It may also be a better idea to use something like the customer email address as their account manager login instead of their account number... this is something to think about for future versions. Paul On 9/23/07, AJ Becker [EMAIL PROTECTED] wrote: only reason i wanted to do this was for users to be able to log into there accounts. Im not fond of low 2-3 digit account numbers to start.. makes it look like you have no customer base. plus its another number they have to remember to get to there account. - Original Message - From: Paul Yasi [EMAIL PROTECTED] To: For users of CitrusDB discussion citrusdb-users@lists.sourceforge.net Sent: Sunday, September 23, 2007 9:41 AM Subject: Re: [Citrusdb-users] (no subject) It is not possible for citrus to change a customer's account number. Keeping the account number the same all the time is very important since it connects the customer with all their information. I would not use a phone number as their customer number, the customer may move and get a new phone number, or in a super rare case that number may be assigned to someone else. You can still search by their phone number, and upon a match it will take you right to that record. Paul On 9/23/07, AJ Becker [EMAIL PROTECTED] wrote: is it possible to change a customers customer number ? Would like to use there phone number as their customer number. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users -- The CitrusDB Project | http://www.citrusdb.org Open Source Customer Care Billing System - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users -- The CitrusDB Project | http://www.citrusdb.org Open Source Customer Care Billing System - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio
Re: [Citrusdb-users] (no subject)
It is not possible for citrus to change a customer's account number. Keeping the account number the same all the time is very important since it connects the customer with all their information. I would not use a phone number as their customer number, the customer may move and get a new phone number, or in a super rare case that number may be assigned to someone else. You can still search by their phone number, and upon a match it will take you right to that record. Paul On 9/23/07, AJ Becker [EMAIL PROTECTED] wrote: is it possible to change a customers customer number ? Would like to use there phone number as their customer number. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users -- The CitrusDB Project | http://www.citrusdb.org Open Source Customer Care Billing System - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
Re: [Citrusdb-users] (no subject)
only reason i wanted to do this was for users to be able to log into there accounts. Im not fond of low 2-3 digit account numbers to start.. makes it look like you have no customer base. plus its another number they have to remember to get to there account. - Original Message - From: Paul Yasi [EMAIL PROTECTED] To: For users of CitrusDB discussion citrusdb-users@lists.sourceforge.net Sent: Sunday, September 23, 2007 9:41 AM Subject: Re: [Citrusdb-users] (no subject) It is not possible for citrus to change a customer's account number. Keeping the account number the same all the time is very important since it connects the customer with all their information. I would not use a phone number as their customer number, the customer may move and get a new phone number, or in a super rare case that number may be assigned to someone else. You can still search by their phone number, and upon a match it will take you right to that record. Paul On 9/23/07, AJ Becker [EMAIL PROTECTED] wrote: is it possible to change a customers customer number ? Would like to use there phone number as their customer number. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users -- The CitrusDB Project | http://www.citrusdb.org Open Source Customer Care Billing System - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users