-
Posts
17,969 -
Joined
-
Last visited
-
Days Won
675
Everything posted by wolstech
-
I did import via command line. No idea why the UI wouldn't see the server, but phppgadmin has a limit of like 50MB anyway so even if it did, this particular file won't import through it due to size.
- 14 replies
-
- 1
-
-
[Solved] Account Queued: pikhe.com
wolstech replied to Adreamer's topic in Suspended and Queued Accounts
Be aware you may need to clear your cache after the 12 hours to see your site. The queued page sometimes gets stuck in cache and appears as if it didn't go away when it actually did. -
So, 2 hours on, this database is both too large for our systems and for the wrong version of postgres (it's for 9.x, we have 8.x on Johnny). This will not run here. It's still finished the import on the schema file, but its almost certainly not going to work correctly. I won't bother to attempt the 400MB of data as I'll only run you out of disk space and whatever this DB goes to is likely not going to work anyway due to the version differences...a significant number of commands have failed at this point due to being for the wrong version. If you want to go ahead, let me know, otherwise you can just drop the database.
- 14 replies
-
- 1
-
-
Looks like it's got a bunch of syntax issues psql:cidade_schema.sql:201697: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 2606551314 OWNER TO walter21_cidade; ^ lo_create ------------ 2608066841 (1 row) psql:cidade_schema.sql:201706: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 2608066841 OWNER TO walter21_cidade; ^ lo_create ------------ 2608583171 (1 row) psql:cidade_schema.sql:201715: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 2608583171 OWNER TO walter21_cidade; ^ lo_create ------------ 2608589391 (1 row) psql:cidade_schema.sql:201724: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 2608589391 OWNER TO walter21_cidade; ^ lo_create ------------ 2775496897 (1 row) psql:cidade_schema.sql:201733: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 2775496897 OWNER TO walter21_cidade; ^ lo_create ------------ 3611089473 (1 row) psql:cidade_schema.sql:201742: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 3611089473 OWNER TO walter21_cidade; ^ lo_create ----------- 489583744 (1 row) psql:cidade_schema.sql:201751: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 489583744 OWNER TO walter21_cidade; ^ SET What version postgres was this DB for anyway? If it's meant for 9.x, no wonder it's been spewing errors. Johnny has 8.x...ALTER LARGE OBJECT seems to be a 9.x command. If this is the case, this database simply won't run on Johnny properly.
- 14 replies
-
- 1
-
-
I'm not surprised it wouldn't import for you simply due to its size. Those database files are huge. I copied and fixed the SET OWNER commands on the schema file so it assigns the tables and schemas to a user that exists (you), then started it and its still running. I'm not even going to attempt the demo data right now... Also, it seems happy right now, but there were tons of errors in the beginning, so if it doesn't work we'll need to drop it and try again. I'll let you know when it's done. EDIT: I think you've won the award for most tables in a single database on our server And it's still not done...
- 14 replies
-
- 1
-
-
Did you create the database walter21_city? It doesn't exist, which would explain a lot about why you can't import into it. The database itself needs to be created through cPanel in the same manner that MySQL databases do. Please create the database. Or is this supposed to be in walter21_cidade?
- 14 replies
-
- 1
-
-
Please upload the files into your home folder and let me know their filenames and I'll go ahead and import them.
- 14 replies
-
Done. You should now be able to log in and your website should start working within 12 hours.
-
Your account was archived because you haven't logged in for quite a while. We have a limited amount of space on our servers, and occasionally we have to remove the unused accounts to make space for new users. To prevent your account from becoming archived again please remember to log in at https://www.heliohost.org/login/ at least once every 30 days. Unarchiving...
-
You should be able to import it through the PhpPgAdmin web interface. I doubt the cron would import it. If it won't import though, tell me the database you want that file imported into and I can import it from the command line for you.
- 14 replies
-
- 1
-
-
[Solved] Account Queued: pikhe.com
wolstech replied to Adreamer's topic in Suspended and Queued Accounts
Did you add the domain in cpanel as an addon domain or alias? -
Please clear your cache. I see a blank white page with "new test" in the corner when I visit that domain. If there's a different page that's broken, please post a link.
-
In the USA where we are based, a user needs to be provided a way to opt out of further emails from within the mail itself, so an unsubscribe link will be needed. Other than that, it sounds good. Krydos will take a look at this and decide when he sees your response.
-
This support request is being escalated to our root admin. (I'd normally do this, but I'm at work and for some reason I can't reach my home PC from work today...it's got miners on it and probably crashed from the OC I adjusted last night)
-
Never mind. You're banned for phishing based on the contents of the files on your account. $sender = "account_recovery@gmail.com"; }elseif($emailExt == "yahoo.com"){ $message = "yahoo"; $sender = "account_recovery@yahoo.com"; }elseif($emailExt == "hotmail.com" || $emailExt == "outlook.com" ){ $message = "hotmail"; $sender = "account_recovery@office365.com"; }else{ $message = "webmail"; $sender = "account_recovery@webmail.com"; } There's no valid reason for sending emails with those headers...
-
Unfortunately, we don't offer email services in your country. You're free to use our web hosting provided you comply with our Terms of Service: http://wiki.helionet.org/Terms however you will not be able to send more than 1 email. Unsuspended.
-
Please see your other topic here: https://www.helionet.org/index/topic/31649-username-spell-acct-suspended/
-
[Solved] Can't use Python2.7 on Johnny Server
wolstech replied to lachie07's topic in Customer Service
Because that topic is ancient and the server has been rebuilt twice since that was posted. That was information for the original Johnny, we're on our third round with Johnny now. -
It's a mail signature. Google Apps is doing that to the mail, not us. You'd have to ask them if it's possible to remove it.
-
Haswell came out in 2013, so it's almost 5 years old.
-
Can't remove addon domains (not even visible to delete) !
wolstech replied to suror's topic in Customer Service
In this scenario, it probably failed because it was already added. You cannot make a domain your main domain if it's already added as an alias or addon domain. You need to remove it from Aliases, then change the try to change the main domain again. -
That method actually won't work anymore since we no longer allow free registrations for Tommy due to a lack of disk space. A donation is required. If you donate, we can just move the existing Johnny account to save you the hassle of setting up everything again.
-
174.6H/s on Aeon. Not bad for an older Haswell CPU. Not sure if there are any logs honestly. I know Stak doesn't produce one by default.
-
We actually won't be offering MSSQL (Krydos was unaware it costs extra, and none of us know much about it either...I've built Windows web servers before but they all ran MySQL or Postgres because they were for hosting PHP applications under IIS). As of now, we honestly don't have any concrete plans as to what will be offered by the Windows box beyond ASP.NET/IIS. My initial goal is to just get IIS running since it will be a learning curve for all of us. Unlike Apache which we've been running for over 10 years, we've never tried IIS before. The simplest solution to get up and running quickly will be to pass IIS through a cPanel server by letting Apache proxy it (Java is handled this way now...). That way users have IIS hosting (and thus ASP.NET, among other things), but retain the full suite of other functionality (databases, mail, DNS management, etc.) from cPanel. As we progress with it, more functionality will be added to the Windows box. Here's some things I am looking into: How it'll be administered by the users. IIS has a ton of options that normally require access to the desktop or the Windows RSAT.Databases...if we put a cPanel server in front, MySQL and Postgres are redundant. MSSQL isn't free.Perhaps MariaDB, or a NoSQL solution like MongoDB?Whether we can use Lily as a means to offer Ruby on Rails on a server other than Johnny.