WHMCS API problem

[mdkhost]

i want to setup whmcs api access , but not in the admin panel , i want it with mysql

i insert IP into the database

INSERT INTO `tblconfiguration` (setting,value) VALUES ("APIAllowedIPs","xxx.xxx.xxx.xxx")

what else do i have to insert?

thnx in advance

[Chrisw]

This is not a WHMCS API or even WHMCS related. This is a general mysql issue. Read the value and send it back with the new IP appended.

 

Here is some examples:

 

 

mysql> select value FROM `tblconfiguration` WHERE `setting` = 'APIAllowedIPs';

+---------------------------------------+

| value |

+---------------------------------------+

| 192.168.1.1

192.168.1.2

192.168.1.3 |

+---------------------------------------+

1 row in set (0.00 sec)

 

mysql> UPDATE tblconfiguration SET `value`='192.168.1.1\r\n192.168.1.2\r\n192.168.1.3\r\n192.168.1.4' WHERE setting='APIAllowedIPs';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

 

mysql> select value FROM `tblconfiguration` WHERE `setting` = 'APIAllowedIPs';

+----------------------------------------------------+

| value |

+----------------------------------------------------+

| 192.168.1.1

192.168.1.2

192.168.1.3

192.168.1.4 |

+----------------------------------------------------+

1 row in set (0.00 sec)

 

mysql>

[mdkhost]

nope , i have again this error : The following error occured: Invalid IP xxx.xxx.xxx.xxx

[openmind]

Then the IP you are connecting from to the API is incorrect.

[laszlof]

Why are you trying to insert this manually anyways? Theres a field for it within Setup -> General Settings -> Security