GST Submit with DSC Error [SOLVED]

Unable to connect to the installed EMSigner. Please close any other application running on following ports 8080, 1645, 1812, 2083 and restart your system, and try again.

Unable to connect to the installed EMSigner. Please close any other application running on following ports 8080, 1585, 1812, 2083 and restart your system, and try again.

If you are getting above error while submitting / verifying your GST application using DSC
then you are at right place.

I tried submitting using google chrome, Mozilla firefox even Internet Explorer but it failed.
Many blog posts suggests changing java settings, port settings even hosts settings.

But for layman and CA's the best possible way is to download and install UC Browser.
When I used this browser it worked like Charm.

Link - https://uc-browser.en.softonic.com/

ITS a FREE Browser.

Happy GST submitting.

IF Browsers were women

reference: sharenator

PHP Regular expressions tool

Regular expressions can be a pain. This tool is designed to help developers learn, practice, and compose regular expressions.


http://gethifi.com/regexp/

http://gethifi.com/regexp/

http://gethifi.com/regexp/

Mysql Timestamps

All that you want to know abouy MySQL timestamps is well documented here.

http://www.gizmola.com/blog/archives/93-Too-much-information-about-the-MySQL-TIMESTAMP.html

Twitter extensions

Twitter is on rage these days.
Twitters apps as firefox extensions just keeps on increasing

https://addons.mozilla.org/en-US/firefox/search?q=twitter&cat=all

MySql GROUP_CONCAT() tip

Recently I found myself into a silly problem because of misunderstaning / confusion relating to data type of variable set in SELECT commmand using GROUP_CONCAT()

I wanted to get all integer ids as comma separated string to be used in other update query

my query:

SELECT GROUP_CONCAT(spm_ids) INTO @csvIds FROM someTable WHERE is_active = 1;

Whenever my select executed correctly it gave e.g. '2,5,6' as a string and when it failed it gave me '0' as a string.

before updating I checked

IF @csvIds <> 0 THEN
// perform some update on some other table
END IF;


I changed to below and my Stored procedure worked perfectly fine.

IF @csvIds <> '0' THEN
// perform some update on some other table
END IF;

Some of mysql String comparison
> select if('2' <> 0, 1, 0)
> 1

> select if('0,2' <> 0, 1, 0) //my problematic condition
> 0

> select if('0' <> 0, 1, 0)
> 0

> select if('2,5,6' <> 0, 1, 0)
> 1





MySql tip 2:
If you are writing too many Stored Procedures(SP) and also including below code in your SPs

DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
SELECT 2 AS `error_code`, 'Fail to update ' AS `error_message` ;
END;

Then I would suggest that you first create your SP entirely run it many times under different conditions, if all working fine than include above code and test it again for failure.
This is because you will save some of your precious time by knowing exactly where the query failed.

Python Type Conversions

Function	Description
int(x [,base])	converts x to an integer
long(x [,base])	converts x to a long integer
float(x)	converts x to a floating-point number
complex(real [,imag])	creates a complex number
str(x)	converts x to a string representation
repr(x)	converts x to an expression string
eval(str)	evaluates str and returns an object
tuple(s)	converts a sequence object to a tuple
list(s)	converts a sequence object to a list
chr(x)	converts an integer to a character
unichr(x)	converts an integer to a Unicode character
ord(c)	converts a character to its integer value
hex(x)	converts an integer to a hexadecimal string
oct(x)	converts an integer to an octal string

Use:
totalRings = int(userInput)
//where totalRings and userInput are variables