mysql problem

2011-04-08 Thread Gianluca D'Auri Muscelli
Hi, i'v installed postfix-mysql + mysql-server + courier-imap and imap-ssl + courier-pop and pop-ssl on OpenBSD 4.8-Stable But now i have a problem with vmail and mysql, i'v created the database for postfix users Pastebin link of database: http://pastebin.com/70qd43AZ And i insert my account

Re: mysql problem

2011-04-08 Thread jirib
On Fri, 8 Apr 2011 09:52:15 +0200 Gianluca D'Auri Muscelli g...@email.it wrote: Hi, i'v installed postfix-mysql + mysql-server + courier-imap and imap-ssl + courier-pop and pop-ssl on OpenBSD 4.8-Stable But now i have a problem with vmail and mysql, i'v created the database for postfix

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-13 Thread Daniel Gracia Garallar
Not quite a solution, I think. What about if /var/www mounts in a different filesystem than /var? Hardlinks from chrooted environments don't seem to be a wise solution anyway... Just IMHO. Regards, Dani El 12/03/2010 12:16, Sunnz escribiC3: 2010/3/11 Janmalepa...@googlemail.com: I didn't

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-13 Thread Edho P Arief
On Fri, Mar 12, 2010 at 6:58 PM, Daniel Gracia Garallar danie...@electronicagracia.com wrote: Not quite a solution, I think. What about if /var/www mounts in a different filesystem than /var? how about - tell mysql to create sock file in /var/www/var/run/mysql; or - tell php to connect to

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-13 Thread Sunnz
2010/3/12 Daniel Gracia Garallar danie...@electronicagracia.com: Not quite a solution, I think. What about if /var/www mounts in a different filesystem than /var? Hardlinks from chrooted environments don't seem to be a wise solution anyway... Just IMHO. In that case you could change the

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-13 Thread L. V. Lammert
On Sat, 13 Mar 2010, Sunnz wrote: 2010/3/12 Daniel Gracia Garallar danie...@electronicagracia.com: Not quite a solution, I think. What about if /var/www mounts in a different filesystem than /var? Hardlinks from chrooted environments don't seem to be a wise solution anyway... Just

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-13 Thread bert beaudin
This has also worked for me in the past. Bert On 3/13/10 9:27 AM, L. V. Lammert l...@omnitec.net wrote: On Sat, 13 Mar 2010, Sunnz wrote: 2010/3/12 Daniel Gracia Garallar danie...@electronicagracia.com: Not quite a solution, I think. What about if /var/www mounts in a different filesystem

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-13 Thread Stuart Henderson
On 2010-03-13, Sunnz sun...@gmail.com wrote: 2010/3/12 Daniel Gracia Garallar danie...@electronicagracia.com: Not quite a solution, I think. What about if /var/www mounts in a different filesystem than /var? Hardlinks from chrooted environments don't seem to be a wise solution anyway... Just

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-12 Thread Sunnz
2010/3/11 Jan malepa...@googlemail.com: I didn't notice, that httpd was still running. kill -TERM ID_of_httpd httpd -u solved the problem. Thank you! Everything works fine! Now that it works we know that it was a problem with chroot. It might be a good practice now to hardlink the

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-12 Thread Jan
Sounds very interesting. But using find / -name mysql.sock isn't successful, so creating a hardlink doesn't work. The directory /var/run/mysql doesn't exist either. Jan Sunnz wrote: 2010/3/11 Jan malepa...@googlemail.com: I didn't notice, that httpd was still running. kill -TERM

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-12 Thread Alexander Hall
Jan wrote: I didn't notice, that httpd was still running. kill -TERM ID_of_httpd httpd -u solved the problem. Thank you! Everything works fine! Well if you're happy running httpd non-chrooted, then fine (seriously). I would not be though. If not, there is more stuff to try in my last

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-11 Thread Jan
I didn't notice, that httpd was still running. kill -TERM ID_of_httpd httpd -u solved the problem. Thank you! Everything works fine! Jan Alexander Hall wrote: Jan wrote: Thank you for the numerous responses! Except the solution to change localhost to 127.0.0.1 in the whole script, I

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-10 Thread Alexander Hall
Jan wrote: Thank you for the numerous responses! Except the solution to change localhost to 127.0.0.1 in the whole script, I tried everything you Do try that then. I dont know the script at hand, but it cannot be that many places that creates a database connection, can it? IIRC, localhost

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-09 Thread Jan
Thank you for the numerous responses! Except the solution to change localhost to 127.0.0.1 in the whole script, I tried everything you proposed. It still doesn't work. Here a short review: === Are you trying to connect to the MySQL socket outside of the httpd chroot? === after having run

Joomla - MySQL Problem: Could not connect to MySQL

2010-03-08 Thread Jan
Hello all together, I installed PHP and MySQL on my box (running apache). When I try to install Joomla, the MySQL Database is recognized by the precheck of the install script. But when I try to connect to the database I get the following error msg: Unable to connect to the database: Could

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-08 Thread Scott McEachern
Jan wrote: I added the following 3 packets, installed MySQL and set the symbolic links: mysql-server-5.0.51ap1.tgz php5-core-5.2.6.tgz php5-mysqli-5.2.6.tgz Any ideas? Jan At the very least you'll also need the php5-mysql-5.2.6.tgz package installed as well. It contains the base

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-08 Thread Floor Terra
On Mon, Mar 8, 2010 at 10:07 PM, Jan malepa...@googlemail.com wrote: Any ideas? Are you trying to connect to the MySQL socket outside of the httpd chroot? Floor -- Floor Terra flo...@gmail.com www: http://brobding.mine.nu/

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-08 Thread Gaby Vanhegan
On 8 Mar 2010, at 21:07, Jan wrote: Unable to connect to the database: Could not connect to MySQL Check that your code is connecting to 127.0.0.1 instead of localhost? Usually fixes it for me and you don't need to worry messing around with sockets. G. -- Bought to you by the Department of

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-08 Thread L. V. Lammert
On Mon, 8 Mar 2010, Jan wrote: Unable to connect to the database: Could not connect to MySQL 1) Create a simple phpinfo() page check to see that your MySQL is configured properly. Did you install php-mysql? 2) I'm also able open the DB using mysql -u root -p. The only valid test is with the

Re: Joomla - MySQL Problem: Could not connect to MySQL

2010-03-08 Thread Fred Crowson
On Mon, Mar 8, 2010 at 9:07 PM, Jan malepa...@googlemail.com wrote: Hello all together, I installed PHP and MySQL on my box (running apache). When I try to install Joomla, the MySQL Database is recognized by the precheck of the install script. But when I try to connect to the database I get

Cyrus-SASL2-mysql problem on 4.2

2007-11-14 Thread Evgeniy Sudyr
Hello misc, I installed cyrus-sasl-2.1.22p1-mysql from packages and trying make it working, but during testsaslauthd queries I not get any results :(. I enabled log queries in mysql but there is no connection attempts from saslauthd to needed table (no connection, no auth, nothing). As

Re: Cyrus-SASL2-mysql problem on 4.2

2007-11-14 Thread Antoine Jacoutot
On Wed, 14 Nov 2007, Evgeniy Sudyr wrote: # cat /usr/local/lib/sasl2/smtpd.conf pwcheck_method: auxprop [...] # testsaslauthd -s smtpd -u eject -p mypassword 0: NO authentication failed If you use auxprop as pwcheck_method, then why are you testing with testsaslauthd? Also, did you

Re: mysql problem

2007-07-16 Thread Marcos Laufer
this was not an OpenBSD or MySQL problem, but a configuration problem , and maybe some other OpenBSD user might have already been there and willing to help other OpenBSD users to work things out. If you are an OpenBSD developer then i must tell you that i understand your 'I could tell you what to do

Re: mysql problem

2007-07-16 Thread Tony Abernethy
to the OpenBSD users, as it was this case. I know this was not an OpenBSD or MySQL problem, but a configuration problem , and maybe some other OpenBSD user might have already been there and willing to help other OpenBSD users to work things out. If you are an OpenBSD developer then i must

Re: mysql problem

2007-07-16 Thread Daniel Ouellet
) I could be asking for help to the OpenBSD users, as it was this case. I know this was not an OpenBSD or MySQL problem, but a configuration problem , and maybe some other OpenBSD user might have already been there and willing to help other OpenBSD users to work things out. And you got a lots

Re: mysql problem

2007-07-15 Thread Marcos Laufer
Ok , i had followed the instructions at http://openbsdsupport.org/mysql.htm And now i have this configuration: I start mysql with this script: # cat /usr/local/bin/mysql.start if [ -x /usr/local/bin/mysqld_safe ] ; then su -c _mysql root -c '/usr/local/bin/mysqld_safe ' /dev/null echo -n

Re: mysql problem

2007-07-15 Thread Otto Moerbeek
On Sun, 15 Jul 2007, Marcos Laufer wrote: Ok , i had followed the instructions at http://openbsdsupport.org/mysql.htm No you did not. You plugged in bigger numbers. That could very well be your problem. Also there should be some correspondence to the numbers in login.conf and my.cnf. Another

Re: mysql problem

2007-07-15 Thread Daniel Ouellet
Marcos Laufer wrote: Ok , i had followed the instructions at http://openbsdsupport.org/mysql.htm Go back and read again many times over until you get it. You didn't read it and you didn't pay attention to statement in bold either. I could tell you what to do to fix it, but then you wouldn't

Re: mysql problem

2007-07-15 Thread Daniel Ouellet
Marcos Laufer wrote: Ok , i had followed the instructions at http://openbsdsupport.org/mysql.htm I also forgot to add this as well in my previous reply, also in the text of the document you have been pointed to. So, be wise and change what you need to change for your setup! But only what

Re: [solved] mysql problem

2007-07-15 Thread Marcos Laufer
despite of what i configured in my.cnf. Regards, - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org; [EMAIL PROTECTED]; Daniel Ouellet [EMAIL PROTECTED] Sent: Sunday, July 15, 2007 3:54 AM Subject: Re: mysql problem On Sun

Re: mysql problem

2007-07-14 Thread Nico Meijer
Hi Marcos, These instructions work for me: http://www.openbsdsupport.org/mysql.htm HTH... Nico

Re: mysql problem

2007-07-14 Thread Darrin Chandler
On Sat, Jul 14, 2007 at 11:52:05PM +0200, Nico Meijer wrote: These instructions work for me: http://www.openbsdsupport.org/mysql.htm Those are close to what I use, with some exceptions. If you follow that and understand *why* you're doing what you're doing, then you're on the path to goodness.

Re: mysql problem

2007-07-13 Thread Gordon Stratton
On 7/12/07, Marcos Laufer [EMAIL PROTECTED] wrote: ERROR 1018 (HY000): Can't read dir of './mysql/' (errno: 9) Use fstat(1) or similar tool to check the open files on the system, maybe you're bumping up against a limit somewhere? There is an old thread[1] on a similar topic which might apply

Re: mysql problem

2007-07-13 Thread Marcos Laufer
Maybe i need to increase something else? Thanks! - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org Sent: Friday, July 13, 2007 3:12 AM Subject: Re: mysql problem On Fri, 13 Jul 2007, Marcos Laufer wrote: I am having

Re: mysql problem

2007-07-13 Thread Otto Moerbeek
On Fri, 13 Jul 2007, Marcos Laufer wrote: I am having a very strange problem on a 3.9 , suddenly i can't access any table on the databases. I have around 100 databases on this server and can't access not even one. This is a production server and i am in an urge to solve it, if anyone can

Re: mysql problem

2007-07-13 Thread Otto Moerbeek
else? Thanks! - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org Sent: Friday, July 13, 2007 3:12 AM Subject: Re: mysql problem On Fri, 13 Jul 2007, Marcos Laufer wrote: I am having a very strange problem

Re: mysql problem

2007-07-13 Thread Marcos Laufer
@openbsd.org Sent: Friday, July 13, 2007 4:07 AM Subject: Re: mysql problem On Fri, 13 Jul 2007, Marcos Laufer wrote: I did read the archives, and it helped me to find out that restarting mysql fixes it for some time, and i increased the values several times but no luck. It starts working fine

Re: mysql problem

2007-07-13 Thread Stuart Henderson
On 2007/07/13 13:41, Marcos Laufer wrote: How are yo starting mysql? You need to explicitly set the login class. Somthing like su -c mysql root /usr/local/bin/mysqld_safe ... I am , and i have a simple and nice script for starting and stopping it properly: Where are you setting

Re: mysql problem

2007-07-13 Thread Bob Beck
? Regards, Marcos - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org Sent: Friday, July 13, 2007 4:07 AM Subject: Re: mysql problem On Fri, 13 Jul 2007, Marcos Laufer wrote: I did read the archives, and it helped

Re: mysql problem

2007-07-13 Thread Marcos Laufer
PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: Otto Moerbeek [EMAIL PROTECTED]; misc@openbsd.org Sent: Friday, July 13, 2007 1:54 PM Subject: Re: mysql problem You are setting the user, not the login class. You have made a login class _mysql in /etc/login.conf, but it looks like you may

Re: mysql problem

2007-07-13 Thread Otto Moerbeek
] To: Marcos Laufer [EMAIL PROTECTED] Cc: Otto Moerbeek [EMAIL PROTECTED]; misc@openbsd.org Sent: Friday, July 13, 2007 1:54 PM Subject: Re: mysql problem You are setting the user, not the login class. You have made a login class _mysql in /etc/login.conf, but it looks like you may

Re: mysql problem

2007-07-13 Thread Clint Pachl
, 2007 3:12 AM Subject: Re: mysql problem On Fri, 13 Jul 2007, Marcos Laufer wrote: I am having a very strange problem on a 3.9 , suddenly i can't access any table on the databases. I have around 100 databases on this server and can't access not even one. This is a production

Re: mysql problem

2007-07-13 Thread Marcos Laufer
- Original Message - From: Clint Pachl [EMAIL PROTECTED] Cc: Marcos Laufer [EMAIL PROTECTED]; misc@openbsd.org Sent: Friday, July 13, 2007 6:05 PM Subject: Re: mysql problem Otto Moerbeek wrote: On Fri, 13 Jul 2007, Marcos Laufer wrote: I did read the archives, and it helped me to find out

Re: mysql problem

2007-07-13 Thread Steve Williams
? Regards, Marcos - Original Message - From: Clint Pachl [EMAIL PROTECTED] Cc: Marcos Laufer [EMAIL PROTECTED]; misc@openbsd.org Sent: Friday, July 13, 2007 6:05 PM Subject: Re: mysql problem Otto Moerbeek wrote: On Fri, 13 Jul 2007, Marcos Laufer wrote: I did read

Re: mysql problem

2007-07-13 Thread Daniel Ouellet
Marcos Laufer wrote: Now what? http://openbsdsupport.org/mysql.htm

mysql problem

2007-07-12 Thread Marcos Laufer
I am having a very strange problem on a 3.9 , suddenly i can't access any table on the databases. I have around 100 databases on this server and can't access not even one. This is a production server and i am in an urge to solve it, if anyone can help i would appreciate it: # mysql mysql -p Enter

snort any interface and 2.6.1.4 mysql problem

2007-04-08 Thread Soner Tari
Hi All, I have more than one interface I need to monitor with snort. I've read http://www.snort.org/docs/faq/1Q05/node35.html, To do that, I've created bridge0 and added both interfaces. Since I need to assign IP addresses to each interface, I could not just up the interfaces and add them to the

Chrooted CGI+Mysql Problem

2005-07-21 Thread Brandon Mercer
Hello all, I've been playing around with database driven web stuff lately in the chrooted apache. I've got a pretty simple CGI written in C that selects all of my blog entries from a database and displays them in a web page. I got things working running httpd with the -u flag and now i'm

Re: Chrooted CGI+Mysql Problem

2005-07-21 Thread Brandon Mercer
Brandon Mercer wrote: Hello all, I've been playing around with database driven web stuff lately in the chrooted apache. I've got a pretty simple CGI written in C that selects all of my blog entries from a database and displays them in a web page. I got things working running httpd with the -u

Re: PHP or Mysql problem?

2005-06-16 Thread Per Engelbrecht
James Strandboge wrote: On Wed, 2005-06-15 at 11:30 +0200, Nico Meijer wrote: Hi Kiraly, mysql error: Can't create/write to file '/tmp/ #sql_4c99_0.MYD' (Errcode: 9) MySQL problem. Simple suggestions, not idiot-proof: I prefer this on OpenBSD 3.6 (should be same on 3.7): Add to /etc

Re: PHP or Mysql problem?

2005-06-16 Thread James Strandboge
On Thu, 2005-06-16 at 09:22 +0200, Per Engelbrecht wrote: James Strandboge wrote: On Wed, 2005-06-15 at 11:30 +0200, Nico Meijer wrote: Hi Kiraly, mysql error: Can't create/write to file '/tmp/ #sql_4c99_0.MYD' (Errcode: 9) MySQL problem. Simple suggestions, not idiot-proof

Re: PHP or Mysql problem?

2005-06-15 Thread Daniel Ouellet
Kiraly Zoltan wrote: mysql error: Can't create/write to file '/tmp/#sql_4c99_0.MYD' (Errcode: 9) snip mysql error: Can't find file: './bsdforums/administrator.frm' (errno: 9) May be a simple search will help you.

Re: PHP or Mysql problem?

2005-06-15 Thread Nico Meijer
Hi Kiraly, mysql error: Can't create/write to file '/tmp/ #sql_4c99_0.MYD' (Errcode: 9) MySQL problem. Simple suggestions, not idiot-proof: /etc/my.cnf: [mysqld_safe] open-files = 1024 Up kern.maxfiles, if needed. `sysctl -w kern.maxfiles=17720`, for instance. Modify /etc/sysctl.conf

Re: PHP or Mysql problem?

2005-06-15 Thread Luca Losio
Nico Meijer wrote: Hi Kiraly, mysql error: Can't create/write to file '/tmp/ #sql_4c99_0.MYD' (Errcode: 9) MySQL problem. Simple suggestions, not idiot-proof: /etc/my.cnf: Mmm..installing mysqlserver usually doesn't create /etc/my.cfn...isn't it? I can't find that file but I'm

Re: PHP or Mysql problem?

2005-06-15 Thread James Strandboge
On Wed, 2005-06-15 at 11:30 +0200, Nico Meijer wrote: Hi Kiraly, mysql error: Can't create/write to file '/tmp/ #sql_4c99_0.MYD' (Errcode: 9) MySQL problem. Simple suggestions, not idiot-proof: I prefer this on OpenBSD 3.6 (should be same on 3.7): Add to /etc/login.conf