HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Configure Live Lookup in HelpSpot

#1

Hello

I’m trying to work out how to do the Live Lookup functionality in MYSQL.

Here’s what I’ve done so far,

  1. Downloaded the sample live_lookup_mysql.php file

  2. Put in the Host, User, Pswd & Databse Name.

  3. Put the file in the appropriate path - which is: http://192.168.1.22:81/helpspot/custom_code/live_lookup_mysql.php

  4. When I go into Create Request type in some name, and then click Live Lookup, nothing happens.

Am I missing something?


MYSQL%202

0 Likes

#2

Hello!
This is hard to test on our end since it’s using an internal IP address, however the best way to test it out is to hit that HTTP end point directly from within your HelpSpot server.

This will test that your HelpSpot instance can reach that HTTP end point, and also hopefully surface any errors in the script.

You may want to adjust the top of the script (after the opening tags <?php) as well to ensure PHP is reporting errors:

error_reporting(E_ALL);
init_set('display_errors', 1);

Are you using Windows or Linux?

In either case, try logging into your server where HelpSpot and making a web request to that LiveLookup end point. This will tell you if there is an issue reaching the script over HTTP.

On linux, you can make a curl request:

curl http://192.168.1.22:81/helpspot/custom_code/live_lookup_mysql.php

On windows you may just want to open IE and add that URL to the browser (again, from within the HelpSpot server) to see if it can reach it.

If it takes a long time / times out, then there’s likely an issue of the web request making requests over port 81, or an issue of that script making a connection to the server that is hosting MySQL.

0 Likes