On Fri, 8 Apr 2011 09:52:15 +0200
"Gianluca D'Auri Muscelli" 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 users
> P
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 in
On 2010-03-13, Sunnz wrote:
> 2010/3/12 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.
>>
>
> In that case you could
This has also worked for me in the past.
Bert
On 3/13/10 9:27 AM, "L. V. Lammert" wrote:
> On Sat, 13 Mar 2010, Sunnz wrote:
>
>> 2010/3/12 Daniel Gracia Garallar :
>>> Not quite a solution, I think. What about if /var/www mounts in a different
>>> filesystem than /var?
>>>
>>> Hardlinks from
On Sat, 13 Mar 2010, Sunnz wrote:
> 2010/3/12 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.
> >
>
> In that ca
2010/3/12 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.
>
In that case you could change the location mysqld itself uses
On Fri, Mar 12, 2010 at 6:58 PM, Daniel Gracia Garallar
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 mysql over tcp/ip
--
O< ascii
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 Jan:
I didn't notice, that httpd was s
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 las
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 :
I didn't notice, that httpd was still running.
kill -TERM ID_of_httpd
httpd -u
solved
2010/3/11 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!
>
>
Now that it works we know that it was a problem with chroot. It might
be a good practice now to hardlink the mysql.sock in the chroot
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
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
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
On Mon, Mar 8, 2010 at 9:07 PM, Jan 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 the following error
>
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 wi
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 R
On Mon, Mar 8, 2010 at 10:07 PM, Jan wrote:
>
> Any ideas?
>
>
Are you trying to connect to the MySQL socket outside of the httpd chroot?
Floor
--
Floor Terra
www: http://brobding.mine.nu/
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 mysql
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 no
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 inst
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 described
) 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 of
somebody
> might be able to fix it and the OS grows.
>
> 2) 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 alrea
ers, 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 tell you that i understan
afe which wouldn't let me open more
that 2048 files despite of what i configured in my.cnf.
Regards,
- Original Message -
From: "Otto Moerbeek" <[EMAIL PROTECTED]>
To: "Marcos Laufer" <[EMAIL PROTECTED]>
Cc: ; <[EMAIL PROTECTED]>; "Daniel Oue
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 y
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
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 t
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 -
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.
Hi Marcos,
These instructions work for me:
http://www.openbsdsupport.org/mysql.htm
HTH... Nico
Marcos Laufer wrote:
Now what?
http://openbsdsupport.org/mysql.htm
g
mysqlcheck -m -A -p
Now what?
Regards,
Marcos
- Original Message -
From: "Clint Pachl" <[EMAIL PROTECTED]>
Cc: "Marcos Laufer" <[EMAIL PROTECTED]>;
Sent: Friday, July 13, 2007 6:05 PM
Subject: Re: mysql problem
Otto Moerbeek wrote:
On Fri, 13
-p
Now what?
Regards,
Marcos
- Original Message -
From: "Clint Pachl" <[EMAIL PROTECTED]>
Cc: "Marcos Laufer" <[EMAIL PROTECTED]>;
Sent: Friday, July 13, 2007 6:05 PM
Subject: Re: mysql problem
Otto Moerbeek wrote:
> On Fri, 13 Jul 2007, Marcos Laufer w
m: "Otto Moerbeek" <[EMAIL PROTECTED]>
To: "Marcos Laufer" <[EMAIL PROTECTED]>
Cc:
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 on a 3.9 , suddenly i can'
I will start it as you say .
I will let you know it it worked
Thanks !
Marcos
- Original Message -
From: "Otto Moerbeek" <[EMAIL PROTECTED]>
To: "Marcos Laufer" <[EMAIL PROTECTED]>
Cc: "Bob Beck" <[EMAIL PROTECTED]>;
Sent: Friday, July
Original Message -
> From: "Bob Beck" <[EMAIL PROTECTED]>
> To: "Marcos Laufer" <[EMAIL PROTECTED]>
> Cc: "Otto Moerbeek" <[EMAIL PROTECTED]>;
> Sent: Friday, July 13, 2007 1:54 PM
> Subject: Re: mysql problem
>
>
>
>
&
t; <[EMAIL PROTECTED]>
To: "Marcos Laufer" <[EMAIL PROTECTED]>
Cc: "Otto Moerbeek" <[EMAIL PROTECTED]>;
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 /et
t;
> --
> and in mysql.server it says:
>
> # Set some defaults
> pid_file=
> server_pid_file=
> use_mysqld_safe=1
> user=_mysql
>
>
> What do you think, should i add more openfiles to mysql?
> Regards,
> Marcos
>
> - Original Message -
> Fro
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 y
- Original Message -
From: "Otto Moerbeek" <[EMAIL PROTECTED]>
To: "Marcos Laufer" <[EMAIL PROTECTED]>
Cc:
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 f
ze = 1M
> read_buffer_size = 1M
> read_rnd_buffer_size = 4M
> myisam_sort_buffer_size = 64M
>
> [mysql.server]
> old-passwords
>
> [mysqld_safe]
> open-files=8192
>
>
>
>
> Maybe i need to increase something else?
> Thanks!
>
>
> -
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
> c
Maybe i need to increase something else?
Thanks!
- Original Message -
From: "Otto Moerbeek" <[EMAIL PROTECTED]>
To: "Marcos Laufer" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, July 13, 2007 3:12 AM
Subject: Re: mysql problem
On Fri, 13 Jul 2007, Marcos Lau
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
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
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 b
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
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
attempti
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/
> >&
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
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 (sh
/etc/login.conf changes:
daemon:\
:ignorenologin:\
:datasize=infinity:\
:maxproc=infinity:\
:openfiles-cur=1024:\ <--- check this one
:stacksize-cur=8M:\
:localcipher=blowfish,8:\
:tc=default:
and/or:
default:\
:path=/usr/bin /bin /u
Hi Luca,
> Mmm..installing mysqlserver usually doesn't create /etc/my.cfn...isn't
> it? I can't find that file but I'm running mysqld...
Nope, you have to create it yourself.
Bye... Nico
Luca Losio wrote:
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...is
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
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. Modif
Kiraly Zoltan wrote:
mysql error: Can't create/write to file '/tmp/#sql_4c99_0.MYD'
(Errcode: 9)
mysql error: Can't find file: './bsdforums/administrator.frm'
(errno: 9)
May be more this one:
http://marc.theaimsgroup.com/?l=openbsd-misc&m=109968112515204&w=2
So far, all th
Kiraly Zoltan wrote:
mysql error: Can't create/write to file '/tmp/#sql_4c99_0.MYD'
(Errcode: 9)
mysql error: Can't find file: './bsdforums/administrator.frm'
(errno: 9)
May be a simple search will help you.
http://www.google.com/search?hl=en&q=mysql+openfiles+openbsd&btnG=Goo
I have an OpenBSD 3.7 webserver. The webserver use PHP and Mysql in
chrooted Apache (1.3.29).
I want to use a Bulletin Board script on webserver called Vbulletin (
http://www.vbulletin.com/ ). This Bulletin Board work but sometimes i
get this error messages :
Error 1 :
--
Database error in vB
61 matches
Mail list logo
