08-17-2009
Using IP.Board on FreeBSD, having SQL/Apache Issues
Server: FreeBSD 7.2-RELEASE
MYSQL Version: MYSQL 5.1.36
PHP Version: 5.2.10 (apache2handler)
IP.Board Version: v3.0.2
Safe Mode: OFF
For the most part previously IP.Board, forum software, has run fine without any issues. Regular web pages and .php pages seem to load fine without any issues. However they reset the server and everything was installed with default settings, as far as I know.
I'm not really an admin who deals with the back-end of things. I usually only admin the software side of things. However I do have root access and am able to modify and set things up. Currently it looks like it is a server configuration issue with something. Possibly optimization or setups for the SQL side of things. It looks like when requesting pages it queries and things are getting stuck or hanging. I either have to repair some of the tables or restart the server.
Anyone have suggestions or ideas on optizing mySQL, apache, php that I can look in trying to make things more stable?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi guys!
well, as some of you might have noticed, i was having issues getting my linux box going correctly -- well, after some long hours and the help of you guys and my trusty o'reilly linux in a nutshell book, everything's runing great and i'm getting much more comfortable using the file... (3 Replies)
Discussion started by: aenemated
3 Replies
2. UNIX Desktop Questions & Answers
question:
i just installed FreeBSD 4.7 on my laptop, when i log in as root, i can startx no problem at all but when i try to start it as a user, i can't. otiginally it told me i needed to be a member of the group 'wheel' to do startx, no problem, added myself in /etc/group, but for some reason i... (1 Reply)
Discussion started by: Calum
1 Replies
3. UNIX for Advanced & Expert Users
i'm following the, "How to setup and secure Snort, MySQL and Acid on FreeBSD 4.6 Release" off of the snort.org website.
in the documentation it says snort should be installed through the following:
-----
make -DWITH_MYSQL -DWITH_FLEXRESP ; make install
-----
later it says to do the... (13 Replies)
Discussion started by: xyyz
13 Replies
4. UNIX for Dummies Questions & Answers
I have been using Linux for 3 years now, and I think I am getting enough knowledge (and confidence) to try some more 'traditional' unix variants. I installed FreeBSD 5.0-CURRENT. I have a couple of questions for the time being:
1) Frequently when I need to compile software packages they can't... (16 Replies)
Discussion started by: cbkihong
16 Replies
5. BSD
All,
I am a bit of a BSD newbie and haven't really played with it for years, but I have had a recent situation whereby someone attempted to load a custom kernel module and ended up breaking my BSD server.
I managed to fix it by doing the following:
Booting into loader mode:
unload
set... (3 Replies)
Discussion started by: drbabbers
3 Replies
6. UNIX for Dummies Questions & Answers
I wrote a script to batch-create directories with .htaccess and .htpasswd files.
I am using the following line to create the .htpasswd file:
htpasswd -cb .htpasswd $USER $PASS
However, I keep getting this message in return:
Usage: htpasswd passwordfile username
The -c flag creates a new... (1 Reply)
Discussion started by: Spetnik
1 Replies
7. Solaris
Hi there,
I'm building a couple of E4500's both with the same spec and seem to be having an issue with the disk boards on each.
I’m running the following config
E4500 6 x 400MHz, 6GB, 2 x X2612A with cards, 1 x disk board with 2 x 9.1GB 10K Disk
I have configured the machine as... (0 Replies)
Discussion started by: wallrunn3r
0 Replies
8. BSD
Hi!
I have a major issue with FreeBSD 7.1 i386.
We did a change in our Unix env where we exchanged home storage from a NetAPP running udp to a NetAPP running tcp.
Now I cant mount homedirs since NFS/AMD seem to fallback to udp :(
Trying to force it with amd options nfs_proto=tcp and so on.
... (0 Replies)
Discussion started by: Esaia
0 Replies
9. AIX
(1) Hi, Am working on FreeBSD 7.4/i386 and installed Opera 11.01 through ports collection manually... But when I run first time am getting "opera: cannot connect X server. Error: Unknown error: 0" What is this error all about???? Please help me to sort out this issue!!!
(2) Hi, currently am... (12 Replies)
Discussion started by: Priya Amaresh
12 Replies
10. BSD
I just got FreeBSD up and running with an XFCE desktop on an old Gateway laptop. It works great, except the wireless setup is scaring me. I can connect to my home WiFi fine most of the time, but I'm concerned about other WiFi that I will need to connect to away from home.
I understand that I can... (1 Reply)
Discussion started by: BrentBANKS
1 Replies
LEARN ABOUT FREEBSD
release_savepoint
RELEASE
SAVEPOINT(7) SQL Commands RELEASE SAVEPOINT(7)
NAME
RELEASE SAVEPOINT - destroy a previously defined savepoint
SYNOPSIS
RELEASE [ SAVEPOINT ] savepoint_name
DESCRIPTION
RELEASE SAVEPOINT destroys a savepoint previously defined in the current transaction.
Destroying a savepoint makes it unavailable as a rollback point, but it has no other user visible behavior. It does not undo the effects of
commands executed after the savepoint was established. (To do that, see ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)].) Destroying a
savepoint when it is no longer needed allows the system to reclaim some resources earlier than transaction end.
RELEASE SAVEPOINT also destroys all savepoints that were established after the named savepoint was established.
PARAMETERS
savepoint_name
The name of the savepoint to destroy.
NOTES
Specifying a savepoint name that was not previously defined is an error.
It is not possible to release a savepoint when the transaction is in an aborted state.
If multiple savepoints have the same name, only the one that was most recently defined is released.
EXAMPLES
To establish and later destroy a savepoint:
BEGIN;
INSERT INTO table1 VALUES (3);
SAVEPOINT my_savepoint;
INSERT INTO table1 VALUES (4);
RELEASE SAVEPOINT my_savepoint;
COMMIT;
The above transaction will insert both 3 and 4.
COMPATIBILITY
This command conforms to the SQL standard. The standard specifies that the key word SAVEPOINT is mandatory, but PostgreSQL allows it to be
omitted.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)], ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)], SAVEPOINT [savepoint(7)]
SQL - Language Statements 2010-05-14 RELEASE SAVEPOINT(7)