Re: failed to update my MySQL table through upgrading "complete.ini"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Your email does not contain any information about
what is actually wrong (logs). Also, try to post the whole
config (at least relevant Gatekeeper::Auth and Gatekeeper::Acct
sections).

----- Original Message ----- From: "Z.Farhan" <mailzafa@xxxxxxxxx>
Sent: Tuesday, May 10, 2005 10:33 AM



I am still failed to update my MySQL table through
upgrading "complete.ini" as follows.
what's the porblems here or I have to do more what?

[SQLConfig]
Driver=MySQL
Host=192.168.0.94:3306
Database=dialer
Username=root Password=


[SQLPasswordAuth]
Driver=MySQL
Host=192.168.0.94:3306
Database=dialer
Username=root
Password=
Table=pin
KeyField=balance
Query=SELECT pinnumber FROM pin WHERE pinnumber='%u'
CacheTimeout=30
MinPoolSize=5

[SQLAliasAuth]
Driver=MySQL
Host=192.168.0.94:3306
Database=dialer
Username=bdcom
Password=
Table=pin
Query=SELECT pinnumber FROM pin WHERE pinnumber='%u'
CacheTimeout=30
MinPoolSize=1


[SQLAuth] Driver=MySQL Host=192.168.0.94:3306 Database=dialer Username=bdcom Password= Table=pin RegQuery=SELECT pinnumber FROM pin WHERE pinnumber='%u' NbQuery=SELECT pinnumber FROM pin WHERE pinnumber='%u' CallQuery=SELECT pinnumber FROM pin WHERE pinnumber='%u' CacheTimeout=30 MinPoolSize=1



[SQLAcct]
Driver=MySQL
Host=192.168.0.94:3306
Database=dialer
Username=bdcom
Password=
MinPoolSize=5
StartQuery=INSERT INTO pin (pinnumber) VALUES ('%u')
UpdateQuery=UPDATE pin SET balance=200 WHERE pinnumber
= '%u' StopQuery=UPDATE pin SET balance=100 WHERE
pinnumber='%u'
TimestampFormat=MySQL



------------------------------------------------------- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click _______________________________________________________

Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/

[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux