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