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
[mysqld]# Allow small words in full-text indexesft_min_word_len=2# Allow packets up to 4MBmax_allowed_packet=4Mdatadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=root# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid
Thanks to who'll look into this
OrCAD Capture CIS running on Windows, using a MySQL ODBC driver communicating with a MySQL database running on Linux, possible. Refer to the cisug.pdf, in the doc\cisug directory of the Cadence SPB product installation, chapter on Setting Up OrCAD Capture CIS, your database will require, at least the four required fields, and any others that you need for your requirements, when you set up the ODBC connection, use the MySQL driver and configure that. You will need to configure a 32-bit ODBC source if you are running a 64-bit Windows edition. What is behind the ODBC configuration is transparent to OrCAD Capture CIS.
CIP is built to use Microsoft Windows based technologies, Microsoft Internet Information Services as the web server and Microsoft SQL Server as the database, these are listed as "requirements" in the CIP documentation. You can run OrCAD Capture CIS, Microsoft IIS and Microsoft SQL Server on the same client machine but this configuration is probably not too great for a multi-user environment. You can run Microsoft IIS and Microsoft SQL Server on the same machine for CIP, if required, you don't need to have dedicated Windows Server hardware for each function.
We're using MYSQL database for CIS and it's on a Linux server and working fine.
CIP is a cloud service that automates transferring information from part distributors to your CIS SQL database.
Deploying CIP may cause you to convert your existing CIS database to their schema structure. But, their database expert brilliantly designed their schema. The whole solution turned out to be the top reason to switch this company from Mentor Graphics.
The choice of operating system only matters where you deploy the CIP service. CIP is written to only work with Microsoft IIS web services. While it uses Java, it's a Microsoft executable. For a large number of users, investement in a MS-Server OS license will pay off.
But, my personal CIP license sits on the same WindowsXP machine as my MS-SQL2008R2/developer license plus Allegro on the whole thing.
For installation tips, contact EMA. They helped me get it online in an hour. Double check with EMA. But, I suspect you might have fewer problems with PostgreSQL over MySQL, as both Postgre and MS SQL are "ACID" compliant.
Was told by EMA today that MS-SQL and SQL-Express are the only SQL-flavors EMA supports.
OK, I get some confusing information about this. Somebody succeed to use mySQL with CIP, somebody else says that Microsoft is the only technology supported ...
I ask now if there it is possible (and possibly how) to put the component SQL database on a network driver and how to make CIP accessible outside the company intranet
Is this the BOM folder mentioned at page 23 of the installation guide?