How to divide the DB and application and web

Post Reply
Aruis.yu
Posts: 39
Joined: Tue Oct 21, 2014 10:20 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

How to divide the DB and application and web

Post by Aruis.yu »

Hi All:

I want to do a test, let the TM1 divided in to 3 layers. One server install the web server , the other is the application server, the third one is the Database server. How to do that?

Now I currently divided 2 layers, Web server and application is on one server, DB is on another server.

And I had modify the tm1s.cfg file and the database file I modify to \\192.168.6.32\C$\XXXX, I had open the port to another server(Web and application)

But when I get to start the service on application, it always says that "Can't connect to admin server at host 192.168.6.32 and port 5498.

But actually i had open the 5498 port for application server.
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: How to divide the DB and application and web

Post by jim wood »

You have to have an install of TM1 for web to work. So you have to install the listener on one, the DB and a full install on web. Then you have to change the default admin host to where the listener is.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Aruis.yu
Posts: 39
Joined: Tue Oct 21, 2014 10:20 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

Re: How to divide the DB and application and web

Post by Aruis.yu »

jim wood wrote:You have to have an install of TM1 for web to work. So you have to install the listener on one, the DB and a full install on web. Then you have to change the default admin host to where the listener is.
You are right. But I did like you said. I copy the DB to another server, and using the listen on the path of the DB, like \\192.168.6.32\C$\DB, after I modify the .cfg and start to run the .cfg. It actually begin to run, but after a while, shows the error. Actually, I open all ports . But it still don't work
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: How to divide the DB and application and web

Post by tomok »

Aruis.yu wrote:[and using the listen on the path of the DB, like \\192.168.6.32\C$\DB, after I modify the .cfg and start to run the .cfg. It actually begin to run, but after a while, shows the error. Actually, I open all ports . But it still don't work
So what do you have as the parameter for the AdminHost item in your tm1s.cfg? If it is "\\192.168.6.32\C$\DB" then that's not going to work. That is pointing to a specific file path on that server. All the AdminHost parameter needs is the name of the server it is running on like "192.168.6.32". In any case, why would you have the Admin Host service run on a different machine than the TM1 Server service???? If they run on the same box then you can leave the AdminHost parameter blank.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Aruis.yu
Posts: 39
Joined: Tue Oct 21, 2014 10:20 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

Re: How to divide the DB and application and web

Post by Aruis.yu »

tomok wrote:
Aruis.yu wrote:[and using the listen on the path of the DB, like \\192.168.6.32\C$\DB, after I modify the .cfg and start to run the .cfg. It actually begin to run, but after a while, shows the error. Actually, I open all ports . But it still don't work
So what do you have as the parameter for the AdminHost item in your tm1s.cfg? If it is "\\192.168.6.32\C$\DB" then that's not going to work. That is pointing to a specific file path on that server. All the AdminHost parameter needs is the name of the server it is running on like "192.168.6.32". In any case, why would you have the Admin Host service run on a different machine than the TM1 Server service???? If they run on the same box then you can leave the AdminHost parameter blank.
Because some company need the security process, let the database and the application separate on different server. And the AdminHost in my .cfg is 192.168.6.32. but the DataBaseDirectory=\\192.168.6.32\C$\DB.
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: How to divide the DB and application and web

Post by lotsaram »

Aruis.yu wrote:Hi All:

I want to do a test, let the TM1 divided in to 3 layers. One server install the web server , the other is the application server, the third one is the Database server. How to do that?

Now I currently divided 2 layers, Web server and application is on one server, DB is on another server.

And I had modify the tm1s.cfg file and the database file I modify to \\192.168.6.32\C$\XXXX, I had open the port to another server(Web and application)

But when I get to start the service on application, it always says that "Can't connect to admin server at host 192.168.6.32 and port 5498.

But actually i had open the 5498 port for application server.
I do not think that in the context of TM1 that you understand what is the application server, database server and web server.
For TM1 there is no distinction between the application server and database server (although there might be to a file server where the offline database definition is stored), and the admin host is none of these 3 entities.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: How to divide the DB and application and web

Post by mvaspal »

For TM1 there is no distinction between the application server and database server
as long as you do not start using the Application Web; so it depends what we understand under application server
Post Reply