Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MSDHosts

Status
Not open for further replies.
chevell

chevell

Technical User
Jul 2, 2010
34
US
Hey guys,
I've got no experience with POS Systems, but a client asked me to make a custom web app that interfaces with his POS. I obviously don't want to develop on his server, so he gave me his CDs to install in a VM in demo mode. Everything installed without issue and I have the license manager running in demo mode.

When I click the Start RES app, it pops up the application starter and sits at "Wait for MDSHosts". I have no idea what that means and can't find any reference to it. Any help would be greatly appreciated!
 
Sort by date Sort by votes
Did you load your own db or are you using the shell off the install CD's. The behavior you are seeing, can typically happen if the IP address for the server in POS Configurator (start--run--poscfg) is in correct.

Have you made any changes to the database for your test environment?
 
Upvote 0 Downvote
I just installed and haven't done anything at all yet. I have a backup to restore to, but the darn thing is not letting me do that either. I am thinking its something with VMWare's network configuration. Gonna troubleshoot that first. Thanks!
 
Upvote 0 Downvote
Ok, I started the database manually in services and now it shows a green arrow in the control panel, but its still doing the MDSHosts deal. Apparently there's more to setting this up than just installing and restoring from backup?

This is all very silly, since I'm only installing to test my application server's connection to the database. Is there a quick way to get the restore done and get this deal up and running? I appreciate your help so far!
 
Upvote 0 Downvote
1. start --> run --> dm

2. If you have a shell you willnot be promted to login

3. Click Restore Database on the right side

4. Click Restore Database under the "Restore Utilities"

5. Browse to the .mbz backup file you would like to restore.



 
Upvote 0 Downvote
Ok,so i just rebuilt the virtual machine and when I go into the database manager and click on restore, everything is grayed out. This is the same as it was before I rebuilt. I thought it was something i did to it while troubleshooting. Ideas?
 
Upvote 0 Downvote
Additionally, in the control panel, the database says its down, but I started the sql service in services. What the heck is going on here! HELP! :)
 
Upvote 0 Downvote
ok, in the CP, i switched it to database and got yellow dots, then off and got green checkmarks. whatever that means, but neither of them gave me the ability to restore in DM.
 
Upvote 0 Downvote
The MDSHosts.xml file is contained in the d:\micros\res\common\etc directory.
It contains host information about the server and workstations.

The workstations automatically should download this file to the workstation but sometimes it doesnt.
To fix this go into services.msc
Restart the Micros Distributed servces manager and the Micros DB update service in that order.

Then go into the micros control panel and select "Restaurant" and reload the database.

The ws4 will now download the mdshosts.xml file, you may need to restart the ws4.
 
Upvote 0 Downvote
This is the server, not the workstation I'm trying to start up.

I did what you said and then started the DB within the Control Panel. Still everything is gray in the database manager, so I can't restore anything.

I called Micros and they referred me to my local distributor who wants money to tell me what's wrong. I kinda figured that would be the case.

Any help would be very much appreciated. Once I get this DB restored, i should be go to go! Thanks!
 
Upvote 0 Downvote
In the control panel the database is green and all started?

go to %micros%\res\common\etc and open mdshosts.xml with notepad and copy the contents into a post here.

 
Upvote 0 Downvote
The database is running, that's a good thing. My guess is that the MDSHosts file is empty, if it's there at all yet. That gets generated/updated when the network nodes are changed and you're nowhere near that point yet.

You have to create a user with db restore privileges to get that backup going. This is kind of a sledgehammer approach, but what the hell, you'll be throwing out the shell db once you get the backup restored.

Try this -
[ol]
[li]Open the POS configurator and go to the Employees tab. It shouldn't promt for a password yet since there aren't any users defined.[/li]
[li]Click the Employee Classes button and add an employee class by clicking the blue plus sign. Enter a name on the new line that gets created.[/li]
[li]Go to the Privileges tab - Privilege Options tab.
Check all the options in the Database Manager section.
[/li]
[li]Close the Employee Classes form and click the Backoffice Classes button.[/li]
[li]Click Create. Enter a name, ignore the HTML stuff and assign Privilege Level 3.[/li]
[li]On the right side click the word Full, then click each of the four buttons under Compound. Go to the System Level tab and click on the word Full. Save the changes and close this screen.
(This is the sledgehammer bit. I don't know what privileges you need in here so we're just enabling everything.)[/li]
[li]Click the Configurator Access button and highlight the employee class you created.[/li]
[li]Click the blue plus sign to add a line. Select your employee class in the left column and "All Forms" on the right.[/li]
[li]Check all four boxes, save and close this form. This will give you full access to the configurator in case we have to go back in and make some changes.[/li]
[li]Click the Employees button and create a new employee by clicking the blue plus. You'll have to enter at least a first and last name.[/li]
[li]Go to the Security tab. Enter 1 in the PC Application ID box and select the classes you made in the Employee Class and Backoffice Class fields.[/li]
[li]Make sure the Change Password and Account Disabled checkboxes are blank and save.
There may be other required fields, it depends on how you loaded RES. Any other required fields will let you know about it when you try to save. Just fill them in as you're prompted. Close the Employee screen once it saves.[/li]
[li]Click the System tab on the main configurator screen and then the Restaurant button - Security tab. Make sure "Use Micros Classic Security" is checked. Make the change and save it is you have to. Close this form but leave the POS Configurator open.[/li]
[/ol]

Now try to open Database Manager. You should be prompted for a password - enter 1. That will sign you on as the new user and should enable the options in the database manager.

If you're going to be developing for RES products I'd definately recommend finding a database from version 3.2. That was the last one before all this database manager nonsense so there's nothing restricting access. Drop in a 3.2 database and log file, start up the control panel and you'll have restore access in DM.
 
Upvote 0 Downvote
I'm thinking you're right. I was working along these same lines before your reply and I think i managed to destroy the privs entirely, because I can't get into half the areas you mentioned now. I'm going to blow it away and start over. Thank god for VMs! Appreciate the advise. I'll get back when I have it up and running again.
 
Upvote 0 Downvote
If you're going to reload RES completely you can restore that backup as part of the process. Instead of installing a shell database, select the option for an existing database and browse to it. When the installation is done it will convert the database to the version you're loading.
 
Upvote 0 Downvote
hmm, this database is an mbz file? The installer didn't seem to like that file. Does that make any sense?
 
Upvote 0 Downvote
OMG, your sledgehammer approach worked! I'm in! If course, now I don't know his passwords, but hey, we're almost there. Thanks so much for the help!
 
Upvote 0 Downvote
Glad I could help. Nothing like a little overkill to get the job done I always say.

If you don't mind, try to keep us posted on the project. There's a site here in NY that was trying to do something similar but never got it working. It's something I would have liked to work on, but I can't take on outside projects. I also know how frustrating it can be to get decent support for upper level Micros stuff so I surf around on here and try to help out where I can.
 
Upvote 0 Downvote
OK, so your help has gottem me this far and I really appreciate it. Unfortunately, I'm at another stopping point.

I finally got to the point of getting the DB restored. Everything seemed to work alright, but when I bring up the POSCFG, the only things in there are the things you had me create. There is no menu, etc. I stopped by the restaraunt and he said there's supposed to a Virtual Terminal come up after the App starter. Thoughts?
 
Upvote 0 Downvote
If that's all you have in the configurator the restoration didn't work. What version is your client on, and what version did you install on your test server? If the database is a later version than what you're loading is may fail. You may need to service pack you're server up to the same version as your client.

Hit start | run and type in versioninfo to get the currently loaded version.
 
Upvote 0 Downvote
Well, it says version 4.0 GR (Build 4.0.8.312). These are the CDs he gave me. Is there a later version? I know he told me his server was 4.0. I tried to run the update app, but I got internet failure. *shrug*
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top