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
ADVERTISEMENT
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
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
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
Jun 30, 2010
create a user for php/MySQL under ms win environment?
View 1 Replies
View Related
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
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
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
Aug 7, 2010
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies
View Related
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
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
View 13 Replies
View Related
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
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
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
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
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().
Code:
session
Session Support enabled
Registered save handlers files user sqlite
Registered serializer handlers php php_binary wddx
DirectiveLocal ValueMaster Value
session.auto_startOffOff
session.bug_compat_42OnOn
session.bug_compat_warnOnOn
session.cache_expire180180
session.cache_limiternocachenocache
session.cookie_domainno valueno value
session.cookie_httponlyOffOff
session.cookie_lifetime00
session.cookie_path//
session.cookie_secureOffOff
session.entropy_fileno valueno value
session.entropy_length00
session.gc_divisor100100
session.gc_maxlifetime14401440
session.gc_probability11
session.hash_bits_per_character44
session.hash_function00
session.namePHPSESSIDPHPSESSID
session.referer_checkno valueno value
session.save_handlerfilesfiles
session.save_path/tmp/tmp
session.serialize_handlerphpphp
session.use_cookiesOnOn
session.use_only_cookiesOffOff
session.use_trans_sid00
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
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
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
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:
Code:
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
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
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
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
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
Dec 4, 2010
i want to pass variable in mysql qyery in c programming
View 1 Replies
View Related
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
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
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:
Code:
> mysql -b -u MY_user -p
Enter password:
[code]....
View 6 Replies
View Related
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
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
Oct 2, 2010
Is there any reason for the mysql user to need bash shell?
From /etc/passwd:
Code:
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
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
