topic WCS Database Down in Wireless

WCS Database Down

ricardorojas123 — Sun, 04 Jul 2021 00:32:19 GMT

Hi, I have installed the WCS 4.1 version and the database is down I don't know how UP the database ... any suggestions??

Thanks

#./WCSStatus

Database server is stopped

Apache server is running

WCS is running

Re: WCS Database Down

Scott Fella — Mon, 04 May 2009 14:14:48 GMT

If you followed the recommended minimum requirement for WCS, then the only thing I would tell you to do is reload WCS back onto the server.

Re: WCS Database Down

ricardorojas123 — Mon, 04 May 2009 14:33:22 GMT

I restart the Linux server , and the database is Down.

Re: WCS Database Down

ericgarnel — Mon, 04 May 2009 16:57:39 GMT

from a root prompt do the following:

df -h

/etc/init.d/WCS4.xxx (your version here) status

/etc/init.d/WCS4.xxx (your version here) start

If this starts the db fine then do the following:

chkconfig --list|grep WCS

the output should be:

WCS4.x.xx.0 0:off 1:off 2:on 3:on 4:on 5:on 6:off

cd /opt/WCS4.xxx/webnms/logs

tail some of the logs for clues

When you installed WCS did you select to run it as a service?

Re: WCS Database Down

CFayNTAdmin83 — Mon, 04 May 2009 18:57:29 GMT

I was thinking that, or maybe he didn't do the restore of the DB properly when the new version got installed. Once you've installed the new version, you need to tell Linux to restore the DB; it should convert the schema, etc to support the new version of WCS you installed. Otherwise, you get WCS with a blank DB. I would retrace the steps performed based on the following document to help with troubleshooting ...

http://www.cisco.com/en/US/docs/wireless/wcs/4.1/configuration/guide/wcsmain.html#wp1077371

Hope this helps,

Craig

Re: WCS Database Down

patgeo1984 — Thu, 13 Aug 2009 14:26:52 GMT

Hello everyone

We WCS (W2003server) also happens this problem, we stopped momentarily to fix the service manually and resume. There any other solution?

Thank you very much

Re: WCS Database Down

Lucien Avramov — Thu, 13 Aug 2009 14:29:27 GMT

WCS should not stop with no reason. It may happen sometimes but if it's too frequent, then we need to look at the WCS logs.

If you want, post the WCS logs zip file, you can get it from Administration -> Logging.

Re: WCS Database Down

marcin.waliczek — Mon, 31 Aug 2009 22:40:31 GMT

Hi,

I got simmilar problem with WCS database.

After few minutes/hours, sometimes days, database goes down. Please see logs, it happened about 21:22.

Re: WCS Database Down

Lucien Avramov — Tue, 01 Sep 2009 07:20:15 GMT

In the logs, the only relevant error is that you tried to create guest users with not using a lobby ambassador account. Then the database did not respond.

I will need the full logs.zip output and not only the wcs-1-0.log to see this further.

Make sure you create guest accounts with a lobby admin account and not an admin account.

Re: WCS Database Down

marcin.waliczek — Wed, 02 Sep 2009 13:52:50 GMT

OK, today I installed WCS 5.2.148.0 again and restored configuration from backup. After a few hours WCS database hanged up at about 16:05. Can you see something in logs what can put database down ? I don't think creating guest accounts make those problems, I do it for years.

Re: WCS Database Down

ericgarnel — Wed, 02 Sep 2009 14:41:36 GMT

Do you have selinux enabled?

Also, do you happen to have a backup job running? Given the fact that WCS is running, some backup programs may have issues trying to backup open files.

Also, what monitoring are you using? and can it alert you if a proc dies. You can always add a proc value to snmpd.conf

Re: WCS Database Down

marcin.waliczek — Wed, 02 Sep 2009 15:11:48 GMT

I forgot to add... OS is Win 2003 Server SP1 all running on VMWare, till August all was OK. There is no backup at this time, it happens randomly. I use BMC PNEt to monitor web login transaction, I get alarm when PNET cannot login to WCS, then I log in via remote desktop, run WCSStatus and see that database server is down 😕

Re: WCS Database Down

marcin.waliczek — Thu, 03 Sep 2009 05:55:35 GMT

Hi, I've found additional logs from X:\WCS\webnms\db\eval_kit\standalone

There is some serious problem with database itself. I have some backups but even if I restore db, it hangs up again.

Re: WCS Database Down

ericgarnel — Thu, 03 Sep 2009 12:02:24 GMT

Hmmm...

your db is located at X:\WCS\webnms\db\eval_kit\standalone

is X: a networked drive? perhaps there are some communications issues that are causing problems and/or corruption with the db. TAC should have some solid db commands/checks that you could run