Author Topic: "fresh" install on Ubuntu 13.10 and mysql 5.5.30  (Read 4316 times)

Offline jaybird2203

  • Decent Indexer
  • ***
  • Posts: 70
  • Helpful: +4/-0
"fresh" install on Ubuntu 13.10 and mysql 5.5.30
« on: 2014-04-07, 08:53:12 pm »
Hey Guys,

Ubuntu 13.10, mysql 5.5.30

After a had some issues with my existing DB, namely search and empty nzb's, I decided to drop the DB, delete all the files then start fresh. I'm constantly stuck at the following error on step 2 for multiple tables after step 1 shows all ok (additional tables that are affected: binaryblacklist, category, content, countries, forumpost, genres, groups, menu, site and tmux)

Code: [Select]
Inserting data into table: 'tvrage'
SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version

Any ideas? if anything is needed from me, let me know the correct commands and I'll update asap.

Offline mordor

  • Prolific Indexer
  • ****
  • Posts: 153
  • Helpful: +7/-0
    • autonzb
Re: "fresh" install on Ubuntu 13.10 and mysql 5.5.30
« Reply #1 on: 2014-04-07, 11:27:56 pm »
why dont you use mysql 5.6?

Offline kevin123

  • Overlord
  • ******
  • Posts: 456
  • Helpful: +49/-0
Re: "fresh" install on Ubuntu 13.10 and mysql 5.5.30
« Reply #2 on: 2014-04-08, 03:27:44 am »
Can you turn on all logging options in www/automated.config.php

Log file is in resources/logs/debug.log

Offline kevin123

  • Overlord
  • ******
  • Posts: 456
  • Helpful: +49/-0
Re: "fresh" install on Ubuntu 13.10 and mysql 5.5.30
« Reply #3 on: 2014-04-08, 04:42:44 am »
I tried installing and found 2 problems

LOAD DATA LOCAL INFILE
That needs to be LOAD DATA INFILE
in DbUpdate.php line 115.

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
That needs to be removed, line 117 step2.php

Offline jaybird2203

  • Decent Indexer
  • ***
  • Posts: 70
  • Helpful: +4/-0
Re: "fresh" install on Ubuntu 13.10 and mysql 5.5.30
« Reply #4 on: 2014-04-08, 03:10:38 pm »
I've been stuck at work for the last few hours, I'll try it when I get home in 2 hours.

Offline jaybird2203

  • Decent Indexer
  • ***
  • Posts: 70
  • Helpful: +4/-0
Re: "fresh" install on Ubuntu 13.10 and mysql 5.5.30
« Reply #5 on: 2014-04-08, 07:47:02 pm »
Ok, so I screwed up something and had to reinstall everything from scratch, including ubuntu desktop 13.10. I followed the install guide for 13.04 and everything seemed to flow, grabbed a fresh git clone, and tried to install again. Now instead of the previous error I'm getting this. Same tables as before, yet when I look at the folder location I can see the .tsv files are there.

Still using mySQL 5.5.35-0ubuntu0.13.10.2 - (Ubuntu) since it's straight forward when doing the apt-get install from the setup guide.

Should also mention that the mysql user is root still. Haven't been bothered to create a different user.

Code: [Select]
Inserting data into table: 'genres'
SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-genres.tsv' not found (Errcode: 13)

Log file shows

Code: [Select]
[08/Apr/2014 22:47] [INIT]   [Initiating new log file.]
[08/Apr/2014 22:47] [NOTICE] [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-binaryblacklist.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-binaryblacklist.tsv" IGNORE INTO TABLE `binaryblacklist` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (id, groupname, regex, msgcol, optype, status, description)]
[08/Apr/2014 22:47] [NOTICE] [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-category.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-category.tsv" IGNORE INTO TABLE `category` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (id, title, parentid)]
[08/Apr/2014 22:47] [NOTICE] [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-content.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-content.tsv" IGNORE INTO TABLE `content` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (id, title, url, body, metadescription, metakeywords, contenttype, showinmenu, status, ordinal, role)]
[08/Apr/2014 22:47] [NOTICE] [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-countries.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-countries.tsv" IGNORE INTO TABLE `countries` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (code, name)]
[08/Apr/2014 22:47] [NOTICE] [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-forumpost.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-forumpost.tsv" IGNORE INTO TABLE `forumpost` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (forumid, parentid, userid, subject, message, locked, sticky, replies)]
[08/Apr/2014 22:47] [NOTICE] [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-genres.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-genres.tsv" IGNORE INTO TABLE `genres` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (title, type)]
[08/Apr/2014 22:47] [NOTICE] [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-groups.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-groups.tsv" IGNORE INTO TABLE `groups` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (name, description, minfilestoformrelease, minsizetoformrelease)]
[08/Apr/2014 22:47] [NOTICE] [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-menu.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-menu.tsv" IGNORE INTO TABLE `menu` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (href, title, tooltip, role, ordinal, menueval)]
[08/Apr/2014 22:47] [NOTICE] [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-site.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-site.tsv" IGNORE INTO TABLE `site` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (setting, value)]
[08/Apr/2014 22:47] [NOTICE] [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-tmux.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-tmux.tsv" IGNORE INTO TABLE `tmux` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (setting, value)]
[08/Apr/2014 22:47] [NOTICE] [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-tvrage.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.20,0.20,0.13] [00H:00M:01S] [MEM:~768KB] [PID:2887] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-tvrage.tsv" IGNORE INTO TABLE `tvrage` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (id, releasetitle, country)]
[08/Apr/2014 22:47] [NOTICE] [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-binaryblacklist.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-binaryblacklist.tsv" IGNORE INTO TABLE `binaryblacklist` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (id, groupname, regex, msgcol, optype, status, description)]
[08/Apr/2014 22:47] [NOTICE] [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-category.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-category.tsv" IGNORE INTO TABLE `category` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (id, title, parentid)]
[08/Apr/2014 22:47] [NOTICE] [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-content.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-content.tsv" IGNORE INTO TABLE `content` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (id, title, url, body, metadescription, metakeywords, contenttype, showinmenu, status, ordinal, role)]
[08/Apr/2014 22:47] [NOTICE] [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-countries.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-countries.tsv" IGNORE INTO TABLE `countries` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (code, name)]
[08/Apr/2014 22:47] [NOTICE] [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-forumpost.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-forumpost.tsv" IGNORE INTO TABLE `forumpost` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (forumid, parentid, userid, subject, message, locked, sticky, replies)]
[08/Apr/2014 22:47] [NOTICE] [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-genres.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-genres.tsv" IGNORE INTO TABLE `genres` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (title, type)]
[08/Apr/2014 22:47] [NOTICE] [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-groups.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-groups.tsv" IGNORE INTO TABLE `groups` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (name, description, minfilestoformrelease, minsizetoformrelease)]
[08/Apr/2014 22:47] [NOTICE] [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-menu.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-menu.tsv" IGNORE INTO TABLE `menu` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (href, title, tooltip, role, ordinal, menueval)]
[08/Apr/2014 22:47] [NOTICE] [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-site.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-site.tsv" IGNORE INTO TABLE `site` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (setting, value)]
[08/Apr/2014 22:47] [NOTICE] [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-tmux.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-tmux.tsv" IGNORE INTO TABLE `tmux` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (setting, value)]
[08/Apr/2014 22:47] [NOTICE] [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [SQLSTATE[HY000]: General error: 29 File '/var/www/nZEDb/resources/db/schema/data/10-tvrage.tsv' not found (Errcode: 13)]
[08/Apr/2014 22:47] [SQL]    [0.14,0.18,0.12] [00H:00M:01S] [MEM:~768KB] [PID:2988] [DB.Exec] [LOAD DATA INFILE "/var/www/nZEDb/resources/db/schema/data/10-tvrage.tsv" IGNORE INTO TABLE `tvrage` FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY "\"" IGNORE 1 LINES (id, releasetitle, country)]
« Last Edit: 2014-04-08, 07:50:12 pm by jaybird2203 »

Offline zacharias

  • Newbie
  • *
  • Posts: 1
  • Helpful: +0/-0
Re: "fresh" install on Ubuntu 13.10 and mysql 5.5.30
« Reply #6 on: 2014-04-10, 11:36:43 am »
Hi,

Same problem here. Installed a fresh 3.10 installation of ubuntu (server/x64). Followed the instructions from the nZEDb-Guide. Also tried to fix the error with adding the "local-infile=1" parameter to "my.cnf" ยป still get the error.

BR/zacharias

Offline jaybird2203

  • Decent Indexer
  • ***
  • Posts: 70
  • Helpful: +4/-0
Re: "fresh" install on Ubuntu 13.10 and mysql 5.5.30
« Reply #7 on: 2014-04-10, 02:18:04 pm »
I gave up on the 13.10 install, went back to 13.04, installed mysql 5.5.30 then updated to 5.6.17. nZEDb installed finally although now I'm getting other errors when I attempt to update the db. Going to start a new thread for that.