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.
How to divide the DB and application and web
- 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
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
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 workjim 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.
-
- 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
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.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
-
- 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
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.tomok wrote: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.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
-
- 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
I do not think that in the context of TM1 that you understand what is the application server, database server and web server.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.
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.
-
- 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
as long as you do not start using the Application Web; so it depends what we understand under application serverFor TM1 there is no distinction between the application server and database server