Re: [Serusers] LCR Module Question

Juha,

Can the IP be stored as a character field rather than as an int?

Paul

On Thu, 17 Feb 2005 23:46:08 +0200, Juha Heinanen jh@lohi.tutpro.com wrote:

Richard writes:

...

When you create the table field, you can use attribute "unsigned".

sure and that is what gw table is using (ser_mysql.sh):

# # Table structure for table 'gw' #

CREATE TABLE gw ( gw_name VARCHAR(128) NOT NULL, ip_addr INT UNSIGNED NOT NULL, port SMALLINT UNSIGNED, grp_id INT UNSIGNED NOT NULL, PRIMARY KEY (gw_name), KEY (grp_id) ) $TABLE_TYPE;

the problem is that

VAL_INT(ROW_VALUES(row)

for ip_addr field produces wrong value if the first bit of the value in db is 1.

-- juha

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers