I have created a database manually on server with user_dbname however won’t show up on cpanel / phpmyadmin .
The solution was to run this
/usr/local/cpanel/bin/dbmaptool cpanelusername --type mysql --dbs 'nameofdatabase' --dbusers 'dbusername'
January 15, 2019
MySQL database exists on the server, but does not show up in the cPanel
January 14, 2019
How to recursively give directories read&execute privileges
To recursively give directories read&execute privileges:
find /path/to/base/dir -type d -exec chmod 755 {} +
To recursively give files read privileges:
find /path/to/base/dir -type f -exec chmod 644 {} +
Or, if there are many objects to process:
chmod 755 $(find /path/to/base/dir -type d)
chmod 644 $(find /path/to/base/dir -type f)
Or, to reduce chmod spawning:
find /path/to/base/dir -type d -print0 | xargs -0 chmod 755
find /path/to/base/dir -type f -print0 | xargs -0 chmod 644December 10, 2018
Your browser sent a request that this server could not understand
Well today I am facing another problem.
Got this answer on a apache behind a proxy .
400 Bad Request
Bad Request
Your browser sent a request that this server could not understand.
Size of a request header field exceeds server limit.
So .. it appear the header that is received by webserver is bigger then normal .
Solution is to increase it .
LimitRequestFieldSize 32760
LimitRequestLine 32760
Please note that is loaded from first VirtualHost.
One solution is to tested with this
curl -v -H “CustomHeader: `printf ‘1%.0s’ {1..n}`” localhost
Where n can be replace with a value of for example 20000
November 22, 2018
Letsencrypt UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0xfc in positio
Well today I was trying to issue a ssl on a old server and find this
File “/opt/eff.org/certbot/venv/lib64/python3.4/site-packages/augeas.py”, line 147, in get
return dec(value.value)
File “/opt/eff.org/certbot/venv/lib64/python3.4/site-packages/augeas.py”, line 65, in dec
return st.decode(AUGENC)
UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0xfc in position 15: invalid start byte
Please see the logfiles in /var/log/letsencrypt for more details.
A short workaround was to modify the
“/opt/eff.org/certbot/venv/lib64/python3.4/site-packages/augeas.py”
the 65 line was something
return st.encode(AUGENC)
with
return st.decode(AUGENC, ‘ignore’)
It worked to get a new certificate .
September 13, 2018
Bypass Authentication Or Access Requirements .htpasswd
Well if you are using letsencrypt with a password protected website is hard to renew the ssl because you need to bypass that .
If you have access to httpd conf the easy solution is to add this
<Directory /var/www/path/.well-known/> Order allow,deny Allow from all Satisfy any </Directory> Then restart the apache/httpd.
