Schema editor can't find server

I’m trying to define a schema but keep getting this error message:
Server or database not available.

My server path is defaulted to: http://localhost/tamino

I was able to start the mydb database.

Is there a .ini file where the server path is defined.

Thanks!!

When using the Tamino Schema Editor you have to specify the database location and database name. When you select the “Define Schema” tab in the Schema Editor, a window will appear requesting you to select the Tamino location you want to connect to.

First step is to add your Tamino URL and you do this by selecting the “Connect to Server/Database” icon. This icon appears to the right of the “Look in:” tab. Once you selected the icon, another window will appear requesting you to specify the server URL, Database name and the user-id and password you want use to logon to your database.

In the “Server:” tab you enter “http://localhost/tamino
In the “Database:” tab you enter “mydb”
and lastly user-id and password to connect.

Once you successfully connected to the database, another window will appear requesting you to define the schema. You select the “Define” button and this should do the trick.

Hope this helps.

Regards
Theo

Thanks Theo!!
I have done those steps in the past but I get an error message saying that it cannot find the server or database. The server is specified as: http://localhost/tamino

I assume this is the default path. How may I confirm the server path?

I’ve also confirmed that I have a mydb database in the server and it is online.

Thanks.

There are various ways to verify the connection to the database. You can issue any of the following “commands” directly in your browser:

Ping Command
http://localhost/tamino/mydb?_diagnose=ping

Echo Command
http://localhost/tamino/mydb?_diagnose=echo

You could also issue these command from the Tamino Interactive Interface. You will note there is a tab at the top of the broweser window, which contains various options, i.e. XQuery, X-Query, Delete, Load, Define, Undefine, Diagnose and Authentication. Select the Diagnose option, this will then result in another page that contains several of the Tamino diagnose commands. You have to specify the correct database URL, i.e. http://localhost/tamino/mydb and then select the command you want to issue.

If you get the following response:

<?xml version="1.0" ?>
- <ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2”>
- <ino:message ino:returnvalue=“8201”>
<ino:messagetext ino:code=“INOXHE8201”>Can’t connect to server on host localhost at port 3210, TCP error code 10061.</ino:messagetext>
</ino:message>
</ino:response>

then it means there is an obvious error to connect to your database or your database might not be up and running. If you get this error, then the problem could be that you are unable to connect to the databse, because of the web server configuration.

Do the above mentioned steps and let me know if you still have a problem to connect to your database. If you still have a problem I will outline the steps you should take to verify your web server configuration.

Regards
Theo

Hi Theo,

I started mydb and then I issued the command
http://localhost/tamino/mydb?_diagnose=ping

and I got a “The page cannot be found” error.

It seems like I have a basic config problem here.

thanks.

First step is to check whether your webserver is up and running. You didn’t mention which web server you are using, but I’ll assume it is Apache. If it is Apache make sure it is started. The command you issued against the database is sent via HTTP and this is the reason why you need a web server up and running to connect to it. The SMH doesn’t use HTTP to connect to the database.

If your database is up and running make sure that the Tamino configuration information appears in the httpd.conf file of Apache.
This configuration information is usually added to the Apache configuration file during the Tmamino install process. The entries you are looking for will appear at the bottom of the httpd.conf file and should look like this:

#
# Software AG # Start # System Management Hub #
ScriptAliasMatch ^/smh/images2/(.) “C:/Program Files/Software AG/System Management Hub/bin/argmlcgi.exe/$1”
ScriptAliasMatch ^/smh/help/(.
) “C:/Program Files/Software AG/System Management Hub/bin/argmlcgi.exe/$1”
ScriptAlias /smh/cgi/ “C:/Program Files/Software AG/System Management Hub/bin/”
Alias /smh/ “C:/Program Files/Software AG/System Management Hub/htmllayer/”
# The following environment variables required for LDAP Administration
# Software AG # End # System Management Hub #
# Start Tamino Alias
Alias /tamino-v4.1.1.1/SDK/TaminoAPI4J/Documentation “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/SDK/TaminoAPI4J/Documentation”
Alias /tamino-v4.1.1.1/SDK/TaminoAPI4DotNET/Documentation “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/SDK/TaminoAPI4DotNET/Documentation”
Alias /tamino-v4.1.1.1/SDK/JScriptAPI/Documentation “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/SDK/JScriptAPI/Documentation”
Alias /tamino-v4.1.1.1/SDK/JavaDOM_API/Documentation “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/SDK/JavaDOM_API/Documentation”
Alias /tamino-v4.1.1.1/SDK/ActiveXAPI/Documentation “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/SDK/ActiveXAPI/Documentation”
Alias /tamino-v4.1.1.1/X_Tools/X_Plorer/Documentation “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/X_Tools/X_Plorer/Documentation”
Alias /tamino-v4.1.1.1/X_Tools/Tamino_Schema_Editor/Documentation “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/X_Tools/Tamino_Schema_Editor/Documentation”
Alias /tamino-v4.1.1.1/navig “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/navig”
Alias /tamino-v4.1.1.1/graphics “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/graphics”
Alias /tamino-v4.1.1.1/general “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/general”
Alias /tamino-v4.1.1.1/fts “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/fts”
Alias /tamino-v4.1.1.1/README.TXT “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/readme.txt”
Alias /tamino-v4.1.1.1/index.htm “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/index.htm”
Alias /tamino-v4.1.1.1/Documentation “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/Documentation”
Alias /tamino-v4.1.1.1/welcome “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/WelcomeToTamino”
Alias /tamino-v4.1.1.1/tii “C:/Program Files/Software AG/Tamino/Tamino 4.1.1.1/X_Tools/Tamino_Interactive_Interface”
Alias /tamino-v3.1.1.1/welcome “C:/Program Files/Software AG/Tamino/Tamino 3.1.1.1/WelcomeToTamino”
Alias /tamino-v3.1.1.1/tii “C:/Program Files/Software AG/Tamino/Tamino 3.1.1.1/X-Tools/Tamino Interactive Interface”
Alias /tamino-v3.1.1.1/taminodoc “C:/Program Files/Software AG/Tamino/Tamino 3.1.1.1/help”
# End Tamino Alias
# -------------------------------------------------------------------
#Software-AG–Tamino----
LoadModule ino_module modules/ApacheModuleIno.dll

<Location /tamino>
SetHandler ino

# -------------------------------------------------------------------
# End Tamino version

Please verify the above and let me know what you get.

Regards
Theo

Theo, sorry, I should have mentioned that my webserver is Microsoft’s IIS. 5.0

Theo,
Why am I having such basic problems? I expected the installation to configure Tamino so it can be functional.

thanks again.

In the Tamino documentation (under the section - ?Important Information before Starting the Installation?) you can find the following reference:

?Communication with Tamino can be done via an HTTP server (web server), as described in the section “Software Prerequisites” below. If you intend to use the Apache or Microsoft IIS HTTP server, please ensure that it is installed before you install Tamino, because the Tamino installation procedure automatically modifies the HTTP server’s configuration file for optimal use with Tamino.?

You will also note the documentation make reference to anti-virus software and what affect their presence during installation process might have. That said and done, let?s move on and see whether we can solve your problem. I don?t have IIS on my machine so I cannot verify all the information 100%.

I suggest you follow the steps outlined in the documentation to verify whether your IIS has been properly configured during the installation process. Refer to the following section in the Tamino documentation: file:///C:/Program%20Files/Software%20AG/Tamino/Tamino%204.1.1.1/Documentation/install/iwconfig.htm#msiis

Let me know whether this solved your problem. You could also consider installing Apache (from the Tamino installation CD) and test whether that solves your problem. The easiest might be to uninstall Tamino, install Apache, ensure Apache is up and running and then install Tamino again. This should solve your problem. If you would prefer to use IIS, then try the steps outlined in the documentation first.

Regards
Theo

Please find attached a document describing in detail the steps to follow for IIS and Apache. I found this document in a response posted by Trevor Ford. The Author of the document is Bill Leeney.

Here is the original thread:
http://tamino.forums.softwareag.com/viewtopic.php?p=5353

Regards
Theo
Tamino_Filter_installation.doc (72 KB)

If you are using IIS also make sure you don’t use “Url Scan”. This can cause problems because it rejects URL’s with “:” or “?” in them. I’ve known one or two customers get caught out with this.

Hope this helps.

Stuart Fyffe-Collins
Software AG (UK) Ltd.