[12:26] <cbx33> hi all
[12:27] <cbx33> I've just installwed a LAMP server
[12:27] <cbx33> do I need to setup the user/pass for MYSQL, and if so how?
[12:39] <neuralis> cbx33: by default, user root has no mysql password; you obviously want to change that for production
[12:39] <neuralis> cbx33: look at the mysql documentation on dev.mysql.com, use google, or ask on #ubuntu to find out how to do that; this is a development channel.
[01:03] <Balachmar> Hi I want to downgrade Mysqlserver5 to 4.1, but I can't do that using synaptic
[01:05] <neuralis> Balachmar: why do you want to do that?
[01:06] <neuralis> and yes, you can do it in synaptic, but 4.1 isn't security-supported.
[01:08] <Balachmar> I don't care... I have to get it running before monday, afterwards I will try and port the database to 5.x
[01:08] <Balachmar> but synaptic causes this error:
[01:08] <Balachmar> Aborting downgrade from (at least) 5.0 to 4.1.
[01:08] <Balachmar> dpkg: error processing /var/cache/apt/archives/mysql-server-4.1_4.1.15-1ubuntu5_i386.deb (--unpack):
[01:08] <Balachmar>  subprocess pre-installation script returned error exit status 1
[01:08] <Balachmar> Errors were encountered while processing:
[01:08] <Balachmar>  /var/cache/apt/archives/mysql-server-4.1_4.1.15-1ubuntu5_i386.deb
[01:08] <Balachmar> E: Sub-process /usr/bin/dpkg returned an error code (1)
[01:08] <Balachmar> A package failed to install.  Trying to recover:
[01:10] <neuralis> they're separate packages, as opposed to downgrades in the same-package, different-version sense.
[01:10] <neuralis> remove mysql-server-5.0, install mysql-server-4.1.
[01:11] <Balachmar> that is basically what Synaptic is trying to do but fails
[01:11] <Balachmar> because I had mysql5 server installed, then I selected 4.1 to be installed it then removed 5.0 first (which went ok) but then fails to install 4.1
[01:12] <Balachmar> I have now reinstalled 5.0 and am now trying to do a complete removal
[01:13] <neuralis> it should just work. if it doesn't, poke at the preinst, see where it breaks.
[01:13] <neuralis> i'm on a slow connection, and don't want to suck down both mysql-server packages to test.
[01:15] <Balachmar> I'm now trying to install 4.1 again
[01:17] <Balachmar> it seems to have worked
[01:19] <neuralis> good.
[05:03] <Balachmar> Hi, I have the following problem: I have written a program, that uses a mysql database
[05:04] <Balachmar> I have that database running on 2 machines. One is a FC3 with Mysql 4.1.18, the other is Ubuntu 6.06 running 4.1.15
[05:04] <Balachmar> And the weird thing is, that if I use the FC3 computer as the server everything works fine
[05:05] <Balachmar> But if I want to use the Ubuntu as the database server it doesn't work
[05:05] <Balachmar> It logs in, but it returns an empty set, where the FC3 server does return a filled set
[05:05] <Balachmar> Does anybody have an idea on where the problem might be?
[05:06] <Balachmar> The ubuntu computer is by the way the same computer as I run the program on, I want to give a demo without having to be connected to the internet
[05:08] <neuralis> did you actually import your data into the ubuntu database?
[05:08] <Balachmar> yes
[05:08] <Balachmar> :)
[05:08] <Balachmar> Hi again :)
[05:09] <Balachmar> and I can login to the database from commandline
[05:09] <Balachmar> I can even login from commandline from antoher computer
[05:10] <neuralis> okay, and does the mysql CLI client show you the data you expect?
[05:10] <Balachmar> yes
[05:11] <neuralis> then obviously it's not the database that's at issue. check your program.
[05:11] <Balachmar> well, the only thing that I change in a config file, is the server
[05:11] <Balachmar> so it cannot be anything else
[05:12] <neuralis> okay, how do you explain what you're seeing then? the database has the data, it's showing you that it has the data, and your program isn't returning it.
[05:13] <Balachmar> Maybe it is because the database is on localhost this time
[05:13] <neuralis> and that matters how, exactly?
[05:13] <Balachmar> although I did change nolisten tcp in gdm.conf
[05:14] <Balachmar> well, in the standard configuration you are not allowed to connect to localhost using tcp
[05:14] <neuralis> what does XDMCP *possibly* have to do with your mysql database?
[05:14] <Balachmar> ghe ghe dunno, I had to change that once, but that was for another databaseprogram
[05:14] <Balachmar> so that should not be any problem... then
[05:15] <neuralis> uh, no. no database program will ask you to go and change xdmcp settings.
[05:15] <neuralis> now, you said your program logs in and then returns empty resultsets. do you KNOW it logs in, or did you just guess that?
[05:16] <Balachmar> Well, if I fill in another random server name, it will says that it is timed out 3 times
[05:16] <neuralis> ...
[05:16] <Balachmar> and with localhost I get no errors except the empty resultset
[05:16] <neuralis> okay, please take this to #ubuntu or the forums.
[05:17] <neuralis> it's not a mysql or ubuntu-server problem. most likely diagnosis is pebkac.
[05:17] <Balachmar> pebkac?
[05:17] <neuralis> yes.
[05:17] <Balachmar> what is that?
[05:18] <Balachmar> Well, thanks for your time anyway!
[05:18] <Balachmar> Cya
[09:07] <d3vice> i cant find ubuntu-server at http://lists.ubuntu.com, is it up ?
[09:23] <neuralis> d3vice: http://lists.ubuntu.com/mailman/listinfo/ubuntu-server
[09:36] <d3vice> thx neuralis