Re: [SOGo] sogo-tool check-doubles don't use correct mysql password
On 10-11-12 7:07 AM, Alessio Fattorini wrote: Thanks but i don't speak about sogo user in passwd, but sogo user in mysql users table. What type of password have sogouser into this table? Fails this command: mysql://sogo:s...@127.0.0.1:3306/sogo/sogocristian001 sogo:sogo means user:pass, this credential are used for connect tu mysql. They are wrong in my case. Look at the entries in your sogo_folder_info vs. your database connection details in your .GNUstepDefaults. sogo-tool will use what's in sogo_folder_info to retrieve data (ie., connect remotely if needed, etc.). You likely changed over time the username/password/hostname in your .GNUstepDefaults and didn't adjust your sogo_folder_info appropriately. Fix your sogo_folder_info or adjust your MySQL permission so what's specified in there will work. Regards, -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-tool check-doubles don't use correct mysql password
Il 12/11/2010 13:18, Ludovic Marcotte ha scritto: On 10-11-12 7:07 AM, Alessio Fattorini wrote: Thanks but i don't speak about sogo user in passwd, but sogo user in mysql users table. What type of password have sogouser into this table? Fails this command: mysql://sogo:s...@127.0.0.1:3306/sogo/sogocristian001 sogo:sogo means user:pass, this credential are used for connect tu mysql. They are wrong in my case. Look at the entries in your sogo_folder_info vs. your database connection details in your .GNUstepDefaults. sogo-tool will use what's in sogo_folder_info to retrieve data (ie., connect remotely if needed, etc.). You likely changed over time the username/password/hostname in your .GNUstepDefaults and didn't adjust your sogo_folder_info appropriately. Fix your sogo_folder_info or adjust your MySQL permission so what's specified in there will work. You're right, as always ;-) I don't understand why I have this dirty situation, only for this user :-| Now I have clean this, Remove doubles works! like this examples: remove-doubles alessio C48738B0-B5B0-0001-A2E6-D62518001127 Removing 2 records... Removed 2 records from 4. Check doubles, don't check anything :-) [s...@sogo root]$ sogo-tool check-doubles The warning limit for folder records is set at 1000 Should I give attention to warning? I don't have folder more big then 1000 records... but I don't have results. -- Alessio Fattorini (alessio.fattor...@nethesis.it) nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU) tel. +39 0721 405516 - fax +39 0721 268147 www.nethesis.it - i...@nethesis.it -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-tool check-doubles don't use correct mysql password
Hi, On Fri, Nov 12, 2010 at 7:54 PM, Alessio Fattorini alessio.fattor...@nethesis.it wrote: You're right, as always ;-) I don't understand why I have this dirty situation, only for this user :-| So, what exactly had you done wrong ? Did you change the password for the sogo user in the db, and forgot to change that in the .GNUStepDefaults ? -- users@sogo.nu https://inverse.ca/sogo/lists