Search results for query: *

Hi all, I moved a site across from one server running MySQL 4 to another running MySQL 5 and forgot to check the collation / encoding defaults on the servers. I'm therefore getting odd characters showing up in my web pages. As data has been entered into the new system since the restore I don't...

Hi all, I have an existing mysql database on a disk, and I want to mount the disk in the databases directory and start mysql to get the database back to where it was from a snapshot. I'm using this script: /etc/init.d/mysqld stop mkdir /var/lib/mysql/mydbname/ chown mysql...

Hi all, Can someone give me a hand with this? I have an XML document which contains results of a questionnaire. The questions are listed at the top of the document and each user's response(s) are listed below. Users may not have answered all the questions, and if they have not answered a...

I can't seem to get PHP to parse either of the php.ini files that comes with PHP 5.2.5: Running php -c . php.ini: php.ini-recommended: PHP Parse error: syntax error, unexpected T_LOGICAL_AND in C:\php\php.ini on line 126 php.ini-dist: Parse error: syntax error, unexpected ',' in...

Hello, I have a problem whereby I have a mailing script which pipes directly into sendmail, but the user is entering extremely long lines and sendmail is rejecting the email because of it. For the HTML portion of the email I can use encode_qp which works fine, but if I use encode_qp for the...

I'm getting the below message when trying to run a perl script: -bash-3.00$ ./search.pl : bad interpreter: No such file or directory But if I run it straight through perl then it's fine: -bash-3.00$ perl search.pl Content-type: text/html So the usual problem is odd characters (e.g. CR / LF)...

Hello, I'm trying to move a database from one server to another, but I'm getting characters such as unlauts turned into question marks on the target database. Running status on both databases shows the encoding to be different: Source: Server characterset: latin1 Db characterset...

Hi all, I've been asked to look at a server, and it looks like Apache has been hacked on it. Users were complaining about pages not working, and just seeing a red square in the top right corner or certain pages. It looks like the exploit code isn't in the actual underlying pages themselves, and...

Hello, I'm using Apache 1.3.33 and the mod_auth_ldap apxs module from: http://www.muquit.com/muquit/software/mod_auth_ldap/mod_auth_ldap.html I have this setup on a linux box and it's working fine authenticating against our Active Directory. I had to install the same versions of Apache and...

I must be going mad! How come I can't create a view? mysql> create view testview as select * from userdetails; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'view testview as select *...

Hello, I have two tables, here are the 'show create' statements for them: CREATE TABLE `useractskills` ( `username` varchar(20) NOT NULL default '', `skilltype` int(11) NOT NULL default '0', `skillid` int(11) NOT NULL default '0', `dept` varchar(20) NOT NULL default '', KEY...

Hi all, A department here has outsourced their website design to a company who don't seem to see security as a important issue. Their code seems to be a definite target for a SQL injection attack, but I've been unsuccessful in coming up with a way to prove this. e.g. one page gets a list of...

OK, so the title sounds a little confusing. Here's the situation: I have two tables, one is a list of items, e.g: id | description ---------------- 1 | Item 1 2 | Item 2 The second lists people against the items, e.g. people who have ordered the items: username | itemno | notes...

Hello, I want to block a whole ISP from accessing a section of my website. Imagine the netblock is in the range: 123.456.31.0 - 123.456.63.255 I've tried: SetEnvIf Remote_Addr "^123.456.[31-63].[0-255]$" ban order deny,allow deny from env=ban allow from all But that didn't work. Can anyone...

Hi all, I need to make a perl application that will allow users to log on using basic authentication, and will then create configuration files in their home directories. I've looked at suEXEC, but that only seems to be useful if you predefine which user you want the script to run as. Is there...

Hi All, I have a webpage with an ActiveX control in it. The activeX control performs a few operations, and the I want it to redirect the page it is on to another URL. How do I do that? C:\DOS:> C:\DOS:>RUN RUN DOS RUN!!

Hi All, In 2000 / XP etc you can get a list of installed hotfixes from HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Hotfix but I was wondering if there was a similar registry key for windows 95/98? C:\DOS:> C:\DOS:>RUN RUN DOS RUN!!

Hi all, How can I use ASP to see if a user is listed in a remote NIS database? C:\DOS:> C:\DOS:>RUN RUN DOS RUN!!

Hi all, I'm trying to get the message headers and body from an email. I am able to get the message body using: Set oOL = CreateObject("Outlook.Application") For x = 1 To oOL.ActiveExplorer.Selection.Count msgBody = oOL.ActiveExplorer.Selection.Item(x).Body Next...

Hi All, I want to open a port on my server, e.g. port 7070 and just log the remote client's IP address and close the connection when someone telnets to port 7070. Can anyone give me a hand? C:\DOS:> C:\DOS:>RUN RUN DOS RUN!!