Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: HGinc on January 23, 2009, 01:08:37 AM
-
Hi all,
We are in the process of installing a T-Server. We understand that there are series of servers, such as db server, config server, configuration manager, LCA .. etc, need to be installed before the T-Server can work properly.
We haven't found a installation guide from Genesys site, but it seems they should have a document for this complicate task. Anyone know if such document exist?
Could anyone perhaps give us some installation tips?
Thank you,
Alex
-
You can find this on support site, and if you have access to it, otherwise talk to the people who installed the platform on your site. This task should be done by genesys certified techs or at least with basic training
-
I tried looking for it in the support site, but I didn't find a useful document of it. I will look for it again.
No one from Genesys is installing this for us, we are just trying to install this T-Server by ourselves. ::)
-
??? ??? ??? So i guess you have received Genesys training...I find this very strange really. Because if you had received training installing this TServer is part of the training and access to the documents are easy because a CD with all data is delivered, also you get an ID to access to support.genesyslab.com and the documents are easy to find.
Genesys never delivers software to anyone without training, and if you are an end user who is trying to trick your provider then I must warn you that you may face a lot of issues and lost all warranty on your installation. Using TServer will impact directly on your licenses.
-
I agree with Cav. You're better off getting some training or an experienced person to do the job for you. Or even both as you'll learn a lot from an experienced professional. It worries me that you may not even have an a basic design of what you're trying to build.
If your installation is quite small you could try Genesys Express as it installs all your required components using a single installer, but you still need a basic understanding of Genesys to even use it.
Pavel
-
Hi cavagnaro,
No, I am not trying to trick anyone here. I am just a developer who is trying to integrate with Genesys T-Server.
We are in Genesys's developer program, and we bought SDK from Genesys as well. (no CD thought, we downloaded the SDK with permission)
Well, I'd like to have a qualified Genesys technician to install the system for me, but my boss asks me to install this, so I have to install it, yeah? ;)
Anyway, I have installed a MS-SQL 2005 on a box while installed a T-Server and a config server on the other box.
It seems like the config server is having trouble connecting to the MS-SQL database. I think the problem is from the following error messages.
[code]
+0094 Could not connect to SQL Server using SQL Native Client driver. Attemting default MS SQL Server driver...
+0110 odbcerr: [Microsoft][ODBC SQL Server Driver]Dialog failed
+0110 MSG_ERROR status='30' msg='[Microsoft][ODBC SQL Server Driver]Dialog failed '
[/code]
I think the correct way is to let config server connect to the SQL database through SQL Native Client Driver, but I am not quite sure what is missing here.
I have attached the log with the error messages. Any help is appreciated.
Thank you,
Alex
-
HGinc
It's sad to know your situation; having very little knowledge on a system but being 'forced' to do.
It sounds like someone arming a knife and is asked to kill enemies with machine guns in a war!
Genesys framework and solutions are great software but quite complex.
Basic understanding on framework is essential.
Installation and configuration wizards fool people that deployment a solution is easy for anyone who types!
The fact is that wizards do help to speed up installation and configuration but it is not all; detail options and third component (e.g., the target PABX in particular) tuning are required to implement a 'working' system.
In Genesys developer program, there should have some 'materials' to cover simulated environment setup and configuration.
If not, it is suggested to get minimum additional training or 'tools'.
I guess your task is focused at client/server applications, the client of T-server. Genesys framework installation and configuration are not the primary business.
The 'bad' news is that simulated switch does not give full event messages as in real switch; the simulated switch is Avaya G3 non-EAS. There are other simulated switches such as Nortel but they are chargeable items. Different T-servers for particular switches/PABXs behave different. Agent mode operations, for examples, are completely different in Avaya, Nortel and Alcatel although same set of Genesys functions with possibly different options values are called.
It is suggested to browse documents "Genesys Rough Guides" posted in this web site.
Relevant documents are
001 - ROUGH GUIDE TO THE GENESYS SOLUTIONS SUITE v7.x.pdf
002 - ROUGH GUIDE TO SCI AND MANAGEMENT FRAMEWORK v7.x.pdf
003 - ROUGH GUIDE TO CME AND SOLUTIONS FRAMEWORK v7.x.pdf
They are named "ROUGH GUDE"; for detail information, you need official Genesys manuals/guides (with correct versions!) for detail configuration.
Manual manuals and materials are copyrighted and cannot be posted here.
Again, you should get required manuals from Genesys or reseller.
In your case, there is configuration error in Configuration layer in which it includes:
- database server (3-party component; MSSQL in your case)
- License Manager (3-party component; FlexLM, required for T-server in your case)
- Valid Genesys License file (you MUST have it to run t-server)
- Genesys DB server (master configuration db server)
- Genesys Configuration server
Client program: Genesys configuration manager, client of Genesys Configuration Server.
[MSSQL] ---- [Genesys DB server] ---- [Genesys configuration server] -----> (Genesys configuration manager)
|
+---- [T-server] ----- client programs (via SDK)
Management layer components (SCS, SCI, message server, db server for message server, ....) are skipped here
Media layer: T-server for voice interaction
Genesys DB server:
- uses TCP/IP protocol to connect to MSSQL database server
- MSSQL port 1433
- supports generic main program entry for different database system
- supports multiple threading (per connected client)
- reads text configuration options (as in configuration layer)
--> this is one of check points in your case; [b]file name = dbserver.cfg[/b]
dbserver.cfg
--------------- Start of file -----------
[dbserver]
[color=blue]host=myhost
port=4040
management-port =4041
dbprocesses_per_client=1
dbprocess_name=./dbclient_msql[/color]
#
oracle_name=./dbclient_oracle
informix_name=./dbclient_informix
msql_name=./dbclient_msql
sybase_name=./dbclient_sybase
db2_name=./dbclient_db2
#
connect_break_time=1200
tran_batch_mode=off
#
#---------- dbserver log options ----------
#
[log]
verbose = standard
standard = cfg_dbserver, network
segment = 5MB
buffering = true
expire = 20
# for Management layer components
[lca]
lcaport=4999
#
--------------- End of file -----------
Genesys Configuration server:
- reads text configuration options (as in configuration layer)
--> this is one of check points in your case; [b]file name = confserv.cfg[/b]
- contains "database connection string" (dbhost, dbserver, dbusername, dbpassword,...)
- validates configuration requests from Genesys Configuration Manager
- buffers configurations in memory
- propogrates configuration changed to ALL connected clients
confserv.cfg
--------------- Start of file -----------
[confserv]
[color=blue]port =2020
management-port =2021
server = cfg_dbserver[/color]
# keep for 32 days; 32 days x 24 x 3600
history-log-keep =2764800
# scan every hour; i.e, 3600 seconds
history-log-scan = 3600
history-log-save = file
history-log-file-size =512000
history-log-file-name =histlog
encryption = false
encoding = utf-8
[log]
verbose = standard
standard = confserv, network
#all = network
print-attributes = true
segment = 5MB
buffering = true
expire = 20
[hca]
schema = none
[[color=blue]cfg_dbserver[/color]]
[color=blue]host =myhost
port =4040
dbengine =mssql
dbserver =mydbserver
dbname =mydb
username =dbusername
password =dbpassword[/color]
server =
reconnect-timeout = 10
response-timeout = 600
[soap]
# for GIS
#port = 2022
#
--------------- End of file -----------
Total costs for proper training and tools will, in the long run, be much smaller than the total time you spend (working in the 'dark').
Good luck
-
Hi bcyk,
Eh, I try not to interpret that I am forced into this situation by my boss... ::)
Yes, I downloaded the ROUGH GUIDES last Thursdays, and got some useful information out of them. (mainly the architecture of the Genesys T-Server)
Anyways, I think we found out the cause of my problem last week. I put the wrong username/password in the confserv.cfg to access MS SQL... =/
Now, we am encountering another problem. It seems like when the conf_server established connection to the dbserver, it sends two SELECT queries to the MS SQL.
[code]
select so.name from sysobjects so where so.type='U' and (so.name = 'CFG_PARAMETERS' or so.name = 'cfg_parameters')
and
select address_line4, address_line5 from cfg_tenant where dbid=1
[/code]
The SQL server returns an error says "invalid object cfg_tenant" on the second query, then conf_server terminates.
Question1:
The MS-SQL server we have does not have any table, so we are wondering if there is a special genesys schema which I need to import to the MS-SQL before the dbserver and confserver can communicate with MS-SQL.
Question2:
We understand that there are several server needs to be installed to make T-Server work. Do we have to install every component to begin with? or can we install one server at a time to ensure one component is working before preceding to another?
I have attached two log files with the problem.
Thank you for your help
-
Guys, not to be bad or something but I disagree to provide all installation steps. This should be done by some certified Genesys we don't know what many other issues he will face and all this info is given in trainings.
Just my thinking.
-
Hey cavagnaro,
I am not asking for a step to step installation guides. I am just asking for help whenever I encounter a problem that I am unable to resolve. I guess the bottom line is "not all company can afford a training"
Judging by your title on the forum, you are probably well known in the forum. And I don't understand why you are denying "the poor" from gaining knowledge.. :-\
-
Oh no no, I like the fact that you like to learn, however if you see in the forum we all have some level of training, unless you are a simple programmer. The fact is that even after you have installed framework comes the part of licensing, connections between components, PBX configuration on Genesys, PBX configuration side, etc etc. It is much much deeper than you are doing. Now the fact that your company has a Genesys is that it is not any company who goes and buys an Asterisk, but bets for high solution and believe me, a bad implementation can be disastrous because later if you need Genesys support they will not give it because you are not a certified. So loosing all support just because your boss is impatient or want to save some bucks (never knew a Genesys sale without an implementation project with it) can be more damage than help. So I would recommend to wait for the specialist to come in, you sit on his side and see how all this is done. Later you will understand my point of view.
I'm always glad to help whenever I can but at this point and in your situation I think it is better to not do it in behalf of your project.
-
Yeah, we were thinking the PBX configuration can be a lot more complicated, but we are not going to connect a real PBX to the T-Server. (we don't even have a PBX to use for this project) We are just trying to connect the simulator to the T-Server so the T-Server can generate some events. So we hope it's not necessary to get a trainner yet.
Well, if we eventually failed at installing a T-Server, then so be it, but at least we tried. Does that make more sense?
Thanks
-
Actually...no.
If no PBX why you have a Genesys???? Sorry but too strange to me. And will not even ask about licensing.
-
We are not buying Genesys solution, we are buying SDK which integrates with Genesys solution. It's only for developement purposes.
The reason why we want to setup this simulated environment is because we want to see what Genesys events looks like, so we can process those events with our software. Your responded to my other thread, so I thought you know already. ;)
-
Alex,
where are you at in regards to the installation? Are you still geting tenant error?
Best regards,
Vic
-
Hum, ok...
So now I do want to ask about licensing. Do you have Genesys licenses? If not everything will be useless.
Now, you need to run the sql scripts that are on the cfgserver folder to start.
-
100% agreed with cavagnaro's comments!
HGinc, you will understand what he means once you have worked into Genesys details.
Unless one is not in the regular pay-roll, my commented [Total costs for proper training and tools will, in the long run, be much smaller than the total time you spend] stands!
I guess we (Genesys animals) are not pushing for anything on formal training or professional service.
The fact is that a formal (or equivalence) training course gives you basic knowledge only.
Large amount of time on manuals reading and trying is mandatory and essential in system design and deployment. Genesys SR (or trouble ticket) knowledege-base is another must-search resource for Genesys implementation. If under Genesys MA, you should be entitled to issue SR for Genesys support. (.....hummm.... it may help if your SR is assigned to an experienced engineer; otherwise, ..........)
It is not sure if there are "pre-requisites" being Genesys Gplus / SDK developer / Reseller. I'll personally very surprised and disappointed if there is none.
Listed components are for running simulated T-server (without CCPulse, skill, ....; agent mode and telephony features only); components in limegreen are optional.
Such environment can normally be completed within a day from scratch (assuming OS, DB, network, installatin media ready) by a trained staff if everything goes 'smoothly'.
Good luck and welcome to Genesys world!
---------------------------------------------------------------
Third-party components
A. Database server (MSSQL in your case)
B. FlexLM license Manager and [u]valid/legal Genesys license [/u] file
Framework components
1. Configuration Layer:
- DB Server
- Configuration Database
- Configuration Server
- Configuration Manager
[color=limegreen] - Configuration Wizard Framework (optional)
- Database Initialization Wizard (optional)
- Configuration Import Wizard (optional)[/color]
Configuration Database initialization
a. From the directory where Configuration Server is installed, open the sql_scripts folder.
b. Open C:\Program Files\GCTI\Singletenant Configuration Server\sql_scripts\mssql\ sql_scripts
c. Copy [b]init_single_mssql.sql [/b] and [b]CfgLocale_mssql.sql [/b] to temporary folder in which MS SQL Enterprise Manager or table creation tool/program is available
d. Load and execute the initialization script
Geneysys/telephony objects via Genesys Configuration Manager
In addition to installed Framework components, the following resources must be registered as Configuration Database objects (or configuration objects) at the time of the Framework deployment:
- Hosts
- Switching Offices
- Switches
- Agent Logins
- DNs
[color=limegreen] - Access Groups[/color]
[color=limegreen] - Skills[/color]
[color=limegreen] - Persons
- Agent Groups
- Places
- Place Groups[/color]
[color=limegreen]2. Management Layer:
- DB Server
- Message Server
- Log Database
- Local Control Agent (required for each computer running Genesys server applications or monitored third-party server applications)
- Solution Control Server (SCS)
- Solution Control Interface (SCI)[/color]
3. Media Layer:
- T-Server
4. Geneyss switch simulator
- refer to installation and configuration manuals
(... solutions such as reporting, inbound routing, outbound campaign, GVP, WFM, ... are not listed...)
-
Victor,
Yeah, I am still having that cfg_tenant error. The conf_server opened connection to the MS-SQL, the conf_server then sends two SELECT statements to the server, then terminated with an error.
I tried running those two statements manually in the MS-SQL, and those two statements seems invalid, so I thought maybe I need to import a predefined schema to the database... Is there are predefined schema that I have to import?
//////////////////////////////////////////
cavagnaro,
We understand there is a license involved because the genesys tech support had mentioned it to us.
However, he said the license doesn't come into play until we installed all the components, so we haven't gotten into it yet.
Okay, so those sql scripts are the "predefined definition" for the MS-SQL, right? I will give it a try tomorrow morning. Thanks.
//////////////////////////////////////////
Hi bcyk,
Yeah, I guess Genesys just count on the 3rd party developers to read hundreds and hundreds pages of PDF.... which I am trying accomplish right now..
I have a list of servers that I need to install in the office, but I don't think the list is as long as yours though. I will double check on it tomorrow.
Thank you
-
[quote author=HGinc link=topic=3763.msg16198#msg16198 date=1233035497]
Victor,
Yeah, I am still having that cfg_tenant error. The conf_server opened connection to the MS-SQL, the conf_server then sends two SELECT statements to the server, then terminated with an error.
I tried running those two statements manually in the MS-SQL, and those two statements seems invalid, so I thought maybe I need to import a predefined schema to the database... Is there are predefined schema that I have to import?
[/quote]
As bcyk wrote you need to the instructions to create the DB schemas;
Configuration Database initialization
a. From the directory where Configuration Server is installed, open the sql_scripts folder.
b. Open C:\Program Files\GCTI\Singletenant Configuration Server\sql_scripts\mssql\ sql_scripts
c. Copy init_single_mssql.sql and CfgLocale_mssql.sql to temporary folder in which MS SQL Enterprise Manager or table creation tool/program is available
d. Load and execute the initialization scripts(in the order mentioned in point c)
There should no problems in running these scripts as they have been around, in various guises for over 10 years.
As a newbie I think the first target should be to get DB Server, Config Server all installed and running so that you can run CME and then take it step by step.
Where are you in the world as I'm sure someone locally could give you a call to help?
Pavel
-
Hi all,
We just followed the procedures which cavagnaro, bcyk and Pavel suggested (to run the sql script), and it seems like the db server and the config server are communicating now. ;D
The newly installed configuration manager seems to be working properly as well.
We found the correct deployment guide yesterday!! so we will be following the guide for management layer installation. Hope it goes well.
Hey Pavel, I am located in California.
Thank you for all your help! I am sure I will be back for more ... :P
-
Hi all,
We are reading this Framework Deployment Guide, and it says we have to install DB Server for Management Layer as well. Do we have to install another DB Server? We have installed a DB Server for the Configuration Layer.
Thank you
-
1 dbserver per database with its own dap
-
[quote author=HGinc link=topic=3763.msg16219#msg16219 date=1233081618]
Hi all,
We just followed the procedures which cavagnaro, bcyk and Pavel suggested (to run the sql script), and it seems like the db server and the config server are communicating now. ;D
The newly installed configuration manager seems to be working properly as well.
We found the correct deployment guide yesterday!! so we will be following the guide for management layer installation. Hope it goes well.
Hey Pavel, I am located in California.
Thank you for all your help! I am sure I will be back for more ... :P
[/quote]
California.....
I'm in the UK so I can't help there.
-
[quote author=HGinc link=topic=3763.msg16189#msg16189 date=1233008022]
We are not buying Genesys solution, we are buying SDK which integrates with Genesys solution. It's only for developement purposes.
The reason why we want to setup this simulated environment is because we want to see what Genesys events looks like, so we can process those events with our software. Your responded to my other thread, so I thought you know already. ;)
[/quote]
First time that I see a company buying SDK without the assistance of an integrator or Genesys, i agree with cavagnaro : very strange ???
The solution Genesys Express was more suitable in this case.
In any case, the TSERVER will not start without valid licensing.
How will you deal with this problem?
-
[quote author=Sylvainsjc link=topic=3763.msg16228#msg16228 date=1233130950]
First time that I see a company buying SDK without the assistance of an integrator or Genesys, i agree with cavagnaro : very strange ???
The solution Genesys Express was more suitable in this case.
In any case, the TSERVER will not start without valid licensing.
How will you deal with this problem?
[/quote]
Dependent on how they are set up in the partner program, they could have no charge lab licenses. He hasn't responded, so we'll have to see if he is aware of this and just has neglected to mention it.
I'm next door in Arizona, but given the economy in California these days, I am afraid to cross the state border - AZ might not let me back in! ;D
-
Ok,
so what did you do this time around that made it work compared to the last one?
The only thing I can imagine is that you have a really old config server (pre 7.2) when they had a problem with some of the SQL statements. Very unlikely though...
-
Hey everyone,
We called Genesys tech support yesterday, and the tech was helpful and pointed us to a much needed installation guides - Management Layer User Guide and DB Server User Guide.
We also requested a license file through the website and it seems like we do not have to pay anything since the SDK purchase covered it already. (well, at least the person who gave us the license files never mentioned anything about license fee...) ;)
Hey victor, I think our config server is version 7.5, and it is working fine so far.
Anyway, we just finished installing the Management layer, LCA, Message Server, SCS, SCI ... etc
and we are about to install the T-Server...
As you know, we are using a simulator instead of a real PBX for our developement, so has anyone configured the T-Server to talk to the Simulator before?
I was walking through the documentations, and wasn't able to find one so far.
Thank you for all your help!
-
Hi all,
We found the documents! ;D
Simulator Test Toolkit Generic T-Server Reference Manual
Simulator Toolkit Generic T-Server Reference Information
Thanks
-
Hey all,
We finally got the simulation to work
Thank you for all your help! ;D