[Vtigercrm-developers] Google oAuth 2.0 failing

Uma S uma.s at vtiger.com
Fri Feb 6 11:13:51 GMT 2015


Hi,

Thanks! for your detail explanation about the issue you are facing.

There is a problem with redirect uri's you have placed as below

https://crm.domain.com/index.php?module=Google&view=List&operation=sync&sourcemodule=Calendar&service=GoogleCalendar
https://crm.domain.com/index.php?module=Google&view=List&operation=sync&sourcemodule=Calendar&service=GoogleContacts

Both of the above url's say sourcemodule value as Calendar instead of
Contacts, Please check the trac
<http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8354> ticket for
clarification.

You are facing this below error with respect to calendar sync

*When I press Calendar sync in vTiger it only gives me this;*

*Error: invalid_client*

*no support email*

Please check Consent screen option under API's & auth to check whether
EMAIL ADDRESS has been selected.



On Fri, Feb 6, 2015 at 3:17 PM, Mike van Egmond <mvanegmond at egmmedia.nl>
wrote:

> Hi Guys,
>
> I'm trying to get the oAuth 2.0 to work with vTiger Google Calender &
> Contact Sync.
>
> 1. Create new app for vTiger in Google
> 2. Enabled APIs for Contact & Calendar
> 3. Generated Credentials and followed the instructions in
> http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8354 to setup the redirect
> URLs as following;
>
>
> https://crm.domain.com/index.php?module=Google&view=List&operation=sync&sourcemodule=Calendar&service=GoogleCalendar
>
> https://crm.domain.com/index.php?module=Google&view=List&operation=sync&sourcemodule=Calendar&service=GoogleContacts
>
> 4. Entered clientid & clientsecret in modules/Google/connectors/Config.php
>
> Now this should work, but all I am getting is this when pressing Google
> Contact sync;
>
> *Error: redirect_uri_mismatch*
>
> The redirect URI in the request:
> https://crm.domain.com/index.php?module=Google&view=List&operation=sync&sourcemodule=Contacts&service=GoogleContacts
> did not match a registered redirect URI.
>
> Request details;
>
>    - scope=https://www.google.com/m8/feeds
>    - response_type=code
>    - access_type=offline
>    - redirect_uri=
>    https://crm.domain.com/index.php?module=Google&view=List&operation=sync&sourcemodule=Contacts&service=GoogleContacts
>    - approval_prompt=force
>    -
>    client_id=68016783142-ina85euuik9sqoh21et65u0lbeh5j0fs.apps.googleuserconten
>
>
> When I press Calendar sync in vTiger it only gives me this;
>
> *Error: invalid_client*
>
> no support email
>
> Hope one of you can help me out here!
>
> Kind regards,
>
> Mike
>
> 2015-02-05 17:43 GMT+01:00 <
> vtigercrm-developers-request at lists.vtigercrm.com>:
>
>> Send vtigercrm-developers mailing list submissions to
>>         vtigercrm-developers at lists.vtigercrm.com
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>>
>> http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers
>>
>> or, via email, send a message with subject or body 'help' to
>>         vtigercrm-developers-request at lists.vtigercrm.com
>>
>> You can reach the person managing the list at
>>         vtigercrm-developers-owner at lists.vtigercrm.com
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of vtigercrm-developers digest..."
>>
>>
>> Today's Topics:
>>
>>    1. Updating "Chosen" Selects using jQuery? (Alan Lord)
>>    2. forgot password link has hard coded from  address (Alan Bell)
>>    3. Re: Updating "Chosen" Selects using jQuery?       [Solved] (Alan
>> Lord)
>>    4. Re: Updating "Chosen" Selects using jQuery?       [Solved]
>>       (socialboostdk)
>>    5. Error w. picklists (socialboostdk)
>>    6. Re: Access quote lineitems from custom module (lajeesh k)
>>    7. Database schema (Phasaphon Kwanrutai)
>>    8. Re: Access quote lineitems from custom module (Alan Lord)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Thu, 05 Feb 2015 13:50:47 +0000
>> From: Alan Lord <alanslists at gmail.com>
>> To: vtigercrm-developers at lists.vtigercrm.com
>> Subject: [Vtigercrm-developers] Updating "Chosen" Selects using
>>         jQuery?
>> Message-ID: <mavsfn$lp6$1 at ger.gmane.org>
>> Content-Type: text/plain; charset=utf-8; format=flowed
>>
>> I have a small customisation to perform a lookup and update various
>> fields in a module based on the value selected by the user.
>>
>> Using jQuery.val(newValue) works for inputs and text boxes, but is not
>> working for Selects.
>>
>> I am selecting the element via it's "name" property in the form object.
>>
>> What do I need to do to update the UI so the Select box shows the change
>> to the user?
>>
>> I found this online:
>>
>> > $("#form_field").trigger("chosen:updated");
>>
>> from http://harvesthq.github.io/chosen/ but this doesn;t seem to have
>> helped at all.
>>
>> Thanks
>>
>> Al
>>
>>
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Thu, 05 Feb 2015 14:06:21 +0000
>> From: Alan Bell <alan.bell at libertus.co.uk>
>> To: vtigercrm-developers at lists.vtigercrm.com
>> Subject: [Vtigercrm-developers] forgot password link has hard coded
>>         from    address
>> Message-ID: <54D378DD.4070405 at libertus.co.uk>
>> Content-Type: text/plain; charset=utf-8; format=flowed
>>
>> in forgotPassword.php around line 48 the mail for a forgotton password
>> is hard coded with a from address of support at vtiger.com
>> This means that if you are using Amazon SMTP (or any other server that
>> is a bit strict about from addresses) for your outgoing mail server you
>> get a mail server not configure error reported, and in the log you get:
>>
>>
>> Thu Feb  5 13:55:07 2015,142 [21421] DEBUG VT - Error in Mail Sending :
>> Error log = 'SMTP Error: Data not accepted.<p>SMTP server error: Message
>> rejected: Email address is not verified.
>> </p>
>> which is Amazon error 554 Message rejected: Email address is not verified
>>
>>
>> http://docs.aws.amazon.com/ses/latest/DeveloperGuide/smtp-response-codes.html
>>
>>
>> this should use the email address configured for the outgoing server.
>>
>>
>> ------------------------------
>>
>> Message: 3
>> Date: Thu, 05 Feb 2015 14:21:56 +0000
>> From: Alan Lord <alanslists at gmail.com>
>> To: vtigercrm-developers at lists.vtigercrm.com
>> Subject: Re: [Vtigercrm-developers] Updating "Chosen" Selects using
>>         jQuery? [Solved]
>> Message-ID: <mavua5$m8i$1 at ger.gmane.org>
>> Content-Type: text/plain; charset=windows-1252; format=flowed
>>
>> On 05/02/15 13:50, Alan Lord wrote:
>> >
>> >> $("#form_field").trigger("chosen:updated");
>>
>> Worked it out in the end... vtiger is using an older version of Chosen
>> and requires the "liszt:updated" syntax.
>>
>> HTH
>>
>> Al
>>
>>
>>
>> ------------------------------
>>
>> Message: 4
>> Date: Thu, 5 Feb 2015 15:28:39 +0100
>> From: socialboostdk <socialboostdk at gmail.com>
>> To: "vtigercrm-developers at lists.vtigercrm.com"
>>         <vtigercrm-developers at lists.vtigercrm.com>
>> Subject: Re: [Vtigercrm-developers] Updating "Chosen" Selects using
>>         jQuery? [Solved]
>> Message-ID:
>>         <
>> CACQ7aj_81M-CsPtX6RV8pw_Ths69WbSNO4R4oFo5t5XazooqTg at mail.gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> *Yes - BTW: *
>>
>> Why dont "we" update to latest version of chosen?
>>
>> Its much better, retina-support, etc?
>>
>> :)
>>
>> On 5 February 2015 at 15:21, Alan Lord <alanslists at gmail.com> wrote:
>>
>> > On 05/02/15 13:50, Alan Lord wrote:
>> >
>> >>
>> >>  $("#form_field").trigger("chosen:updated");
>> >>>
>> >>
>> > Worked it out in the end... vtiger is using an older version of Chosen
>> and
>> > requires the "liszt:updated" syntax.
>> >
>> > HTH
>> >
>> > Al
>> >
>> > _______________________________________________
>> > http://www.vtiger.com/
>> >
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150205/73f2eecd/attachment-0001.html
>> >
>>
>> ------------------------------
>>
>> Message: 5
>> Date: Thu, 5 Feb 2015 15:56:44 +0100
>> From: socialboostdk <socialboostdk at gmail.com>
>> To: "vtigercrm-developers at lists.vtigercrm.com"
>>         <vtigercrm-developers at lists.vtigercrm.com>
>> Subject: [Vtigercrm-developers] Error w. picklists
>> Message-ID:
>>         <
>> CACQ7aj_iYaG_pNCA51fHGx5ZyN9dO2miPF-s6pW8xD+mph4ZDw at mail.gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> Hi there Uma & co :)
>>
>> I've found a small bug w. picklists.
>>
>> Ie. normally, when adding a picklist its not possible to include comma
>> (",") in the list, as this will trigger a new option in the picklist. Ie
>> "Somewhere, sometown, somecountry" becomes "Somewhere" + "sometown" +
>> "somecountry".
>>
>> But - if I add the picklist first, and then later under "picklisteditor"
>> add the values, then I CAN add a value like "Somewhere, sometown,
>> somecountry" , ie. make "Somewhere, sometown, somecountry" , "Otherewhere,
>> othertown, othercountry", etc.
>>
>> This kinda works :)
>>
>> But, then if i want to make picklist dependency - which is possible to set
>> up with the above values - then the acutal contents shown in the picklists
>> are not showing. Ie. the "dependant" picklist no 2 is not having the
>> values
>> shown in its drop-down.
>>
>> There are 3 options as I see it, in prioritized order:
>>
>> 1) Either this should be fixed so we can indeed use comma, which is
>> clearly
>> preferred. As a minimum this means fixing the picklist-dependancy setup,
>> so
>> this is robust. Perhaps even the "add-new-fields" option, while this is
>> not
>> a requirement.
>>
>> 2) There is perhaps a small loophole ie. a comma can be shown as two
>> different ascii-charcters (, vs ‚) -  dont know if this would
>> work?
>>
>> 3) Make it so that you cannot add comma under picklist-editor either, so
>> the picklist-dependancy setup is robust.
>>
>> :)
>>
>> Chris
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150205/240e23ef/attachment-0001.html
>> >
>>
>> ------------------------------
>>
>> Message: 6
>> Date: Thu, 5 Feb 2015 20:53:24 +0530
>> From: lajeesh k <lajeeshk at gmail.com>
>> To: vtigercrm-developers <vtigercrm-developers at lists.vtigercrm.com>
>> Subject: Re: [Vtigercrm-developers] Access quote lineitems from custom
>>         module
>> Message-ID:
>>         <CAA1bLmoELocWkrst8kjhSt0bHKryeV-3VZT39bu-=p7dhYc=
>> FQ at mail.gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> Use getAssociatedProducts function  in include/utils/EditViewUtils.php
>>
>> $focus = CRMEntity::getInstance($module);
>> $focus->id = $recordId;
>> $related_products = getAssociatedProducts($module,$focus);
>>
>>
>>
>>
>> Regards,
>> Lajeesh
>>
>> On Thu, Feb 5, 2015 at 3:53 PM, Uma S <uma.s at vtiger.com> wrote:
>>
>> > Hi,
>> >
>> > Using getProducts() api on Inventory record model, will get information
>> > regarding line-items linked with inventory modules (SalesOrder/ Quotes/
>> > Invoice/ PurchaseOrder).
>> >
>> > On Thu, Feb 5, 2015 at 1:11 PM, Alan Lord <alanslists at gmail.com> wrote:
>> >
>> >> On 04/02/15 22:22, Richard Hills - Technologywise wrote:
>> >>
>> >>> I am now doing this as follows:
>> >>>
>> >>>                  include_once 'modules/Quotes/QuotePDFController.php';
>> >>>>                 $controller = new
>> Vtiger_QuotePDFController('Quotes');
>> >>>> $controller->loadRecord(vtlib_purify($request->get('quote')));
>> >>>>                 foreach($controller->associated_products as
>> $lineitem)
>> >>>> ...
>> >>>>
>> >>> Happy to hear of any better methods.
>> >>>
>> >>
>> >> I haven't looked at the Quote/Inventory design but I would have thought
>> >> you should be simply getting the Record model for the
>> >> Quote/SalesOrder/Invoice. I would have assumed that the line item data
>> will
>> >> be present (or accessible) in the Record itself.
>> >>
>> >> HTH
>> >>
>> >> Al
>> >>
>> >>
>> >> _______________________________________________
>> >> http://www.vtiger.com/
>> >>
>> >
>> >
>> >
>> > --
>> > With
>> > Best Regards
>> > Uma.S
>> > Vtiger Team
>> >
>> > _______________________________________________
>> > http://www.vtiger.com/
>> >
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150205/2fa54c49/attachment-0001.html
>> >
>>
>> ------------------------------
>>
>> Message: 7
>> Date: Thu, 5 Feb 2015 23:34:45 +0700
>> From: Phasaphon Kwanrutai <sunkohchangresort at gmail.com>
>> To: vtigercrm-developers at lists.vtigercrm.com
>> Subject: [Vtigercrm-developers] Database schema
>> Message-ID:
>>         <
>> CAPAnwr4aKquuVqPGDKmLo_fEgpfyPXOFHpny+Y2n+BiDsP5HxQ at mail.gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> Hi, please help :-)
>> I need to update database schema to suit to v 6.2. i believe migration
>> wasn't successful 100% and to make it working I would like to update all
>> default fields and relations. I am very far from expertise in mysql
>> therefore I would like to ask you to help me in this case. Possibly some
>> script or command line tool?
>> OK, hope you can help somehow.
>>
>> Phasa
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150205/05943b28/attachment-0001.html
>> >
>>
>> ------------------------------
>>
>> Message: 8
>> Date: Thu, 05 Feb 2015 16:43:12 +0000
>> From: Alan Lord <alanslists at gmail.com>
>> To: vtigercrm-developers at lists.vtigercrm.com
>> Subject: Re: [Vtigercrm-developers] Access quote lineitems from custom
>>         module
>> Message-ID: <mb06j0$da1$1 at ger.gmane.org>
>> Content-Type: text/plain; charset=windows-1252; format=flowed
>>
>> On 05/02/15 15:23, lajeesh k wrote:
>> > Use getAssociatedProducts function  in include/utils/EditViewUtils.php
>> >
>> > $focus = CRMEntity::getInstance($module);
>> > $focus->id = $recordId;
>> > $related_products= getAssociatedProducts($module,$focus);
>>
>> Why?
>>
>> This is old code. Surely it is better and more "correct" now to use the
>> MVC pattern and use the Record model.
>>
>> In a Quote the Record model extends the Inventory Record model which
>> extends the Vtiger Record Model. In the Inventory Record model are all
>> the APIs required to retrieve the data in the correct format and with
>> the correct permissions.
>>
>> $recordModel = Vtiger_Record_Model::getInstanceById(crmid, 'Quotes');
>> $lineItems = $recordModel->getProducts();
>>
>> HTH
>>
>> Al
>>
>>
>>
>>
>> ------------------------------
>>
>> _______________________________________________
>> vtigercrm-developers mailing list
>> vtigercrm-developers at lists.vtigercrm.com
>> http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers
>>
>>
>> End of vtigercrm-developers Digest, Vol 109, Issue 27
>> *****************************************************
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>



-- 
With
Best Regards
Uma.S
Vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150206/db9b86ac/attachment-0001.html>


More information about the vtigercrm-developers mailing list