Jump to content
The Uniform Server Community

twpmarket

Member
  • Posts

    16
  • Joined

  • Last visited

Previous Fields

  • SourceForge ID
    twpmarket

twpmarket's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Ok, I copied the orignal Uniserver phpmyadmin folder elsewhere for safe keeping. and downloaded the latest phpMyAdmin ver. 2.7.0 pl2. I installed this in /home/admin/www/phpmyadmin to replace the original Uni.Server installation. On first attempt to run phpMyAdmin from apanel,I got the 1045 error: ("#1045 - Access denied for user: 'root@localhost' (Using password: NO)"), so I copied conf.ini.php from the original Uniform Server installation (no change there). phpMyAdmin then started properly from apanel (although the skin colors are different). I then opened my db table and tried to manually add a new record from the "browse" page in phpMyAdmin, the option is at the bottom of the page: "insert new record". The record DID get inserted, correctly, but the error screen still reports this: Warning: require(./sql.php%3Flang%3Den-utf-8%26amp%3Bserver%3D1%26amp%3Bcollation_connection%3Dutf8_general_ci%26amp%3Bdb%3Dtwpproducts%26amp%3Btable%3Dproducts%26amp%3Bpos%3D0%26amp%3Bsession_max_rows%3D30%26amp%3Bdisp_direction%3Dhorizontal%26amp%3Brepeat_cells%3D100%26amp%3Bdontlimitchars%3D0%26amp%3Bsql_query%3DSELECT%2B%252A%2BFROM%2B%2560products%2560) [function.require]: failed to open stream: No error in W:\home\admin\www\phpMyAdmin\tbl_replace.php on line 261 Fatal error: require() [function.require]: Failed opening required './sql.php%3Flang%3Den-utf-8%26amp%3Bserver%3D1%26amp%3Bcollation_connection%3Dutf8_general_ci%26amp%3Bdb%3Dtwpproducts%26amp%3Btable%3Dproducts%26amp%3Bpos%3D0%26amp%3Bsession_max_rows%3D30%26amp%3Bdisp_direction%3Dhorizontal%26amp%3Brepeat_cells%3D100%26amp%3Bdontlimitchars%3D0%26amp%3Bsql_query%3DSELECT%2B%252A%2BFROM%2B%2560products%2560' (include_path='.;/usr/local/PHP/includes;/usr/local/PHP/pear') in W:\home\admin\www\phpMyAdmin\tbl_replace.php on line 261 Ok, what next? This is not a big problem, as you note, since it works. It is disconcerting since I do not know why it is generating these errors. I can wait for the next version of Uni. Server, but it would be nice to hear from anyone else who has the same problem.
  2. I've found thes errors in the mysql err log for my database and I don't know how to run the functions requested. Does this mean the something (me?) changed the "format" for passwords, or does it just mean the password itself was changed? 060108 6:49:41 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run 060108 6:49:41 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them Can someone tell me where and how to run the "fix" function specified above and how to create the missing Table 'mysql.time_zone_leap_second'?
  3. I've gotten this error when adding anew record to my database table. I can't interpret it so I'm passing it along to the forum. Note that I am using the link a the bottom of the "Browse' window in PhpMyAdmin. The record DOES get added, but the message (second second) says it is fatal. Nothing dies that I can detect. The messages strings are unformatted and I have forced them to fit in this window. Warning: require(./sql.php%3Flang%3Den-utf-8%26amp%3Bserver%3D1%26amp%3B collation_connection%3Dutf8_general_ci%26amp%3Bdb%3Dtwpproducts%26amp% 3Btable%3Dproducts%26amp%3Bpos%3D0%26amp%3Bsession_max_rows%3D30 %26amp%3Bdisp_direction%3Dhorizontal%26amp%3Brepeat_cells%3D100%26am p%3Bdontlimitchars%3D0%26amp%3Bsql_query%3DSELECT%2B%252A%2BFROM %2B%2560products%2560) [function.require]: failed to open stream: No error in W:\home\admin\www\phpMyAdmin\tbl_replace.php on line 262 Fatal error: require() [function.require]: Failed opening required './sql.php%3Flang%3Den-utf-8%26amp%3Bserver%3D1%26amp%3Bcollation_conn ection%3Dutf8_general_ci%26amp%3Bdb%3Dtwpproducts%26amp%3Btable%3D products%26amp%3Bpos%3D0%26amp%3Bsession_max_rows%3D30%26amp%3 Bdisp_direction%3Dhorizontal%26amp%3Brepeat_cells%3D100%26amp%3Bdont limitchars%3D0%26amp%3Bsql_query%3DSELECT%2B%252A%2BFROM%2B%25 60products%2560' (include_path='.;/usr/local/PHP/includes;/usr/local/PHP/pear') in W:\home\admin\www\phpMyAdmin\tbl_replace.php on line 262 If anyone cares to analyze this, perhaps it will help?
  4. And, no, it did not work from localhost until I "allowed from all". But, I'm in now and can work on it. thanks again.
  5. Ah, got it, thanks. and I see when you say it is 'risky", at least this machine is not publically accessible.
  6. Based on my limited testing, on UniServer localhost and an outside commercial host which runs my public website. It works on the commercial server but fails on my local machine when running Uniform Server. It (css styles sheet) works on my Firefox browser during development off-line, but fails for that one font when I run my code under UniServer. It may fail for other fonts, but I don't have time for an exhaustive test... Apparently local fonts are not visible to the Uniserver? PS Good luck on your move, no envy here.
  7. Hmmm, my http.conf file is the same as you quote below for /status (not changed from original installation). Same is true of the <Location /info> (Allow remote server configuration reports). I'm assuming that using the Uniform Server apanel appears as a request from localhost. which is "allowed" under /status and /info. I get a 403 "You don't have permission to access /status (/info) on this server." when using apanel's menu link to "Apache Status" or "Apache Info". Who, or what, should be allowed in http.conf so that apanel's links will work? I thought that apanel has localhost priviledges? No?
  8. The font works on other, outside, servers, but not on the localhost installation of Uniform Server. I also notice a difference between the font as shown on my real website host and on my local computer. I'll look into WEFT, thanks for the pointer. I did a workaround and replaced my use of that font with a image instead of plain text. I't a kludge but it looks better than nothing. thanks again
  9. Thank, I'll try this and get back to you if I still have trouble. Risky, probably, but hey it's just my whole development code, guess I should do a backup first...
  10. It is a TrueType font (symbol.ttf) in my Win2000 font list. This is a greek letter alphabet that I use for my business logo. I assume (perhaps I'm wrong?) that the server can utilize the windows fonts if installed, which they are on my machine. Loaded question: How do I install other fonts on Uniform Server? Thanks for the assist.
  11. It was the NameVirtualHost * which WAS commented out. Uncommented theline and then I used your example, and it works perfectly. Thank you!
  12. On my Win2000 system, the start directory/folder is the location of the batch file server_start.bat. The target directory is the location of the uniform server installation which in my case is the same. start: C:\Program Files\...\Uniform Server\Server_Start.bat" target: "C:\Program Files\...\Uniform Server\Server_Start.bat" Notice that these are NOT the, as yet, unmounted drive which will be recreated by the batch file. I'm going to guess that your "F:\WAMP\UniServer_v3.3". may be the actual installation folder? WOMM
  13. Ok, after too many sleepless hours, this is what I did and it works for my usage: I set up one Virtual Host in http_conf: ##########VIRTUAL HOST SETUP########## # LOCALHOST <VirtualHost *> ServerName localhost DocumentRoot /www/ </VirtualHost> In the "www" root folder, I have sub-folders for each of my sites, containing the full site code, as if the sub-folder were the root. In the "www" root folder, I placed a single page, "index.php" and it contains simple html links to as many other sub-folders as I want. For example: <a href="http://localhost/twpmarket">TWP Marketing</a> <a href="http://localhost/stopbrite">Stop*Brite</a> Since I use Dreamweaver to upload my files to the host, I've configured DW for each site to point to the sub-folder on LocalHost, ie: Remote Folder: w:\www\twpmarke\ http address: http://localhost:80/www/stopbrite/ Remote Folder: w:\www\stopbrite\ http address: http://localhost:80/www/twpmarket/ This works for me and I hope others may be able to use this method. Please let me know if anybody is aware of potential problems from this configuration. Thanks!
  14. I want to create two (or more) virtual hosts on my local Uniform Server installation. I've read through the forum postings and see some discussion of doing this, but no enough to match my situation. I have multiple development websites being tested on the Uniform Server platform before uploading to a server on the 'net. I can get one or the other to be displayed, but only by reversing their sequence in the http_conf file. I read in the Apache docs that this is probably because the first Vhost on the list is considered the main server and will be delivered to the browser if the other Vhost servers have an "unknown name". The Apache docs have little to say about configuring using localhost, except this: "Requests for any address not specified in one of the <VirtualHost> directives (such as localhost, for example) will go to the main server, if there is one." Will someone explain to me where my configuration (below) is failing? Is localhost only able to handle only one virtual host name, or did I code it incorrectly? Listen is set to port 80 Userdir is /www/ I used the VHost script in the Uniform Server to create these vir. hosts. Each folder in DocumentRoot has a complete and functional set of files in its respective directories, they both work. This is the code from my http_conf file: ##########VIRTUAL HOST SETUP########## # STOPBRITE.LOCALHOST <VirtualHost *> ServerName stopbrite.localhost DocumentRoot /www/stopbrite </VirtualHost> ##########VIRTUAL HOST SETUP########## # TWPMARKET.LOCALHOST <VirtualHost *> ServerName twpmarket.localhost DocumentRoot /www/twpmarket </VirtualHost>
  15. Can someone tell me why I can't access the "Apache Status" option on apanel? I get this message: "You don't have permission to access /status on this server." I have edited .htaccess and commented out the three lines around deny to open my IP address, but this may not be related. Suggestions? comments?
×
×
  • Create New...