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

The user you use for rack-tables, has it permissions to UPDATE?

Fre 2009-01-09 klockan 15:15 +0100 skrev Tim Carr:
> 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/
> 
> 
> 
-- 
Sincerely,

Patrik Båt
UNIX System Administrator
_____________________________________________
Cypoint IT Services AB
Sehlstedtsgatan 9
SE-100 52 Stockholm
http://www.cypoint.se

Phone: +46 (0)8 545 87 300
Direct: +46 (0)8 545 87 326
Mobile: +46 (0)73 32 07 326
E-mail: patrik.bat@xxxxxxxxxx

Other related posts: