Welcome to Lumache’s documentation!

Lumache (/lu’make/) is a Python library for cooks and food lovers that creates recipes mixing random ingredients. It pulls data from the Open Food Facts database and offers a simple and intuitive API. Lumache has its documentation hosted on Read the Docs Ahmad. Check out the Usage section for further information, including how to Installation the project.

Note

This project is under active development.

Contents

Usage

Installation

To use Lumache, first install it using pip:

(.venv) $ pip install lumache

Creating recipes

To retrieve a list of random ingredients, you can use the lumache.get_random_ingredients() function:

The kind parameter should be either "meat", "fish", or "veggies". Otherwise, lumache.get_random_ingredients() will raise an exception.

For example:

>>> import lumache
>>> lumache.get_random_ingredients()
['shells', 'gorgonzola', 'parsley']

Confluence

#Confluence setup:

##DB:

####Download:

• download mysql80-community-release

# sudo rpm -ivh mysql80-community-release-el7-3.noarch.rpm # sudo rpm -pql mysql80-community-release-el7-3.noarch.rpm # sudo md5sum mysql80-community-release-el7-3.noarch.rpm # sudo grep ‘temporary password’ /var/log/mysqld.log # sudo mysql_secure_installation

• Connect to the database:

# mysql -h 127.0.0.1 -P 3308 -u netset -pword -e “SHOW VARIABLES LIKE ‘%max_connections%’;” # mysql -u root

Note1: I use JNDI datasource connection

#####SHOW in DATABASE:

> SHOW VARIABLES LIKE ‘innodb_log_file_size’; > SHOW VARIABLES LIKE ‘max_allowed_packet’; > SHOW VARIABLES LIKE ‘%max_connections%’; > SHOW VARIABLES LIKE ‘%innodb_strict_mode%’; for Zabbix server > SHOW VARIABLES LIKE ‘%validate_password%’; > show global variables like ‘local_infile’; > SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE schema_name = ‘confluence’; > SELECT title, lastmoddate FROM CONTENT group by lastmoddate; > SELECT User, Host, plugin, authentication_string FROM mysql.user;

SHOW PRIVILIGES:

> show grants for ‘netset’@’localhost’; > SET GLOBAL local_infile=1;

SHOW tatal nember of tables:

>SELECT count(*) AS TOTALNUMBEROFTABLES FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘confluence’;

#####Modify DATABASE:

> CREATE DATABASE confluence character set utf8 collate utf8_bin; <br/> > ALTER DATABASE confluence CHARACTER SET utf8 COLLATE utf8_bin; <br/> > CREATE USER ‘netset’@’localhost’ IDENTIFIED BY ‘word’; <br/> > GRANT ALL ON confluence.* TO ‘netset’@’localhost’; > FLUSH PRIVILEGES;

> UPDATE user SET plugin=’mysql_native_password’ WHERE User=’netset’; > ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘’; OR > UPDATE mysql.user SET authentication_string = PASSWORD(‘’) WHERE User = ‘netset’ AND Host = ‘localhost’; OR > SET PASSWORD FOR ‘netset’@’localhost’ = PASSWORD(‘’);

> SET GLOBAL mysqlx_max_connections = 300; > SET GLOBAL max_connections = 300; > SET GLOBAL max_connections = 500; > SET GLOBAL innodb_log_file_size=2000000; > SET GLOBAL max_allowed_packet=1073741824; > SET GLOBAL sql_mode=’STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,

ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’;

> SET session sql_mode=”STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,

ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”;

> SET GLOBAL validate_password.policy=LOW; > SET GLOBAL validate_password.mixed_case_count = 0; > SET GLOBAL validate_password.number_count = 0; > SET GLOBAL validate_password.check_user_name = 0; > SET GLOBAL validate_password.special_char_count = 0; > SET GLOBAL validate_password.LENGTH = 0;

ALTER TABLE table_name

> DROP COLUMN column_name;

#####Modify database in conf file:

[mysqld]

validate_password.length=0 validate_password.mixed_case_count=0 validate_password.number_count=0 validate_password.policy=LOW validate_password.special_char_count=0 default-storage-engine=INNODB

innodb_log_file_size=2GB max_allowed_packet=256M binlog_format=row character-set-server=utf8 collation-server=utf8_bin

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

---

Free the memory from caches first level: # sync; echo 1 > /proc/sys/vm/drop_caches

1- Add work directory (Home directory) to the installation directory: # nano -w atlassian-confluence-7.11.1/confluence/WEB-INF/classes/confluence-init.properties confluence.home=/home/confluence/confluence-7.10.2.1 2- copy the database connector: # cp confluence/confluence/WEB-INF/lib/mysql-connector-java-5.1.47.jar atlassian-confluence-7.11.1/confluence/WEB-INF/lib/ 3- copy the sever conf file: # cp confluence/conf/server.xml atlassian-confluence-7.11.1/conf/

Note: jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&amp;useSSL=false

4- unlink confluence and link new confluence:

# ln -s atlassian-confluence-7.11.1 confluence

4- sudo rm -r logs/* sudo rm -r temp/* sudo rm -r plugins-cache/* sudo rm -r plugins-osgi-cache/* sudo rm -r plugins-temp/*

6-

CATALINA_OPTS=”-Xms1024m -Xmx6000m -XX:+UseG1GC ${CATALINA_OPTS}” JRE_HOME=”/opt/jre11”

7- chown -R confluence:confluence atlassian-confluence-7.11.1 chown -R confluence:confluence /home/confluence/confluence-7.11.1/

---

jar -xf confluence-7.11.1.jar and change

nano -w databaseSubsystemContext.xml

DESCRIBE [table name];

DENORMALISED_SPACE_VIEW_PERMISSIONS DENORMALISED_SPACE_EDIT_PERMISSIONS DENORMALISED_SID

DROP table MIG_EXCLUDE_APP;

MIG_APP_ACCESS_SCOPE;

SELECT max(lastmoddate) FROM ATTACHMENTS; select TITLE, LASTMODIFIER, LASTMODDATE, USERNAME from CONTENT group by TITLE;

select * from CONTENT LIMIT 1;

SELECT email_address AS “email”, user_name AS “username”, display_name AS “displayname”, active AS “active” FROM cwd_user;

1- JAVA 8 ELLER JAVA 11 1- JAVA eller JRE 2- MYSQL ELLER MARIADB 3- MYSQL 5.7 eller 8.0.23 4- mysql-connector-java-8.0.23.jar (saknar datetimelocal )eller äldre 5.1.47 5- xmx=6000 6- Attachments folder in HOME_dir

Lumache has its documentation hosted on Read the Docs Ahmad.