Hi,

I am new with PTXdist and don’t know if this is the right forum to seek help. We have just started a project with a Wago PFC200 (http://www.wago.com/wagoweb/documentation/750/eng_dat/d07508204_00000000_0en.pdf).

Our first goal is install a MySQL database server on the Wago PFC200 and access the database with php. I have used “ptxdist menu” and selected MySQL (“-*- mysql”) and php5 mysql extension (“php5->Extension->[*] mysql”). Afterwards I ran “ptxdist go” and created a new Wago PFC200 image. The php mysql extension is successfully tested on an external MySQL database.

But the MySQL database is not up running? When “>mysql” -> .

admin@PFC200-400FA9:/usr mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/' (13)

I have tried as root to run “mysql_install_db” –>   

bash-3.2# mysql_install_db

WARNING: The host 'PFC200-400FA9' could not be looked up with resolveip.

This probably means that your libc libraries are not 100 % compatible

with this binary MySQL version. The MySQL daemon, mysqld, should work

normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames

when specifying MySQL privileges !

Installing all prepared tables

Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server

to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'

/usr/bin/mysqladmin -u root -h PFC200-400FA9 password 'new-password'

See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run

the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be

able to use the new GRANT command!

You can start the MySQL daemon with:

cd /usr ; /usr/bin/mysqld_safe &

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

and then “mysqld_safe &” ->

bash-3.2# mysqld_safe &

[1] 2928

bash-3.2# Starting mysqld daemon with databases from /var

rm: /var/run: is a directory

STOPPING server from pid file /var/PFC200-400FA9.pid

140324 10:30:50  mysqld ended

[1]+  Done                    mysqld_safe

Hope somebody can help – thanks in advance!

Med venlig hilsen/Best regards



Lars Lindegaard Mikkelsen
Project Manager

Direct:  +45 5311 2916
email: llm@automationlab.dk

Forskerparken Svendborg
Kullinggade 31E
DK-5700 Svendborg
+45 53112910
mail@automationlab.dk
www.automationlab.dk