[racktables-users] Re: Changing the name on an object

Sorry - I thought you meant that things might work differently if I used the 
initial administrator account to try the change rather than one that I had set 
up later with administrative privileges.  Yes, making a direct database change 
works well and doesn't seem to affect anything else.

Thanks,
Tim


-----Original Message-----
From: racktables-users-bounce@xxxxxxxxxxxxx 
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Frank Altpeter
Sent: Thursday, January 08, 2009 2:44 PM
To: racktables-users@xxxxxxxxxxxxx
Subject: [racktables-users] Re: Changing the name on an object

Hi there,

on 2009-01-08 at 21:36:18 CET, Tim Carr wrote:
> Good idea...I just tried that, though, and I still get the same result.

eh... I meant to try the sql statement directly within the mysql
console... e.g.


mysql -u useruser -p yourpass databasename
Password:
mysql> update RackObject set name='Mail02', label='Mail02', barcode=NULL, 
objtype_id='4', has_problems='no', asset_no=NULL, comment='' where id='205' 
limit 1


So, there can not be the same result, there must be a mysql error
output...


> -----Original Message-----
> From: racktables-users-bounce@xxxxxxxxxxxxx 
> [mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Frank Altpeter
> Sent: Thursday, January 08, 2009 2:34 PM
> To: racktables-users@xxxxxxxxxxxxx
> Subject: [racktables-users] Re: Changing the name on an object
> 
> Hi there,
> 
> on 2009-01-08 at 21:23:30 CET, Tim Carr wrote:
> > If I try to change the Common Name on an object once it has been created, I 
> > get the following error:
> > 
> > SQL query 'update RackObject set name='Mail02', label='Mail02', 
> > barcode=NULL, objtype_id='4', has_problems='no', asset_no=NULL, comment='' 
> > where id='205' limit 1' failed
> 
> Did you try this when directly connected to your mysql database with the
> credentials configured in your racktables config? Could be that you get
> a deny there due to insufficient permissions.
> 
>  
> Le deagh dhùraghd,
> 
>       Frank Altpeter
> 
> -- 
> FA-RIPE *** http://www.altpeter.de/
> 
> 
> 

 
Tìoraidh an-dràsda,

        Frank Altpeter

-- 
FA-RIPE *** http://www.altpeter.de/

Other related posts: