+- Networked Media Tank (http://www.networkedmediatank.com)
+-- Forum: Community Jukebox, Themes, & UserApps Section (/forumdisplay.php?fid=106)
+--- Forum: 200/300/400 Series - Development and User Apps (/forumdisplay.php?fid=121)
+--- Thread: [100/200/300/400] MySQL v5.5.29 (/showthread.php?tid=49867)
Pages: 1 2
MySQL v5.5.29 - vaidyasr - 02-14-2011 07:26 AM
MySQL database is the world's most popular open source database because of its fast performance, high reliability, ease of use, and dramatic cost savings.
Installation:
For 100 Series : O-PKG.
For 200/300 Series : O-PKG.
For 400 Series : O-PKG.
RE: [Apps] MySQL - C200/A200/A210 - WFX - 07-25-2011 11:36 PM
Hi vaidyasr,
I tried to install mysql by installing packages mysql-server-5 and php5-mysql but I got some errors :
for mysql-server-5 :
sh-3.00# Apps/local/bin/ipkg install mysql-server-5
Installing mysql-server-5 (5.5.5-1) to root...
Downloading http://sourceforge.net/projects/c200ipkg/files/mysql-server-5_5.5.5-1_mips.ipk
Configuring mysql-server-5
FATAL ERROR: Could not find /share/Apps/local/share/mysql/fill_help_tables.sql
If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.
If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location.
/share/Apps/local/etc/init.d/70mysqld.sh: line 263: /usr/bin/hostname: No such file or directory
Starting MySQL.. ERROR! The server quit without updating PID file (/share/Apps/local/var/.pid).postinst script returned status 1
ERROR: mysql-server-5.postinst returned 1
Configuring mysql-server-core-5
FATAL ERROR: Could not find /share/Apps/local/share/mysql/fill_help_tables.sql
If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation.
If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location.
/share/Apps/local/etc/init.d/70mysqld.sh: line 263: /usr/bin/hostname: No such file or directory
Starting MySQL.
ERROR! The server quit without updating PID file (/share/Apps/local/var/.pid).postinst script returned status 1
ERROR: mysql-server-core-5.postinst returned 1
Successfully terminated.
php5-mysql :
Configuring libdb4.2
Configuring libgcrypt11
Configuring libgdbm3
Configuring libgpg-error0
Configuring libsocket0
Configuring libxslt1.1
Configuring mysql-server-core-5
/share/Apps/local//share/Apps/local/lib/ipkg/info/mysql-server-core-5.postinst: line 13: /share/Apps/local/bin/mysql_install_db: No such file or directory
/share/Apps/local//share/Apps/local/lib/ipkg/info/mysql-server-core-5.postinst: line 20: /share/Apps/local/etc/init.d/70mysqld.sh: No such file or directory
postinst script returned status 127
ERROR: mysql-server-core-5.postinst returned 127
Configuring php5
Successfully terminated.
When I check the phpinfo, I don't have mysql enabled.
Can you give me the right procedure ?
Thanks
WFX
RE: [Apps] MySQL - C200/A200/A210 - vaidyasr - 07-26-2011 02:25 AM
I'll fix the package by today and you can reinstall via ipkg.
RE: [Apps] MySQL - C200/A200/A210 - WFX - 07-26-2011 03:38 PM
OK tell me when it's ok so I can try again and give you my feedback
Thanks !
WFX
RE: [Apps] MySQL - C200/A200/A210 - vaidyasr - 08-02-2011 01:14 PM
The package has been fixed in ipkg. Do a ipkg update.
RE: [Apps] MySQL - C200/A200/A210 - WFX - 08-02-2011 02:24 PM
Thanks !
I'll try it ASAP and give you a feedback.
WFX
RE: [Apps] MySQL - C200/A200/A210 - KidE79 - 09-02-2011 04:07 PM
(08-02-2011 01:14 PM)vaidyasr Wrote: The package has been fixed in ipkg. Do a ipkg update.
after install the installer shows:
FATAL ERROR: Could not find /share/Apps/local/libexec/mysqld
the file mysqld is not located inside the package
RE: [Apps] MySQL - C200/A200/A210 - vaidyasr - 09-02-2011 05:02 PM
I'll look into it on Monday, it seems I may missed some files in the package.
RE: [Apps] MySQL - C200/A200/A210 - KidE79 - 09-02-2011 05:14 PM
(09-02-2011 05:02 PM)vaidyasr Wrote: I'll look into it on Monday, it seems I may missed some files in the package.
please do look at both 5 and 5.5 because both are missing multiple files.
Please use hard coded paths because 5 will only config if your pwd is /share/Apps/local
RE: [Apps] MySQL - C200/A200/A210 - vaidyasr - 09-06-2011 10:24 AM
Have you tried to install mysql-server-5.5? The mysql-server-5 is an outdated version.
RE: [Apps] MySQL - C200/A200/A210 - KidE79 - 09-07-2011 09:53 AM
yes 5.5 deosnt install the binary mysqld either
[Apps] MySQL - C200/A200/A210 - fortify - 09-07-2011 01:44 PM
Hi everyone,
mysql-server-5 work perfectly on my A200.
You have to make some changes to work.
1. install only mysql-server-5 from ipkg
2. adduser -D -S -H -G nmt mysql
3. create a link :
#cd /share/Apps/local/libexec]
#ln -s /share/Apps/local/sbin/mysqld mysqld
4. change /etc/my.cnf
5. copy file "errmsg.sys" to /share/Apps/local/share/mysql/english
6. create initial database
# mysql_install_db --user=mysql
7. change in file: /share/Apps/local/bin/mysqld_safe
err_log=$DATADIR/`hostname`.err
pid_file="$DATADIR/`hostname`.pid"
8. start server
#cd /share/Apps/local
#./etc/init.d/70mysqld.sh start --default-storage-engine=myisam --skip-grant-tables
OBS: I don't know how to attach a file (my.cnf and errmsg.sys).
RE: [Apps] MySQL - C200/A200/A210 - vaidyasr - 09-07-2011 01:50 PM
(09-07-2011 01:44 PM)fortify Wrote: Hi everyone,I'll fix the ipkg with the above findings. Thanks.
mysql-server-5 work perfectly on my A200.
You have to make some changes to work.
1. install only mysql-server-5 from ipkg
2. adduser -D -S -H -G nmt mysql
3. create a link :
#cd /share/Apps/local/libexec]
#ln -s /share/Apps/local/sbin/mysqld mysqld
4. change /etc/my.cnf
5. copy file "errmsg.sys" to /share/Apps/local/share/mysql/english
6. create initial database
# mysql_install_db --user=mysql
7. change in file: /share/Apps/local/bin/mysqld_safe
err_log=$DATADIR/`hostname`.err
pid_file="$DATADIR/`hostname`.pid"
8. start server
#cd /share/Apps/local
#./etc/init.d/70mysqld.sh start --default-storage-engine=myisam --skip-grant-tables
OBS: I don't know how to attach a file (my.cnf and errmsg.sys).
RE: [Apps] MySQL - C200/A200/A210 - dc11ab - 09-07-2011 02:48 PM
(09-07-2011 01:44 PM)fortify Wrote: OBS: I don't know how to attach a file (my.cnf and errmsg.sys).
I'm not sure if all users have access to attach files, and which types, size limits etc., but if you make a "full" reply, below the input field there's a separate bar "Attachments" where you can add files to a post. (As I'm a moderator and not the admin this may only apply for mods and not normal users)
Another alternative is to upload files to the NMT Wiki, use the same credentials as for the NMT forum to login.
Yet another alternative is to share the files from some cloud storage/share file service like Dropbox, Sendfile, Megaupload etc. etc.
Thank's for investigating this mysql issue!
RE: [Apps] MySQL - C200/A200/A210 - KidE79 - 09-15-2011 06:51 AM
well mysql 5.5 doest this after install
Code:
PCH-A210[local]# ipkg list_installed | grep mysql
PCH-A210[local]# ipkg update
Downloading http://sourceforge.net/projects/c200ipkg/files/Packages
Updated list of available packages in /share/Apps/local/lib/ipkg/lists/c200local
Downloading http://sourceforge.net/projects/popcorn-ipkg/files/Packages
Updated list of available packages in /share/Apps/local/lib/ipkg/lists/popcorn-ipkg
Successfully terminated.
PCH-A210[local]# ipkg install mysql-server-5.5
Installing mysql-server-5.5 (5.5.13-1) to root...
Downloading http://sourceforge.net/projects/c200ipkg/files/mysql-server-5.5_5.5.13-1_mips.ipk
Installing libmysqlclient18 (5.5.13-1) to root...
Downloading http://sourceforge.net/projects/c200ipkg/files/libmysqlclient18_5.5.13-1_mips.ipk
Installing mysql-common (5.5.5-1) to root...
Downloading http://sourceforge.net/projects/c200ipkg/files/mysql-common_5.5.5-1_mips.ipk
Installing mysql-client-5.5 (5.5.13-1) to root...
Downloading http://sourceforge.net/projects/c200ipkg/files/mysql-client-5.5_5.5.13-1_mips.ipk
Installing mysql-server-core-5.5 (5.5.13-1) to root...
Downloading http://sourceforge.net/projects/c200ipkg/files/mysql-server-core-5.5_5.5.13-1_mips.ipk
Configuring libmysqlclient18
Configuring mysql-client-5.5
Configuring mysql-common
Configuring mysql-server-5.5
FATAL ERROR: Could not find ./share/mysql_system_tables.sql
If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.
If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.
Starting MySQL.The server quit without updating PID file (/var/run/PCH-A210.pid). ... failed!
postinst script returned status 1
ERROR: mysql-server-5.5.postinst returned 1
Configuring mysql-server-core-5.5
Successfully terminated.fix
Code:
cd mysql
ls *sql >sqlfiles
cd ../
for i in $(cat mysql/sqlfiles ); do ln -s mysql/$i $i; doneerror
Code:
FATAL ERROR: Could not find ./bin/mysqldfix
put this file in /share/Apps/local/bin Download File - 13.4 Mb
Code:
adduser -D -S -H -G nmt mysql
mkdir -p mysql/data
chown -R mysql:nmt mysql
bin/mysql_install_db --datadir=/share/Apps/local/mysql/data --user=mysqlnow you can start the db manual by bin/mysqld --user=mysql
run bin/mysqld-upgrade
pkill mysqld
change the init start script and chaneg the line:
Code:
basedir=
datadir=into
Code:
basedir=
datadir=/share/Apps/local/mysql/datavoila your done ;-)
Code:
7320 root 0:00 /bin/sh /share/Apps/local/bin/mysqld_safe --datadir=/share/Apps/local/mysql/data --pid-file=/var/run/PCH-A210.pid
7395 mysql 0:04 /share/Apps/local/bin/mysqld --basedir=/share/Apps/local --datadir=/share/Apps/local/mysql/data --plugin-dir=/share/Apps/local/lib/plugin --user=mysql --log-error=/share/Apps/local/mysql/data/PCH-A210.err --pid-file=/var/run/PCH-A210.pidCould somebody mod the package to accomodate these changes?