Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


NameCrane Offloaded SQL is now in public BETA! - Page 4
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

NameCrane Offloaded SQL is now in public BETA!

1246713

Comments

  • @Francisco said: Unless you mean an API w/ WHMCS/Blesta modules?

    Well something like that would be really nice (I only need api tho) :)

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @JabJab said: Seems like disabled is not enabled ( ) aka I can switch this to "Disabled" while creating or editing user, but it will always come back as Active/Enabled after clicking Save. Like it's not saving that field status and falling back to default?

    This is on New, right?

    Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @Francisco said: @JabJab said: Seems like disabled is not enabled ( ) aka I can switch this to "Disabled" while creating or editing user, but it will always come back as Active/Enabled after clicking Save. Like it's not saving that field status and falling back to default?

    Yep, I had it forced active on save. It should honor the dropdown now.

    Francisco

  • Ok time to do some bug hunting :wink:

  • JabJabJabJab Member

    @Francisco said: Yep, I had it forced active on save. It should honor the dropdown now.

    Plot twist... I can disable now, but can't re-enable (on Edit user) and it still ends with disabled.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    Plot twist... I can disable now, but can't re-enable (on Edit user) and it still ends with disabled.
    >

    Was just a locally cached data not getting updated, but should behave now.

    Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @BasToTheMax said:
    Ok time to do some bug hunting :wink:

    Go for it!

    Francisco

  • BasToTheMaxBasToTheMax Member
    edited March 30

    First bug i found:

    On the product details page (not the manage page).

    This button redirects to an invalid hostname (CRANEBASE-22061 of course isn't a valid public hostname :wink: )

    Or maybe this is just a limitation of whmcs?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @BasToTheMax said: This button redirects to an invalid hostname (CRANEBASE-22061 of course isn't a valid public hostname )

    Or maybe this is just a limitation of whmcs?

    WHMCS quirk I guess since we don't set a proper 'domain' on the service, just the
    CRANEBASE-$serviceid name.

    Francisco

    Thanked by 1BasToTheMax
  • JabJabJabJab Member

    @Francisco said: Was just a locally cached data not getting updated, but should behave now.

    Can confirm, edit works now.
    Now the question is... should I be able to login via phpMyAdmin if the user is set to "Disabled" because I still can (or it takes some times to sync it?).

    If I create user with Status "Disabled" I can't login to phpMyAdmin - too many redirects, throws me out to phpMyAdmin login screen.

    If I create user with Status "Enabled", login to phpMyAdmin and then Edit User to Status "Disabled" I can still login to phpMyAdmin.

  • Once the stable release product thingy will launch, what will be the smallest plan available (just curious)?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @JabJab said: If I create user with Status "Enabled", login to phpMyAdmin and then Edit User to Status "Disabled" I can still login to phpMyAdmin.

    I'll have to tweak that. At the moment I only check the value of the phpmyadmin drop down, it doesn't take it and active status into consideration when doing grants/revokes.

    Give me a few minutes and I'll make 'active' override it.

    Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @JabJab said: If I create user with Status "Disabled" I can't login to phpMyAdmin - too many redirects, throws me out to phpMyAdmin login screen.

    If I create user with Status "Enabled", login to phpMyAdmin and then Edit User to Status "Disabled" I can still login to phpMyAdmin.

    OK this should behave properly. Go ahead and edit the user, save it as is, and it should propagate the correct settings.

    @BasToTheMax said: Once the stable release product thingy will launch, what will be the smallest plan available (just curious)?

    Probably 10GB, $5/year. We want to make the product extremely accessible to our shared/reseller users.

    Francisco

    Thanked by 1BasToTheMax
  • @BasToTheMax said:

    @Francisco said: Unless you mean an API w/ WHMCS/Blesta modules?

    Well something like that would be really nice (I only need api tho) :)

    Or at least an api to create databases/users (and assign them to databases)/allowed ips so i could make my own frontend thingy :)

  • iSkyiSky Member

    @Francisco said:

    @iSky said: any beta test on SG ? and if already officially, will SG included ?

    SG will be a ways out. Mike & I will have to decide if we want to do this as a standalone product, or try to make it shared/resellers only.

    If we do it as a standalone I'd also throw a node in Kansas to cover mid-west USA.

    Francisco

    does it mean will never or will have at future but still very long way before you launch it on SG ?

    what about your shared hosting at SG, will it have a good peering with this product on EU or US server of your ?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @iSky said:

    @Francisco said:

    @iSky said: any beta test on SG ? and if already officially, will SG included ?

    SG will be a ways out. Mike & I will have to decide if we want to do this as a standalone product, or try to make it shared/resellers only.

    If we do it as a standalone I'd also throw a node in Kansas to cover mid-west USA.

    Francisco

    does it mean will never or will have at future but still very long way before you launch it on SG ?

    what about your shared hosting at SG, will it have a good peering with this product on EU or US server of your ?

    It’s a ways out.

    Peering won’t matter in this case, it’s just a distance thing. Even the best peering in the world is still going to be... 130 - 140ms from Singapore to Vegas? More? That's a lot of latency for every query you run.

    Francisco

  • @Francisco said:
    This service currently only available in Las Vegas, but we expect it to be live in the Netherlands in the next couple weeks.

    Singapore when?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @suyadi92 said: Singapore when?

    Not an immediate priority, we don't have soul crushing SQL loads over there at the moment.

    NL will get it next month.

    Francisco

    Thanked by 1suyadi92
  • labzelabze Member, Patron Provider
    edited March 30

    @Francisco said:

    @suyadi92 said: Singapore when?

    Not an immediate priority, we don't have soul crushing SQL loads over there at the moment.

    NL will get it next month.

    Francisco

    Since you mention NL instead of Lux is that because you also expect the servers to be migrated in that period for the shared hosting? Or will NL databases be live before the migration will happen?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @labze said: Since you mention NL instead of Lux is that because you also expect the servers to be migrated in that period for the shared hosting? Or will NL databases be live before the migration will happen?

    I expect the first round of shared nodes to move within a week of NL going live, likely within the first day or two. They're something I can kick off a live migration for and check back when it's done. I can then get LUX to ship those now empty nodes to NL and we then do the final push over.

    I'll take it as a good time to upgrade the last of our CL7 nodes to CL8.

    SQL isn't overly involved to roll out now that I put together a template for it. Cranemail will be the more involved project, but even that is only an afternoon.

    Francisco

  • @Francisco said:

    @suyadi92 said: Singapore when?

    Not an immediate priority, we don't have soul crushing SQL loads over there at the moment.

    NL will get it next month.

    Francisco

    Any plans for UK?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @luissousa said: Any plans for UK?

    Not in the immediate, but never say never :)

    Francisco

  • Seems like if you make a account with phpMyAdmin disable and enable later you get mysqli::real_connect(): (HY000/4151): Access denied, this account is locked

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @Kevinf100 said: Seems like if you make a account with phpMyAdmin disable and enable later you get mysqli::real_connect(): (HY000/4151): Access denied, this account is locked

    >

    I would remake the user and see if it still happens. It's possible it was related to the status not getting passed properly as @jarjar123 pointed out eariler.

    Francisco

    Thanked by 1Kevinf100
  • @Francisco said:

    @Kevinf100 said: Seems like if you make a account with phpMyAdmin disable and enable later you get mysqli::real_connect(): (HY000/4151): Access denied, this account is locked

    >

    I would remake the user and see if it still happens. It's possible it was related to the status not getting passed properly as @jarjar123 pointed out eariler.

    Francisco

    Yeah, seems you can't disable and enable phpMyAdmin, only on creation it'll follow whats selected.
    Also I don't know if you care if people see that stats of the server (we can see the server's total stats, not just our own!)

  • FranciscoFrancisco Top Host, Host Rep, Veteran
    edited March 30

    @Kevinf100 said: Yeah, seems you can't disable and enable phpMyAdmin, only on creation it'll follow whats selected.
    Also I don't know if you care if people see that stats of the server (we can see the server's total stats, not just our own!)

    Will test edit.

    Will also think on the status as well :) It's probably not a big deal but lets see.

    Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @Kevinf100 said:

    @Francisco said:

    @Kevinf100 said: Seems like if you make a account with phpMyAdmin disable and enable later you get mysqli::real_connect(): (HY000/4151): Access denied, this account is locked

    >

    I would remake the user and see if it still happens. It's possible it was related to the status not getting passed properly as @jarjar123 pointed out eariler.

    Francisco

    Yeah, seems you can't disable and enable phpMyAdmin, only on creation it'll follow whats selected.
    Also I don't know if you care if people see that stats of the server (we can see the server's total stats, not just our own!)

    Can you PM me your mysql username? I got a hunch as to what it is and i'll have to add a note to the page once confirm.

    Francisco

  • Kevinf100Kevinf100 Member
    edited March 30

    @Francisco said:

    @Kevinf100 said: Yeah, seems you can't disable and enable phpMyAdmin, only on creation it'll follow whats selected.
    Also I don't know if you care if people see that stats of the server (we can see the server's total stats, not just our own!)

    Will test edit.

    Will also think on the status as well :) It's probably not a big deal but lets see.

    Francisco

    To add more to it. If you enable phpMyAdmin on the user when created, the user can login to phpMyAdmin. If you disable that users access to phpMyAdmin they can still login, just not be able to access any tables.
    If you disable phpMyAdmin when the user is created, they can never login it seems.
    Enable.

    Disable.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @Kevinf100 said: To add more to it. If you enable phpMyAdmin on the user when created, the user can login to phpMyAdmin. If you disable that users access to phpMyAdmin they can still login, just not be able to access any tables.

    If you disable phpMyAdmin when the user is created, they can never login it seems.
    Enable.

    Do you have % as a host? :)

    Francisco

  • Kevinf100Kevinf100 Member
    edited March 30

    @Francisco said:

    @Kevinf100 said: To add more to it. If you enable phpMyAdmin on the user when created, the user can login to phpMyAdmin. If you disable that users access to phpMyAdmin they can still login, just not be able to access any tables.

    If you disable phpMyAdmin when the user is created, they can never login it seems.
    Enable.

    Do you have % as a host? :)

    Francisco

    No. In fact I just notice, I have my VPN on and I can login to phpMyAdmin while it's not whitelisted (the ip).

Sign In or Register to comment.