General :: Test Login To Mysql Via Mod_perl?
Aug 6, 2010
would this script not work?
Code:
#!/usr/bin/perl
#PERL module
use Mysql;
#CONFIG VARIABLES
[Code].....
I clearly have a lot to learn, but I have done about 10 Google searches trying to find out how to test connectivity b/t mod_perl and mysql.. maybe I'm confused on how this works.
I have this in httpd.conf
Code:
Perlrequire /etc/httpd/conf/perl-startup.pl
PerlWarn On
PerlModule Apache::DBI
I have this in perl-startup.pl
[Code]....
View 4 Replies
ADVERTISEMENT
Mar 15, 2010
I am trying to install mysql 5.1.44..so i downloaded the binary package, i extracted it and then followed the instructions that were in the manual but i keep getting this error when running this command
Code:
scripts/mysql_install_db --basedir=/home/mosty/mysql
the error is
Code:
Installing MySQL system tables...
100315 20:07:27 [Warning] Can't create test file /var/lib/mysql/mosty.lower-test
100315 20:07:27 [Warning] Can't create test file /var/lib/mysql/mosty.lower-test
[code]....
You can try to start the mysqld daemon with:
shell> /home/mosty/mysql/bin/mysqld --skip-grant &
and use the command line tool /home/mosty/mysql/bin/mysql to connect to the mysql database and look at the grant tables:
shell> /home/mosty/mysql/bin/mysql -u root mysql
mysql> show tables
View 1 Replies
View Related
Feb 8, 2010
mysql -u root -p but unable to create any database.
if i tried to configure it's giving error ERROR 1006 (HYOOO) : can't create database 'test' (error: 2)
my location for database is /var/lib/mysql and permissions are
drwxrwxrwx mysql root.....
View 1 Replies
View Related
Nov 18, 2009
I did command:
sudo -s
chmod 770 .
chmod 770 ..
And now I cannot login on my test server notebook. Please do not ask why I use server software on my notebook. Cause I like it and I use it only for typing text en learning linux commands. So I have a notebook with ubuntu server 8.04.2.
First question is:
Why have linux after command ls -l -a this output?
drwxr-xr-x 21 root root 4096 2009-11-04 20:45 .
drwxr-xr-x 21 root root 4096 2009-11-04 20:45 ..
And how must it to set and use? What is it's function? How can I repair my server notebook? Must I unmount my harddisk with a sqrewdriver and connect it to/on an other linux machine? If its needed, I can do that.
View 6 Replies
View Related
Jul 21, 2011
Since I have never had the need to create one, the first time I encounterd it I asked myself: what is it?I was looking for MySql installation guidelines on mysql.com, when, reading them, I found this command:shell> useradd -r -g mysql mysql.Now, I read the man page of useradd looking for explanation about -r option, but I didn't found it useful.It just says that -r options creates a System account, but it doesn't say anything else.So my question is: what is a system account? Few lines under the command it says:"Because the user is required only for ownership purposes, not login purposes, the useradd command uses the -r option to create a user that does not have login permissions to your server host."What would be the benefits if mysql user has not login permission?
View 6 Replies
View Related
Sep 29, 2010
I know very little about MySQL, but I've got some users that need it for testing on a Linux server.So I had set it up a while back, but now I'm running into some small problems.Right now, each user has his own database that I created and can do whatever with it. Each user only sees their own database.I didn't want them to be able to create new databases at all, but they can and when they do anyone can see them.
EDIT(Apparently they can only create databases beginning with the word "test" in the name)
I need to either:
1) Stop them from creating new databases (without affecting their ability to interact with the existing database)
OR
2) Make it so that when they create a database, only they have privileges on it and only they can see it (except mysql root of course).
Anybody know the statement to set these kinds privileges up?
EDIT: pfft... I've a read a bit more and realize that this is an intended part of the installation.
EDIT2
I'd still like to remove the ability to make test databases.
EDIT3:Ok, for reference this is how you prevent users from making and using test databases:
shell> mysql -u root -p
Enter password: (enter root password here)
mysql> DELETE FROM mysql.db WHERE Db LIKE 'test%';
mysql> FLUSH PRIVILEGES;
View 4 Replies
View Related
Jul 8, 2010
I was playing with the mysql my.cnf file yesterday, trying to move my database files to my dropbox folder so I can use the database on my other machine. All I changed was the datadir setting to point to my dropbox folder. I also moved my mysql data files there.
When I tried to restart mysql and test the new location it said my mysqld.sock was missing. I searched and searched the web and my filing system for it but I have no idea what's happened to it?? I have even tried changing the datadir path back and reinstalling mysql but that doesn't seem to work either.
View 2 Replies
View Related
Mar 26, 2011
I have created mobility of 20 nodes and vbr traffic using following attached script I executed the file as ns234 vbr.tcl I got the vbr.tr and vbr.nam but I was unable to load the graph using matlab <trgraph> I thought problem with is vbr.tcl script.
View 1 Replies
View Related
Jun 2, 2010
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
View 9 Replies
View Related
May 2, 2010
Is possible to use mod_perl with lighttpd?
View 1 Replies
View Related
May 2, 2011
Just for some testing on a test non-productive machine, how to allow Gnome login by root user on squeeze?
View 8 Replies
View Related
Nov 15, 2010
Few months ago I'd got problem with Apache on my server. Some requests required few gigabytes of memory, much more than was avaliable. I've set ulimit -v XXX and this fixed problem for single request.
I still have got problem with multiples requests. I'm using mod perl, which runs few processes for requests, we can assume, that there is one process per request. ulimit cannot handle this, because it can only limit virtual memory per process, not for a group of processes.
View 1 Replies
View Related
Sep 10, 2010
I am trying to compile and install mod_perl with apache so I can use apache:asp.
I run Makefile.PL with this command.
Code:
perl Makefile.PL APACHE_SRC=../apache_2.2.9/src
DO_HTTPD=1 USE_APACI=1 EVERYTHING=1
APACI_ARGS='--prefix=/usr/local/httpd_perl'
then I run make.
I get this error.
[error]
/usr/bin/ld: cannot find -lperl
collect2: ld returned 1 exit status
make[1]: *** [mod_perl.so] Error 1
make[1]: Leaving directory `/usr/src/mod_perl/src/modules/perl'
make: *** [modperl_lib] Error 2
[/error]
It does not seem to be finding perl but I do nt know why or what to do about it?
could this be the problem? APACI_ARGS='--prefix=/usr/local/httpd_perl' I do not have the slightest ideal what that means or if I need it.
View 2 Replies
View Related
Oct 9, 2010
I have a trouble with the installation the libapreq2 package to configure mod_perl and Template Toolkit on Centos Linux with Apache 2.2.3 I obtained the following error message:
This error message appears when it tries to configure apxs.
View 3 Replies
View Related
Apr 12, 2011
I'm installing mod_perl and when running the make test I got the following errors:
-o mod_perl.so
/usr/bin/ld: cannot find -lperl
collect2: ld returned 1 exit status
make[1]: *** [mod_perl.so] Error 1
make[1]: Leaving directory `/home/alan/mod_perl-2.0.5/src/modules/perl'
make: *** [modperl_lib] Error 2
So as this is the first time I have tried developing with mod_perl I tried googling the error and -lperl
View 2 Replies
View Related
Apr 27, 2011
I have mod_cgi working perfectly. However, it turns out there are features of mod_perl that I'm trying to use. I have followed all the documentation I can find on using Ubuntu's mod_perl install with Apache2. There seems to be some type of problems with the mod_perl's documentation, as it doesn't work as it's defined. However, I found a modification to make it work, but only is designated directories. If I tried to use in a directory with my other HTML files the regular HTML files will fail.
Using these steps (but using apt-get's install rather than compiling the tar ball). I did as follows:
[URL]
placed this in the httpd.conf file (which was basically the same as "a2enmod perl".
httpd.conf line:
Code:
LoadModule perl_module /usr/lib/apache2/modules/mod_perl.so
Alias /perl/ /home/web/perl/
<Directory /home/web/perl>
SetHandler perl-script
[Code]....
View 7 Replies
View Related
Jul 10, 2010
I am installing mod_perl on the Linux box. Could successfully installed httpd, mod_perl, expat. Now when I try to run "make" command for libapreq2-2.12, it gives following error -
[FONT="Arial"]Making all in glue
make[1]: Entering directory `/opt/customer/apache/2.2.8_64_modperl/lib/libapreq2-2.12/glue'
cd perl; /usr/bin/perl Makefile.PL -apxs /opt/customer/apache/2.2.8_64_modperl/bin/apxs
Can't locate Apache2/Build.pm in @INC (@INC contains: /usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi /usr/lib/perl5/5.8.5 /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.4/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.3/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.2/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.1/x86_64-linux-thread-multi
[Code]...
View 2 Replies
View Related
Oct 2, 2010
I'm having problems with a mysql install on a ubuntu server edition.
I forgot the mysql root password(or maybe it's always been screwy), so I attempted to reset the root password using this:
Code:
sudo dpkg-reconfigure mysql-server-5.0
However this did not work.
So I decided to run
Code:
sudo apt-get purge mysql-server-5.0 && sudo apt-get install mysql-server-5.0
And re-entered the root password and again I still can't login!
This is the error I keep getting.
Code:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Is there any further steps I can do to wipe this crappy mysql install?
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
Feb 19, 2010
Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 Replies
View Related
May 13, 2011
I have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.
now a these days i am connect through ssh and excuting below command
#mytop mysql -u root -p <passwd>
In my mysql db i have added the userip & passwd (allowed the privileages for that ip)
If i use mysql-administrator i am getting below error
MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)
View 6 Replies
View Related
Jun 14, 2011
I have tried many different ways to interact with the mysql to reset the root mysql pass. This is what I got to right now
Code:
#!/bin/sh
newpass=$1
service mysqld stop
mysqld_safe --skip-grant-tables --skip-networking &
echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD("$newpass") where User="root";" >> /tmp/mysql_pass_reset.txt
[Code]...
View 6 Replies
View Related
Apr 8, 2009
I have installed Postfix + Amavisd-new, then I am started all services (and configured main.cf and master.cf to use amavis).
The questions are:
1) I am trying to test antivirus scan using eicar test virus
Code:
And the message is successfully delivered to mailbox with mark "CLEAN" in maillog. But I cant see any attachment using
Code:
Where is my mistake?
2) Should I update clam and how I can do it?
3) Is spamassassin enabled by default in amavis (I have started daemon)?
4) Where configuration files of spamassassin is stored?
View 1 Replies
View Related
Jun 9, 2010
I have machine which manages all mail accounts and their traffic and as well mysql database and some more stuff. Theres also windows server where users are managed and they get their programs from over rdp. I have login screen on Linux machine. It says Debian GNU/Linux 5.0. And I have root password, but I know that I have to login first with simple user account after which I can access login as root. But where can I get simple user account info. I need to manage mailaccounts mainly there.
View 3 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
Mar 16, 2010
I have been trying to set up GLPI with OCS inventory but am having issues installing OCS. I have been following the below directions and when i go to [url] the login page gives me an error.
Quote:
Now i have not tried to log in yet so its like there is a auto log in. What config file do i have to edit to turn this off?
Something that may be effecting this would be the following step (below high lighted in red)i do not do as i do not see this line when installing. I am installing 1.3.1 not 1.0 like the guide was written for, which i think is what is causing me not to see this step.
This install procedure was meant for Debian Etch but should work for Ubuntu. Just add sudo to the beginning of all the commands. Or you can login as root and run them by typing:
At a command prompt type:
View 2 Replies
View Related
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Jul 23, 2015
I just switched form MySQL to MariaDB for my WordPress website which is run with Apache, but I had a little problem logging in. So, I backed up all of my databases, deleted all of MySQL's configuration files, and reinstalled MariaDB. However, now I'm completely unable to login to MariaDB.
Whenever I try to, it says: ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded.
Also, why didn't MariaDB ask me to set up a password during the installation process like MySQL does?
View 8 Replies
View Related
Nov 25, 2010
I have so far: installed and configured postfix, installed courier, installed MySQL and SASL. mostly following a guide on [URL]
When I want to login via POP3 with a user from the MySQL database, authentication fails.
The mail.log file contains the followiung error:
Nov 25 18:47:55 asmahan pop3d: Disconnected, ip=[::ffff:10.11.39.33]
Nov 25 18:48:05 asmahan pop3d: Connection, ip=[::ffff:10.11.39.33]
Nov 25 18:48:16 asmahan pop3d: LOGIN FAILED, user=john, ip=[::ffff:10.11.39.33]
The problem only occurs when I try to login via POP3. I can send emails via SMTP using the same account without any problems.
View 1 Replies
View Related
Jun 26, 2011
how to implement a password login system that both sends passwords over the internet in an encrypted form (so my users don't get that annoying message saying "this web site is about to send your password in an unsafe form..." and stores its user data in a MySQL database? This seems to need a combination of mod_auth_digest and mod_auth_mysql.
View 1 Replies
View Related
