josywong Posted June 25, 2013 Share Posted June 25, 2013 i played around with 5.0 and encounter a problem with webserver. tried to save some random site into the web folder and got them working but not when i try to connect to mysql thru php code. //mnt/user/web/test/ -> 192.168.1.6:8000/test/test.php it just show a blank page without error. php code <?php mysql_connect ("192.168.1.6", "root", "root") or die (mysql_error()); echo "Success.. Connected to MySQL...<br />"; mysql_select_db("testdb") or die(mysql_error()); echo "Success.. Connected to Database... "; ?> unraid: 5.0-rc15a SF, unmenu, mysql installed. able to create databases through telnet using mysql -u root -p root usr/bin/mysql Ver 14.14 Distrib 5.5.30, for Linux (i686) using EditLine wrapper //mnt/user/mysql/Server.err /usr/bin/tail -n 1000 -f //mnt/user/mysql/Server.err 130318 13:47:01 mysqld_safe Starting mysqld daemon with databases from /mnt/user/mysql 130318 13:47:01 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. 130318 13:47:01 InnoDB: Initializing buffer pool, size = 8.0M 130318 13:47:01 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file /mnt/user/mysql/ibdata1 did not exist: InnoDB: a new database to be created! 130318 13:47:01 InnoDB: Setting file /mnt/user/mysql/ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 130318 13:47:01 InnoDB: Log file /mnt/user/mysql/ib_logfile0 did not exist: new to be created InnoDB: Setting log file /mnt/user/mysql/ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 130318 13:47:01 InnoDB: Log file /mnt/user/mysql/ib_logfile1 did not exist: new to be created InnoDB: Setting log file /mnt/user/mysql/ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 130318 13:47:01 InnoDB: Started; log sequence number 0 0 130318 13:47:01 [Note] Event Scheduler: Loaded 0 events 130318 13:47:01 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.56-log' socket: '/var/run/mysql/mysql.sock' port: 3306 Source distribution 130320 9:03:08 [Note] /usr/libexec/mysqld: Normal shutdown 130320 9:03:08 [Note] Event Scheduler: Purging the queue. 0 events 130320 9:03:08 InnoDB: Starting shutdown... 130320 9:03:12 InnoDB: Shutdown completed; log sequence number 0 44233 130320 9:03:12 [Note] /usr/libexec/mysqld: Shutdown complete 130320 09:03:12 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended //mnt/user/mysql/aRaid.err /usr/bin/tail -n 1000 -f //mnt/user/mysql/aRaid.err 130622 00:53:33 mysqld_safe Starting mysqld daemon with databases from /mnt/user/mysql /usr/sbin/mysqld: /usr/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld) 130622 0:53:33 InnoDB: The InnoDB memory heap is disabled 130622 0:53:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130622 0:53:33 InnoDB: Compressed tables use zlib 1.2.5 130622 0:53:33 InnoDB: Using Linux native AIO 130622 0:53:33 InnoDB: Initializing buffer pool, size = 128.0M 130622 0:53:33 InnoDB: Completed initialization of buffer pool 130622 0:53:33 InnoDB: highest supported file format is Barracuda. InnoDB: 127 rollback segment(s) active. 130622 0:53:33 InnoDB: Waiting for the background threads to start 130622 0:53:34 InnoDB: 5.5.30 started; log sequence number 44233 130622 0:53:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130622 0:53:35 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130622 0:53:35 [Note] Server socket created on IP: '0.0.0.0'. 130622 0:53:35 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 130622 0:53:35 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 130622 0:53:35 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 130622 0:53:35 [Note] Event Scheduler: Loaded 0 events 130622 0:53:35 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 130622 1:03:23 [Note] /usr/sbin/mysqld: Normal shutdown 130622 1:03:23 [Note] Event Scheduler: Purging the queue. 0 events 130622 1:03:23 InnoDB: Starting shutdown... 130622 1:03:24 InnoDB: Shutdown completed; log sequence number 1589339 130622 1:03:24 [Note] /usr/sbin/mysqld: Shutdown complete 130622 01:03:24 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended 130622 01:07:32 mysqld_safe Starting mysqld daemon with databases from /mnt/user/mysql /usr/sbin/mysqld: /usr/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld) 130622 1:07:32 InnoDB: The InnoDB memory heap is disabled 130622 1:07:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130622 1:07:32 InnoDB: Compressed tables use zlib 1.2.5 130622 1:07:32 InnoDB: Using Linux native AIO 130622 1:07:32 InnoDB: Initializing buffer pool, size = 128.0M 130622 1:07:32 InnoDB: Completed initialization of buffer pool 130622 1:07:32 InnoDB: highest supported file format is Barracuda. 130622 1:07:32 InnoDB: Waiting for the background threads to start 130622 1:07:33 InnoDB: 5.5.30 started; log sequence number 1589339 130622 1:07:33 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130622 1:07:33 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130622 1:07:33 [Note] Server socket created on IP: '0.0.0.0'. 130622 1:07:33 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 130622 1:07:33 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 130622 1:07:33 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 130622 1:07:33 [Note] Event Scheduler: Loaded 0 events 130622 1:07:33 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 130622 01:15:39 mysqld_safe A mysqld process already exists 130622 1:16:42 [Note] /usr/sbin/mysqld: Normal shutdown 130622 1:16:42 [Note] Event Scheduler: Purging the queue. 0 events 130622 1:16:42 InnoDB: Starting shutdown... 130622 1:16:43 InnoDB: Shutdown completed; log sequence number 1589339 130622 1:16:43 [Note] /usr/sbin/mysqld: Shutdown complete 130622 01:16:43 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended 130622 01:17:32 mysqld_safe Starting mysqld daemon with databases from //mnt/user/mysql /usr/sbin/mysqld: /usr/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld) 130622 1:17:32 InnoDB: The InnoDB memory heap is disabled 130622 1:17:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130622 1:17:32 InnoDB: Compressed tables use zlib 1.2.5 130622 1:17:32 InnoDB: Using Linux native AIO 130622 1:17:32 InnoDB: Initializing buffer pool, size = 128.0M 130622 1:17:32 InnoDB: Completed initialization of buffer pool 130622 1:17:32 InnoDB: highest supported file format is Barracuda. 130622 1:17:32 InnoDB: Waiting for the background threads to start 130622 1:17:33 InnoDB: 5.5.30 started; log sequence number 1589339 130622 1:17:33 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130622 1:17:33 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130622 1:17:33 [Note] Server socket created on IP: '0.0.0.0'. 130622 1:17:33 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 130622 1:17:33 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 130622 1:17:33 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 130622 1:17:33 [Note] Event Scheduler: Loaded 0 events 130622 1:17:33 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution what am i doing wrong here? syslog.txt Quote Link to comment
dgaschk Posted June 25, 2013 Share Posted June 25, 2013 Post this issue in the web server forum. You are unlikely to find an appropriate expert in this forum. This forum is for issues with stock systems only. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.