January 16, 201313 yr Did you upgrade to nzbplus? I was having trouble after I upgrade then I: cd /tmp wget https://raw.github.com/kop1/newznab/master/db/latestregex.sql mysql -u USERNAME -p DATABASENAME < latestregex.sql And it fixed everything. You should not have to do this with nnplus. Did you put the ID you were emailed into the nn main settings page like instructed? When you do that it will download the regex's by itself each time the releases script is run.
January 16, 201313 yr I actually completely replace the newznab from the plugin with the nnplus version I got. I am sure you are right about the regex thing. I kept putting in my username they gave me instead of the keycode from the email, so that is probably why it wasn't working. I figured I would post the workaround in case it would help anyone. Mine is running great now. Does anyone have any suggestions for newsgroups not already listed?
January 16, 201313 yr Did you upgrade to nzbplus? I was having trouble after I upgrade then I: cd /tmp wget https://raw.github.com/kop1/newznab/master/db/latestregex.sql mysql -u USERNAME -p DATABASENAME < latestregex.sql And it fixed everything. fucking eh dude that did the trick!!! thanks a shit load lets see how long it stays functioning this time around lol Glad I could help.
January 16, 201313 yr Here is the code for the new mysql: <FILE Name="/boot/packages/mysql-5.5.29-i486-1gds.txz" Run="upgradepkg --install-new"> <URL>http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.29-i486-1gds.txz</URL> <MD5>529146b7ab863b4be7164e8bed340432</MD5> </FILE>
January 16, 201313 yr Did you upgrade to nzbplus? I was having trouble after I upgrade then I: cd /tmp wget https://raw.github.com/kop1/newznab/master/db/latestregex.sql mysql -u USERNAME -p DATABASENAME < latestregex.sql And it fixed everything. You should not have to do this with nnplus. Did you put the ID you were emailed into the nn main settings page like instructed? When you do that it will download the regex's by itself each time the releases script is run. i noticed afterwards when i was browsing the pages, that after i reinstalled everyting i didnt enter the ID in the "edit site" page lol. so i figured that was part of the reason also, but hey, why do it easy when u can do it the hard way with newznab in the past week or so, i learned how to change rights, owners, groups, copy, edit, update plg with the new mysql link, rebuild/repair mysql databases, backup databases, still gotta figure how to restore the backups though lol, but hey, it's an ongoing project
January 16, 201313 yr I'm using Tybio's newznab_cron.sh script and that works great https://github.com/Tybio/mux Exactly what I was trying to find. Thank you!
January 16, 201313 yr I can't get the script to work I get: Jan 16 16:54:21 Tower emhttp: title not found Jan 16 17:03:37 Tower emhttp: title not found Jan 16 17:05:23 Tower emhttp: title not found Jan 16 17:10:01 Tower crond[1164]: exit status 126 from user root /mnt/user/appdata/newznab/misc/update_scripts/nix_scripts/newznab_cron.sh -p 1> /dev/null Jan 16 17:10:01 Tower crond[5967]: unable to exec /usr/sbin/sendmail: cron output for user root /mnt/user/appdata/newznab/misc/update_scripts/nix_scripts/newznab_cron.sh -p 1> /dev/null to /dev/null
January 17, 201313 yr I can't get the script to work I get: Jan 16 16:54:21 Tower emhttp: title not found Jan 16 17:03:37 Tower emhttp: title not found Jan 16 17:05:23 Tower emhttp: title not found Jan 16 17:10:01 Tower crond[1164]: exit status 126 from user root /mnt/user/appdata/newznab/misc/update_scripts/nix_scripts/newznab_cron.sh -p 1> /dev/null Jan 16 17:10:01 Tower crond[5967]: unable to exec /usr/sbin/sendmail: cron output for user root /mnt/user/appdata/newznab/misc/update_scripts/nix_scripts/newznab_cron.sh -p 1> /dev/null to /dev/null exit status 126 was the same issue i had here http://lime-technology.com/forum/index.php?topic=24676.msg219055#msg219055 . as i said there, in my case was just me being stupid and didnt download/save the cron.sh file correctly. so it was a windows file, instead of linux... so i copied one of the existing *.sh files and copied the text in there, made sure in notepad++ it said unix and it all started working. but i managed to brake something on mine again. i have now mutliple cron.sh jobs running... not sure how i've managed this, it is still grabbing releases though. also the logs page under SF is now most of the times inaccessible unless i delete the cron.log file manually from /logs directory
January 17, 201313 yr You can edit the cron file by doing: crontab -e Just delete duplicates if you see them. You may be right about the windows file. I will try again when I get home.
January 17, 201313 yr You were correct. If you don't save it correctly it puts ^M in the script which makes it not work.
January 17, 201313 yr I have re install everything, now I cant get mysql to work, got this in newznab The following error(s) were encountered: • Unable to select database Using mysql-5.5.29-i486-1gds.txz I have done chmod 777 /tmp Mysql installed on /mnt/cache/.mysql/ What is this ;-) EDIT I see this in my syslog Jan 17 17:33:12 tower useradd[10682]: failed adding user 'mysql', data deleted (Minor Issues) and this in mysgl log 130117 17:33:06 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended 130117 17:33:12 mysqld_safe Starting mysqld daemon with databases from /mnt/cache/.mysql 130117 17:33:12 InnoDB: The InnoDB memory heap is disabled 130117 17:33:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130117 17:33:12 InnoDB: Compressed tables use zlib 1.2.5 130117 17:33:12 InnoDB: Using Linux native AIO 130117 17:33:12 InnoDB: Initializing buffer pool, size = 128.0M 130117 17:33:12 InnoDB: Completed initialization of buffer pool 130117 17:33:12 InnoDB: highest supported file format is Barracuda. 130117 17:33:12 InnoDB: Waiting for the background threads to start 130117 17:33:13 InnoDB: 1.1.8 started; log sequence number 1595675 130117 17:33:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130117 17:33:13 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130117 17:33:13 [Note] Server socket created on IP: '0.0.0.0'. 130117 17:33:13 [Note] Event Scheduler: Loaded 0 events 130117 17:33:13 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution //Peter
January 17, 201313 yr You can edit the cron file by doing: crontab -e Just delete duplicates if you see them. 45 minutes later, tring to figure out how to save the edited crontab lol :wq is the magic one... deleted all entries i made, to see if it stops, then i'll re add later as there were no duplicates
January 17, 201313 yr I have re install everything, now I cant get mysql to work, got this in newznab The following error(s) were encountered: • Unable to select database Using mysql-5.5.29-i486-1gds.txz I have done chmod 777 /tmp Mysql installed on /mnt/cache/.mysql/ What is this ;-) EDIT I see this in my syslog Jan 17 17:33:12 tower useradd[10682]: failed adding user 'mysql', data deleted (Minor Issues) and this in mysgl log 130117 17:33:06 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended 130117 17:33:12 mysqld_safe Starting mysqld daemon with databases from /mnt/cache/.mysql 130117 17:33:12 InnoDB: The InnoDB memory heap is disabled 130117 17:33:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130117 17:33:12 InnoDB: Compressed tables use zlib 1.2.5 130117 17:33:12 InnoDB: Using Linux native AIO 130117 17:33:12 InnoDB: Initializing buffer pool, size = 128.0M 130117 17:33:12 InnoDB: Completed initialization of buffer pool 130117 17:33:12 InnoDB: highest supported file format is Barracuda. 130117 17:33:12 InnoDB: Waiting for the background threads to start 130117 17:33:13 InnoDB: 1.1.8 started; log sequence number 1595675 130117 17:33:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130117 17:33:13 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130117 17:33:13 [Note] Server socket created on IP: '0.0.0.0'. 130117 17:33:13 [Note] Event Scheduler: Loaded 0 events 130117 17:33:13 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution //Peter i was always worried about the user "mysql" could not be added in te log file, but it doesnt mean shit apparently the log below, is exactly same as mine and mine runs fine... only thing i see is running with the /.mysql/ library. i read before that mysql doesnt like hidden directories with .mysql. i ended up converting all my plugins to a cache only share recommended one was /cache/apps apps being the cache only share
January 17, 201313 yr I changed path of mysql , its running , same as previuse path, but I cant connect using newznab or spotweb ps -ef | grep mysql root 840 1 0 18:19 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/mnt/cache/mysql5 --pid-file=/var/run/mysql/mysql.pid --user=mysql mysql 1150 840 0 18:19 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/mnt/cache/mysql5 --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/mnt/cache/mysql5/tower.err --pid-file=/var/run/mysql/mysql.pid --socket=/tmp/mysql.sock --port=3306
January 17, 201313 yr These command works, but can't use web interface to configure it Run this command Code: [select] mysql -u root -p Type in mysql password. you should see something like this if you're connected Code: [select] mysql> Type this command in to create database Code: [select] CREATE DATABASE spotweb; this will create 'spotweb' database. Type Code: [select] exit To exit out of mysql command.
January 17, 201313 yr You can edit the cron file by doing: crontab -e Just delete duplicates if you see them. 45 minutes later, tring to figure out how to save the edited crontab lol :wq is the magic one... deleted all entries i made, to see if it stops, then i'll re add later as there were no duplicates You can do too.
January 17, 201313 yr I have re install everything, now I cant get mysql to work, got this in newznab The following error(s) were encountered: • Unable to select database Using mysql-5.5.29-i486-1gds.txz I have done chmod 777 /tmp Mysql installed on /mnt/cache/.mysql/ What is this ;-) EDIT I see this in my syslog Jan 17 17:33:12 tower useradd[10682]: failed adding user 'mysql', data deleted (Minor Issues) and this in mysgl log 130117 17:33:06 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended 130117 17:33:12 mysqld_safe Starting mysqld daemon with databases from /mnt/cache/.mysql 130117 17:33:12 InnoDB: The InnoDB memory heap is disabled 130117 17:33:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130117 17:33:12 InnoDB: Compressed tables use zlib 1.2.5 130117 17:33:12 InnoDB: Using Linux native AIO 130117 17:33:12 InnoDB: Initializing buffer pool, size = 128.0M 130117 17:33:12 InnoDB: Completed initialization of buffer pool 130117 17:33:12 InnoDB: highest supported file format is Barracuda. 130117 17:33:12 InnoDB: Waiting for the background threads to start 130117 17:33:13 InnoDB: 1.1.8 started; log sequence number 1595675 130117 17:33:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130117 17:33:13 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130117 17:33:13 [Note] Server socket created on IP: '0.0.0.0'. 130117 17:33:13 [Note] Event Scheduler: Loaded 0 events 130117 17:33:13 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution //Peter I had a similar problem but I couldn't even connect to the database via telenet. I ended up just installing the unmenu version of mysql and everything works fine now.
January 17, 201313 yr going to try that, but is very old mysql in unmenu? see if I can upgrade it. //Peter
January 18, 201313 yr I am getting this error now. I think the cron script is causing it: [17-Jan-2013 23:53:22 UTC] PHP Warning: preg_split(): Compilation failed: unknown option bit(s) set at offset 0 in /mnt/user/appdata/newznab/www/lib/smarty/plugins/shared.mb_wordwrap.php on line 25 [17-Jan-2013 23:53:22 UTC] PHP Warning: Invalid argument supplied for foreach() in /mnt/user/appdata/newznab/www/lib/smarty/plugins/shared.mb_wordwrap.php on line 30 [17-Jan-2013 23:53:22 UTC] PHP Warning: preg_split(): Compilation failed: unknown option bit(s) set at offset 0 in
January 18, 201313 yr The script was still in the wrong format. I am not getting that error anymore. My script always fails for the rar part. What are people putting for the path to unrar?
January 18, 201313 yr The script was still in the wrong format. I am not getting that error anymore. My script always fails for the rar part. What are people putting for the path to unrar? /usr/bin/unrar same goes for mediainfo + lame + ffmpeg. Installed manually or keeping inside the /boot/extra directory on the flash drive to install auto on reboot
January 19, 201313 yr I still have issue to connect from newznab webpage & spotweb, I have tested unmenu-mysql, same issue, so I'm back with the latest mysql plugin I can connect using PHPMyadmin ,and I can create database manually, so it's looks like mysql are installed fine and working, below is the log from the SF webserver, there are a few errors, but I don't know if these are bad? Anyone that have newznab up and running maybe coild verify my log below //Peter [19-Jan-2013 07:59:19 UTC] PHP Warning: Unknown: POST Content-Length of 41 bytes exceeds the limit of 10 bytes in Unknown on line 0 [19-Jan-2013 07:59:19 UTC] PHP Notice: Undefined index: host in /mnt/cache/www/newznab_plus/www/install/step2.php on line 19 [19-Jan-2013 07:59:19 UTC] PHP Notice: Undefined index: user in /mnt/cache/www/newznab_plus/www/install/step2.php on line 20 [19-Jan-2013 07:59:19 UTC] PHP Notice: Undefined index: pass in /mnt/cache/www/newznab_plus/www/install/step2.php on line 21 [19-Jan-2013 07:59:19 UTC] PHP Notice: Undefined index: db in /mnt/cache/www/newznab_plus/www/install/step2.php on line 22 [19-Jan-2013 08:00:48 UTC] PHP Warning: preg_replace(): Compilation failed: unknown option bit(s) set at offset 0 in /mnt/cache/www/newznab_plus/www/lib/smarty/plugins/modifier.truncate.php on line 35 [19-Jan-2013 08:01:01 UTC] PHP Warning: Unknown: POST Content-Length of 45 bytes exceeds the limit of 10 bytes in Unknown on line 0 [19-Jan-2013 08:01:01 UTC] PHP Notice: Undefined index: host in /mnt/cache/www/newznab_plus/www/install/step2.php on line 19 [19-Jan-2013 08:01:01 UTC] PHP Notice: Undefined index: user in /mnt/cache/www/newznab_plus/www/install/step2.php on line 20 [19-Jan-2013 08:01:01 UTC] PHP Notice: Undefined index: pass in /mnt/cache/www/newznab_plus/www/install/step2.php on line 21 [19-Jan-2013 08:01:01 UTC] PHP Notice: Undefined index: db in /mnt/cache/www/newznab_plus/www/install/step2.php on line 22 ==> /mnt/cache/www/newznab_plus <== This is strin 35 in modifier.truncate.php , migh tbe a issue with UTF8 ?? $string = preg_replace('/\s+?(\S+)?$/' . Smarty:_UTF8_MODIFIER, '', mb_substr($string, 0, $length + 1, Smarty:_CHARSET));
January 19, 201313 yr I gave up. With the unmenu mysql, it was deleting my database everytime I restarted and with the 5.5 mysql I would get the error that it couldn't add the user mysql. I have a membership to 2 newznab sites that other people are doing for the next 2 years so if both of those go down or in 2 years I may try doing my own newznab again.
January 19, 201313 yr I gave up. With the unmenu mysql, it was deleting my database everytime I restarted and with the 5.5 mysql I would get the error that it couldn't add the user mysql. I have a membership to 2 newznab sites that other people are doing for the next 2 years so if both of those go down or in 2 years I may try doing my own newznab again. i know the feeling... mine seems to work for a day or two and then decides to stop updating shit... i gave spotweb a go along side newznab and it was a lot easier to setup to begin with. but also close to just say fuck it. not worth the headaches
Archived
This topic is now archived and is closed to further replies.