forums
new posts
donate
UER Store
events
location db
db map
search
members
faq
terms of service
privacy policy
register
login




UER Forum > Private Boards Index > Tech Talk > Mac OS X, Apache, MySql, php, PunBB (Viewed 3819 times)
Geo 


Total Likes: 0 likes




 |  | 
Mac OS X, Apache, MySql, php, PunBB
< on 9/27/2007 2:33 AM >
Reply with Quote
Posted on Forum: UER Forum
And I'm a total *nix noob...my brain hurts.
But, I have enabled php on apache via the terminal and gotten a php mailer to work...kinda.
I have installed mysql..correctly I believe. Now I'm trying to learn how to set it up...all this so I can run a forum on my mac..maybe.
At any rate it is interesting stuff to learn. Anyone else go this route to learning this stuff?
GV




Washu 


Location: Ottawa
Gender: Male
Total Likes: 0 likes




 |  |  | Yahoo! IM | AIM Message
Re: Mac OS X, Apache, MySql, php, PunBB
< Reply # 1 on 9/27/2007 3:27 AM >
Reply with Quote
Posted on Forum: UER Forum
I can probably help you out with some of the application config, but I'm not really up on the specifics of using them on OSX. What exactly is not working?

Now, this is not a Mac bash, but if you are going to be dedicating this machine to your forum (IE, not also using it as a desktop) you should seriously consider installing one of the BSDs or Linux on it. OSX is a good desktop, but it's performance in web hosting and mysql is well known to be sub par.





Geo 


Total Likes: 0 likes




 |  | 
Re: Mac OS X, Apache, MySql, php, PunBB
< Reply # 2 on 9/27/2007 3:40 AM >
Reply with Quote
Posted on Forum: UER Forum
Right now, I dont think I have mysql dbase configured correctly..I cant install punbb...im getting a .sock file error...
i tried to cd my way to the directory...i dont know the *nix command to list the contents of the directory so I cant see if the file is there. I'll go at it more tomorrow...my brain meats are getting bended.
GV




Washu 


Location: Ottawa
Gender: Male
Total Likes: 0 likes




 |  |  | Yahoo! IM | AIM Message
Re: Mac OS X, Apache, MySql, php, PunBB
< Reply # 3 on 9/27/2007 3:57 AM >
Reply with Quote
Posted on Forum: UER Forum
Try connecting to mysql from the command line. Just type "mysql" and if it connects and/or gives you a user/pass error then mysql is at least running. If it can't connect then mysql hasn't even started.

Type "ls" to list the contents of a directory.




Geo 


Total Likes: 0 likes




 |  | 
Re: Mac OS X, Apache, MySql, php, PunBB
< Reply # 4 on 9/27/2007 10:31 AM >
Reply with Quote
Posted on Forum: UER Forum
Posted by Washu
Try connecting to mysql from the command line. Just type "mysql" and if it connects and/or gives you a user/pass error then mysql is at least running. If it can't connect then mysql hasn't even started.

Type "ls" to list the contents of a directory.



Yes, I can access mysql and mysqladmin from the command line. When I try to install punbb I get the error. It seems, a directory isnt present, I think.
I'll have a go at it later and post the exact error.
GV




Geo 


Total Likes: 0 likes




 |  | 
Re: Mac OS X, Apache, MySql, php, PunBB
< Reply # 5 on 9/27/2007 5:53 PM >
Reply with Quote
Posted on Forum: UER Forum
error i'm recieving,


An error occured on line 58 in file /Library/WebServer/Documents/forum/include/dblayer/mysql.php.


PunBB reported: Unable to connect to MySQL server. MySQL reported: Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)

GV
ps. thanks for the assistance





Washu 


Location: Ottawa
Gender: Male
Total Likes: 0 likes




 |  |  | Yahoo! IM | AIM Message
Re: Mac OS X, Apache, MySql, php, PunBB
< Reply # 6 on 9/27/2007 6:22 PM >
Reply with Quote
Posted on Forum: UER Forum
Posted by GeoViolator
error i'm recieving,


An error occured on line 58 in file /Library/WebServer/Documents/forum/include/dblayer/mysql.php.


PunBB reported: Unable to connect to MySQL server. MySQL reported: Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)

GV
ps. thanks for the assistance




Looks like you need to edit your php.ini to point to the right sock file.

See if this helps: http://www.agavegroup.com/?p=58




Geo 


Total Likes: 0 likes




 |  | 
Re: Mac OS X, Apache, MySql, php, PunBB
< Reply # 7 on 9/28/2007 1:07 AM >
Reply with Quote
Posted on Forum: UER Forum
That thread seems to coincide with some other posts I read on it. I'm just trying to get my head around it, and I'm not sure which method to use.
I have another complete noob question, in what order should I start mysql and apache?
And I use the pref panel to start mysql, it says its running, it shows up in the processor threads, but a post I read said to start it manually anyway?(something about manual start writing mysql.sock to a different directory, ie: the correct one)

Well I'm at it, is there anyway to "display" the entire directory tree for a given "folder"?
Thats where I get lost...navigating within the terminal, through "folders" that are invisible to the gui.

Thanks again for all your help
GV




Washu 


Location: Ottawa
Gender: Male
Total Likes: 0 likes




 |  |  | Yahoo! IM | AIM Message
Re: Mac OS X, Apache, MySql, php, PunBB
< Reply # 8 on 9/28/2007 2:40 AM >
Reply with Quote
Posted on Forum: UER Forum
Start order doesn't matter. Apache will run fine without mysql running, but of course you won't be able to connect to any DBs.

I'm not sure about the prefs panel. I'll read some more and look around on my Mac, but as I said I'm not up on the specifics of OSX vs BSD/Linux. The thread I referenced said to edit the php.ini to point it to the directory that mysql.sock gets written to.

"ls -R" will list subdirectories as will the "du" command. OSX is bad for that, you might want to look around for an alternate file manager that shows all directories.





Geo 


Total Likes: 0 likes




 |  | 
Re: Mac OS X, Apache, MySql, php, PunBB
< Reply # 9 on 9/28/2007 3:06 AM >
Reply with Quote
Posted on Forum: UER Forum
ok..whew..kinda.
MySql is running, got the php.ini file made and modified.
was able to install punbb...
Now, all I get is a blank index.php page..trying to figure it out.
Is changing permissions in the get info window the same as chmod?
thanks again
GV




Washu 


Location: Ottawa
Gender: Male
Total Likes: 0 likes




 |  |  | Yahoo! IM | AIM Message
Re: Mac OS X, Apache, MySql, php, PunBB
< Reply # 10 on 9/28/2007 4:09 AM >
Reply with Quote
Posted on Forum: UER Forum
Find out where the apache log files are and take a look at the error log in a text editor and it might give you some hint as to why the page is not loading.

As for the permissions thing, I would assume that yes they are the same, but I'm not 100% on that.





Geo 


Total Likes: 0 likes




 |  | 
Re: Mac OS X, Apache, MySql, php, PunBB
< Reply # 11 on 9/28/2007 1:54 PM >
Reply with Quote
Posted on Forum: UER Forum
woohoo...I made it!.
My config.php had 1 wrong character in it.
Thanks again for all your help, the ls command helped most.
GV




UER Forum > Private Boards Index > Tech Talk > Mac OS X, Apache, MySql, php, PunBB (Viewed 3819 times)


Add a poll to this thread



This thread is in a public category, and can't be made private.



All content and images copyright © 2002-2024 UER.CA and respective creators. Graphical Design by Crossfire.
To contact webmaster, or click to email with problems or other questions about this site: UER CONTACT
View Terms of Service | View Privacy Policy | Server colocation provided by Beanfield
This page was generated for you in 218 milliseconds. Since June 23, 2002, a total of 740869809 pages have been generated.