Skip to content
View in the app

A better way to browse. Learn more.
Unraid

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
Unraid Summer Sale in live: 20% off Starter and Unleashed + buy one, get one 50% off

Webserver

josywong
in General Support (V5 and Older)

Featured Replies

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

    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

    • Archived

    This topic is now archived and is closed to further replies.

    Go to topic listing

    Account

    Navigation

    Search

    Search

    Configure browser push notifications
    Chrome (Android)
    1. Tap the lock icon next to the address bar.
    2. Tap Permissions → Notifications.
    3. Adjust your preference.
    Chrome (Desktop)
    1. Click the padlock icon in the address bar.
    2. Select Site settings.
    3. Find Notifications and adjust your preference.