03-02-2016 06:45 AM
Hi,
I have recently upgraded my OPSC from 7.6.0.3 to 7.7.1.
I've tried to connect to database via 'dbisqlc' and recieved popup with "Database server not found" message.
I think that I gave proper user/pass and database name:
user: DBA
pass: SQL
database name: opscenter_<hostname>
if anyone had such a problem?
Any advice how I can debug the issue?
Regards
Madej
Solved! Go to Solution.
03-04-2016 04:59 AM
figured it out, you must put opscenter_opscenter in the servername field, not the database field. leave that blank
03-03-2016 03:24 AM
Is the database server online?
run
opsadmin -monitor
03-03-2016 10:47 AM
Yes, I can login to webgui. OPSC is runnig properly.
Command returns (Windows :) :(
c:\Program Files\Symantec\OpsCenter\server\bin>opsadmin.bat -monitor
Invalid arguments
"HELP:opsadmin.bat [ start | stop ]"
Database server service is running:
c:\Program Files\Symantec\OpsCenter\server\bin>sc query SQLANYs_VERITAS_OPSCENTE
R
SERVICE_NAME: SQLANYs_VERITAS_OPSCENTER
TYPE : 10 WIN32_OWN_PROCESS
STATE : 4 RUNNING
(STOPPABLE, NOT_PAUSABLE, ACCEPTS_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0
Regards
Madej
03-03-2016 02:56 PM
If you're trying to connect remotely, check your database's server.conf file (C:\Program Files\Symantec\OpsCenter\server\db\CONF\server.conf) and see if it still has the LocalOnly=NO
If I remember correctly, when I did this upgrade my conf file got reset and I had to recover it.
If thats not the case, run C:\Program Files\Symantec\OpsCenter\server\db\WIN64\dblocate.exe and make sure it lists your DB. Also, tell us where are you running dbisqlc from?
03-03-2016 10:24 PM
server.conf file contains:
-n OPSCENTER_OPSCENTER -x tcpip(LocalOnly=YES;ServerPort=13786) -gd DBA -gk DBA -gl DBA -gp 4096 -ti 0 -c 256M -ch 1024M -cl 256M -zl -os 1M -m -o "C:\Program Files\Symantec\OpsCenter\server\db\log\server.log" -m
This is default.
But I run dbisqlc localy, so this shouldn't matter.
And dblocate found my database as I expected:
c:\Program Files\Symantec\OpsCenter\server\db\WIN64>dblocate.exe
SQL Anywhere Server Enumeration Utility Version 16.0.0.2095
Server Name Address
----------- -------
opscenter_opscenter opscenter:13786
1 server found
It is strange.
Regards
Madej
03-04-2016 02:56 AM
Post exactly what you're entering, screenshot please.
03-04-2016 03:14 AM
Two screenshots attached.
Regards
Madej
03-04-2016 03:45 AM
Put the server name in there too
03-04-2016 04:11 AM
c:\Program Files\Symantec\OpsCenter\server\db\WIN64>hostname
opscenter
Port 13786 is opened, I can telnet on it.
Before upgrade I could connect without problems in the same way.
Maybe the problem is that I have tested the backup/restore of database using dbbackup command. But I don't think so. Few times I was doing this and always was ok after that.
Regards
Madej
03-04-2016 04:59 AM
figured it out, you must put opscenter_opscenter in the servername field, not the database field. leave that blank
03-04-2016 05:48 AM
:-))))
You're wright. I feel so stupid.
But I am pretty sure I have tested this way.
Thanks and sorry for wasted time.
Regards
Madej
03-04-2016 07:02 AM
No problem :)