Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-users digest..."
Today's Topics:
1. error during bind export (Benjamin Ellenbeck)
2. Re: error during bind export (Matej Vadnjal)
3. Re: error during bind export (Benjamin Ellenbeck)
----------------------------------------------------------------------
Message: 1
Date: Fri, 08 Nov 2013 10:50:55 +0100
From: Benjamin Ellenbeck <[email protected]>
Subject: [Netdot-users] error during bind export
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset="iso-8859-15"
Dear Netdot-users,
we used to export our zones for bind with netdot but today a new error
occured.
Any idea to solve this problem?
Exporter Output:
ERROR - Transaction aborted: DBD::mysql::db selectall_arrayref failed:
Incorrect key file for table '/tmp/#sql_c47_0.MYI'; try to repair it
[for Statement "SELECT rr.name, zone.name, aip.version, aip.address,
rrtxt.txtdata, rrhinfo.cpu, rrhinfo.os, ..........
Atteched you'll find the complete output.
best regards,
benjamin ellenbeck
-------------- next part --------------
Exporter Output:
ERROR - Transaction aborted: DBD::mysql::db selectall_arrayref failed:
Incorrect key file for table '/tmp/#sql_c47_0.MYI'; try to repair it [for
Statement "SELECT rr.name, zone.name, aip.version, aip.address,
rrtxt.txtdata, rrhinfo.cpu, rrhinfo.os,
rrptr.ptrdname, rrns.nsdname, rrmx.preference,
rrmx.exchange, rrcname.cname, rrloc.id,
rrsrv.id, rrnaptr.id, rrds.algorithm, rrds.key_tag,
rrds.digest_type, rrds.digest, rr.active,
rraddr.ttl, rrtxt.ttl, rrhinfo.ttl, rrns.ttl, rrds.ttl,
rrmx.ttl, rrcname.ttl, rrptr.ttl
FROM zone, rr
LEFT OUTER JOIN (ipblock aip CROSS JOIN rraddr) ON
(rr.id=rraddr.rr AND aip.id=rraddr.ipblock)
LEFT OUTER JOIN (ipblock pip CROSS JOIN rrptr) ON
(rr.id=rrptr.rr AND pip.id=rrptr.ipblock)
LEFT OUTER JOIN rrtxt ON rr.id=rrtxt.rr
LEFT OUTER JOIN rrhinfo ON rr.id=rrhinfo.rr
LEFT OUTER JOIN rrns ON rr.id=rrns.rr
LEFT OUTER JOIN rrds ON rr.id=rrds.rr
LEFT OUTER JOIN rrmx ON rr.id=rrmx.rr
LEFT OUTER JOIN rrcname ON rr.id=rrcname.rr
LEFT OUTER JOIN rrnaptr ON rr.id=rrnaptr.rr
LEFT OUTER JOIN rrsrv ON rr.id=rrsrv.rr
LEFT OUTER JOIN rrloc ON rr.id=rrloc.rr
WHERE rr.zone=zone.id AND zone.id=3
ORDER BY pip.address,rr.name"] at
/usr/local/netdot/lib/Netdot/Model/Zone.pm line 519.
Stack:
[/usr/local/netdot/lib/Netdot/Model/Zone.pm:519]
[/usr/local/netdot/lib/Netdot/Exporter/BIND.pm:142]
[/usr/local/netdot/lib/Netdot/Exporter/BIND.pm:93]
[/usr/local/netdot/lib/Netdot/Model.pm:746]
[/usr/local/netdot/lib/Netdot/Exporter/BIND.pm:105]
[/usr/local/netdot/htdocs/export/config_tasks.html:144]
[/usr/local/netdot/htdocs/export/autohandler:64]
[/usr/share/perl5/HTML/Mason/Request.pm:948]
[/usr/local/netdot/htdocs/masondata/obj/1249759374/export/autohandler.obj:21]
[/usr/local/netdot/htdocs/autohandler:76]
Trace begun at /usr/local/netdot/lib/Netdot.pm line 105
Netdot::throw_fatal('Netdot::Model', 'Transaction aborted: DBD::mysql::db
selectall_arrayref failed: Incorrect key file for table
\'/tmp/#sql_c47_0.MYI\'; try to repair it [for Statement "SELECT rr.name,
zone.name, aip.version, aip.address, rrtxt.txtdata, rrhinfo.cpu, rrhinfo.os,^J
rrptr.ptrdname, rrns.nsdname, rrmx.preference,
rrmx.exchange, rrcname.cname, rrloc.id, ^J rrsrv.id,
rrnaptr.id, rrds.algorithm, rrds.key_tag, rrds.digest_type, rrds.digest,
rr.active,^J rraddr.ttl, rrtxt.ttl, rrhinfo.ttl, rrns.ttl,
rrds.ttl, rrmx.ttl, rrcname.ttl, rrptr.ttl^J FROM zone, rr^J
LEFT OUTER JOIN (ipblock aip CROSS JOIN rraddr) ON
(rr.id=rraddr.rr AND aip.id=rraddr.ipblock)^J LEFT OUTER
JOIN (ipblock pip CROSS JOIN rrptr) ON (rr.id=rrptr.rr AND
pip.id=rrptr.ipblock)^J LEFT OUTER JOIN rrtxt ON
rr.id=rrtxt.rr^J LEFT OUTER !
JOIN rrhinfo ON rr.id=rrhinfo.rr^J LEFT OUTER JOIN rrns
ON rr.id=rrns.rr^J LEFT OUTER JOIN rrds ON
rr.id=rrds.rr^J LEFT OUTER JOIN rrmx ON rr.id=rrmx.rr^J
LEFT OUTER JOIN rrcname ON rr.id=rrcname.rr^J
LEFT OUTER JOIN rrnaptr ON rr.id=rrnaptr.rr^J LEFT
OUTER JOIN rrsrv ON rr.id=rrsrv.rr^J LEFT OUTER JOIN
rrloc ON rr.id=rrloc.rr^J WHERE rr.zone=zone.id AND
zone.id=3^J^I ORDER BY pip.address,rr.name"] at
/usr/local/netdot/lib/Netdot/Model/Zone.pm line 519.^J^JStack:^J
[/usr/local/netdot/lib/Netdot/Model/Zone.pm:519]^J
[/usr/local/netdot/lib/Netdot/Exporter/BIND.pm:142]^J
[/usr/local/netdot/lib/Netdot/Exporter/BIND.pm:93]^J
[/usr/local/netdot/lib/Netdot/Model.pm:746]^J
[/usr/local/netdot/lib/Netdot/Exporter/BIND.pm:105]^J
[/usr/local/netdot/htdocs/export/config_tasks.html:144]^J [/usr/local/netd!
ot/htdocs/export/autohandler:64]^J [/usr/share/perl5/HTML/Mason/Reque
st.pm:948]^J
[/usr/local/netdot/htdocs/masondata/obj/1249759374/export/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J') called at
/usr/local/netdot/lib/Netdot/Model.pm line 766
Netdot::Model::do_transaction('Netdot::Model', 'CODE(0x7fc5b9417640)') called
at /usr/local/netdot/lib/Netdot/Exporter/BIND.pm line 105
eval {...} at /usr/local/netdot/lib/Netdot/Exporter/BIND.pm line 89
Netdot::Exporter::BIND::generate_configs('Netdot::Exporter::BIND=HASH(0x7fc5b941df78)',
'zone_ids', 'ARRAY(0x7fc5bd4e2ca0)', 'nopriv', 1) called at
/usr/local/netdot/htdocs/export/config_tasks.html line 144
eval {...} at /usr/local/netdot/htdocs/export/config_tasks.html line 142
HTML::Mason::Commands::__ANON__('bind_no_priv', 'on', 'submit', 'Export',
'config_types', 'BIND', 'zones', 'ARRAY(0x7fc5bd5a5ee8)', 'showheader', 1)
called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fc5bcbe2180)',
'bind_no_priv', 'on', 'submit', 'Export', 'config_types', 'BIND', 'zones',
'ARRAY(0x7fc5bd5a5ee8)', 'showheader', 1) called at
/usr/share/perl5/HTML/Mason/Request.pm line 1302
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'bind_no_priv', 'on', 'submit',
'Export', 'config_types', 'BIND', 'zones', 'ARRAY(0x7fc5bd5a5ee8)',
'showheader', 1) called at /usr/share/perl5/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7fc5bcdc8f38)')
called at /usr/local/netdot/htdocs/export/autohandler line 64
HTML::Mason::Commands::__ANON__('bind_no_priv', 'on', 'submit', 'Export',
'config_types', 'BIND', 'zones', 'ARRAY(0x7fc5bd5a5ee8)', 'showheader', 1)
called at /usr/share/perl5/HTML/Mason/Component.pm line 157
HTML::Mason::Component::run_dynamic_sub('HTML::Mason::Component::FileBased=HASH(0x7fc5bceecf28)',
'main', 'bind_no_priv', 'on', 'submit', 'Export', 'config_types', 'BIND',
'zones', 'ARRAY(0x7fc5bd5a5ee8)', 'showheader', 1) called at
/usr/share/perl5/HTML/Mason/Request.pm line 948
HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=HASH(0x7fc5bcdc8f38)',
'main', 'bind_no_priv', 'on', 'submit', 'Export', 'config_types', 'BIND',
'zones', 'ARRAY(0x7fc5bd5a5ee8)', 'showheader', 1) called at
/usr/local/netdot/htdocs/masondata/obj/1249759374/export/autohandler.obj line 21
HTML::Mason::Commands::__ANON__('bind_no_priv', 'on', 'submit', 'Export',
'config_types', 'BIND', 'zones', 'ARRAY(0x7fc5bd5a5ee8)', 'showheader', 1)
called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fc5bceecf28)',
'bind_no_priv', 'on', 'submit', 'Export', 'config_types', 'BIND', 'zones',
'ARRAY(0x7fc5bd5a5ee8)', 'showheader', 1) called at
/usr/share/perl5/HTML/Mason/Request.pm line 1302
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'bind_no_priv', 'on', 'submit',
'Export', 'config_types', 'BIND', 'zones', 'ARRAY(0x7fc5bd5a5ee8)',
'showheader', 1) called at /usr/share/perl5/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7fc5bcdc8f38)',
'showheader', 1) called at /usr/local/netdot/htdocs/autohandler line 76
HTML::Mason::Commands::__ANON__('bind_no_priv', 'on', 'submit', 'Export',
'config_types', 'BIND', 'zones', 'ARRAY(0x7fc5bd5a5ee8)') called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fc5bd471ed8)',
'bind_no_priv', 'on', 'submit', 'Export', 'config_types', 'BIND', 'zones',
'ARRAY(0x7fc5bd5a5ee8)') called at /usr/share/perl5/HTML/Mason/Request.pm line
1297
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'bind_no_priv', 'on', 'submit',
'Export', 'config_types', 'BIND', 'zones', 'ARRAY(0x7fc5bd5a5ee8)') called at
/usr/share/perl5/HTML/Mason/Request.pm line 481
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 481
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7fc5bcdc8f38)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7fc5bcdc8f38)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7fc5b963b450)',
'Apache2::RequestRec=SCALAR(0x7fc5bcdbee18)') called at
/usr/local/netdot/lib/Netdot/Mason.pm line 59
Netdot::Mason::handler('Apache2::RequestRec=SCALAR(0x7fc5bcdbee18)') called at
-e line 0
eval {...} at -e line 0
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5068 bytes
Desc: S/MIME Cryptographic Signature
Url :
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20131108/b543f62a/attachment-0001.bin
------------------------------
Message: 2
Date: Fri, 08 Nov 2013 14:21:45 +0100
From: Matej Vadnjal <[email protected]>
Subject: Re: [Netdot-users] error during bind export
To: Benjamin Ellenbeck <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset="iso-8859-1"
Hi Benjamin
I had this error when my drive was full.
Kind regards
Matej Vadnjal
On 11/08/2013 10:50 AM, Benjamin Ellenbeck wrote:
> Dear Netdot-users,
>
> we used to export our zones for bind with netdot but today a new error
> occured.
>
> Any idea to solve this problem?
>
>
> Exporter Output:
>
> ERROR - Transaction aborted: DBD::mysql::db selectall_arrayref failed:
> Incorrect key file for table '/tmp/#sql_c47_0.MYI'; try to repair it
> [for Statement "SELECT rr.name, zone.name, aip.version, aip.address,
> rrtxt.txtdata, rrhinfo.cpu, rrhinfo.os, ..........
>
>
>
> Atteched you'll find the complete output.
>
>
>
>
> best regards,
> benjamin ellenbeck
>
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20131108/914febf1/attachment-0001.html
------------------------------
Message: 3
Date: Fri, 08 Nov 2013 19:32:16 +0100
From: Benjamin Ellenbeck <[email protected]>
Subject: Re: [Netdot-users] error during bind export
To: Matej Vadnjal <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hi Matej,
thanks for your response. Yes, that was the problem !
I'm executing following command but the database isn't getting thinner:
./prune_db.pl -F -A -M -a -t -d 30 -g
What's going wrong?
best regards,
benjamin ellenbeck
Am 08/11/2013 14:21, schrieb Matej Vadnjal:
> Hi Benjamin
>
> I had this error when my drive was full.
>
> Kind regards
> Matej Vadnjal
>
>
> On 11/08/2013 10:50 AM, Benjamin Ellenbeck wrote:
>> Dear Netdot-users,
>>
>> we used to export our zones for bind with netdot but today a new error
>> occured.
>>
>> Any idea to solve this problem?
>>
>>
>> Exporter Output:
>>
>> ERROR - Transaction aborted: DBD::mysql::db selectall_arrayref failed:
>> Incorrect key file for table '/tmp/#sql_c47_0.MYI'; try to repair it
>> [for Statement "SELECT rr.name, zone.name, aip.version, aip.address,
>> rrtxt.txtdata, rrhinfo.cpu, rrhinfo.os, ..........
>>
>>
>>
>> Atteched you'll find the complete output.
>>
>>
>>
>>
>> best regards,
>> benjamin ellenbeck
>>
>>
>> _______________________________________________
>> Netdot-users mailing list
>> [email protected]
>> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 60, Issue 2
*******************************************
