recentpopularlog in

theskett : for   142

« earlier  
How to fix and reason for "fatal: Unable to find remote helper for 'https'" - Google Groups
Uninstalled Cygwin git, installed Git for Windows, this added /c/Program Files/Git/cmd to Cygwin PATH, git from Cygwin seems ok now.
fatal:  Unable  to  find  remote  helper  for  https  cygwin  git  windows  path  error 
june 2018 by theskett
(Windows Fix) fatal: Unable to find remote helper for 'https' - support - Atom Discussion
Cygwin git was giving this message, on 'git push'

I uninstalled Cygwin git (and related utils), installed Git for Windows, this added /c/Program Files/Git/cmd to the Cygwin zsh path.
Git seems ok now, in Cygwin.
cygwin  Windows  fatal:  Unable  to  find  remote  helper  for  https  git  push 
june 2018 by theskett
database - How do you find the row count for all your tables in Postgres - Stack Overflow
row count for each table:

CREATE FUNCTION rowcount_all(schema_name text default 'public')
RETURNS table(table_name text, cnt bigint) as
$$
declare
table_name text;
begin
for table_name in SELECT c.relname FROM pg_class c
JOIN pg_namespace s ON (c.relnamespace=s.oid)
WHERE c.relkind = 'r' AND s.nspname=schema_name
LOOP
RETURN QUERY EXECUTE format('select cast(%L as text),count(*) from %I.%I',
table_name, schema_name, table_name);
END LOOP;
end
$$ language plpgsql;

select * from rowcount_all('sg') order by cnt desc;

Takes a few minutes, so slow but tolerable
postgres  postgresql  row  count  for  each  all  table  tables  in  database 
march 2018 by theskett
networking - how to fix " a start job is running for the raise network " in ubuntu server 16.0 LTS - Ask Ubuntu
mkdir -p /etc/systemd/system/networking.service.d/
echo -e "[Service]\nTimeoutStartSec=10sec" > /etc/systemd/system/networking.service.d/timeout.conf
systemctl daemon-reload
a  start  job  is  running  for  raise  network  ubuntu  hang  hung  boot  interface 
january 2018 by theskett
Install the Linux Subsystem on Windows Server | Microsoft Docs
Run PowerShell
Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Windows-Subsystem-Linux

Invoke-WebRequest -Uri https://aka.ms/wsl-ubuntu-1604 -OutFile ~/Ubuntu.zip -UseBasicParsing

Tip: If the download is taking a long time, turn off the progress bar by setting $ProgressPreference = 'SilentlyContinue'

Expand-Archive ~/Ubuntu.zip ~/Ubuntu

Make sure your target directory (~/Ubuntu in the above example) is on your system drive. Usually this is your C: drive.

Run the installer, named <distro>.exe
For example: ubuntu.exe, fedora.exe, etc.

Troubleshooting: Installation failed with error 0x8007007e
This error occurs when your system doesn't support WSL. Make sure that:
- You're running Windows build 16215 or later. Check your build.
- The Windows Subsystem for Linux optional component is enabled and the computer has restarted. Make sure WSL is enabled.

Create a UNIX user
The first time you install the Windows Subsystem for Linux, you will be prompted to create a UNIX username and password.
This UNIX username and password can be different from, and has no relationship to, your Windows username and password.

Run the distro's preferred update/upgrade.
sudo apt-get update
sudo apt-get upgrade

You're done! Go use your new Linux environment!
install  wsl  windows  subsystem  for  linux  server 
december 2017 by theskett
Use vim to search by hex code - Stack Overflow
Search (e.g. using / ) for \%x1b
(where 1b is the particular hex code to find)
vim  vi  search  for  hex  code  control  character 
november 2017 by theskett
PostgreSQL error cache lookup failed for relation - what causes it and why? - Stack Overflow
deleting orphaned temp tables allowed vacuum to complete:

I was dropping a schema and I had this error "lookup failed for relation xxxx". There was the name of a table also. It seemed some tables from the schema I was deleting, were in a strange state. At the end we did this third steps.

We obtain the C.oid of the table.
select c.oid
from pg_class c
join pg_namespace n on n.oid=c.relnamespace
where c.relname = 'MY_TABLE_NAME'
and n.nspname='MY_SCHEMA_NAME';
Next:
delete from pg_class where oid = MY_OID;
delete from pg_depend where objid = MY_OID;
delete from pg_constraint where conrelid = MY_OID;
Finally:
drop schema MY_SCHEMA_NAME cascade
Then appeared another similar error with another table and we repeated steps 1 to 3 until we deleted the schema.
postgresql  error  cache  lookup  failed  for  relation  orphan  table  tables  delete  from  pg_class  vacuum  full  transaction 
september 2017 by theskett
Change Sudo Password Timeout | LinuxG.net
# grep Defaults /etc/sudoers
Defaults env_reset,timestamp_timeout=10

timestamp_timeout=0 to always prompt for the password
sudo  password  timeout  always  prompt  for  passwd 
july 2017 by theskett
Postfix cannot start on centos · Codinfox
fatal: parameter inet_interfaces: no local interface found for ::1

vi /etc/postfix/main.cf
comment out inet_interfaces: all
add inet_protocol: ipv4
fatal:  parameter  inet_interfaces  no  local  interface  found  for  ::1  postfix  mail  system  fail  fails  ipv4  ipv6 
june 2017 by theskett
load - Selenium wait until document is ready - Stack Overflow
WebDriverWait wait = new WebDriverWait(dr, 30); wait.until(ExpectedConditions.jsReturnsValue("return document.readyState==\"complete\";"));
selenium  webdriver  wait  for  page  to  load  complete  ready  loaded  ec  expectedconditions  expected  conditions 
may 2017 by theskett
Can't print to PDF using cups-pdf; used to work, now "failed to set file mode" printing as non-root - Unix & Linux Stack Exchange
After adding HP PSC 1600 to cups and then to Andrea's Mac, get this message: "failed to set file mode for PDF file".
This link advises checking cups-pdf log, but cups-pdf wasn't installed.
cups  printer  failed  to  set  file  mode  for  pdf  error 
december 2016 by theskett
How to add custom color for Windows 10 taskbar
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Themes\Personalize
See the 32-bit DWORD value SpecialColor
Value data is Alpha, Blue, Green, Red
add  custom  color  for  windows  10  taskbar  task  bar 
october 2016 by theskett
« earlier      
per page:    204080120160

Copy this bookmark:





to read