Programming :: PHP/MySQL FOSS For Managing User Sessions On The Web?

Apr 24, 2009

My co-worker and I are working on this robotics project where robots are controlled over the web. I don't want to go into all the details, but basically the users visit a page where they have access to a PHP-based interface that allows them to send commands to robots in our tech lab (via an intermediate server). Our web server is running Apache.

Anyway, now we need to implement session control, with user-names and passwords so that only certain people can have access to the interface at a certain time, with access to only certain robots, et cetera. We were hoping there was some kind of pre-fab FOSS solution for handling both the session control and maintaining the MySQL user/password database.

My co-worker knows a little PHP, and I know a little MySQL, but we are both noobs enough that we would prefer to do as little of this from scratch as is possible. We don't have a lot of time, and I know it is easy for inexperienced MySQL programmers to introduce security vulnerabilities.

View 1 Replies


Programming :: PHP Auto Removes Stale Sessions On It's Own But Doesn't Remove From MYSQL Table

Aug 24, 2010

I know PHP auto removes stale sessions on it's own, but that doesn't remove them from the MYSQL table. So I was gonna make a cron script that ran once every hour that removed any MYSQL shopping cart item from the table if the original session_id that created it does not exist anymore.

From my understanding a session_id is an "actual" file located somewhere on the harddisk (is it not? correct me if I'm wrong), so I was going to do a simple check for each item in the shopping cart to check for it's original session file, if it didn't exist on the harddisk, then simply remove it from the mysql table.

View 1 Replies View Related

Programming :: Kill Pids For All Sessions For A Specific User Except Their Current One?

Oct 20, 2010

I have several users on handhelds and they like to let their sessions time out. Their zombie processes then cause record locks.I've come up with calls for killing the pids for any prior sessions started by a given user. This procedure would be executed in the .bash_profile.

View 3 Replies View Related

Ubuntu :: Managing User With User ID Below 1000?

Nov 7, 2010

I set a User's ID below 1000 because I did not want it to show in the login screen as an option and the Other User option would have to be used. I can login into that account using the Other User option, although, when I go to Users and Groups, the account doesn't show up there. How can I get it to show up there or how can I manage this user account.

View 4 Replies View Related

Programming :: Create A User For Php/MySQL Under Ms Win Environment?

Jun 30, 2010

create a user for php/MySQL under ms win environment?

View 1 Replies View Related

Programming :: Get A Password In A Bash Script For Mysql User Creation?

Apr 25, 2010

I'm trying to get a password in a bash script for mysql user creation. But sometimes a get a non-alphanumeric character(s) in the password, and mysql failes with that. I tryed with apg -EO0Il1`~!@#$%^&*()_+-=[];./{}|:"'<>? but failed. I tryed with sed 's/[^a-zA-Z2-9]//g' , but at that moment the minimum password lenght failed. I'm also fine when there is a better alternative then apg.

View 2 Replies View Related

Server :: What Is The Shell Command Which Allows To Know How Many Opened Sessions On A Mysql?

Jul 6, 2010

1-what is the shell command which allows me to know how many opened sessions on a mysql server?

2- what are the important points we can manage in a mysql server?

View 2 Replies View Related

Programming :: Managing Instances Of A Program?

Mar 23, 2011

I finished a program that connects to a remote server and does some stuff there for a while. What I want to do is to run several instances of the program to have different connections at the same time, and to be able to manage those processes automatically (for example, if the connection stops, detect it and reconect).

I guess I will have to use the pid of the processes and handle them somehow but I dont really know what to do because I haven't used c++ in a while and I never went that deep. All this will be running in suse, debian and/or yellowdog distros Maybe there's a tutorial or you guys know some tool that i can use,

View 3 Replies View Related

General :: Create A New Mysql User And A Mysql Database At The Shell Prompt?

Aug 7, 2010

How do I create a new mysql user and a mysql database at the shell prompt?

View 1 Replies View Related

Server :: Mysql 'Table 'mysql.user' Doesn't Exist'?

Aug 2, 2010

I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run

GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:


View 13 Replies View Related

General :: Link Terminal Sessions - Show Logged In As The Same User?

Jun 7, 2011

I was doing some rather lengthy procedures using a terminal. Then I wrote script using Kate, and input it into that terminal, and then realized that I was logged in as a normal user in that terminal as opposed to a superuser, which is how I was logged in at the other terminal. I've never noticed this before because I've never done anything that takes this long.

Is there any way to link all terminal sessions in such a way that they all show me logged in as the same user? I don't even know if this is even important, but I don't want to risk losing any things that I had done.

View 2 Replies View Related

Security :: Non Privileged User Sessions Close Immediately After Login?

Apr 16, 2009

while hardening a red hat enterprise 5 installation I have done something that causes the sessions of all user accounts except root to close immediately after authentication. in the /var/log/secure log file it will show three log entries per attempt:

<date/time><hostname> login: pam_unix(login:session): session opened for user fred by LOGIN(uid=0)
<date/time><hostname> login: LOGIN ON tty1 BY fred
<date/time><hostname> login: pam_unix(login:session): session closed for user fred

Since I did a number of things and have not been able to identify what caused this.

View 2 Replies View Related

General :: Using Script To Automatically Record Terminal Sessions When A User Logs In?

Mar 3, 2010

I'm trying to set up automatic recording of user sessions when they login without their knowledge. I tried sticking the script command into /etc/profile and but that didn't really work. I also tried /etc/bashrc but that had the same affect.I have also tried setting the shell in /etc/passwd to SHELL=/bin/bash /usr/bin/script -q /testing.txt.

View 8 Replies View Related

General :: Administration - Managing SAMBA Shares And Giving User Specific Access For The Shares

Jul 28, 2010

I am working as a Linux administrator in a very small data centre with 5 servers with following routine tasks.

1. Managing SAMBA shares and giving user specific access for the shares.
2. Scheduling backup of some mount points with rsycn to store data in remote hard disk
3. User and group administration, with sudo access.
4. Creating and Managing Xen Virtual machines and giving access to other project teams.
5. Automating some tasks with Shell Scripting.
6. Managing FTP server for user uploads.

I have practiced a lot in my home laptop without RHEL training, Cleared RHCE and LPIC1. I want to do some advanced system admin tasks, but do not have option in my current data centre. With Above skills is it possible to get a job ?

View 9 Replies View Related

Programming :: PHP Sessions Variables Are Not Persistent

Jan 10, 2010

I just created a website in PHP and tested on my own webserver. All of my session variables worked great. Today I uploaded it to my commercial server host and it does not remember the session vars from one page to the next. Here is the session section of phpinfo().

Session Support enabled
Registered save handlers files user sqlite
Registered serializer handlers php php_binary wddx
DirectiveLocal ValueMaster Value
session.cookie_domainno valueno value
session.entropy_fileno valueno value
session.referer_checkno valueno value

You can see that session.save_path is set to /tmp, which is the default on the shared server. /tmp does exist in my document root directory.

View 3 Replies View Related

Ubuntu :: Screen, Graphics Card And Input Device Setting Could Not Be Detected / Speech Dispacher Configured For User Sessions?

Sep 6, 2010

i am having dell inspiron 1540 laptop installed with ubuntu 10.04 (updated). i wanted to install LAMP(Linux,Apache,MySQL,PHP) for software development purpose.

but after restarting the system, following things occured:-Message box appears saying "Ubuntu is running in low-graphics mode" Your screen, graphics card and input device setting could not be detected... OK

Then i get prompt saying what would you like to do ?Run ubuntu in low-graphics mode for just one session.
i get a message starting display in one minute.....nothing happens ... i switch to text mode by pressing
escape. There is a brown color star before: Speech dispacher configured for user sessions.on battery state there is a infinte loop i.e. no response and system just hangs there...startx at text mode makes the screen blank...

Please tell which part of '/var/log/Xorg.0.log' sholud be scanned to find required information.

i am a new to ubuntu How to solve this problem i donot have internet connection and its important that i get it repaired as soon as possible....essential to get it running else i will be forced to goto Windows...

View 3 Replies View Related

General :: FOSS Alternative To Skype?

May 10, 2011

Given the recent dealings between Skype and Microsoft (here), one can guess that Linux support will be dropped. It wasn't amazing, but it ran. Moreover, security of transmitted data, in my own opinion, will be more questionable as of this acquisition.

What are the alternatives? If there are no full solutions - I propose the unification of several partial solutions into a merged FOSS project. I recommend a secure chat/video client with SIP capabilities and native ports for Linux Console, X, and FreeDos.

View 7 Replies View Related

Programming :: Bash Script To Test For Open FTP Sessions From Specific Clients?

Apr 8, 2009

I look after a server which accepts automatic overnight PASV FTP uploads from remote clients. When the uploads are complete, my Bash script copies the files to another location. The problem is, my script needs to be a bit smarter when it comes to detecting active FTP sessions.

I was using:


netstat -n | grep ":21 " | grep ESTABLISHED

to test if there were active sessions, but came unstuck when a local user left an unrelated FTP session active. The result - my script hung around all night thinking there was an active upload from a remote client. My server is behind a firewall, so remote clients all show an internal (NAT) address,so I can't differentiate by source IP address.I can't install LSOF or FUSER for security reasons. Is there a way I can test for active FTP sessions from specific users? I am running Red Hat Enterprise Linux Server release 5.2 (Tikanga).

View 7 Replies View Related

Software :: FOSS Alternative To Adobe Dreamweaver?

Dec 11, 2010

I know GIMP and OpenOffice Draw can both easily supplant Adobe Photoshop, but what about Dreamweaver? Is there any FOSS alternative that is at least as full-featured as GIMP?

View 5 Replies View Related

Software :: FOSS Image Editor Capable Of Saving As SVG?

Jun 19, 2010

Is there any FOSS image editor in the Ubuntu repositories that is capable of saving .SVG files?

I currently have GIMP. I can open an SVG file just fine. But when I go to save it, GIMP thinks the file is a new one. When I click "Replace", an error pops up "The following file does not have a known file extension". I want to know if there is an FOSS image editor that will write SVG files, not just read them.

View 2 Replies View Related

General :: Adjust And Combine Multiple Lower Quality Photos Into One Better Using FOSS?

Mar 12, 2011

I have multiple noisy photos (caputed without tripod) that needs to be adjusted (moved/rotated) and averaged.

How it's better to do it in Linux with FOSS console-based programs?

Current way is something like:

mplayer mf://*.JPG -vo yuv4mpeg:file=qqq.yuv
transcode -i qqq.yuv -y null -J stabilize=maxshift=500:fieldsize=100:fieldnum=6:stepsize=50:shakiness=10
transcode -i qqq.yuv -J transform=smoothing=100000:sharpen=0:optzoom=0 -y raw -o www.yuv

Update: Experimented with "Hugin". It only distorted all photos according some "projection" and refused to merge them: enblend: excessive overlap detected; remove one of the images. Of course "excessive" - they're all almost in the same place. No averaging? /* and images are not actually aligned */.

Proceeding to experiments with enblend/panorama_tools/ale.

View 3 Replies View Related

Programming :: Error ""Can't Connect To Local MySQL Server Through Socket" In Connecting To MySQL In C Language

Sep 29, 2010

I wrote a code in C to connect to MySQL by using mysql_real_connect function but I recieved error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" (by using mysql_error function).

I also did the following things: in mysql I typed 'SHOW VARIABLES LIKE '%SOCKET%'', it returned /var/lib/mysql/mysql.sock I typed 'mysql_config --socket' in shell, it returned /var/lib/mysql/mysql.sock I modified /etc/my.cnf file

View 3 Replies View Related

Programming :: Pass Variable In Mysql Qyery In C Programming?

Dec 4, 2010

i want to pass variable in mysql qyery in c programming

View 1 Replies View Related

Fedora :: Creating User For Mysql?

May 21, 2010

I am having fedora 12 with php and mysql rpms installed on my computer.. but I am unable to log in...nether create an user?

View 3 Replies View Related

Fedora Servers :: MYSQL MAX Connection Per User

Sep 28, 2009

I am running a mysql 5.0.41 community edition server.i have a user x and i need to set max connection limit for the user... Can any one give the correct syntax to update the current user to include max connection for the user x.

View 1 Replies View Related

OpenSUSE :: Cannot Login To Mysql As User Other Than Root?

Feb 8, 2010

I cannot see what the problem is here. I have installed MySQL 5.1.36 via YaST on my openSUSE 11.2 (32-bit) system.I can log in as root. I can "create user MY_user identified by 'my_passwd';" and a new user is created. But I cannot log in to the database using that new user name. I keep getting the message:

> mysql -b -u MY_user -p
Enter password:


View 6 Replies View Related

General :: Backing Up /var/lib/mysql As Non-root User?

Jan 4, 2011

I am using Ubuntu 10.04.1 LTS x64. I would like to backup my /var/lib/mysql directory as a non-root user.

I have been backing this up using cron as the root user, but another admin in my company insists that we create a separate user to perform this task for security reasons. I have created a user, created a group, added the user to the group, but still cannot access /var/lib/mysql/mysql directory as that user. I would like that user to have +rx access only.

View 5 Replies View Related

Server :: Asterisk User Andvoicemails With Mysql?

Jun 1, 2010

I have been reading about asterisk, I did some basic configuration, a small ivr, record messages.. but I was wondering how and what/where should I modify to use a database to save sip users and voicemail user..then we can add user/voicemail with php-myadmin I always search but I cant find about this configuration..

View 1 Replies View Related

Server :: Does The Mysql User Need Bash Shell

Oct 2, 2010

Is there any reason for the mysql user to need bash shell?

From /etc/passwd:

mysql:x:100:103:MySQL server:/var/lib/mysql:/bin/bash

Will anything break if I change that to /bin/false?

View 2 Replies View Related

Server :: User Privileges In Mysql Replication

Sep 27, 2010

Might this is silly question but I am not much familiar to database.I am doing master slave Mysql replication for load balancing. On master server different database has different user privileges. I create backup using mysqldump command and restore on slave server instead of using load data from master; command.When i replicate database from master to slave will i require to set user privileges same as master ?One more question: How to lock all database in mysql?

View 2 Replies View Related

Copyrights 2005-15, All rights reserved