mysql.sock missing: php connection works but cant connect from terminal

When I try to run mysql from the command line I get the following:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) 

interestingly the php scripts that connect to mysql in /var/www appear to be connecting just fine and when I stop MySQL these scripts can no longer connect as expected. However when I start mysql I continue to get the missing .sock error from the command line while my php scripts once again are connected to the database they are supposed to.

I have tried restarting mysql in various ways (restarting, starting then stopping, sudo pkill mysql) and still no luck. The only sock file on my system is /run/mysqld/mysqld.sock; but, without being sure that this is the cause of the command line error I dont want to haphazardly make symbolic links in my /tmp directory.

How can I resolve the issue of connecting to mysql via the command line? some suggestions I have read recommend reinstalling MySQL which I don’t want to do considering my php connection is working.

Hosting a IIS webserver using cellular connection

sorry if this is in the wrong place, please move it accordingly

So, I need an answer to my problem. I need to setup local IIS server and need to access it from public. I tested the IIS server, works well locally, also I can access it using my ISP public IP, with port forwarded of course.

The problem is, the place where the IIS Server will be located, is only reachable via 4G/LTE internet. I’ve tried using Huawei E3772 USB Modem, connected to TP Link MR3420v5 router, forwarded the port, but it’s still closed when I check it on canyouseeme.org

Any other solution?

mySQL Workbench new Connection : There is no disk in drive. Please insert disk in \Device\Harddisk2\DR2

I’m trying to migrate the data at my company from Excel to mySQL so I’m very new at this. I just installed the latest mySQL package via the standard installer and when I try a new connection (I’m trying to get through the mySQLTutorial) the error pops up:

MySQLWorkbench.exe - No disk  There is no disk in drive.  Please insert disk in drive \Device\Harddisk\DR2 

My setup for the new connection is as follows:

Connection name: local Connection method: Standard (TCP/IP)  Hostname: 127.0.0.1 Port: 3306 Default schema: "" 

Anyone have any ideas? I’m completely at a loss here…

connection failed activation of network connection failed

I am using Kali linux and once I use macchanger I lose internet no ipv4.

troubleshooting I tried – tried different machine with fresh install – made sure I disable the network interface before changing the MAC – tried network restart – tried dhclient – tried -e flag

nothing seems to work, I been using this for a while and I never had an issue with it. message “Activation of network connection failed”

VPN connection to server with public IP that is part of remote subnet

I need to setup a connection between an Ubuntu Server 16.04 LTS running an OpenVPN daemon and multiple new Windows clients (Windows 10 Pro & 8.1 Pro).

On the server there is a bridge between the OpenVPN tap device and the NIC that is attached to the company network, which carries the server’s (public) IP address. This IP address is part of the subnet from which all clients are to be supplied.

With multiple Linux clients I never had any problems connecting to the company network and accessing all the company services (after the correct routes had been applied), but on the Windows systems I am not yet able to establish a stable connection.

The above problem again with example IP addresses:

  • Company subnet is 1.0.0.0/24 (public addresses, cannot be changed!)
  • VPN server has address 1.0.0.1
  • Firewall is configured to allow incoming traffic for 1.0.0.1 on port 1194 and deny everything else
  • Client has local IP address 10.90.86.45/24, local gateway 10.90.86.1 and VPN address 1.0.0.200

The result of “route print” after setting all the routes that were necessary during the attempts with the Linux clients:

Network Destination      Netmask   Gateway              Interface     Metric         0.0.0.0          0.0.0.0   10.90.86.1           10.90.86.45      2      10.90.86.0    255.255.255.0   On-link              10.90.86.45    257     10.90.86.45  255.255.255.255   On-link              10.90.86.45    257    10.90.86.255  255.255.255.255   On-link              10.90.86.45    257       127.0.0.0        255.0.0.0   On-link                127.0.0.1    306       127.0.0.1  255.255.255.255   On-link                127.0.0.1    306 127.255.255.255  255.255.255.255   On-link                127.0.0.1    306         1.0.0.0    255.255.255.0   On-link                1.0.0.200     20       1.0.0.200  255.255.255.255   On-link                1.0.0.200     20         1.0.0.1  255.255.255.255   10.90.86.1           10.90.86.45     20       224.0.0.0        240.0.0.0   On-link                127.0.0.1    306       224.0.0.0        240.0.0.0   On-link                1.0.0.200    266       224.0.0.0        240.0.0.0   On-link              10.90.86.45    257 255.255.255.255  255.255.255.255   On-link                127.0.0.1    306 255.255.255.255  255.255.255.255   On-link                1.0.0.200    266 255.255.255.255  255.255.255.255   On-link              10.90.86.45    257 

Despite those three lines with metric 20 (which are enough on Linux) all pings to systems in the 1.0.0.0 subnet fail (again, on Linux I get a response from every system)

“tracert 1.0.0.1” results in

1     <1 ms     <1 ms     <1 ms  _gateway-name [10.90.86.1] 2     21 ms     21 ms     21 ms  www.xxx.yyy.zzz 3     ... 

I also manually increased the metric of the default route so that it was above the metric of the VPN connection, but as expected that didn’t change anything. (After all, it may not…)

“ipconfig” returns (it is german, but I think you will be able to understand it)

Ethernet-Adapter OpenVPN:  Verbindungsspezifisches DNS-Suffix: Beschreibung. . . . . . . . . . . : TAP-Windows Adapter V9 Physische Adresse . . . . . . . . : 00-FF-BB-F1-38-3A DHCP aktiviert. . . . . . . . . . : Ja Autokonfiguration aktiviert . . . : Ja IPv4-Adresse  . . . . . . . . . . : 1.0.0.200 (Bevorzugt) Subnetzmaske  . . . . . . . . . . : 255.255.255.0 Lease erhalten. . . . . . . . . . : Samstag, 19. Januar 2019 23:00:45 Lease läuft ab. . . . . . . . . . : Sonntag, 19. Januar 2020 23:00:45 Standardgateway . . . . . . . . . : DHCP-Server . . . . . . . . . . . : 1.0.0.0 NetBIOS über TCP/IP . . . . . . . : Aktiviert  Ethernet-Adapter Ethernet:                                                          Verbindungsspezifisches DNS-Suffix: some.suffix                                   Beschreibung. . . . . . . . . . . : Gigabit-Netzwerkverbindung Intel(R) 82577LM Physische Adresse . . . . . . . . : AA-BB-CC-DD-EE-FF                           DHCP aktiviert. . . . . . . . . . : Ja                                          Autokonfiguration aktiviert . . . : Ja                                          IPv4-Adresse  . . . . . . . . . . : 10.90.86.45(Bevorzugt)                      Subnetzmaske  . . . . . . . . . . : 255.255.255.0                               Lease erhalten. . . . . . . . . . : Samstag, 19. Januar 2019 22:57:36           Lease läuft ab. . . . . . . . . . : Dienstag, 29. Januar 2019 22:57:33          Standardgateway . . . . . . . . . : 10.90.86.1                                  DHCP-Server . . . . . . . . . . . : 10.90.86.1                                  DNS-Server  . . . . . . . . . . . : 10.90.86.1                                  NetBIOS über TCP/IP . . . . . . . : Aktiviert                                   

And concerning the OpenVPN server config, I removed all “push route…” directives for the moment and tried setting them manually via “route add…”. IP address allocation is done by the OpenVPN server itself (using the server-bridge directive).

Can anybody tell me what I am doing wrong on Windows? As I said before I’ve got absolutely no problem on my linux systems…

Multiple vpn connection for VPN Gateway

All the PCs in the LAN currently connects to internet via a single VPN Connection:

                    +------+ Devices +---------> | TUN0 |+-----> ISP ROUTER                     +------+ 

Now, I need to connect the devices to the internet via 2 VPN Connection; some of them to connect via tun0, while others via tun1.

                    +------+ Device 1 +--------> | TUN0 |                            |+------> ISP ROUTER    Device 2 +--------> | TUN1 |                     +------+ 

How can I do this?

No connection with new Ethernet wiring

I ran my own ethernet cable yesterday to my living room, with the sole purpose being it would connect straight to my nvidia shield. I ran line last night,no problems. This morning, no problems, Later in the day, I plugged new ethernet cable into my nvidia shield, and thats where the problem occured.Shield said signal strenghth was excellent, however nothing would load. My 2 guests lost the wifi on their phones, my computer, which is connected to an entirely different ethernet cable on the second floor would not work, and my cordless phone which is also upstairs, would not work. I unplug from shield, everything works.

How do I understand the connection of module components (e.g., code/design/frontend/template/block, etc.) in Magento 1.9?

I’m very new to Magento and am familiar with MVC and OOP and a lot of the design patterns that Magento uses. However, I find it difficult to understand the relationship between all the components of a module, specially because I am working on a codebase that has many custom modules. The documentation like this are not very clear for me. I’m sure those who are more experienced have found simpler ways to understand the architecture of customer modules

How do I circumvent the “Your connection is not private” error

For school, I sometimes need to go to third party websites for audio books for class. A lot of the youtube ones are restricted, so I try to find ones on third party sites. I then get an error saying “Your connection is not private”. How can I tell google chrome or the school wifi that I don’t care that my connection is not private? I don’t have super secret data or passwords. I am just some random student, why would any attacker target me? And since I don’t have any important info, what is the worst they could do? How can I make it clear that I don’t care how private my connection is?

Can I use something like websocket connection instead of gRPC for GCP speech recognition

This is my first question in StackExchange – WebApps. I am starting with a project – speech recognition of streaming audio using Google speech recognition.

The website says, “Streaming speech recognition is available via gRPC only”. Well, I am new so I went on to check gRPC and what it needs. and for a new-comer it obviously needs a lot of study and understanding of new technologies (which is good, but time consuming)

I am intrigued with the things I read about Google Protocol buffers (faster data transfer). I have never used Protocol buffers and have not started off with the the project yet.

Before starting the project, I want to make sure what should be my approach towards this project? Is there, another way to use Google service (other than gRPC), for example using websockets, like IBM watson speech to text for streaming audio. The audio is sent over a websocket connection to the watson server and the response is read (doesn’t sound complex, Since I have already done a similar project on this).

Could anyone help me figure this out (My questions are highlighted with bold fonts in above paragraph)?

Thanks in advance 🙂