[Vtigercrm-developers] Google oAuth 2.0 failing

Mike van Egmond mvanegmond at egmmedia.nl
Fri Feb 6 09:47:59 GMT 2015


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
> *****************************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150206/9278a637/attachment-0001.html>


More information about the vtigercrm-developers mailing list