Table: cnotas, rows: 168

Page 1 of 17
           

idtitulocontenido
196fedora httpd firewallDespues de la instalacion
-------------------------------------
sudo firewall-cmd --add-service=http
sudo firewall-cmd --add-service=https
195export import m_dbhttp://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
194Joomla tmp filesudo 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
193uninstall mariadbIf 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
192ubuntu 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
191imagick manjaro php 8Ubuntu:
-----------
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
190manjaro php 8 httpdFile /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

189phpmyadminQuitar 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



188ssh start remote apparranca el file manager nautilus
-----------------------------------
ssh -Y picota nautilus
187Enviar mensaje a Telegraminstalar 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: