why don't you use mariadb ?@zyxmon
Unfortunately, after merge, package "mysql-server - 5.1.73-2" disappeared. Is it possible in the future to have "mysql server" package again? Thanks.
why don't you use mariadb ?@zyxmon
Unfortunately, after merge, package "mysql-server - 5.1.73-2" disappeared. Is it possible in the future to have "mysql server" package again? Thanks.
why don't you use mariadb ?
180327 18:50:25 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
180327 18:50:25 [Note] mysqld (mysqld 5.5.58-MariaDB) starting as process 16083 ...
180327 18:50:25 InnoDB: The InnoDB memory heap is disabled
180327 18:50:25 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
180327 18:50:25 InnoDB: Compressed tables use zlib 1.2.11
180327 18:50:25 InnoDB: Initializing buffer pool, size = 128.0M
180327 18:50:25 InnoDB: Assertion failure in thread 1074652080 in file ut0mem.c line 103
InnoDB: Failing assertion: ret || !assert_on_error
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
180327 18:50:25 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
To report this bug, see http://kb.askmonty.org/en/reporting-bugs
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Server version: 5.5.58-MariaDB
key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=27
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 25316 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x20000
(my_addr_resolve failure: fork)
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
total used free shared buffers
Mem: 255892 75232 180660 0 592
Swap: 262140 0 262140
Total: 518032 75232 442800
Github repository - https://github.com/Entware
aarch64 (kernel 3.10 and higher), packages - http://bin.entware.net/aarch64-k3.10/Packages.html
generic installer - http://bin.entware.net/aarch64-k3.10/installer/generic.sh
alternative installer http://bin.entware.net/aarch64-k3.10/installer/alternative.sh
armv7 (kernel 3.2 and higher), packages - http://bin.entware.net/armv7sf-k3.2/Packages.html
http://bin.entware.net/armv7sf-k3.2/installer/generic.sh
http://bin.entware.net/armv7sf-k3.2/installer/alternative.sh
These are for broadcom arm routers:
armv7 (kernel 2.6.36 and higher), packages - http://bin.entware.net/armv7sf-k2.6/Packages.html
http://bin.entware.net/armv7sf-k2.6/installer/generic.sh
http://bin.entware.net/armv7sf-k2.6/installer/alternative.sh
Hi, thank you for the reply,Type "opkg list-installed" (no quotes) in a term.
For more try "opkg --help"
edit
Then verify the packages using this url you quoted above.
aarch64 (kernel 3.10 and higher), packages - http://bin.entware.net/aarch64-k3.10/Packages.html
If they do not match then you likely have arm7 packages when you want arm8 for the 86U.
Use this installer - generic installer - http://bin.entware.net/aarch64-k3.10/installer/generic.sh
Yes, you will need to remove the arm7 version if you have confirmed that is what you have installed now. I'm not sure proper uninstall. I formatted my USB drive and reinstalled when entware-ng released.Hi, thank you for the reply,
How do I use the installer ?
Do I need to un-install Entware first ?
Thanks
This is a list of what I have, it looks upto date, I was just concerned about all the un-found links when installing but the packages seem to have downloaded.Yes, you will need to remove the arm7 version if you have confirmed that is what you have installed now. I'm not sure proper uninstall. I formatted my USB drive and reinstalled when entware-ng released.
Just download the aarch64 generic.sh, run chmod command to make it executable, then run it in the router terminal.
Those version numbers and the architecture versions match what I have on my AC86U, so I think you are good. Congrats! If I remember that is the basic install set.This is a list of what I have, it looks upto date, I was just concerned about all the un-found links when installing but the packages seem to have downloaded.
*****@RT-AC86U-Router:/tmp/home/root# opkg list-installed
entware-opt - 227000-3
entware-release - 1.0-2
entware-upgrade - 1.0-1
file - 5.25-2
findutils - 4.6.0-1
grep - 2.26-1
libc - 2.27-8
libgcc - 7.3.0-8
libmagic - 5.25-2
libncursesw - 6.1-1
libpcre - 8.41-2
libpthread - 2.27-8
librt - 2.27-8
libssp - 7.3.0-8
libstdcpp - 7.3.0-8
locales - 2.27-8
nano - 2.9.3-1
opkg - 2011-04-08-9c97d5ec-17b
terminfo - 6.1-1
zlib - 1.2.11-2
zoneinfo-asia - 2018c-1
zoneinfo-europe - 2018c-1
*****@RT-AC86U-Router:/tmp/home/root# opkg print-architecture
arch all 100
arch armv8-3x 150
arch aarch64-3.10 160
*****@RT-AC86U-Router:/tmp/home/root#
Does it look correct or should there be more ready installed ?
Thank you,
After you make sure that it is executable, thenThank you for your help , hopefully I will start to learn the commands better, still not sure how to run the .sh file on the router
sh /path_to_file/file_name.sh
Hi again,After you make sure that it is executable, then
Code:sh /path_to_file/file_name.sh
Take a look at the "Creating Scripts" section here.
https://github.com/RMerl/asuswrt-merlin/wiki/User-scripts
That Wiki has more info to help as you learn.
My AC87U setup (see footer) runs like a charm on firmware 384/NG - I had a stable and working setup on 380.69 (including VPN) and did the Entware/NG update there (running twice(!): opkg update && opkg upgrade) after some days of testing that Entware/NG is fine, I tried the firmware update to 384/NG without factory reset (dirty update) - and it works like a charm!Do I need to update the Entware packages on these devices? I have upgraded the firmware from 380.96_2 to 384.4_2 but no amount of factory resetting and manually reconfiguring could made the VPN work. The vpn just would not connect. I have reverted to the older firmware and have not upgraded to 380.70 because it also mentions the Entware update package.
You can place the file wherever you want. I just place and run temporary install scripts like this from /tmp/home/root.Hi again,
So would you copy the file to a spare folder on the routers attached drive ?
Then run CHMOD on it and then run something like sh /dev/sda2/files/entware_new.sh ?
What would be the CHMOD command to make the file executable ?
Thank you
On another question is there a minimum speed requirement for USB drive running the scripts, is there any advantage to having it on the USB3 or is USB2 fast enough ? (I have my hard drive with shared files on the USB3 ATM and a stick in USB2 with the scripts and swapfile on, obviously the USB3 hard drive is a lot faster but it is shared by SMB and UPnP server).
chmod a+rx /path_to_scripts/name.sh
You can place the file wherever you want. I just place and run temporary install scripts like this from /tmp/home/root.
Code:chmod a+rx /path_to_scripts/name.sh
I'll refer you again to the Wiki page on user scripts for the chmod command.
Take a look at the "Creating Scripts" section here.
https://github.com/RMerl/asuswrt-merlin/wiki/User-scripts
Hi, it’s the placing the file that I just cant seem to understand, its downloaded onto a windows computer and its getting it from there onto the root of the usb drive that I cant find info for ?
Or am I wrong in downloading it to my computer, is there a way to download it directly to the usb drives root ?
Very confusing when I have never even looked at Linux before, harder than windows :/
Thank you.
Ah ha. You need to look into Putty and WinSCP to get files from your Win computer to the router. There are many mentions here on SNB, and probably some tutorials on doing that.Hi, it’s the placing the file that I just cant seem to understand, its downloaded onto a windows computer and its getting it from there onto the root of the usb drive that I cant find info for ?
Or am I wrong in downloading it to my computer, is there a way to download it directly to the usb drives root ?
Very confusing when I have never even looked at Linux before, harder than windows :/
Thank you.
Ah ha. You need to look into Putty and WinSCP to get files from your Win computer to the router. There are many mentions here on SNB, and probably some tutorials on doing that.
I've used Linux off and on for 30 years and use it now on my desktop, so I cannot walk you through the basics, but search Putty and WinSCP here on SNB and the 'Net and you should find enough to get you running.
Good luck, have fun.
There is plenty of help on the 'Net these days to walk you through what you need to know. That and the Wiki pages or websites provided by the utilities here on SNB. I was comfortable with Linux, but not with technical aspects of networking when I jumped in here headfirst a year ago. With patience and lots of reading you can learn enough to be dangerous in a short time.I was going to run Linux on a desktop about 20 years ago just to learn how, I even installed Red Hat but when it opened up I just didn’t have the time to get my head around it, so ended up re-installing Windows.
I really wish i had taken the time now
Welcome To SNBForums
SNBForums is a community for anyone who wants to learn about or discuss the latest in wireless routers, network storage and the ins and outs of building and maintaining a small network.
If you'd like to post a question, simply register and have at it!
While you're at it, please check out SmallNetBuilder for product reviews and our famous Router Charts, Ranker and plenty more!