topic Re: Accessing PCM+ DB using MySQL Tools in Switches, Hubs, and Modems

Accessing PCM+ DB using MySQL Tools

Michael Freymond — Mon, 27 Oct 2008 17:27:46 GMT

Hi,

I am running PCM + version B.02.322.

I am attempting to connect to the database using MySQL tools to run my own queries against it.

I am unable to do so successfully. When I attempt to connect (on port 3908), it gives the following error:

Could not connect to the specified instance.

MySQL Error Number 1045
Access denied for user 'Administrator@' (using password: YES)

It seems that this is possiable - I'm not sure what I'm doing wrong.

The version of the MySQL tools that I attempting to connect with is the MySQL Administrator version 1.2.12.

Any help would be appreciated.

Thanks

Re: Accessing PCM+ DB using MySQL Tools

cenk sasmaztin — Mon, 27 Oct 2008 18:05:58 GMT

which runing operating system pcm+
and which language operating system

Re: Accessing PCM+ DB using MySQL Tools

Michael Freymond — Mon, 27 Oct 2008 19:30:08 GMT

PCM is running on W2K3 x64 english.

Re: Accessing PCM+ DB using MySQL Tools

cenk sasmaztin — Tue, 28 Oct 2008 07:04:09 GMT

please check SQL database connection
use the mySQL.exe file to connect to the pcm database.

mysql.exe is found in the pcm server at:

\Program files\hewlett-packart\pnm\server\mysql\bin

once at the prompt you will need to type in the executable name that you want to run along with the executable variables.In this case the executable is the mysql.exe whit following variables.

port 3908
user [the pcm user with external database access privileges]
password[password of pcm user mentioned above]
netmgmt [name of the database]

Re: Accessing PCM+ DB using MySQL Tools

Michael Freymond — Tue, 28 Oct 2008 13:12:16 GMT

I checked and made sure that the administrator account has the 'External DB Access' enabled.

I've run the following command from the server:

mysql --port=3908 --password=password --user=Administrator netmgmt

And it coughs up this error:

ERROR 1045 (28000): Access denied for user 'Administrator'@'localhost' (using password: YES)

Re: Accessing PCM+ DB using MySQL Tools

Jason Scott — Wed, 29 Oct 2008 07:15:51 GMT

I did this a while back with MySQL tools. My connection dialog shows my username but no password or connection schema. I believe on the server I had to create a basic account to enable this access but for the life of me I cannot recall what I did.