I just checked the code. It worked! From a CLI, run a live log ( asterisk -cvvvvvvr)
Then make a test call, post everything from the point where it asks for your "PIN NUMBER"
Here is what my log looks like for my test call
-- Goto (customerlookup,s,1)
-- Executing [s@customerlookup:1] Answer("SIP/1000-00000055", "") in new stack
-- Executing [s@customerlookup:2] Playback("SIP/1000-00000055", "please-enter-your&pin_number") in new stack
-- <SIP/1000-00000055> Playing 'please-enter-your.gsm' (language 'en')
-- <SIP/1000-00000055> Playing 'pin_number.gsm' (language 'en')
-- Executing [s@customerlookup:3] Read("SIP/1000-00000055", "pinnumber,then-press-pound,4,,1,10") in new stack
-- Accepting a maximum of 4 digits.
-- <SIP/1000-00000055> Playing 'then-press-pound.gsm' (language 'en')
-- User entered '4123'
-- Executing [s@customerlookup:4] MYSQL("SIP/1000-00000055", "Connect connid localhost root P8X2050 customerinfo") in new stack
-- Executing [s@customerlookup:5] MYSQL("SIP/1000-00000055", "Query resultid 33 SELECT name from account where id=4123") in new stack
-- Executing [s@customerlookup:6] MYSQL("SIP/1000-00000055", "Fetch fetchid 34 accountname") in new stack
-- Executing [s@customerlookup:7] MYSQL("SIP/1000-00000055", "Disconnect 33") in new stack
-- Executing [s@customerlookup:8] NoOp("SIP/1000-00000055", "&& the value found is Jane Doe ") in new stack
-- Executing [s@customerlookup:9] ExecIf("SIP/1000-00000055", "0?playback(hangup-try-again)") in new stack
-- Executing [s@customerlookup:10] ExecIf("SIP/1000-00000055", "0?HANGUP()") in new stack
-- Executing [s@customerlookup:11] Playback("SIP/1000-00000055", "auth-thankyou") in new stack
-- <SIP/1000-00000055> Playing 'auth-thankyou.gsm' (language 'en')
-- Executing [s@customerlookup:12] Hangup("SIP/1000-00000055", "") in new stack
== Spawn extension (customerlookup, s, 12) exited non-zero on 'SIP/1000-00000055'
issabel*CLI>
Make a test call and then try. If you can post a copy of your log file, that would help a lot to diagnose what is wrong.