[racktables-users] Re: Changing the name on an object
- From: Patrik Båt <patrik.bat@xxxxxxxxxx>
- To: "racktables-users@xxxxxxxxxxxxx" <racktables-users@xxxxxxxxxxxxx>
- Date: Thu, 15 Jan 2009 16:57:52 +0100
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:
