|
|
198 | install windows 11 from iso file | install woeusb:
sudo pamac build woeusb
make bootable USB:
sudo woeusb --device Win11_22H2_EnglishInternational_x64v2.iso /dev/sda
|
|
|
197 | Cambiar fecha a un directorio de fotos | exiftool -AllDates="2023:07:05 11:30:00" . |
|
|
196 | fedora httpd firewall | Despues de la instalacion
-------------------------------------
sudo firewall-cmd --add-service=http
sudo firewall-cmd --add-service=https |
|
|
195 | export import m_db | http://picota/phpmyadmin
select m_db
export
Custom - display all possible options
Object creation options
Add statements:
Add CREATE DATABASE / USE statement
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement
Go
Save file en ~/bin/sql/picota/m_db.sql
cd ~/bin/sql/picota
./m_dbImport |
|
|
194 | Joomla tmp file | sudo mkdir /home/http/tmp
sudo chown www-data:martinez /home/http/tmp
sudo nano /etc/php/7.4/apache2/php.ini
edit:
file_uploads = On
upload_tmp_dir ="/home/http/tmp"
upload_max_filesize = 100M
post_max_size = 100M
sudo systemctl restart apache2
|
|
|
193 | uninstall mariadb | If you are using ubuntu, I suggest you to use the apt-get command to remove the database package, for instance:
$ sudo apt-get purge mariadb-server
You may check which mariadb packages are installed with:
$ sudo dpkg -l | grep mariad |
|
|
192 | ubuntu mysql root | $ sudo mysql -u root # I had to use "sudo" since is new installation
mysql> USE mysql;
mysql> SELECT User, Host, plugin FROM mysql.user;
+------------------+-----------------------+
| User | plugin |
+------------------+-----------------------+
| root | auth_socket |
+------------------+-----------------------+
As you can see in the query, the root user is using the auth_socket plugin
There are 2 ways to solve this:
You can set the root user to use the mysql_native_password plugin
You can create a new db_user with you system_user (recommended)
Option 1:
$ sudo mysql -u root # I had to use "sudo" since is new installation
mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;
$ sudo service mysql restart
Option 2: (replace YOUR_SYSTEM_USER with the username you have)
$ sudo mysql -u root # I had to use "sudo" since is new installation
mysql> USE mysql;
mysql> CREATE USER 'YOUR_SYSTEM_USER'@'localhost' IDENTIFIED BY 'YOUR_PASSWD';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'YOUR_SYSTEM_USER'@'localhost';
mysql> UPDATE user SET plugin='auth_socket' WHERE User='YOUR_SYSTEM_USER';
mysql> FLUSH PRIVILEGES;
mysql> exit;
$ sudo service mysql restart
|
|
|
191 | imagick manjaro php 8 | Ubuntu:
-----------
sudo apt install php-imagick
manjaro
----------
sudo pacman -S php-imagick
File:
/etc/php/conf.d/imagick.ini
descomentar:
extension=imagick
ubuntu
-----------
sudo systemctl restart apache2
manjaro
-----------
sudo systemctl restart httpd |
|
|
190 | manjaro php 8 httpd | File /etc/httpd/conf/httpd.conf
comentar:
#LoadModule php7_module modules/libphp7.so
#AddHandler php7-script .php
#
poner al final:
LoadModule php_module modules/libphp.so
AddHandler php-script php
Include conf/extra/php_module.conf
Include conf/extra/phpmyadmin.conf
|
|
|
189 | phpmyadmin | Quitar el error tmp
-------------------------
sudo mkdir /usr/share/webapps/phpMyAdmin/tmp/
sudo mkdir /usr/share/webapps/phpMyAdmin/tmp/twig
sudo chown -R http /usr/share/webapps/phpMyAdmin/tmp/
quitar phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied
--------------------------------------------------------------------------------------------------------------
CREATE USER 'phpmyadmin'@'%' IDENTIFIED BY 'gurugu';
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'%' WITH GRANT OPTION;
En manjaro editar /etc/php/php.ini y descomentar
extension=iconv
|
|
|
188 | ssh start remote app | arranca el file manager nautilus
-----------------------------------
ssh -Y picota nautilus |
|
|
187 | Enviar mensaje a Telegram | instalar telegram-cli:
-------------------------
sudo snap install telegram-cli
La primera vez progunta por el telefono del movil y envia un codigo
pregunta por el codigo que que es un mensaje en telegram del movil
se mira en el movil y se responde.
Mi nombre mismo es telegram
Ejemplo enviar el comando la respuesta al comando date
----------------------------------------------------------------
telegram-cli -W -e "msg Telegram 'Hoy es: `date`' "
telegram-cli -W -e "msg Urs_Jenzer 'Heute ist: `date`' "
comandos:
telegram-cli
>
To see a list of people in your contacts list who you can message, type:
> contact_list
To view a list of all current chats, groups and unread messages type:
> dialog_list
To message a contact or group, type msg followed by their name (remember that you can use tab to autocomplete) and then your message:
> msg
To view a conversation or chat history type history followed by the name of the contact or group and the number of lines you wish to see:
> history
To exit
> quit
E.g.: history Liam 10 will print the 10 most recent messages in my conversation with Liam:
|
|
|
186 | cups printer manjaro | sudo systemctl start cups.service
sudo systemctl status cups.service
sudo systemctl enable cups.service
lpstat -p -d
respuesta: printer HP-LaserJet-m1120n-MFP
lpr -P printer filename
lpr filename |
|
|
185 | How to get rid of MySQL error 'Prepared statement needs to be re-prepared' | The error went away for me when I added table_definition_cache=5000 in my /etc/my.cnf file (under the [mysqld] section), and restarted mysqld. Note that my.cnf may be in a different location for you |
|
|
184 | borrar keyring | rm ~/.local/share/keyrings/login.keyring |
|
|
183 | ubuntu 19.10 apache userdir modul | # cd /etc/apache2/conf-available
# vim httpd-userdir.conf
(editart)
# cd /etc/apache2/conf-enabled
# ln -s ../conf-avalaible/httpd-userdir.conf .
# cd /etc/apache2/mods-enabled
# ln -s ../mods-avalaible/userdir.load .
# systemctl restart apache2
# systemctl status apache2
|
|
|
182 | mysql password | cd c:\wamp64\bin\mysql\mysql5.7.26\bin
mysql -uroot mysql
mysql> set password for root@localhost=password('gurugu'); |
|
|
181 | manjaro HP Laserjet M1120n MFP | $ sudo hp-plugin
start programm HP device Manager |
|
|
180 | mysql from remote host torre | in host giraldo:
----------------------
create user 'martinez'@'torre' identified by 'gurugu';
grant all privileges on *.* to 'martinez'@'torre.%' identified by 'gurugu' with grant option;
|
|
|
179 | banco popular | Cuenta banco popular Nombre: Maria Encarnacion Martinez Santamaria
Entidad: 0075
Oficina: 0250
D.C: 73
Num. Cuenta: 0700504028
IBAN: ES19 0075 0250 7307 0050 4028
|
