TARGET 3001! PCB Design Freeware is a Layout CAD Software|Support, Tutorials, Shop - User contributions [en]

MySQL

2014-03-20T14:44:20Z

Giovanni: /* Set up / adapt a MySQL server and insert a TARGET 3001! data base */

[[image: mysqlight.png|SQLiteMySQL|right]] 
Have a look at the article [[Component database]] as well.
== MySQL: The powerful database for TARGET 3001! multiuser ==

If you are in a network with multiple workstations and want to use one common TARGET 3001! component database you will need to have the components stored in a '''MySQL database.''' The SQLite database being pre installed with TARGET 3001! performs in multi user situations with normal transfer rates very slowly though in standalone mode in our experience the SQLite database is in the lead.

== Download MySQL ==

[http://dev.mysql.com/downloads/mysql/ http://dev.mysql.com/downloads/mysql/] 

== Install a MySQL server ==

While the SQLite database works with only one DLL and one single database file, a MySQL database needs a MySQL server. This should preferably be installed on a separate server within the network or as an auxiliary on one of the workstations. The server has always to be on power if a client in the network wants to use TARGET 3001!.

Typically you will ask your system administrator to set up a MySQL server. Linux as well as Windows computers are suitable to run such a MySQL server. You will find several tutorials in the Internet to install MySQL to the various systems:

[http://www.google.de/#hl=en&q=mysql-server+installation+tutorial Google: MySQL installation]

== Set up / adapt a MySQL server and insert a TARGET 3001! data base ==
You have two options:
* Use a console (recommended)
* Use a browser application, e. g. phpMyAdmin (not recommended. Your server might be occupied up to 2 hours.)

'''NOTE''': User names ans passwords must not have more than 16 characters.

=== Using a console ===

'''Set up, adapt'''

Please set the following options to configure the server so that TARGET 3001! can access to the database correctly:

[mysqld]
thread_stack = 256K
query_cache_size = 32M
#bind-address = 127.0.0.1
bind-address = 0.0.0.0
max_allowed_packet=2M

[mysql]
max_allowed_packet=2M

The Linux configuration file is named "my.cnf", the Windows configuration file "my.ini".

'''Insert the initial TARGET 3001! database'''

In order to insert the initial TARGET 3001! component database to the MySQL server, you need a DUMP file of the database and a brief script file for the import. Whether you have a Linux or a Windows system, different scripts need to be started. Following the link please find a zip file containing all you need:

[http://server.ibfriedrich.com/download/mysql/mysql_target3001db.zip Dump and scripts]

Each script needs to be adapted according to the number of users. The MySQL server is setup after that.

=== Using phpMyAdmin or similar ===

The following section explains how to install the MySQL-DB target3001db with a browser application in order to administrate MySQL-databases (e.g. phpMyAdmin).

The dump import can take up to two hours. You should use the console (s. 4) not to block the server for too long time.

In your application you may enter the SQL-commands as text or by menus and dialogs. In terms of common understanding we denote the commands here as text.

'''The database target3001db etc.:'''

-- Create User 1, furnish him with rights needed *** if needed replace target3001user1 and target3001user1_password ***
GRANT USAGE ON *.* TO 'target3001user1'@'%' IDENTIFIED BY 'target3001user1_password';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON target3001db.* TO 'target3001user1'@'%';

-- Create User 2, furnish him with rights needed *** if needed replace target3001user2 and target3001user2_password ***
GRANT USAGE ON *.* TO 'target3001user2'@'%' IDENTIFIED BY 'target3001user2_password';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON target3001db.* TO 'target3001user2'@'%';

-- further User

-- create database
CREATE DATABASE target3001db CHARACTER SET utf8 COLLATE utf8_general_ci;

-- modify variables
-- To change a global variable you need the permission SUPER.
SHOW VARIABLES LIKE 'thread_stack';
-- if smaller than 256K, then:
SET GLOBAL thread_stack = 256K;
SHOW VARIABLES LIKE 'query_cache_size';
-- if smaller than 32M, then:
SET GLOBAL query_cache_size = 32M;
SHOW VARIABLES LIKE 'max_allowed_packet';
-- if smaller than 2M, then:
SET GLOBAL max_allowed_packet = 2M;

'''Now the DB-Dump is going to be imported without components (empty3001db.sql):'''

Not the whole dump with components at once! Remember the db has over 60MB but unfortunately the dump import always is limited, see image. Example phpMyAdmin:

[[Image: dumpimport_e.png]] 

[[media:empty3001db.zip|Download the Dump here.]] 

'''TARGET 3001! Online DB Update:'''
[[Update the component database|Load all components etc. from our server]]. The download only takes a few seconds but the dump import would take up to two hours. Your server/network would be charged accordingly. 

=== Particularity for Windows server ===

Required for Windows server (with console):

$ mysql -u root -p

or without password: $ mysql -u root

mysql> use mysql
mysql> GRANT ALL ON *.* to root@'%' IDENTIFIED BY '<your-mysql-root-password>';
mysql> FLUSH PRIVILEGES;

These setting you can also do with phpMyAdmin or the workbench.
 

== Setting up a MySQL client in TARGET 3001! ==

In the same directory as the TARGET 3001! program you will find a file called "libmysql.dll". It represents the client driver to connect to the MySQL server. In TARGET 3001! itself you need to enter few things in order to get response from the MySQL server:

Open an new project and press function key [F2] to open the component browser. At the end of the top menu line you will see that you are still connected to the SQLite database: 

[[image:mysql1_e.jpg]] (Image 1: Component browser, migration)
 
Now click on the menu entry "[ connected with ... ]". In the opening menu choose option "Settings". Now enter the following:

Start TARGET 3001! using MySQL database (enter "Yes")
MySQL Server (name or IP of your MySQL server)
MySQL User (your user name for the MySQL server)
MySQL Password (your respective password)
MySQL SSH Key (if SSH is used: SSH key file)
MySQL SSH Cert (if SSH is used: certificate file)
MySQL SSH CA (if SSH is used: certificate authority file)

== Insert your customized components (migration) ==

If you already created your own USER components in SQLite (target3001.db), you can import them '''once only''' from your TARGET 3001! version to the bare database provided by IBF. All component IDs and custom component types and so on remain the same in the database. We call this action "migration". Select the most important SQLite database from one of the several workstations. Further components from the other users can be added later on.

First use menu "[connected with...]" in order to switch to the MySQL database. In this menu select "Migration from SQLite to MySQL". Then enter this most important SQLite database target3001.db, which shall be migrated to MySQL. So the easiest way to perform the migration, is to do it on the computer with that most important SQLite database.

Now all clients will have access to the MySQL database.

[[de:MySQL]][[fr:MySQL]]

TARGET 3001! running on Mac

2009-10-05T13:07:46Z

Giovanni:

UNDER CONSTRUCTION!!! This article will be completed in the next few days.

http://en.wikipedia.org/wiki/Darwine

http://www.kronenberg.org/darwine/

http://www.codeweavers.com/

http://en.wikipedia.org/wiki/Microsoft_Virtual_PC

* ... PowerPC or Intel-Mac?
* ... Wine/Darwine, emulator or virtual machine?
* ... Reviews

File:Chaxpander.png

2009-04-21T12:28:24Z

Giovanni:

File:Bahn.png

2009-04-21T12:27:50Z

Giovanni:

File:Pic small solidedge.png

2009-04-21T12:27:01Z

Giovanni:

File:Step dialog en.png

2009-01-09T13:40:05Z

Giovanni:

File:Solidedge options 1.png

2009-01-08T11:17:57Z

Giovanni:

File:Solidedge options 2.png

2009-01-08T11:17:23Z

Giovanni:

File:Pic small ida-step.PNG

2009-01-07T13:56:13Z

Giovanni:

File:Ideal en.png

2008-11-19T14:48:52Z

Giovanni:

File:Uic 2 en.png

2008-11-19T14:43:18Z

Giovanni:

File:Uic 1 en.png

2008-11-19T14:42:59Z

Giovanni:

File:Not connected en.png

2008-11-19T14:29:09Z

Giovanni:

File:Sinus source ieee.png

2008-11-19T14:22:04Z

Giovanni:

File:Uic 3 en.png

2008-11-19T14:16:02Z

Giovanni:

File:Not connected.png

2008-11-18T08:32:29Z

Giovanni:

File:5Vref.png

2008-11-18T08:32:02Z

Giovanni:

File:Esel.png

2008-11-18T08:30:27Z

Giovanni:

Import extern models

2008-02-22T08:07:45Z

Giovanni:

Back to [[Model import or creation]]

If a modelcard or a subcircuit [[Models in (P)SPICE and TARGET 3001!]] is needed: 

'''Example:''' The component '''LF156''' (operation amplifier) in TARGET should get a model. 

'''
Searching for a model via Internet:''' 
'''USER:''' Search e.g. with Google.de: "LF156 model spice" 
'''GOOGLE:''' Site www.national.com/models/spice/LF/LF156.MOD found (model provided by the manufacturer National Semiconductor). 
'''USER:''' Save file LF156.MOD. 

'''Import, instance and pin assignment:''' 

Components in the schematic or in the library can be supplied with models. The operation is identical in both cases, starting from the models dialog. 

'''Either by calling the models dialog for a component in the schematic:''' 
'''USER:''' Doubleclick the symbol (see also chapter 8.1.3.2{8.1.3.2 Edit the circuit}). 
'''TARGET:''' Dialog "Change symbols" will appear. 
'''USER:''' Click the button "Models". 
'''TARGET:''' Dialog "Models for ..." (models dialog) will appear. 

'''Or by calling the models dialog for a component in the library:''' 
'''USER:''' Open the library browser; Press the function key F2 in the schematic view (also with the menu file). 
'''USER:''' Switch to the component selection and unfold the branch "IC\ANALOG\OpAmp". 
'''USER:''' Select the component LF156 with the right mouse button. 
'''TARGET:''' Popup menu will appear. 
'''USER:''' Select menu item "Edit component model". 
'''TARGET:''' Dialog "Models for ..." (models dialog) will appear. 

'''Starting from the models dialog:''' 
'''USER:''' Click the button "Search". 
'''TARGET:''' Model browser will appear. 
'''INFO:''' The left window shows all global modelcards and subcircuits in the library or in the schematic. 
'''USER:''' Click in the right window with the right mouse button. 
'''TARGET:''' Popup menu will appear. 
'''USER:''' Select menu item "Reload from..." and the following submenu item "Files with (P)SPICE models". 
'''USER:''' Load file LF156.MOD. 
'''TARGET:''' All models from the file will be listed in the right window; here only the model (subcircuit) LF156/NS. 
'''USER:''' Click the model LF156/NS with the right mouse button and select "Import" in the popup menu. 
'''TARGET:''' The model will be imported/copied into the left window. 
'''INFO:''' The model is now saved in the library or in the schematic, but still without any assignment to the component! 
'''USER:''' Click the model LF156/NS in the left window with the right mouse button and select "Create instance for component" in the popup menu. 
'''TARGET:''' The appropriate model dialog will appear; here for a subcircuit. 
'''USER:''' Now it is necessary to do the pin assignment! Click the button pin assignment. 
'''TARGET:''' Dialog for the pin assignment will appear, each pin of the component is listed in the left top window with its symbol affiliation, pin name and pin number. 
'''TARGET:''' All "pins" of the model are listed in the right bottom window; here the nodes of the subcircuit: 1, 2, 99, 50, 28 
'''INFO:''' The nodes of this subcircuit are unfortunately not meaningful, but the comment of a subcircuit usually contains information about the meaning of the nodes. 
'''USER:''' Click the button INFO (Load node info). 
'''TARGET:''' The subcircuit will be shown in its original text format (Spice text format). 
'''INFO:''' Comment lines always starts with a star "*". 
'''INFO:''' The node information are usually located directly over the line ".SUBCKT...". 
'''USER:''' Select the node information with the left mouse button and close the window. (Often it is necessary to select previously a suitable character font) 
'''TARGET:''' The selected text (node information) will appear in the info window of the pin assignment dialog. 
'''USER:''' Drag&Drop the pins (pin numbers) of the component from the left side to the nodes. 
'''USER:''' Quit pin assignment dialog and model dialog with the OK button. 
'''USER:''' Info and level (e.g. LEVEL = ANALOG) for the instance can be registered in the models dialog. 

If a further component in the schematic or in the library needs the same modelcard/subcircuit, then naturally the modelcard/subcircuit must not be imported again! Thus "Reload from" and also "Import" are void. 

[[category:Simulation]][[de: Fremde Modelle importieren]]