Re: Perl Error

[Jonathan Callahan <Jonathan.S.Callahan@xxxxxxxx>]

Matt,

When regenerating the LAS user interface you will need to provide a login name and password that has permission to drop tables and databases.  This would be the same privileged mysql user that you used when first configuring LAS.  The 'las' user is only for servlet interactions with the database.   For security reasons, this 'las' user has no DROP privileges and cannot be used to update the LAS databases (a.k.a. "regenerate the interface").


-- Jon


Matt Fulgo wrote:

When running the latest version of LAS (6.4.2.0), I get the attatched
error while regenerating the interface.

Thanks in advance,
Matt

DB host: [constellation.nrlssc.navy.mil] DB login name: [las] DB password: [] 
DBD::mysql::db do failed: Can't drop database 'las4'; database doesn't exist at ../xml/perl/LASDB.pm line 428, <STDIN> line 3.
Serializing file:/usr/local/nvods/archive/las_old/server/las.xml to database
Building indexes...
DBD::mysql::db do failed: alter command denied to user 'las'@'supply.nrlssc.navy.mil' for table 'elements' at ../xml/perl/LASDB.pm line 478.
DBD::mysql::db do failed: alter command denied to user 'las'@'supply.nrlssc.navy.mil' for table 'elements' at ../xml/perl/LASDB.pm line 478.