[racktables-users] Re: Copy Object Plugin install instructions
- From: Joshua Morales <Joshua.Morales@xxxxxxxxx>
- To: "racktables-users@xxxxxxxxxxxxx" <racktables-users@xxxxxxxxxxxxx>
- Date: Mon, 24 Nov 2014 16:41:20 +0000
That worked perfectly. It also worked on our production version 0.20.8. Our
test environment is running 0.20.7.
Once again, thank you for helping us out with this. It's going to save us from
having to do a lot of repetitive work.
Best regards
Josh
From: racktables-users-bounce@xxxxxxxxxxxxx
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Maximilian Mensing
Sent: Saturday, November 22, 2014 12:50 PM
To: racktables-users@xxxxxxxxxxxxx
Subject: [racktables-users] Re: Copy Object Plugin install instructions
Hi Joshua,
I forgot to include @historicbruno<https://github.com/historicbruno>'s patch
for everyone who's not using the link management plugin..
Please try this version:
https://github.com/madmax2012/racktables-contribs/blob/master/local_copy_object.php
It should work now :)
Cheers,
Max
Von: Joshua Morales <Joshua.Morales@xxxxxxxxx<mailto:Joshua.Morales@xxxxxxxxx>>
Antworten an:
"racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>"
<racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>>
Datum: Tuesday 18 November 2014 18:29
An: "racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>"
<racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>>
Betreff: [racktables-users] Re: Copy Object Plugin install instructions
Hi Max,
Disregard my last email....I created a local.php file in the plugins directory
and copied your code into it. The "Object Copier" tab was then exposed. I am
now getting a database error when I try to do a test copy.....am I missing
something?
[cid:image001.png@01D007C2.6A6CF600]
Pdo exception: PDOException
SQLSTATE[42S02]: Base table or view not found: 1146 Table
'racktables.LinkBackend' doesn't exist (42S02)
at file /www/html/racktables/inc/database.php, line 3845
/www/html/racktables/inc/database.php:3845 execute(Array
(
[0] => 348
)
)
/www/html/racktables/plugins/local.php:61 usePreparedSelectBlade('SELECT
Port.id,
Port.name,
Port.object_id,
Object.name AS object_name,
Port.l2address,
Port.label,
Port.reservation_comment,
Port.iif_id,
Port.type AS oif_id,
(SELECT PortInnerInterface.iif_name FROM PortInnerInterface WHERE
PortInnerInterface.id = Port.iif_id) AS iif_name,
(SELECT Dictionary.dict_value FROM Dictionary WHERE Dictionary.dict_key =
Port.type) AS oif_name,
IF(lba.porta, lba.cable, lbb.cable) AS cableid,
IF(lba.porta, pa.id, pb.id) AS remote_id,
IF(lba.porta, pa.name, pb.name) AS remote_name,
IF(lba.porta, pa.object_id, pb.object_id) AS remote_object_id,
IF(lba.porta, oa.name, ob.name) AS remote_object_name,
(SELECT COUNT(*) FROM PortLog WHERE PortLog.port_id = Port.id) AS log_count,
PortLog.user,
UNIX_TIMESTAMP(PortLog.date) as time
FROM
Port
INNER JOIN Object ON Port.object_id = Object.id
LEFT JOIN LinkBackend AS lba ON lba.porta = Port.id
LEFT JOIN Port AS pa ON pa.id = lba.portb
LEFT JOIN Object AS oa ON pa.object_id = oa.id
LEFT JOIN LinkBackend AS lbb on lbb.portb = Port.id
LEFT JOIN Port AS pb ON pb.id = lbb.porta
LEFT JOIN Object AS ob ON pb.object_id = ob.id
LEFT JOIN PortLog ON PortLog.id = (SELECT id FROM PortLog WHERE PortLog.port_id
= Port.id ORDER BY date DESC LIMIT 1)
WHERE
Port.object_id = ?', Array
(
[0] => 348
)
)
/www/html/racktables/plugins/local.php:22 fetchBackendPortList('Port.object_id
= ?', Array
(
[0] => 348
)
)
/www/html/racktables/plugins/local.php:15 getObjectBackendPortsAndLinks('348')
/www/html/racktables/plugins/local.php:132 amplifyCell_object_Backend_Port(Array
(
[realm] => object
[id] => 348
[name] => socctxpvs08
[label] =>
[asset_no] =>
[objtype_id] => 4
[rack_id] => 23
[container_id] =>
[container_name] =>
[container_objtype_id] =>
[has_problems] => no
[comment] =>
[nports] => 3
[8021q_domain_id] =>
[8021q_template_id] =>
[etags] => Array
(
[56] => Array
(
[id] => 56
[tag] => dl380 g8
[parent_id] => 26
[user] => admin
[time] => 1400024680
)
)
[itags] => Array
(
[26] => Array
(
[id] => 26
[is_assignable] => yes
[tag] => server
[parent_id] =>
[refcnt] => Array
(
[total] => 1
[object] => 1
)
[trace] => Array
(
)
)
)
[dname] => socctxpvs08
[atags] => Array
(
[0] => Array
(
[tag] => $id_348
)
[1] => Array
(
[tag] => $typeid_4
)
[2] => Array
(
[tag] => $any_object
)
[3] => Array
(
[tag] => $cn_socctxpvs08
)
[4] => Array
(
[tag] => $no_asset_tag
)
[5] => Array
(
[tag] => $attr_10006_50023
)
[6] => Array
(
[tag] => $attr_10079_1500
)
[7] => Array
(
[tag] => $attr_10013_50060
)
[8] => Array
(
[tag] => $attr_10051_1500
)
[9] => Array
(
[tag] => $attr_10004_50019
)
[10] => Array
(
[tag] => $attr_10049_50196
)
[11] => Array
(
[tag] => $attr_10048_50194
)
[12] => Array
(
[tag] => $attr_2_105
)
[13] => Array
(
[tag] => $attr_26_1500
)
[14] => Array
(
[tag] => $attr_10021_50150
)
[15] => Array
(
[tag] => $attr_10068_50241
)
[16] => Array
(
[tag] => $attr_10005_50018
)
[17] => Array
(
[tag] => $attr_10016_50106
)
[18] => Array
(
[tag] => $attr_10023_50174
)
[19] => Array
(
[tag] => $attr_10000_50005
)
[20] => Array
(
[tag] => $attr_10022_50153
)
[21] => Array
(
[tag] => $attr_10001_50009
)
[22] => Array
(
[tag] => $attr_10050_50201
)
[23] => Array
(
[tag] => $attr_10071_50245
)
[24] => Array
(
[tag] => $attr_4_1812
)
)
[ports] => Array
(
[0] => Array
(
[id] => 201
[name] => ILO
[object_id] => 348
[object_name] => socctxpvs08
[l2address] => B4:B5:2F:ED:0D:54
[label] => 172.16.39.3
[reservation_comment] =>
[iif_id] => 1
[oif_id] => 19
[iif_name] => hardwired
[oif_name] => 100Base-TX
[cableid] =>
[remote_id] =>
[remote_name] =>
[remote_object_id] =>
[remote_object_name] =>
[log_count] => 0
[linked] => 0
[last_log] => Array
(
)
)
[1] => Array
(
[id] => 202
[name] => NIC0
[object_id] => 348
[object_name] => socctxpvs08
[l2address] =>
[label] =>
[reservation_comment] =>
[iif_id] => 1
[oif_id] => 24
[iif_name] => hardwired
[oif_name] => 1000Base-T
[cableid] =>
[remote_id] =>
[remote_name] =>
[remote_object_id] =>
[remote_object_name] =>
[log_count] => 0
[linked] => 0
[last_log] => Array
(
)
)
[2] => Array
(
[id] => 203
[name] => NIC1
[object_id] => 348
[object_name] => socctxpvs08
[l2address] =>
[label] =>
[reservation_comment] =>
[iif_id] => 1
[oif_id] => 24
[iif_name] => hardwired
[oif_name] => 1000Base-T
[cableid] =>
[remote_id] =>
[remote_name] =>
[remote_object_id] =>
[remote_object_name] =>
[log_count] => 0
[linked] => 0
[last_log] => Array
(
)
)
)
[ipv4] => Array
(
)
[ipv6] => Array
(
)
[nat4] => Array
(
[out] => Array
(
)
[in] => Array
(
)
)
[files] => Array
(
)
)
)
copyLotOfObjects()
/www/html/racktables/index.php:235 call_user_func('copyLotOfObjects')
Error info:
Array
(
[0] => 42S02
[1] => 1146
[2] => Table 'racktables.LinkBackend' doesn't exist
)
Parameters:
GET
module
redirect
page
object
tab
objectcopier
op
copyLotOfObjects
POST
object_id
348
namelist
testcopy1 testcopy2 testcopy3
global_type_id
4
taglist
got_very_fast_data
Go!
COOKIE
_ga
GA1.2.279975318.1408647524
__utma
187029111.279975318.1408647524.1408647524.1414696902.2
__utmz
187029111.1414696902.2.2.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=(not
provided)
__insp_slim
1414696915205
__insp_nv
true
__insp_ref
aHR0cDovL3d3dy5nb29nbGUuY29tL3VybD9zYT10JnJjdD1qJnE9JmVzcmM9cyZzb3VyY2U9d2ViJmNkPTEmdmVkPTBDQ0FRRmp...
__insp_norec_sess
true
__insp_wid
73322007
PHPSESSID
185ruloe3fpvtk785tltolssh7
From:
racktables-users-bounce@xxxxxxxxxxxxx<mailto:racktables-users-bounce@xxxxxxxxxxxxx>
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Maximilian Mensing
Sent: Tuesday, November 18, 2014 2:16 AM
To: racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>
Subject: [racktables-users] Re: Copy Object Plugin install instructions
Hi Joshua,
The version in the official Racktables-contribs repository was intended for
0.19.6..
I've a working version over here:
https://github.com/madmax2012/racktables-contribs/blob/master/local_copy_object.php
Please tell me if this one works for you.
We will add another patch for 0.20.8 in a few weeks.
Cheers,
Max
Von: Joshua Morales <Joshua.Morales@xxxxxxxxx<mailto:Joshua.Morales@xxxxxxxxx>>
Antworten an:
"racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>"
<racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>>
Datum: Friday 14 November 2014 19:48
An: "racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>"
<racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>>
Betreff: [racktables-users] Copy Object Plugin install instructions
Hi All,
I'm trying to figure out how to install the "local_copy_object" plugin to our
RT server. We're currently running version 0.20.7. I copy the
local_copy_object.php file under the plugins directory. I restart the web
server and it breaks RT. Could somebody please give me some instructions on
what exactly I'm supposed to do to get this plugin to work? I have to input a
few hundred objects and it would be handy to use this plugin to increase
efficiency.
Thanks,
Josh
Other related posts:
