The following nasty sql will create ptr records for your zone files from the ser subscriber table. It works on the assumption that all your usernames are only 4 characters long, and they are infact numeric...
select concat(reverse(insert(insert(insert(username, 4,0,'.'), 3,0,'.'), 2,0,'.')),'\tNAPTR\t100\t10\t"u"\t"E2U+sip"\t"!^\\+',username,'$!sip:',username,'@',domain,'!".') AS PTR from subscriber where username REGEXP '^[0-9]...$';
If any one knows how (in sql) the hell I can put a '.' between every character of a mysql result when the data length is variable then I'd like to know :)
Regards, -Jev
Hi,
is there a guy who could help to solve this problem:
Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /iptel/phplib/db_mysql.inc on line 73
Thanks