Ubuntu 18.04 apparantly offline? and yet I can browse fine

So I got this VM up and running with Plex andNextcloud a while ago but I’ve not been happy with the plex performance so I wanted to move it from a snap install to a regular install but apparantly I can’t install plexmediaserver because I’m offline??

Makes no sense to me – I can use the browser just fine as well as run apt updates and still access my nextcloud and plex installs

Anyone have any ideas?

my network icon in the top left says “wired unmanaged” and has a little x in the bottom right of the icon and if I click connect in the drop-dwon nothing happens…

List “filters pane” works fine for text STARTING WITH. But how to filter on text that CONTAIN words?

In Sharepoint 365 I created a list and by default you can filter with the filter pane. For instant I have a company colum and a company name in ABC International. I want to filter for all compies with INTERNATIONAL in the name. That seems not possible because the filter pane on the page only allows you to search for text that “begins with” … How to search for items that CONTAINS your text you want to filter on?

The code is fine?

Hi.

I have started a programming bootcamp in Barcelona.

In the first exercise, they gave us a design made in sketch, and between three peo… | Read the rest of http://www.webhostingtalk.com/showthread.php?t=1771990&goto=newpost

Magento 2.3.2 – Search is not working fine

I setup my store to search for product name but is not working fine. For example my product name is Battery LG SQU-804 11.1V 4400mAh/49Wh .

If I search like this BATTERY LG SQU-804 I will not get any result, however if I search for BATTERY SQU-804 I will get results.

Also I changed clause="should" to clause="must" in this file vendor/magento/module-catalog-search/etc/search_request.xml

but without any success.

What I can do?

Thanks

Stored procs fine tuning for processing bulk data – 5 million records

I have the below procedure which is used for bulk upload data from a temporary table (temp_rules_master) into two other related tables.

It has 5 million records. The actual 5 million records to temp table upload take less than 10 mins.

But later the below procs takes around 10 hrs for running through all those 5 million records and do the processing.

Is there any way to improve the speed?

Stored Procedure:-

DELIMITER $  $   DROP PROCEDURE IF EXISTS load_rules$  $    CREATE PROCEDURE load_rules() BEGIN     DECLARE finished INTEGER DEFAULT 0;     DECLARE groupname,starting_material_code,lower_limit,higher_limit,description,severity,active,create_date,created_by VARCHAR(255);     DECLARE cur CURSOR FOR SELECT r.groupname,r.starting_material_code,r.lower_limit,r.higher_limit,r.description,r.severity,r.active,r.create_date,r.created_by from temp_rules_master r;     DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished = 1;      OPEN cur;      read_loop: LOOP         FETCH cur INTO groupname,starting_material_code,lower_limit,higher_limit,description,severity,active,create_date,created_by;          IF finished = 1 THEN              LEAVE read_loop;         END IF;          /* Checks if an error already exists for the groupname */         IF (SELECT ce.id FROM compatibility_error ce WHERE ce.code=groupname) THEN             /* if exists use the existing error */             BEGIN                 SELECT ce.id INTO @ERROR_ID FROM compatibility_error ce WHERE ce.code=groupname;             END;         ELSE             /* If no error exists for the groupname create a new error record */             BEGIN                 insert into compatibility_error(active,create_date,created_by,modified_by,modified_date,code,description,severity)                      values(true,create_date,0,0,NOW(),groupname,description,severity);                 SET @ERROR_ID=LAST_INSERT_ID();             END;         END IF;          /* Checks if starting material exists */         IF (select id from starting_material sm where sm.code=starting_material_code) THEN             BEGIN                 select id INTO @SM_ID from starting_material sm where sm.code=starting_material_code;             END;         ELSE             BEGIN                 SET @SM_ID = null;             END;         END IF;          /* Insert rule */         select UPPER(md5(UUID())) INTO @CODE;         insert into compatibility_rule(active,create_date,created_by,modified_by,modified_date,code,description,groupname,higher_limit,lower_limit,compatibility_error_id,starting_material_id)              values(true,create_date,0,0,NOW(),@CODE,description,groupname,higher_limit,lower_limit,@ERROR_ID,@SM_ID);         END LOOP read_loop;      CLOSE cur;      select 'done...'; End$  $    DELIMITER ; 

Lenovo Legion PXI-E61 Media Test Failure, Check Cable. Exiting PXE ROM. Then restarts and works fine

After a series of unfortunate events, I was finally able to install ubuntu 19.04 in my Lenovo Legion Y530. I had to install the OS for like 10 times after erasing the last ubuntu installation again and again. (after erasing the preinstalled windows 10 for the first time) and in Legacy Mode. Now the problem I am facing is the following:

When I start the machine, after displaying Legion logo, the following message comes:

Intel UNDI , PXE 2.1 ....Realtek PCIe GBE family controller series v2.66... PXE-E61: Media Test Failure, check cable. PXE-M0F: Exiting PXE ROM. 

After that, it shuts down, starts again and loads ubuntu properly

Specs and other info:

Lenovo Legion Y530 No Dual Boot HDD (No SDD) 8 GB RAM 4 GB NVIDIA GeForce 1050 Ubuntu 19.04 Legacy Mode 

I don’t know why is it happening?

Is my code fine in the areas of read and write?

What:

This is a code that when executed simply writes packet to certain file types. Packet is very simple and contains things like:

description, partCount, price... 

Please:

  1. Ignore the usage of namespace std; as this is for educational purposes, mostly. It will most likely not be reproduced in a real program.
  2. Focus on reviewing the read and write portions as I would love feedback on those portions.
  3. I used some other things for simplicity, but in general I am mainly looking for feedback on read/write portions of the code.

Intent:

I’m specifically looking for feedback on the read and write portions of the code. Could I get feedback on it as well as is it feasible as a piece of code and what can I improve on/etc.???

Main.cpp:

#include <iostream> #include <fstream> #include <vector>  #include "Packet.h"  using namespace std;  int main() {     cout << "----------------------------------------------------" << endl;     cout << "Input and Output Filing System" << endl;     cout << "----------------------------------------------------" << endl;     ifstream inFile;     ofstream outFile;     fstream bOutFile;     vector<Packet> package;     Packet one(0, "A packet of cheese.", 21.99, 4);     package.push_back(one);     Packet two(1, "A packet of super-cheese.", 31.99, 2);     package.push_back(two);      cout << "Starting to write packets to file..." << endl;      outFile.open("Insert Your Destination of File Here.Txt");     for (int i = 0; i < package.size(); ++i) {         outFile << "{" << endl;         outFile << package[i].getPartId() << "," << endl;         outFile << package[i].getDescription() << "," << endl;         outFile << package[i].getPartCount() << "," << endl;         outFile << package[i].getPrice() << "," << endl;         outFile << "}" << endl << endl;     }     outFile.close();      cout << "Starting to read packets from file..." << endl;      inFile.open("Insert Your Destination of File Here.Txt");     string line;     while (getline(inFile, line)) {         if (line[0] != '{' && line[0] != '}') {             cout << line.substr(0, line.size() - 1) << endl;         }     }     inFile.close();      cout << "Starting to write packets to binary..." << endl;      bOutFile.open("Insert Your Destination of File Here.bin", ios::out | ios::binary);     for (int i = 0; i < package.size(); ++i) {         bOutFile.write((char*)&package[i], sizeof(package[i]));     }     bOutFile.close();      system("pause"); } 

Packet.h:

#pragma once #include <string>  using namespace std;  class Packet { public:     Packet(int partId, string description, double price, int partCount) :         partId(partId), description(description), price(price), partCount(partCount) {}     int getPartId() const { return partId; }     string getDescription() const { return description; }     double getPrice() const { return price; }     int getPartCount() const { return partCount; }  private:     int partId;     string description;     double price;     int partCount; }; 

autossh working fine from terminal, bot causing permission denied from systemctl

I’m trying to integrate autossh on a raspberry pi.

if I launch the command by itself

autossh -o "ServerAliveInterval 10" -o "ServerAliveCountMax 3" -N -R 22002:localhost:22 user@myserver 

everything works fine, but launching the same command from systemctl

[Unit] Description=AutoSSH tunnel service Remote port 22002 to local 22 After=network.target [Service] Environment="AUTOSSH_GATETIME=0" ExecStart=/usr/bin/autossh -o "ServerAliveInterval 10" -o "ServerAliveCountMax 3" -N -R 22002:localhost:22 user@myserver.com [Install] WantedBy=multi-user.target 

returns

Jun 25 13:43:22 pi autossh[995]: Permission denied, please try again. Jun 25 13:43:22 pi autossh[995]: Permission denied, please try again. Jun 25 13:43:22 pi autossh[995]: Permission denied (publickey,password). Jun 25 13:43:22 pi autossh[995]: ssh exited with error status 255; restarting ssh 

I am able to ssh my server without password from my pi.

anything i should check up or do ?

Thanks,