I am looking for advice about installing CIP in my company. My goal is to have a central database residing on a Linux RH server station running mySQL and having installed an ODBC interface to communicate with the clients.
I am following the "Component Information Portal™ (CIP) Installation Guide Version 4.3" and I am referring to Figure 1 - CIP architecture Diagram and "System Requirements at page 8
I have some basic questions first:
- what is CAPTURE.INI for? A sample capture.ini is delivered
- is the Web Server on the bottom left a PC running Windows 7 and the CIP Web engine? it should be always 'on' then?
- can the Web server reside on a client? probably not ...
- is the CIP-E / CIS Database (SQL) in the middle a database running on my Linux machine, then a mySQL database whith ODBC shell? I see in the picture "SQL 2005 or later" so I assume that a Microsoft SQL server is needed right, right? But I am supposing that a combo of ODBC+mySQL will also do the job
That means TWO servers in the company to support this???
- and the file server? is it a third server in the game?
I am really confused by this architecture diagram ... anyway I tried to move on so I installed the ODBC drivers for Linux RH from http://www.microsoft.com/en-us/download/confirmation.aspx?id=36437# and I installed them on my company server machine .
Then I am reading "Before you begin" and I see 'Gather required inputs, such as the Database Server name, Web Server name (if not the same as the Database Server), Database User Credentials, and the Centralized Location that will house the Cadence OrCAD Capture Symbols, Allegro PCB Footprints, Technical Datasheets and other essential files)'. I have no clue how to determine these names: do they pre-exists? probably the Database Server name is the IP address of the machine where the web server resides (or the CIP-E / CIS database of Figure 1??). Overall there is a lack of examples in this manual :(
I am thinking it is sufficient to have Linux RH machine on the intranet having ODBC and mySQl, right?
so far so (not too) good
I am moving to page 14 and Installing CIP. I assume the steps listed here are to be done sequentially with the manual page progression ... right?
Page 17 is a key page: I think I fall into this case "If you plan on using separate Database and Web Servers to host the CIP Database and CIP Web Engine, you can remotely install the Database to a desired SQL Server Instance" How can I remotely install blah blah blah? I look at Figure 10 now: what is <SQL SERVER NAME>? is the \\<ip address> of the machine where the ODBC+mySQL demon is running? on my linux machine I installed the ODBC and added two users to mySQL so I was thinking it was sufficient for Figure 8 (I check SQL server authentication using login ID and password below" but it does not work: I get the message box telling "There was an error logging in to Microsoft SQL server. Error [DBNETLIB] ConnectionOpen ... blah blah". So the installation program is looking for a Microsof SQL server. That means ODBC does not work? Is there only one SQL server in the game, residing in the CIP-E/CIS database right?
I tried to run CIP-E Starter Library first, with no success :( What is the name of the database catalog? Should I choose it and upposedly the instalaltion program will populate it by connecting to cadence? I choose one (but I see a browse button which makes me understand this is already existing: very confusing again) and go: now I get a different error "there was an error logging on to Microsoft SQL Server (it is STILL looking to a Microsoft server!) ... Specified SQL server not found"
Also database server has a dropdown lsit: how could I get it before logging in?
Figure 11 shows me that the system is PROBABLY trying to copy an existing database of component resing on the SQL databaes into the client (or the Web server? or the FIle Server: see Figure 1 again)
Anyway I cannot get there since I cannot connect according to dialog box in figure 10 or Figure
Some more info
MY odbc.ini on the Linux machine
[DSNname]Driver=SQL Server Native Client 11.0Description=Reference Design Srl ODBCTrace=YesServer=192.168.0.254Port=1433Database=NSCDB_3
# Allow small words in full-text indexes
# Allow packets up to 4MB
# Disabling symbolic-links is recommended to prevent assorted security risks
Thanks to who'll look into this