Abrar,
investigate how many processes are needed for your users (how many of them use more than one session) and add a few (in your case 5) for internal use. For my example how to change the database parameter I'll assume a value of 300. As long as this value is below 2047 you do not need to change anything on os-level.
The syntax to change the database parameter (assuming you work with a spfile) is:
Then you'll need to bounce (restart) your database for this change to take effect.
Having a problem on AIX 4.3.3 with the following error when more than 2 users try and sign onto the server.
3004-312 All available login sessions are in use.
???? (1 Reply)
hi,
does anyone knows how to trace a user session on a unix system:
i want to log these things
1- login
2- date of starting session
3- date of closing session
i've tryed who and last but they don't give closing time of session
regards
hmaiida (2 Replies)
I logged on yesterday and ran something that made my ID hang. I X'd out of the session and then logged on again and my ID from the original session is still there. I checked again this morning and the ID is still there (I checked using the WHO command). How can I kill that first session using... (7 Replies)
We used to have a ftp user id with no telnet session allowed in server side.
We used this ftp user id in script by transferring file from client to Server.
Currently we need to implement sftp to replace ftp.
We have tested few round and working fine by using sftp with normal user id (allow... (2 Replies)
A gnome session is launched by UserA of System A, I am connected to userB of System B(or A) through PUTTY. I want to launch an application for eg: gedit through Putty in the display of system A. how can I achieve this.
for eg:-
root is logged in to System A, with gdm.
DISPLAY=0.0, ip =... (4 Replies)
I want to restrict user's loging according to number of session.
example the user named "patrik" can be login concurrently from 12 stations thru telnet the 13th if some body tries to telnet 13th session it should not allow, until any of the 12 sessions are closed.
is it possibel ...i think... (2 Replies)
hi,
I am facing a problem
from the remote system if i login to my AIX5.3 machine as root (thru telnet) the session does not expire for 2 hours even if the session is kept ideal
But whenever i do the same thing from some other user then the session is lost within 10 minutes (if session is kept... (2 Replies)
I need to write a script, where I have to get names of files that are to be deleted from a user and have to delete those files when he exits session.
How to set a particular command to be run as soon as user exits from a session?
Can somebody help?
I have to write a script on linux system.... (3 Replies)
Discussion started by: yashashri
3 Replies
LEARN ABOUT DEBIAN
apache::session::store::mysql
Apache::Session::Store::MySQL(3pm) User Contributed Perl Documentation Apache::Session::Store::MySQL(3pm)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.10.1 2010-10-18 Apache::Session::Store::MySQL(3pm)