[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[McIDAS #HZP-657281]: Moving McIDAS-XCD server

Hi Hsie,

> I reboot the machine this morning.

I noticed.  I was logged on to stratus trying to investigate a problem I
found that is affecting the writing of GRIB messages to disk.  This problem
is being seen on stratus, but not on other systems that I have access to
including 64-bit Linux and 32-bit Solaris SPARC.

> After reboot, everything seems
> running fine.  But I can not get the GRID data:
> stratus:[44]% grdlist.k RTGRIBS/GFS-ALL PAR=U FHO=0 LEV=500 GPR=PS NUM=100
> grdlist.k: Error: DATABASE in dsserve, but not on machine
> GRDLIST - done

I just logged onto stratus and tried to run 'gribadmin num'.  Here is the 

stratus:[54]% gribadmin num
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mcrtgrib'

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mcrtgrib'
  Model Number   % of 
  Name  of Grids Total
  ===== ======== =====
  ----- -------- -----

I tried deleting the MySQL database, but this also failed in the same way:
stratus:[55]% gribadmin removedb
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 

The only time I have seen messages like this was when the password for the MySQL
database was incorrect.  It seems to me that we are seeing this situation now
on stratus.

So, I suggest resetting the password for the MySQL database; this needs to be
done as 'root'.

Here are a couple of references that show how to change the MySQL password:


After the password has been reset, I think that it would be wise to delete and
remake the database:

<as 'mcidas'>
-- wait until DMBIN has exited
gribadmin removedb
gribadmin makedb


Unidata User Support                                    UCAR Unidata Program
(303) 497-8642                                                 P.O. Box 3000
address@hidden                                   Boulder, CO 80307
Unidata HomePage                       http://www.unidata.ucar.edu

Ticket Details
Ticket ID: HZP-657281
Department: Support McIDAS
Priority: Normal
Status: Open

NOTE: All email exchanges with Unidata User Support are recorded in the Unidata inquiry tracking system and then made publicly available through the web. If you do not want to have your interactions made available in this way, you must let us know in each email you send to us.