CLTSVR: Security key not found (HELP) 1

[justadoode]

POS GURUS: I have built a new server for my restaurant and installed the Aloha POS by using the discs from my local dealer. Everything seemed to have gone well, except whenever I reboot or I try to access the Aloha Manager, I receive "CLTSVR Security key not found" error message. I have read all of your posts and have tried to follow all of your instructions to the letter. All of the old info and profiles and everything have come over, but I STILL get that error message and am VERY frustrated. Can anyone PLEASE advise? Thank you in advance.

 

[bigblok403]

Is they option for menus and submenus greyed out, or just not available to select?

 

[justadoode]

It's not available to select at all. I had copied all of the submenus under Aloha from my old server (which is still up and running) and on the old server, I can see the menus and sub menus but not on the new server. I just don't get it and I'm about to just bring out a hammer and a bottle of Tequila.

 

[bigblok403]

Found this Document ->

If ALOHAMGR.EXE (Aloha Manager) is missing drop-down menus or drop-down menu options, verify that the CTL4X.DLL, MNT4X.DLL, and USERTOOL.DLL applications are registered. The easiest way to verify successful registration is to manually register them, and verify that they return a successful response. Refer to document AKBID1019 for more information on manually registering and un-registering the ALOHA® application software.

The following .DLL files affect the following drop-down menus:

CTL4X.DLL - Functions, Reports, Utilities
MNT4X.DLL - Maintenance
USERTOOL.DLL - Tools

Register them one by one by copying the line in the Iber_52844.bat file and pasting them in dos. Make sure they register ok.

 

[bigblok403]

You could also completely delete the security level .dbf files. It will just create a new blank ones when you start Aloha Manager up.

 

[justadoode]

I have a real quick question. I copied those lines out of the 'register_iber_52844.bat' file and pasted them in dos and hit enter and nothing happened, except it it returned back to the c prompt. Should something have confirmed a succesful register? I called the local dealer and asked them if we could work out a deal to get the menus toggled on. The owner said sho would still charge me the full $650 and to add insult to injury, she said "That's what you get for trying to build your own server." I cannot believe the audacity this woman has for me just trying to save a total of $1600 plus tax to build and configure my own server. Anyway, should I have gotten something telling me I successfully registered these .dll's?

 

[justadoode]

I don't know, I'm getting discouraged. After registering those three dll's and rebooting countless times, the Alohamgr program just stalls now. I start it and it asks for my user ID and password. I put in the super user values and it just stays locked there. I check the task manager and it says not responding. I have rebooted and still no fix. By the way, also, where do I find the security .dbf files that you suggested I delete? I don't know if they are under the newdata folder and I don't know the names. Thank you again.

 

[bigblok403]

Start Aloha Manager and paste the last couple paragraphs from these 2 files here - DEBOUT.TXT and DEBOUT.svr. They are located in Aloha\TMP. These are 2 files that show info about Aloha Manager and Control Server problems.

 

[alohaakamai3]

Also, one cool feature of Aloha is that each day of sales history is like a "snap shot" of that particular day. So, if you think you have data base corruption, you can always go back a few days before your problems started, and post of the contents of that day into your Data/Newdata directories. (a few files you don't want to transfer for over, mainly the trans.log is the only one you need to worry about)

I'd probably go this route before I'd start removing individual files within the databse and trying to get it to work. Go back to when it DID work, and try using that data.

Just my humble opinion.

 

[justadoode]

I see. I brought the computer home to fix it, but I guess since I don't have the security key attached to the back, it creates problems. Here's what I have:
DEBOUT.svr
Jan 20, 12:06:34 CTLSVR: Started CtlServiceThread... version 5.045
Jan 20, 12:06:34 CTLSVR 5.045 is running on workstation ALOHABOH1
Jan 20, 12:06:34 CTLSVR: IBERDIR is C:\Aloha
Jan 20, 12:06:34 CTLSVR: Is NOT running in SQLMODE.
Jan 20, 12:06:34 CTLSVR: bRobust = TRUE
Jan 20, 12:06:56 CTLSVR: Security key not found
Jan 20, 12:12:33 CTLSVR: Start background processing...
Jan 20, 12:12:33
Jan 20, 12:12:33 CTLSVR: CtlServiceThread Terminated.

DEBOUT.TXT
Jan 20, 11:09:37 ............................................................
Jan 20, 11:09:37 AlohaMgr starting... version 5.045
Jan 20, 11:09:37 MODE SETTINGS
Jan 20, 11:09:37 ***** Version: 5.045
Jan 20, 11:09:37 ***** Workstation: ALOHABOH1
Jan 20, 11:09:37 ***** QuickService Only
Jan 20, 11:09:37 ***** Site Id: 1
Jan 20, 11:09:37 >>>>>>>>>> ********** DBUP2.EXE For Generation 2 Ver 5.045 ********** <<<<<<<<<<

Jan 20, 11:09:37 Running in Debug Mode
Jan 20, 11:09:37 Iberdir is C:\Aloha
Jan 20, 11:09:37 Will Rebuild DBF CDX Files If Necessary
Jan 20, 11:09:37 Running in Attended Mode
Jan 20, 11:09:37 Current DBF File(s) Location C:\Aloha\NEWDATA
Jan 20, 11:09:37 Upgraded DBF File(s) Location C:\Aloha\NEWDATA
Jan 20, 11:09:37 Upgrading Both DBF Files and the Relational Database.
Jan 20, 11:09:37 Running For Non Enterprise Site.
Jan 20, 11:09:37 Read INI File C:\Aloha\DATA\ALOHA.INI
Jan 20, 11:09:37 Created the Table Depot
Jan 20, 11:09:37 Rebuilding DBF CDX Files If Necessary...
Jan 20, 11:09:37 Building CDX File For DBF File ACC
Jan 20, 11:09:38 Building CDX File For DBF File AMNU
Jan 20, 11:09:38 Building CDX File For DBF File AMNUD
Jan 20, 11:09:38 Building CDX File For DBF File BTN
Jan 20, 11:09:38 Building CDX File For DBF File CashCard
Jan 20, 11:09:38 Building CDX File For DBF File CAT
Jan 20, 11:09:38 Building CDX File For DBF File CEVNT
Jan 20, 11:09:38 Building CDX File For DBF File CEVNTSUB
Jan 20, 11:09:39 Building CDX File For DBF File CIT
Jan 20, 11:09:39 Building CDX File For DBF File CMG
Jan 20, 11:09:39 Building CDX File For DBF File CMP
Jan 20, 11:09:39 Building CDX File For DBF File CTK
Jan 20, 11:09:39 Building CDX File For DBF File DNK
Jan 20, 11:09:39 Building CDX File For DBF File DsplyBrd
Jan 20, 11:09:39 Building CDX File For DBF File DWR
Jan 20, 11:09:39 Building CDX File For DBF File EMP
Jan 20, 11:09:40 Building CDX File For DBF File EMPI9
Jan 20, 11:09:40 Building CDX File For DBF File EXC
Jan 20, 11:09:40 Building CDX File For DBF File FIXPRICE
Jan 20, 11:09:40 Building CDX File For DBF File FLEXTAX
Jan 20, 11:09:40 Building CDX File For DBF File GCI
Jan 20, 11:09:40 Building CDX File For DBF File GIF
Jan 20, 11:09:40 Building CDX File For DBF File HSE
Jan 20, 11:09:40 Building CDX File For DBF File ITM
Jan 20, 11:09:41 Building CDX File For DBF File ITMGRP
Jan 20, 11:09:41 Building CDX File For DBF File ITMGRPL
Jan 20, 11:09:41 Building CDX File For DBF File JOB
Jan 20, 11:09:41 Building CDX File For DBF File JRV
Jan 20, 11:09:41 Building CDX File For DBF File LAB
Jan 20, 11:09:41 Building CDX File For DBF File LABEL
Jan 20, 11:09:41 Building CDX File For DBF File MEMB
Jan 20, 11:09:41 Building CDX File For DBF File MNU
Jan 20, 11:09:42 Building CDX File For DBF File MOD
Jan 20, 11:09:42 Building CDX File For DBF File MSG
Jan 20, 11:09:42 Building CDX File For DBF File MULTCURR
Jan 20, 11:09:42 Building CDX File For DBF File NOSALER
Jan 20, 11:09:42 Building CDX File For DBF File OCC
Jan 20, 11:09:42 Building CDX File For DBF File OCT
Jan 20, 11:09:42 Building CDX File For DBF File ODR
Jan 20, 11:09:43 Building CDX File For DBF File PC
Jan 20, 11:09:43 Building CDX File For DBF File PCID
Jan 20, 11:09:43 Building CDX File For DBF File PCPD
Jan 20, 11:09:43 Building CDX File For DBF File PCPLD
Jan 20, 11:09:43 Building CDX File For DBF File PET
Jan 20, 11:09:44 Building CDX File For DBF File PNL
Jan 20, 11:09:44 Building CDX File For DBF File Poll
Jan 20, 11:09:44 Building CDX File For DBF File PollEvnt
Jan 20, 11:09:44 Building CDX File For DBF File PollSubs
Jan 20, 11:09:44 Building CDX File For DBF File PRD
Jan 20, 11:09:44 Building CDX File For DBF File PRF
Jan 20, 11:09:44 Building CDX File For DBF File PRG
Jan 20, 11:09:44 Building CDX File For DBF File PRL
Jan 20, 11:09:44 Building CDX File For DBF File PRO
Jan 20, 11:09:45 Building CDX File For DBF File PRT
Jan 20, 11:09:45 Building CDX File For DBF File QTYPRICE
Jan 20, 11:09:45 Building CDX File For DBF File QUE
Jan 20, 11:09:45 Building CDX File For DBF File RCP
Jan 20, 11:09:45 Building CDX File For DBF File REG
Jan 20, 11:09:45 Building CDX File For DBF File REV
Jan 20, 11:09:45 Building CDX File For DBF File RSN
Jan 20, 11:09:46 Building CDX File For DBF File RTL
Jan 20, 11:09:46 Building CDX File For DBF File SCALE
Jan 20, 11:09:46 Building CDX File For DBF File SCR
Jan 20, 11:09:46 Building CDX File For DBF File SECLVL
Jan 20, 11:09:46 Building CDX File For DBF File SECLVLDT
Jan 20, 11:09:46 Building CDX File For DBF File SMCRD
Jan 20, 11:09:46 Building CDX File For DBF File SMG
Jan 20, 11:09:46 Building CDX File For DBF File SQLRPT
Jan 20, 11:09:47 Building CDX File For DBF File SQLRPTPM
Jan 20, 11:09:47 Building CDX File For DBF File STO
Jan 20, 11:09:47 Building CDX File For DBF File STREDIT
Jan 20, 11:09:47 Building CDX File For DBF File STRGRP
Jan 20, 11:09:47 Building CDX File For DBF File STRGRPM
Jan 20, 11:09:47 Building CDX File For DBF File SUB
Jan 20, 11:09:47 Building CDX File For DBF File SUR
Jan 20, 11:09:47 Building CDX File For DBF File Survey
Jan 20, 11:09:48 Building CDX File For DBF File TAB
Jan 20, 11:09:48 Building CDX File For DBF File TABDEF
Jan 20, 11:09:48 Building CDX File For DBF File TARE
Jan 20, 11:09:48 Building CDX File For DBF File TAX
Jan 20, 11:09:48 Building CDX File For DBF File TDR
Jan 20, 11:09:48 Building CDX File For DBF File TRK
Jan 20, 11:09:48 Building CDX File For DBF File TRM
Jan 20, 11:09:48 Building CDX File For DBF File VAL
Jan 20, 11:09:49 Building CDX File For DBF File VER
Jan 20, 11:09:49 Building CDX File For DBF File VGP
Jan 20, 11:09:49 Building CDX File For DBF File VID
Jan 20, 11:09:49 Building CDX File For DBF File VOL
Jan 20, 11:09:49 Building CDX File For DBF File ZAP
Jan 20, 11:09:49 CheckCDX: 89 Index Files Were Built
Jan 20, 11:09:49 DBF CDX Files Rebuilt Successfully.
Jan 20, 11:09:49 CAlohaMgrApp::RequestCtlSvr() called...
Jan 20, 11:09:49 WaitForCtlSvrStartupComplete()...
Jan 20, 11:09:49 ACtlSvrConnect: (thread) - Begin Run()
Jan 20, 11:10:13 ACtlSvrConnect: (ICtlSvrCom::AreYouAlive failed (0x4))
Jan 20, 11:10:13 ACtlSvrConnect: Connection to CtlSvr lost Prompting for reconnect...
Jan 20, 11:10:15 ACtlSvrConnect: Lost connection to CtlSvr. User did not choose to reconnect.
Jan 20, 11:10:17 CBOHSecurity::SecuritySetup() - nonSQLMode - successful return
Jan 20, 11:10:22 AlohaMgr Login: TCR TCR
Jan 20, 11:10:22 CTL4X.DLL initializing... version 5.045
Jan 20, 11:10:22 CAlohaMgrApp::RequestCtlSvr() called...
Jan 20, 11:10:22 ACtlSvrConnect: (ICtlSvrCom::AreYouAlive failed (0x0))
Jan 20, 11:10:22 ACtlSvrConnect: Connection to CtlSvr lost Prompting for reconnect...
Jan 20, 11:10:22 RequestCtlSvrReconnect: Waiting to reconnect CtlSvr...
Jan 20, 12:06:21 CTL4X.DLL initializing... version 5.045
Jan 20, 12:06:21 CTL4X.DLL exiting...
Jan 20, 12:06:21 USERTOOL.DLL initializing... version 5.045
Jan 20, 12:06:21 USERTOOL.DLL exiting...
Jan 20, 12:06:21 Returning from /UnregServer on EdcSvr
Jan 20, 12:06:24 CTL4X.DLL initializing... version 5.045
Jan 20, 12:06:25 CTL4X.DLL exiting...
Jan 20, 12:06:26 USERTOOL.DLL initializing... version 5.045
Jan 20, 12:06:26 USERTOOL.DLL exiting...
Jan 20, 12:06:26 Database Versions and Generation are Current.
Jan 20, 12:06:27 Returning from /Service on EdcSvr
Jan 20, 12:06:34
Jan 20, 12:06:34 ............................................................
Jan 20, 12:06:34 AlohaMgr starting... version 5.045
Jan 20, 12:06:34 MODE SETTINGS
Jan 20, 12:06:34 ***** Version: 5.045
Jan 20, 12:06:34 ***** Workstation: ALOHABOH1
Jan 20, 12:06:34 ***** QuickService Only
Jan 20, 12:06:34 ***** Site Id: 1
Jan 20, 12:06:34 >>>>>>>>>> ********** DBUP2.EXE For Generation 2 Ver 5.045 ********** <<<<<<<<<<

Jan 20, 12:06:34 Running in Debug Mode
Jan 20, 12:06:34 Iberdir is C:\Aloha
Jan 20, 12:06:34 Will Rebuild DBF CDX Files If Necessary
Jan 20, 12:06:34 Running in Attended Mode
Jan 20, 12:06:34 Current DBF File(s) Location C:\Aloha\NEWDATA
Jan 20, 12:06:34 Upgraded DBF File(s) Location C:\Aloha\NEWDATA
Jan 20, 12:06:34 Upgrading Both DBF Files and the Relational Database.
Jan 20, 12:06:34 Running For Non Enterprise Site.
Jan 20, 12:06:34 Read INI File C:\Aloha\DATA\ALOHA.INI
Jan 20, 12:06:34 Created the Table Depot
Jan 20, 12:06:34 Rebuilding DBF CDX Files If Necessary...
Jan 20, 12:06:34 CheckCDX: 0 Index Files Were Built
Jan 20, 12:06:34 DBF CDX Files Rebuilt Successfully.
Jan 20, 12:06:34 CAlohaMgrApp::RequestCtlSvr() called...
Jan 20, 12:06:34 WaitForCtlSvrStartupComplete()...
Jan 20, 12:06:34 ACtlSvrConnect: (thread) - Begin Run()
Jan 20, 12:07:35 ACtlSvrConnect: (ICtlSvrCom::AreYouAlive failed (0x3))
Jan 20, 12:07:35 ACtlSvrConnect: Connection to CtlSvr lost Prompting for reconnect...
Jan 20, 12:12:35 ACtlSvrConnect: Lost connection to CtlSvr. User did not choose to reconnect.
Jan 20, 12:14:50 CBOHSecurity::SecuritySetup() - nonSQLMode - successful return
Jan 20, 12:14:55 AlohaMgr Login: TCR TCR
Jan 20, 12:14:55 CTL4X.DLL initializing... version 5.045
Jan 20, 12:14:55 CAlohaMgrApp::RequestCtlSvr() called...
Jan 20, 12:14:55 ACtlSvrConnect: (ICtlSvrCom::AreYouAlive failed (0x0))
Jan 20, 12:14:55 ACtlSvrConnect: Connection to CtlSvr lost Prompting for reconnect...
Jan 20, 12:14:55 RequestCtlSvrReconnect: Waiting to reconnect CtlSvr...

 

[bigblok403]

I can see that MNT4X.Dll and ALOHASEC.EXE are not initializing at all, but I'm not sure if that's because you don't have the key on or these files were different in this version. This could easily be what's causing the issues. Change the Aloha Manager shortcut to include the remote switch.

Example "C:\Aloha\BIN\AlohaMgr.exe /remote" and see if you still have the same problems.

Also try these at a dos prompt ->

C:\WINDOWS\system32\Regsvr32.exe C:\Aloha\bin\Mnt4x.DLL
C:\Aloha\bin\ALOHASEC.EXE /regserver
C:\Aloha\bin\AlohaMgr.EXE /regserver

It should say successful after each one

 

[justadoode]

Ok, I did that and including the remote switch bypasses the stalling which is great. Thank you. I then ran each one of the command lines in DOS and it said each was successful, but I still don't have the menu or submenu options. To be safe, I went back through and registered the CTL4X.DLL,MNT4X.DLL, and USERTOOL.DLL files using the same command you gave me. The only difference is that I changed the path to read C:\WINNT\system32\Regsvr32.exe C:\Aloha\bin\Mnt4x.DLL (I changed WINDOWS to WINNT because this is Windows 2000 Pro). At any rate, still no menus or submenus. They didn't pop up when I had the security key. Could it be they are not initializing because they aren't the same version? The version my local dealer gave me on CD is 5.029 and mine is 5.045. They said as long as the bin files are updated, that wouldn't matter. (these dll's are located in the bin folder) I have another cd they burned for me that has the 5.045 bin folder and I over wrote the existing bin files with that one. Should I go into my Aloha and overwrite the new bin files from the cd with MY CURRENT BIN files that are on the old existing server?

 

[bigblok403]

I would remove the whole Aloha folder on the server, reinstall without putting in your restaurant database using the new cd and the default database, and see if you can access the menus now. If you can, then it is a problem with the database without a doubt.

 

[alohaakamai3]

Doode: Did you see my earlier post?

>>>One cool features of Aloha is that each day of sales history is like a "snap shot" of that particular day. So, if you think you have data base corruption, you can always go back a few days before your problems started, and paste all of the contents of that day into your Data/Newdata directories. (a few files you don't want to transfer for over, mainly the trans.log is the only one you need to worry about. You'll have to change the date Aloha, too. But I would definitely use the older Aloha.ini). But because this server is not yet in use, none of this is that critical.

I'd probably go this route before I'd start removing individual files within the databse and trying to get it to work. Go back to when it DID work, and try using that data.<<<<<

If database corruption is the problem, this will help.

Generally speaking, if there is a version problem, you'll get an error message saying "Database Version Not Current" when you log in. I do agree it makes for a smoother installation you do have the same version, but I've not see it where menu options just dissapeared. So I am not convinced that because it's a older version, is why you're having issues.

Using older data from a week or so before the install or any problems occured, is not that hard really, and an easy way to rule out problems with your current database. I'd do that first.

 

[justadoode]

I just wanted to let you guys know the problem was the stupidest thing in the world. It turns out that I installed Quick Service for Aloha instead of Table Service. Quick service is for fast food places and uses tablets instead of menus, so that's why the menus and submenus were missing. Thank you all so much for your help. You guys are as sharp as they get. Now I know where to go to really get expert advice. Thanks again!!