Linux, OpenOffice.org and Open Source Software

The use of multiple servers with dedicated functionality can communicate with each other through API and notifications.  OVERVIEW Example where a backend server that performs a task followed ...

http://tboxmy.blogspot.com/2024/04/rabbitmq-implementation-in-laravel-and.html

Cockpit provides a web interface to manage Centos Linux servers. E.g. https://10.1.1.123:9090/  However, users have found login error on Centos that mentions  This web browser is too old to...

http://tboxmy.blogspot.com/2024/03/cockpit-login-error-on-centos.html

In PHP and Laravel, date and time can be managed using Carbon. Default PHP uses the Date object, which does not have as many flexibility as Carbon object. To start using Carbon on Laravel, add at...

http://tboxmy.blogspot.com/2024/01/handling-date-and-time-with-carbon.html

On Centos Linux (in this case version 8), the command systemctl allows administration of services on Linux. The version of systemctl in use is displayed with command systemctl --version syste...

http://tboxmy.blogspot.com/2023/12/manage-services-on-centos-linux.html

Here, I will describe usage of Swagger, list the L5 Swagger basic configurations, provide templates to document POST and GET API (Application Programming Interface). What does L5 Swagger provid...

http://tboxmy.blogspot.com/2023/10/configure-l5-swagger-and-documention.html

Programming is made more systematic with a large number of helper classes in Laravel. Examples are the Arr::last, Arr::add, Arr::get, asset, route, secure_url, url, dd, collect, env) Lots of do...

http://tboxmy.blogspot.com/2023/10/laravel-helper-class.html

LARAVEL 10 AND USER API AUTHENTICATION WITH SANCTUM Laravel 10 is available to create restful API where it provides (1)process to issue API tokens to users AND (2)authentication of single page a...

http://tboxmy.blogspot.com/2023/10/laravel-10-user-api-authentication-with.html

Drupal CMS includes a webform where each form has an ID. An example to retrieve number of user access of a Drupal database for a given node id. The column ws.created is stored with a unix timesta...

http://tboxmy.blogspot.com/2023/10/mysql-group-by-unix-timestamp.html

The R programming language can be downloaded then installed from https://cran.r-project.org/index.html Next download and install R Studio from https://posit.co/download/rstudio-desktop/ Ins...

http://tboxmy.blogspot.com/2023/09/r-language-basics.html

Monitor Centos Linux 7 servers through a web browser. On Centos Stream 8, Cockpit is installed by default on the most parts. STEPS TO INSTALL COCKPIT AND START THE SERVICE These require Linux ...

http://tboxmy.blogspot.com/2023/09/centos-7-monitoring-with-cockpit.html

Users created in MySQL should be for localhost access. In order for a user to be connected from a remote computer, the IP address must be mentioned in its user record. Removing a user access is a...

http://tboxmy.blogspot.com/2023/09/how-to-add-remote-mysql-user-access.html

Extracting from MySQL and PostgreSql database can be done via Reportserver.net. Other relational databases are also supported as of Reportserver.net version 4. CONFIGURATION Step 1: Login as a...

http://tboxmy.blogspot.com/2023/09/how-to-add-datasource-to-reportservernet.html

PhpSpreadsheet provides a PHP library of classes to read and write formats such as LibreOffice Calc, Microsoft Office and CSV. The default encoding uses UTF-8. Ref: https://phpspreadsheet.read...

http://tboxmy.blogspot.com/2023/09/how-to-read-excel-data-with.html

It is useful to have the current Git branch appear at user prompt. This can be done for Centos Linux BASH by updating the user's configuration file .bashrc in the user's home directory. Add the...

http://tboxmy.blogspot.com/2023/09/display-git-branch-in-linux.html

Git remote provide information to sync with a Git repository to do stuff like git fetch, git push, git pull. This information is stored in .git/config. In the case of a new directory, that does...

http://tboxmy.blogspot.com/2023/09/how-to-add-remote-to-git-repo.html

SQL join statements are used to combine rows from two or more tables, based on related column(s) between those tables.  These statements assist user to extract data from tables which have one-to...

http://tboxmy.blogspot.com/2023/08/basic-of-sql-joins.html

Working with GIT allows tagging specific points along the repository that have some importance. Commonly, tag is used when a version is released. Here are examples of listing tags, adding and del...

http://tboxmy.blogspot.com/2023/03/git-tag-and-retag.html

 PHP provides a class to create a temporary object where no specific class and members are required. The class stdClass is the empty class in PHP used to cast other types to object. Among the ...

http://tboxmy.blogspot.com/2023/03/how-to-create-dynamic-object-from.html

The community edition of Reportserver.net provide a large number of useful functions. This include managing user access, download in different formats, user freedom to customise the report and ac...

http://tboxmy.blogspot.com/2023/02/reportserver-query-with-wildcards.html

In a server with only 1 CPU, there are times where Linux service fight to gain usage of resources. However, Selinux strict policies may cause a service to repeatedly demand usage that lead to 100...

http://tboxmy.blogspot.com/2023/02/centos-stream-8-with-selinux-and-high.html

This is a note on usage of JSON in Laravel 8. Given a Postgresql database with a table name customer, that have a column name status it would look like this status= The function to search f...

http://tboxmy.blogspot.com/2023/02/laravel-and-search-for-json-content-in.html

MS Windows 10 have been an interesting change for Microsoft operating system, and maybe MS Windows 11 will build on its capability to work with more operating systems. Here is how to update MS ...

http://tboxmy.blogspot.com/2023/01/linux-on-ms-windows-10.html

 Tinker is the tool for command line debugging in Laravel.  To start the tool, type php artisan tinker CREATE AN OBJECT FROM MODEL In tinker command line, objects can be created and save...

http://tboxmy.blogspot.com/2023/01/tinker-and-controller-methods.html

 There are cases where from the Linux terminal, it is required to post the output as an attachment in jpg or png. If ImageMagick is installed, this can be done easily, otherwise they use the tra...

http://tboxmy.blogspot.com/2023/01/save-linux-output-to-jpg-or-image-file.html

 How do I find files in a Linux system? or specifically on Centos Linus? The command ls will list files in a specific directory. Using the asterisk (*) its possible to display list of files an...

http://tboxmy.blogspot.com/2023/01/find-files-by-data-and-type-in-linux.html