I have been tearing my hair out with this. As part of a backend perl script i am holding the Epoch time as session data using apache session and mysql so i can delete sessions after an expiry period. When I retrieve the time it is about three months old even when i only just set it. The code example below best describes the problem:
View 5 RepliesI have been fighting with this for days. I upgraded from etch to lenny. I tried installing mysql-5.1. I have uninstalled, reinstalled, updated, upgraded, many, *many*, times. It just stubbornly refuses to work.
Quote:
Been working with this problem for over a week now and has come to a dead end, I have installed pureFTPD with MySQL on Debian 5 Lenny 64bit. My problem is I can't login with the users in the sql-database, but for some strange reason, I'm allowed to loggin as anonymous. Unix users can't login either.
I have followed the guide on: [URL]..
- Created a ftpgroup and ftpuser.
- Created a database ftpd
- Created a user vhosts and given access to ftpd db
My configurations files
/etc/pure-ftpd/auth/30mysql
Code:
/etc/pure-ftpd/db/mysql.conf
/etc/pure-ftpd/db/mysql.conf
[Code]...
My Apache web server (respectively a child process) is crashing several times a day. I wanted to find the exact reason and activated the core dumps but even though the crashing-issues continue, the core dumps were never created. I have found several howto's which basically point to the same steps:
- set "ulimit -c unlimited"
- add "CoreDumpDirectory" directive into apache2.conf (Debian's httpd.conf)
Another info I've found is that /proc/sys/fs/suid_dumpable shouldn't be 0 - so on one howto it said to echo 2 into it, on another one to echo 1 to /proc/sys/fs/suid_dumpable - didn't work with neither of them.
I can't get mysql to update from lenny (mysql-5.0) to squeeze (5.1). apt tries to start the server but comes up with some kind of configuration script error.
View 1 Replies View Relatedi do have a strange problem get running php5 on lenny 64 inside apache2. i had installed it as all instructions on the web does: # apt-get install php5 libapache2-mod-php5 php5-cli php5-common php5-cgi
apt has enabled php automatically, so
/etc/apache2/mods-enabled/php5.conf does have inside:
<ifmodule mod_php5.c>
AddType application/x-httpd-php .php .phtml .php3
AddType application/x-httpd-php-source .phps
</ifmodule>
[Code]...
I've been trying to install MySQL in Lenny via source binaries, following the instructions given on the MySQL official website[url]
But when i try to run the scripts/mysql_install_db --user=mysql command, doesn't work.
For the record, i'm particularly interested on installing MySQL with the generic source binaries.
how to install Apache web server as I want to run my Perl and PHP scripts in web environment. what configuration I need for Perl and PHP. Does I also need some separate software/package/module for perl and PHP? I have experience of running ASP scripts with IIS in Windows environment but have no idea of Apache in Linux for Perl and PHP.
View 4 Replies View RelatedI am trying to write a perl script which will give an interactive session to a user to execute command on the server. I have written a small script to do this :
Code: !/usr/bin/perl -w
use strict;
use Net::SSH::Perl;
my $host = '192.168.1.1';
my $username = 'user';
my $login_passwd = 'test123';
[Code]...
I've got this issue for past week.
Mysql Crashes with 111 error although it starts back up instantly.
but i can't seem to figure out why.
-Server Is Deb. Lenny + Direct Admin.
Quad Core 2.5, 8GB Ram.
-Mysql ver 5.3
-Htop shows mysql is most of the time using 33 - 50% CPU.
(the init.d name is /etc/init.d/mysqld )
-This is from the err log of last crash. code...
As I mentioned on another thread, I have 2 Ubuntus - Jaunty and Meerkat - as separate drives on my secondary IDE channel. I am removing Jaunty. Meerkat blows it away. And is certainly my preferred OS. However I am looking for a replacement for Jaunty that is more flexible in certain key areas than Ubuntu appears to be.I dont want to be restricted to Debian versions of things like Perl, MySQL, PHP and others. I can run LAMPP, but I would prefer to compile and have the versions of my choice as part of a main test system (apart from Meerkat that is).
I have had enough nightmares in Jaunty with things getting broken and spiralling out of control. I want a distro that doesnt rely on the GUI and its attendant utilities, but can run them when called. Meerkat is stable and has resisted me breaking it so far, but I do not want to push my luck. I have too much time invested in it. I intend to use Meerkat as my primary system on the machine, but want an alternative to *PLAY* with.
I just installed apache2 on my VPS (running Debian 5 (lenny)). Problem is that when i start apache2 nothing happens.
Code:
ps ax |grep apache
and
Code:
ps ax |grep httpd
returns only the grep process itself, and
[Code]....
The upgrade actually went pretty well, except for what looks like a new "feature" to mysql-server-5.1. But I post here, because the issue seemed to be in "/etc/hosts" file. If it should really be somewhere else, feel free to move it. The problem is that I don't understand what this means. What potential problems do I have without a "127.0.1.1"? Or could this have been effected by some change to the "users" table in mysql? This mythtv server "musem" is my main machine, and is being remotely accessed by the Linux box next to my TV.
View 1 Replies View Relatedi'm new to Debian os and currently want to install php5 apache2 and mysql 5.1. But ive got problem to start the mysql services.The error on command prompt as belows:
[Code]...
I have a debian server default installed and i am trying to get cross subdomain session to work. I used this code to test on 2 subdomains
<?php
session_set_cookie_params(0 , '/', '.domain.ltd');
session_start ();
[code]....
I'm running a linux cloud server with the following config
1.2ghz Processor allocation
752MB Ram
The site loads slow and clicking a link almost freezes the page for a second. Also, the page loads could be much faster. We've been running mysqltuner and have pretty much optimized all slow queries. Is there anything we can do to fine tune the server for faster and more responsive?
Httpd.conf
Timeout 20
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
<IfModule prefork.c>
code....
I'm running an Apache web server version 2.2.11 on Fedora 10. I'm trying to get it to run a PERL cgi script but with only partial success. The script uses the PERL cgi package.
The perl script is a simple test case that creates a form to fill in. Once the submit button has been clicked it should then return the data submitted. The perl script writes this to a file called output.cgi
The intial script located in /var/www/cgi-bin/index.cgi gets executed fine when I go to [URL], this works with no probs. However once I hit the button to submit the data I then get the error
Not Found
The requested URL /cgi-bin/output.cgi was not found on this server. Apache/2.2.11 (Fedora) Server at localhost Port 80 Im not sure if its a perl problem or server setup problem, theres probably a simple switch or something but Im out of ideas at the moment.
Running slackware13.1 with mysql on box2 and apache on box1 both in same lan. How do i configure mysql for apache connection? I have looked at many mysql config. howto which i can follow but i'm confused about whether the connection type is considered remote connection because the 2 services are on seperate boxes but are in same lan? Apache will be serving public webpages not just to the lan.
View 1 Replies View RelatedWe are working on a new ERP for the company. This will run in MySQL 5.1.x, the GUI will be Web, the language PHP. This is a big project, is a good option to have the 3 applications in the same server or is better to have Mysql on 1 server and httpd+php on other server?
Speaking that I want to virtualize this app with Xen on Centos 5.5 as Host and the guest's will run Ubuntu.
I found the desktop version but I am wondering is there a server version where apache php mysql are all there?
View 1 Replies View RelatedI have a problem with AMXbans. My Linux is Slackware 13.0. , mysql is version 5.0.84, Apache/2.2.13,PHP 5.2.3 from locahost or real IP in internet explorer i see this error " Lost connection to MySQL server at 'reading initial communication packet', system error: 111".
In /var/log/httpd/error_log I see this error:
" [error] [client IP] PHP Warning: mysql_connect()
[<a href='function.mysql-connect'>>function.mysql-connect</a>]:
Lost connection to MySQL server at 'reading initial communication packet',
system error: : 111 in /var/www/htdocs/web/include/config.inc.php on line 48,
referer: http://My real IP/web/
//connect to db - "this is line 46"
$config->db_host=gethostbyname($config->db_host); "this is line 46"
$mysql = mysql_connect($config->db_host,$config->db_user,$config->db_pass) or die (mysql_error()); - "this is line 48"
I run mysqld on another server. I just switched to another dedicated server now, and i'm having trouble connecting to the mysqld server. If i run the php script from the bash console( php connect.php ) it works perfectly and connects to the mysqld server. However, if i run the script from apache ( http://localhost/connect.php ) it returns this: Can't connect to MySQL server on '(mysqld real ip)' (13) Mysql connection from another server(old httpd server) works perfectly, so it's not from the database server.
View 4 Replies View Relatedi have apache and mysql running, i can access my web server by visiting localhost on port 80 but for some reason when it doesnt work when i try using my ISP provided IP address... (it used to work).. i have my router setup with a DMZ on my LAN IP (my computers IP, this is the computer in my home network that serving with apache).. i also cant seem to shut down my mysql server (theres an update ive been trying to get) even when i use sudo...
View 5 Replies View RelatedGood tutorial, using images for a lamp server that has, MySQL,PHP, Apache, FTP with all the fruit for running a server that will host a Gallery, forum and main site
I know there's heaps around for Ubuntu 9.10, but its not quiet what I'm looking for as in Gd, ImageMagick and some extras for Apache mods
I need to tune the mysql and apache server for the comparatively busy webserver. My scenario is like this.
1. The Web request is around 2000 request at a time or more.
2. Each web request will generate one mysql query.
3. The query to database is all read.
4. This server load will be at peak for around 3-4 hours after that the load will subside. As the task will be published, around 300,000 will be viewing the page.
5 quad servers are deployed, load is balanced via DNS but performance is not as expected. Centos 5.5 is used as OS. Top command shows The mysql process is around 185%!
I just installed Centos 5.5 on one of my systems today and something is eluding me. Basically I had a web site and forum software (phpBB, but I don't think it's that, other forum software like Xoops does the same thing) running on Fedora 13, and I copied it over to the new Centos installation. Apache is running fine and displays a PHP test file and .html files just fine.
MySQL seems to be fine, I can log into that, show databases etc. Just can't get any forum software to know there is MySQL there. I did change the path of the site, and the databases, and edited /etc/my.cnf and /etc/httpd/conf/httpd.conf to reflect that. Thought I made the needed changes in /etc/php.ini but who knows. Seemed like everything should have tar'd up and moved easy, but not the case...
Just setup an Apache2 server, and I would like to setup a login. I also wanted to use the same method that is setup for vsftpd For vsftpd I've created a mysql database.... structured as:
Code:
mysql> use vsftpd
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> describe accounts;
[Code]...
I'm working on a side project where I would like to install three ubuntu server systems,each with only one task.So server0 would be the apache server, server1 would be the database and server2 would be the file server.which key terms I should be researching?
View 9 Replies View RelatedI started over combining the first parts of this guide: [URL]..ubuntu8.04 (Only the first few parts in terms of configuration and naming). Then I used this guide: [URL]..Surprisingly enough all steps worked.
1. Now I need to set up LAMP servers with MySQL master/slave replication and Apache rsync.
2. Next i need to add BIND to both my Load Balancers with master/slave backup and replication...
Are there any guides to look at to follow on these? Can tou point me to the right direction for BIND with replication.
I had debian 7 with GNOM,XFCE and LXDE woking fine. After I upgraded it to debian 8 (the DE mentioned also upgraded to e newer versions) I started having problems with switching between US and RU keyboard layouts. It now behaves as if I have two US layouts and one RU, so when I press CTRL+SHIFT several times the layout changes as follows: US-RU-US-US-RU-US-US-RU etc.
This happens in all the three DEs installed. If I exit a DE using CTRL+ALT+F1 to the command line the layout switches normally. So I guess something wrons is with DEs.
My /etc/default/keyboard file reads as follows:
Code: Select allXKBLAYOUT="us,ru"
XKBVARIANT=","
XKBOPTIONS="grp:ctrl_shift_toggle"
XKBMODEL="pc105"
BACKSPACE="guess"