Visit Our UNIX and Linux User Community

Linux and UNIX Man Pages

Test Your Knowledge in Computers #224
Difficulty: Easy
In September 2019, according to NetMarketShare, Windows had just over 87% of the global desktop market, followed by Linux at close to 10%, and macOS in third place at around 2%.
True or False?
Linux & Unix Commands - Search Man Pages

apache::session::lock::mysql(3pm) [debian man page]

Apache::Session::Lock::MySQL(3pm)			User Contributed Perl Documentation			 Apache::Session::Lock::MySQL(3pm)

NAME
Apache::Session::Lock::MySQL - Provides mutual exclusion using MySQL SYNOPSIS
use Apache::Session::Lock::MySQL; my $locker = Apache::Session::Lock::MySQL->new(); $locker->acquire_read_lock($ref); $locker->acquire_write_lock($ref); $locker->release_read_lock($ref); $locker->release_write_lock($ref); $locker->release_all_locks($ref); DESCRIPTION
Apache::Session::Lock::MySQL fulfills the locking interface of Apache::Session. Mutual exclusion is achieved through the use of MySQL's GET_LOCK and RELEASE_LOCK functions. MySQL does not support the notion of read and write locks, so this module only supports exclusive locks. When you request a shared read lock, it is instead promoted to an exclusive write lock. CONFIGURATION
The module must know how to connect to your MySQL database to acquire locks. You must provide a datasource name, a user name, and a password. These options are passed in the usual Apache::Session style, and are very similar to the options for Apache::Session::Store::MySQL. Example: tie %hash, 'Apache::Session::MySQL', $id, { LockDataSource => 'dbi:mysql:database', LockUserName => 'database_user', LockPassword => 'K00l' }; Instead, you may pass in an already opened DBI handle to your database. tie %hash, 'Apache::Session::MySQL', $id, { LockHandle => $dbh }; AUTHOR
This module was written by Jeffrey William Baker <jwbaker@acm.org>. SEE ALSO
Apache::Session perl v5.10.1 2010-10-18 Apache::Session::Lock::MySQL(3pm)

Check Out this Related Man Page

Session::Store::MySQL(3)				User Contributed Perl Documentation				  Session::Store::MySQL(3)

NAME
Apache::Session::Store::MySQL - Store persistent data in a MySQL database SYNOPSIS
use Apache::Session::Store::MySQL; my $store = new Apache::Session::Store::MySQL; $store->insert($ref); $store->update($ref); $store->materialize($ref); $store->remove($ref); DESCRIPTION
Apache::Session::Store::MySQL fulfills the storage interface of Apache::Session. Session data is stored in a MySQL database. SCHEMA
To use this module, you will need at least these columns in a table called 'sessions', or another table name if you provide the TableName argument: id char(32) # or however long your session IDs are. a_session text To create this schema, you can execute this command using the mysql program: CREATE TABLE sessions ( id char(32) not null primary key, a_session text ); If you use some other command, ensure that there is a unique index on the table's id column. CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the options hash (see Apache::Session documentation). The options are: DataSource UserName Password TableName Handle Example: tie %hash, 'Apache::Session::MySQL', $id, { DataSource => 'dbi:mysql:database', UserName => 'database_user', Password => 'K00l', TableName => 'sessions' }; Instead, you may pass in an already-opened DBI handle to your database. tie %hash, 'Apache::Session::MySQL', $id, { Handle => $dbh }; AUTHOR
This modules was written by Jeffrey William Baker <jwbaker@acm.org> SEE ALSO
Apache::Session perl v5.12.1 2007-09-28 Session::Store::MySQL(3)

14 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Apache/Unix

OK, i followed the online directions to installing MySQL/Apache/PHP4 and it all seemed to be workign until i went into (OSX) System prefrences and tried to start Web shareing (turn on apache) ....it just kidna sits there saying 'statring web sharing'. should i just redo the steps online to install... (10 Replies)
Discussion started by: cpk0
10 Replies

2. Cybersecurity

Web site Security WRT MySql - how set up?

Hiya all, Newbie here - hope you can help Trying to set up a login authorization on my website. Reading away - it says works well with MySql database. Apache book goes onto to explain how to install Mysql etc.... But How do I set up the login page tho? Please assist Cheers... (5 Replies)
Discussion started by: marty 600
5 Replies

3. HP-UX

Mod_ssl patch for Apache server v2.0.49

Hi there, Please help, anyone know where to download latest Mod_SSL patch for Apache server v2.0.49 . Have tried www.apache.org but there is not latest patch available. (8 Replies)
Discussion started by: e_jeffhang
8 Replies

4. Shell Programming and Scripting

Problem with looping construct

Hi all I have tried to search for this, but keep getting a MySQL db connect error, so am posing the question here, and taking a risk of incurring the wrath of the mods with my first post... I have the following test script: #!/bin/bash HTTPD=`/bin/ps -axcu | /usr/bin/grep httpd... (6 Replies)
Discussion started by: mikie
6 Replies

5. Shell Programming and Scripting

Mutex in Perl

Hello Everyone, I just joined this forum and this is my first post. I would like to know how can I impliment basic read/write locks in perl. I have a database (file) which can be accessed simultaneously but has to be locked while writing. If there is no such support in perl, my next... (6 Replies)
Discussion started by: superuser84
6 Replies

6. UNIX for Dummies Questions & Answers

Question about excutable software in Unix

I am using SCO OpenServer 5.0 now, and have the old software as database (similar with MySQL) to store all data. I want to know that how can I read those data in the file. For example, I have file named OE.USECD, which is data file when I use the software to store my data to database. it's not... (5 Replies)
Discussion started by: wendyz
5 Replies

7. Web Development

Confused maybe about MySQL Dump & PHP

Hello. the purpose of my efforts right now are to get a larger script of mine (which the admin told me he'd put into cron for me) to properly back-up my MySQL database. To test out the sql back-up part (before getting the whole script into cron, and having it not work) I wanted to test it. So... (12 Replies)
Discussion started by: jzacsh
12 Replies

8. What is on Your Mind?

Monthly Salary in India for Web Programmer?

Anyone know the normal and average monthly salary (and hourly wage for part time) for a solid Web Development in India? Basic requirements. LAMP (Linux, Apache, MySQL, PHP), HTML, CSS, Javascript. vBulletin a plus, but not necessary. Anyone have any idea? (5 Replies)
Discussion started by: Neo
5 Replies

9. What is on Your Mind?

OpenSolaris's Imminent Demise

Hi Everyone, I would like to ask you about OpenSolaris's imminent disappearance under the ongoing Oracle stewardship. How do you feel about it? I have been an active user of this OS since its beginning and have deployed it in my educational institution across 7 campuses on more than 700... (7 Replies)
Discussion started by: Jawwad
7 Replies

10. Homework & Coursework Questions

C/C++ program that connects to a MySQLserver

Hi Programming Geeks, I got an interesting C++ and MySQL problem to solve. I was unable to do this as I am not much confident on MySQL DB. Please have a go at it if possible. Write a C/C++ program that connects to a MySQLserver and checks if the InnoDB plug-in is installed on it. If so,... (5 Replies)
Discussion started by: vivek.goel.piet
5 Replies

11. Web Development

met problem with do() in MySQL

Hi, I had a chance to create a database refreshing the previous post. An error was tossed out with the following message:DBI connect('nr20111117_db','yifangt',...) failed: Unknown database 'nr20111117_db' at create-nrDB-20111214.pl line 17 Cannot connect: Unknown database 'nr20111117_db' at ... (6 Replies)
Discussion started by: yifangt
6 Replies

12. Red Hat

Patch Rhel5.4

Hi, I am managing a Few Applications (like Apache,Jboss) running on RHEL 5.4. I have just been notified that these servers need to be patched. My question is ,will the configurations for Apache and Jboss and other applications get disturbed if the server is patched.? If so what precautions... (5 Replies)
Discussion started by: Hari_Ganesh
5 Replies

13. Shell Programming and Scripting

Compare File & Copy Replace if Successful

Hi All, I have written a shell script that creates a backup of my MySQL database. The script performs the following functions: Creates a Backup of the MySQL database Compresses the Backup Copies the Backup to a Remote Server Send an E-Mail displaying the size of the Backup Removes any... (6 Replies)
Discussion started by: SalientAnimal
6 Replies

14. News, Links, Events and Announcements

MySQL dropped in favor of MariaDB

Fedora and openSUSE will replace MySQL with MariaDB: Oracle who? Fedora & openSUSE will replace MySQL with MariaDB | ZDNet The article also has a comment that Chakra is planning on doing the same. No doubt the Fedora based distributions are planning to do the same. (7 Replies)
Discussion started by: figaro
7 Replies

Featured Tech Videos