serial/SOA

[MOUCHONS]

Hello,

I want to change my SOA serial in date instead of timestamp.

I change the value in the base but the change is not apply in the secondary DNS.

I need to request a real change (for example a new A record) to see the change done.

So I have already test this plesk scripts :

#!/bin/sh

ADMIN_PASS=`cat /etc/psa/.psa.shadow`
MYSQL_BIN_D=`grep MYSQL_BIN_D /etc/psa/psa.conf | awk '{print $2}'`
PRODUCT_ROOT_D=`grep PRODUCT_ROOT_D /etc/psa/psa.conf | awk '{print $2}'`
mysql="${MYSQL_BIN_D}/mysql -N -uadmin -p${ADMIN_PASS} psa"

query="select name from domains;"
domains=`echo $query | $mysql `

for i in ${domains}; do
echo "echo $i"
$PRODUCT_ROOT_D/admin/sbin/dnsmng update $i
done



It seems that it doesnot work for this kind of change.

Can you advise me to have a solution to force the apply on the secondary dns without manual intervention on the plesk console management ?

Regards

 

[IgorG]

You should change serial in dns_zone table.

 

[MOUCHONS]

Hello,

Exact, I have make this command :

update dns_zone set serial_format='YYYYMMDDNN' where serial_format='UNIXTIMESTAMP';

But to apply the change on the secondary, plesk need some real change on the DNS control plesk interface.

So I have execute this request

insert into dns_recs (dns_zone_id, type, displayHost, host, displayVal, val, opt, time_stamp) select dns_zone_id,'TXT',CONCAT(name,'.'),CONCAT(name,'.'),'flag','flag','',now() from domains

to insert a record in all the domains on the server.

So no change, it seems that request the change from the interface done some supplementary operations.

Can you help me ?

Regards

 

[IgorG]

Look at option -soa-serial-format in http://download1.parallels.com/Plesk/PPP9/Doc/en-US/plesk-9.5-unix-cli/40730.htm