| === nictuku [n=yves@ubuntu/member/nictuku] has joined #ubuntu-server | ||
| === CarlF1 [n=carl@c-67-163-39-124.hsd1.il.comcast.net] has joined #ubuntu-server | ||
| === innovagest [n=chatzill@151.55.67.86] has joined #ubuntu-server | ||
| === screeb [n=seb@pons.rez-rennes.supelec.fr] has joined #ubuntu-server | ||
| === ivoks [n=ivoks@ubuntu/member/ivoks] has joined #ubuntu-server | ||
| === cbx33 [n=node50@ubuntu/member/cbx33] has joined #ubuntu-server | ||
| cbx33 | hi all | 12:26 |
|---|---|---|
| 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:27 |
| 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. | 12:39 |
| === Toadstool [n=jcorbier@ubuntu/member/toadstool] has joined #ubuntu-server | ||
| === Balachmar [n=balachma@cp192685-a.tilbu1.nb.home.nl] has joined #ubuntu-server | ||
| Balachmar | Hi I want to downgrade Mysqlserver5 to 4.1, but I can't do that using synaptic | 01:03 |
| neuralis | Balachmar: why do you want to do that? | 01:05 |
| neuralis | and yes, you can do it in synaptic, but 4.1 isn't security-supported. | 01:06 |
| 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:08 |
| 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:10 |
| 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:11 |
| Balachmar | I have now reinstalled 5.0 and am now trying to do a complete removal | 01:12 |
| 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:13 |
| Balachmar | I'm now trying to install 4.1 again | 01:15 |
| Balachmar | it seems to have worked | 01:17 |
| neuralis | good. | 01:19 |
| === innovagest_ [n=chatzill@151.55.70.203] has joined #ubuntu-server | ||
| === Toadstool [n=jcorbier@ubuntu/member/toadstool] has joined #ubuntu-server | ||
| === zenrox [n=zenrox@71.115.198.118] has joined #ubuntu-server | ||
| === nictuku [n=yves@ubuntu/member/nictuku] has joined #ubuntu-server | ||
| === Balachmar [n=balachma@cp192685-a.tilbu1.nb.home.nl] has joined #ubuntu-server | ||
| Balachmar | Hi, I have the following problem: I have written a program, that uses a mysql database | 05:03 |
| 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:04 |
| 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:05 |
| 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:06 |
| neuralis | did you actually import your data into the ubuntu database? | 05:08 |
| Balachmar | yes | 05:08 |
| Balachmar | :) | 05:08 |
| Balachmar | Hi again :) | 05:08 |
| Balachmar | and I can login to the database from commandline | 05:09 |
| Balachmar | I can even login from commandline from antoher computer | 05:09 |
| neuralis | okay, and does the mysql CLI client show you the data you expect? | 05:10 |
| Balachmar | yes | 05:10 |
| 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:11 |
| === b-rad [n=fubar@c-68-45-146-162.hsd1.pa.comcast.net] has joined #ubuntu-server | ||
| === b-rad [n=fubar@c-68-45-146-162.hsd1.pa.comcast.net] has left #ubuntu-server [] | ||
| 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:12 |
| 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:13 |
| 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:14 |
| 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:15 |
| 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:16 |
| 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:17 |
| Balachmar | Well, thanks for your time anyway! | 05:18 |
| Balachmar | Cya | 05:18 |
| === ivoks [n=ivoks@ubuntu/member/ivoks] has joined #ubuntu-server | ||
| === screeb [n=seb@pons.rez-rennes.supelec.fr] has joined #ubuntu-server | ||
| === d3vice [n=pedro@a213-22-31-96.cpe.netcabo.pt] has joined #ubuntu-server | ||
| d3vice | i cant find ubuntu-server at http://lists.ubuntu.com, is it up ? | 09:07 |
| neuralis | d3vice: http://lists.ubuntu.com/mailman/listinfo/ubuntu-server | 09:23 |
| d3vice | thx neuralis | 09:36 |
| === ..[topic/#ubuntu-server:neuralis] : Ubuntu Server development discussions | for general support please use #ubuntu | mailing list: http://ln-s.net/B+P | forum: http://ln-s.net/B+Q | CD download: http://releases.ubuntu.com/dapper/ | ||
| === innovagest [n=chatzill@151.55.68.18] has joined #ubuntu-server | ||
| === CarlF1 [n=carl@c-67-163-39-124.hsd1.il.comcast.net] has joined #ubuntu-server | ||
| === CarlF1 [n=carl@c-67-163-39-124.hsd1.il.comcast.net] has joined #ubuntu-server | ||
| === ivoks [n=ivoks@ubuntu/member/ivoks] has joined #ubuntu-server | ||
| === CarlF1 [n=carl@c-67-163-39-124.hsd1.il.comcast.net] has joined #ubuntu-server | ||
| === CarlF1 [n=carl@c-67-163-39-124.hsd1.il.comcast.net] has joined #ubuntu-server | ||
| === d3vice [n=pedro@a213-22-31-96.cpe.netcabo.pt] has joined #ubuntu-server | ||
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!