=== 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!