| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<crashputer> Hi all... I have a quick question
<jjb_lyceum> ask
<crashputer> I'm setting up a media server which requires php and mysql. It has a test page which says that I do not have mysql for php enabled. I have the packages for php4, mysql-common, mysql-server, mysql-client, and php4-mysql installed. Is there some type of configuration I'm missing?
<crashputer> I'm running Ubuntu 5.10
<crashputer> you can view the test page at http://crashputer.homelinux.org/mp3/test.php
<EyeCue> crashputer , configure arguments telling php to include mysql-support
<EyeCue> and or the php-mysql extension itself
<EyeCue> if you installed the php4-mysql
<EyeCue> it should have modified the php.ini or extensions ini in your local etc dir
<crashputer> ah k
<EyeCue> seeing as though i dont know OS specefici details, i cant get much more helpful than that
<crashputer> That's a start though
<EyeCue> i mean, if you load up a page containning <?php phpinfo(); ?>
<EyeCue> youll see what the php configure args were, and since they were packages, im guessing there 'werent' any :)
<EyeCue> or there was a standard configure, since you didnt compile php.
<crashputer> probably not... They're freshly baked packages... I've done no configuring to them at all
<EyeCue> soooooooo, the point being
<crashputer> (this being my first time playing with php and mysql)
<EyeCue> if phpinfo() doesnt report --with-mysql (i think) or something to that effect, with a whole section on mysql support
<EyeCue> then yeh, its not compiled into your precompiled package.
<EyeCue> faik.
<crashputer> ah k
<crashputer> checking
<EyeCue> mind you, just because its not in the "Configure Command" section of phpinfoi, doesnt meant it cant be loaded as a seperate extension :)
<EyeCue> this is the line in mine
<EyeCue> :
<EyeCue> './configure' '--enable-versioning' '--enable-memory-limit' '--with-layout=GNU' '--with-config-file-scan-dir=/usr/local/etc/php' '--disable-all' '--with-regex=php' '--with-apxs=/usr/local/sbin/apxs' '--disable-ipv6' '--prefix=/usr/local' 'i386-portbld-freebsd4.11'
<EyeCue> but, mysql support is loaded in a seperate extensions.ini
<crashputer> ah k
<EyeCue> and compiled seperately from the same php source, into its own extension
<EyeCue> so to speak.
<crashputer> I'm looking in /etc/php4/apache/php.ini
<crashputer> and I see a commented example in extensions saying extension=mysql.so
<EyeCue> krad :)
<EyeCue> have a dig.
<EyeCue> hopefully you have a mysql.so around somewhere :)
<crashputer> This (or similar) is what I'm looking for then?
<crashputer> checking now
<EyeCue> im ***uming the php4-mysql package put it on your system
<EyeCue> a precompiled version
<coolzone> Hi, I have created a dump from an iso8859-1 database, I have manualle changed all characters into utf8 and saved the file as utf8 with the file editor. I am trying to restore the dump on a new machine running a mysql 5.x with default character set as utf8. When I restore the dump, all the characters which I had changed become messed up. What could I be doing wrong?
<crashputer> yes I do
<coolzone> manualle = manually
<EyeCue> crashputer , uncomment it, and restart apache
<crashputer> right... Doing so, but had another package (unrelated) installing from synaptic
<crashputer> was just waiting for it to finish
<EyeCue> open another shell
<EyeCue> :)
<crashputer> have about 8 going now lol
<EyeCue> fun
<crashputer> yup
<crashputer> shutting down unnecessary clutter
<crashputer> and starting test page
<coolzone> seems like mysql is really bad at handeling different character-sets
<crashputer> hmm
<crashputer> still fail
<EyeCue> phpinfo
<EyeCue> what does it say
<EyeCue> make a phpinfo.php file in the same dir as test
<EyeCue> lemme see it
<crashputer> k 1 sec
<crashputer> EyeCue: http://crashputer.homelinux.org/mp3/test2.php
<crashputer> brb
<EyeCue> wow
<EyeCue> its got pgsql
<EyeCue> but no mysql
<EyeCue> rofl
<EyeCue> :)
<EyeCue> and a whole lot of krud youll never use
<EyeCue> other than suggesting you uncomment the mysql.so line in /etc/php4/apache/php.ini
<EyeCue> i have no idea.
<EyeCue> it should work.
<EyeCue> where is your mysql.so
<crashputer> /usr/lib/php4/20050606
<fericitu_> how can make a backup of mysql database ...i have Debian
<gleam_> mysqldump, mysqlhotcopy, lvm snapshot, shutdown teh server and copy out the datadir
<gleam_> replicate to a slave and then do any one of those
<gleam_> pick your poison
<fericitu_> wher is the dir ???
<crashputer> EyeCue: You think I should copy mysql.so to another directory?
<EyeCue> nope, its in the right place as far as libs are concerned
<crashputer> k
<EyeCue> my extensions.ini only says mysql.so as well
<EyeCue> if you installed the packages, they should have set it up correctly
<EyeCue> and i wont have a bar of linux, so aside rom what weve dicussed, i have no idea
<crashputer> sok... you've been a help
<crashputer> Talking to a guy in the program's channel now
<crashputer> Who uses Debian... and Ubuntu (my flavor) is a variant of, so hopefully we can get it straightened out
<seanr> Anyone know how to get this query to work in mysql 4.0.27?
<seanr> SELECT s.tid, s.uid, sum(points) FROM tournament_scores s JOIN tournament_places p ON s.pid = p.pid WHERE s.tid = 0 GROUP BY s.tid, s.uid ORDER BY sum(points) DESC;
<seanr> schema and data are here: http://drupal.pastebin.com/743704
<seanr> Switching ISPs is sadly not an option for me right now.
<seanr> That query returns: #1111 - Invalid use of group function
<seanr> :-(
<crashputer> Eyecue: I was going through my php info page and noticed _ENV["PATH"] has /bin:/usr/bin:/usr/local/bin
<crashputer> Should I try to find that in php.ini and give the directory of mysql.so to it?
<crashputer> aside from that, checking my permissions now
<crashputer> trying a traditional reboot...
<crashputer> EyeCue: When all else fails, reboot lol
<crashputer> Fixed!
<EyeCue> dear oh dear.
<EyeCue> linux < windows.
<gleam_> eh?
<crashputer> That fixed that problem... I can catch the rest from here
<crashputer> Thanks for the help, mate
<EyeCue> np
<scud> i have a field that is text how can i query for the field if it is not empty?
<HS^> can i configure mysqld to never time out?
<necrite> hi
<necrite> there is any way to create one table with one collumn named "default" ?
<gleam_> `default`
<Aphixe2x> hello
<gleam_> and don't, because that's silly.
<necrite> ty
<gleam_> don't use reserved words
<gleam_> it makes things a pain int he *** for whoever has to maintain your code
<Aphixe2x> I need help uninstalling completely and reinstalling to latest. I want to clean it fully out
<frank-> Aphixe2x: we need more info then
<frank-> distro, version, etc.
<Aphixe2x> frank-, redhat 9 its version 3 mysql
<frank-> ok, man rpm to figure out how to remove a package
<Aphixe2x> I messed up my copy of ,mysql trying to install update
<frank-> then grab the latest rpm and man rpm to figure out how to install it
<Aphixe2x> can I check what packages I have with rpm? I dont know the proccess
<frank-> man rpm, sure
<Aphixe2x> haha
<frank-> what's so funny?
<Aphixe2x> I know -e, -U, -i for rpm
<frank-> this is not #redhat
<Aphixe2x> I dont always understand a man
<Aphixe2x> I know its mysql which is my problem
<frank-> then unsintall it
<frank-> and reinstall it
<Aphixe2x> I would if I knew how, and if I knew how.. I wouldnt be in here
<frank-> please go to #redhat
<frank-> this is a redhat support question
<frank-> if you need help configuring mysql later come back here
<frank-> thank you, come again.
<keithalexander> how difficult is it likely to be to downgrade from mysql 5 back to 4 ?
<keithalexander> on mac osx
<frank-> there are howtos
<frank-> I suggest you follow them
<frank-> there are a couple of crutial steps
<gleam_> why would you downgrade? :P
<gleam_> more importantly
<gleam_> why would you run mysql on osx?
<frank-> mysql runs well enough on osx
<gleam_> lies
<frank-> I've ran it
<frank-> there are quirks
<gleam_> it functions
Return to
#mysql
or
Go to some related
logs:
#sdl
#php
#css
set global-alias ubuntu
#perl
#kde
defragging lvm
run Ubuntu from Windows
mod_vhost_alias.so: undefined symbol: apr_pstrdup
fluxbox xmb
|
|
