Benutzer-Werkzeuge

Webseiten-Werkzeuge


Seitenleiste

3D

INTERN

ADOBE

ARDUINO

BITBUCKET

DOCKER

C4D

GIT

HTML

IPHONE

JAVASCRIPT

JTL-SHOP

LARAVEL

MAGENTO2

MYSQL

PHP

PLESK

PROCESSING

PYTHON

SUITECRM

SEO

TRYTON

THUNDERBIRD / ICEDOVE / FossaMail

TYPO3

TYPO3: BACKEND

TYPO3: TYPOSCRIPT

UNIX

VLC

VVVV

WINDOWS

WINDOWS 10

WORDPRESS

XAMPP

XT:C 4 (Veyton)

filemaker-to-mysql

filemaker to mysql

00 (optional) create db and user on remote linux

(optional) create table filemaker and user with rights for db on localhost

mysql> create database 'filemaker';
mysql> grant all on filemaker.* to 'filemaker'@'localhost' identified by 'filemakerpass';

01 make ssh tunnel from windows-pc to target linux

  1. download and install bitvise ssh client (stays in tray on reboot and keeps ssh open)

bitvise konfiguration

–> 01-configure login data

–> 02-setup-client-to-server-portforwarding

–> 03-voila = testing with heidisql shows sql server ist accessible via localhost (yes, its the remote one)

02 install and configure mysql odbc driver for windows

  • In Windows go to ContolPanel\Administrative Tools and Click on Data Sources
  • IN German Windows the path is 'Systemsteuerung\Alle Systemsteuerungselemente\Verwaltung'
  • then Data Sources ODBX (Datenquellen ODBC)
  • start it and type the server data in a new mysql thingy in user-dsn AND system-dsn

connect filemaker to odbc/jdbc driver

  • [Filemaker]>File>Sharing>enable ODBC/JDBC

  • with opened filemaker db: File>Manage>Security>Privilege Sets
  • Tab:Extended privileges > double click on Access via ODBC/JDBC (fmxdbc) so this has rights = granted
  • then: File>Manage>Externel Data Sources
  • add new
  • Type: ODBC
  • choose DSN

filemaker-to-mysql.txt · Zuletzt geändert: 2015/02/10 10:45 von admin